• Home

  • Custom Ecommerce
  • Application Development
  • Database Consulting
  • Cloud Hosting
  • Systems Integration
  • Legacy Business Systems
  • Security & Compliance
  • GIS

  • Expertise

  • About Us
  • Our Team
  • Clients
  • Blog
  • Careers

  • CasePointer

  • VisionPort

  • Contact
  • Our Blog

    Ongoing observations by End Point Dev people

    Blog posts tagged ‘database’

    Testing user-defined functions with pgTAP

    Todor “Theo” Dimov · September 25, 2023

    How To Set Up pgTAP for Writing PostgreSQL Database Unit Tests

    Edgar Mlowe · April 12, 2023

    Find Text in Any Column of a PostgreSQL Table

    Josh Tolley · February 6, 2023

    Data Migration Tips

    Josh Tolley · February 4, 2023

    Using pgTAP to automate database testing

    Josh Tolley · March 16, 2022

    Database Design: Using Documents

    Emre Hasegeli · March 9, 2022

    String Processing in SQL, the Hard Way

    Josh Tolley · February 28, 2022

    Migrating a Node.js app database from MongoDB to PostgreSQL

    Phineas Jensen · February 25, 2022

    Database integration testing with .NET

    Kevin Campusano · January 12, 2022

    Full-text search on a budget: Xapian

    Marco Pessotto · August 19, 2021

    Database Design: Using Composite Keys

    Emre Hasegeli · May 20, 2021

    Spatial queries with MySQL

    Juan Pablo Ventoso · March 24, 2021

    Database Design: Using Natural Keys

    Emre Hasegeli · March 15, 2021

    Job opening: PostgreSQL database administrator & developer

    Jon Jensen · November 13, 2020

    Detecting gaps in time-series data in PostgreSQL

    David Christensen · October 26, 2020

    Using CTEs to do a binary search of large tables with non-indexed correlated data

    David Christensen · October 2, 2020

    Improving max() performance in PostgreSQL: GROUP BY vs. CTE

    David Christensen · June 30, 2020

    Migrating large PostgreSQL databases

    Árpád Lajos · April 21, 2020

    A Tool to Compare PostgreSQL Database Schema Versions

    Selvakumar Arumugam · February 11, 2020

    GraphQL — An Alternative to REST

    Zed Jensen · May 11, 2019

    How to Migrate from Microsoft SQL Server to PostgreSQL

    Selvakumar Arumugam · January 23, 2019

    Switching PostgreSQL WAL-based Backup Options

    Josh Williams · January 3, 2019

    Building Rasters in PostGIS

    Josh Tolley · September 12, 2018

    Systematic Query Building with Common Table Expressions

    Josh Tolley · June 12, 2018

    Recycling Web Workers: Just Proper Hygiene

    Josh Williams · March 23, 2018

    Using PostgreSQL cidr and inet types, operators, and functions

    Phineas Jensen · September 28, 2017

    Amazon AWS upgrades to Postgres with Bucardo

    Greg Sabino Mullane · June 6, 2017

    DBA Revenge: How To Get Back at Developers

    Josh Williams · April 1, 2017

    Seedbank: Structured Seed Files for Rails Projects

    Patrick Lewis · December 21, 2016

    Connect Multiple JPA repositories using Static and Dynamic Methods

    Selvakumar Arumugam · November 16, 2016

    Making cross-blogs queries in multi-site WordPress performant

    Kamil Ciemniewski · November 2, 2016

    WAL-based Estimates For When a Record Was Changed

    Josh Williams · July 1, 2016

    Bucardo replication workarounds for extremely large Postgres updates

    Greg Sabino Mullane · May 31, 2016

    Randomized Queries in Ruby on Rails

    Kent Krenrich · May 12, 2016

    Postgres 9.5: three little things

    Greg Sabino Mullane · January 28, 2016

    PostgreSQL Point-in-time Recovery: An Unexpected Journey

    David Christensen · January 15, 2016

    Postgres checksum performance impact

    Greg Sabino Mullane · December 31, 2015

    Pgbouncer user and database pool_mode with Scaleway

    Greg Sabino Mullane · September 24, 2015

    Bucardo replication from Postgres to sqlite and mariadb using pgbench

    Greg Sabino Mullane · August 12, 2015

    Selectively firing Postgres triggers

    Greg Sabino Mullane · July 15, 2015

    Heroku: dumping production database to staging

    Marina Lohova · June 17, 2015

    Updated NoSQL benchmark: Cassandra, MongoDB, HBase, Couchbase

    Josh Williams · June 4, 2015

    Postgres “unsupported frontend protocol” mystery

    Greg Sabino Mullane · May 28, 2015

    Connected to PgBouncer or Postgres?

    Greg Sabino Mullane · May 18, 2015

    Handling databases in dev environments for web development

    Spencer Christensen · April 21, 2015

    New NoSQL benchmark: Cassandra, MongoDB, HBase, Couchbase

    Jon Jensen · April 13, 2015

    Postgres searchable release notes—​one page with all versions

    Greg Sabino Mullane · March 11, 2015

    Temporary tables in SQL query optimization

    Jeff Boes · February 25, 2015

    Postgres ON_ERROR_ROLLBACK explained

    Greg Sabino Mullane · February 24, 2015

    Postgres pg_dump implicit cast problem patched!

    Greg Sabino Mullane · February 16, 2015

    Postgres custom casts and pg_dump

    Greg Sabino Mullane · February 10, 2015

    DBD::Pg escaping placeholders with backslashes

    Greg Sabino Mullane · January 12, 2015

    DBD::Pg: one ping to rule them all

    Greg Sabino Mullane · January 7, 2015

    PostgreSQL conflict handling with Bucardo and multiple data sources

    Greg Sabino Mullane · July 24, 2014

    Version 5 of Bucardo database replication system

    Greg Sabino Mullane · June 23, 2014

    Why Can’t I Edit this Database Table? Don’t Forget the Client!

    Mark Johnson · June 11, 2014

    DBD::Pg, array slices, and pg_placeholder_nocolons

    Greg Sabino Mullane · May 25, 2014

    Custom plans prepared statements in PostgreSQL 9.2

    Greg Sabino Mullane · April 28, 2014

    MySQL, ASCII Null, and Data Migration

    Mark Johnson · February 26, 2014

    Rails ActiveRecord with Database Column Defaults

    Kent Krenrich · February 7, 2014

    Copy Data Between MySQL Databases with Sequel Pro

    Greg Davidson · January 10, 2014

    Increasing MySQL 5.5 max_connections on RHEL 5

    Jon Jensen · December 24, 2013

    Database federation performance showdown

    Josh Tolley · December 19, 2013

    How to Enable MySQL Event Scheduler

    Emanuele “Lele” Calò · November 26, 2013

    How to DRY out your Active Record queries with Squeel

    Kamil Ciemniewski · October 24, 2013

    Ecommerce Innovation 2013

    Richard Templet · October 16, 2013

    SFTP virtual users with ProFTPD and Rails: Part 2

    Brian Gadoury · July 10, 2013

    Window functions in action

    Josh Tolley · June 5, 2013

    Foreign Data Wrappers

    Josh Tolley · May 13, 2013

    Dimensional Modeling

    Josh Tolley · May 8, 2013

    NoSQL benchmark of Cassandra, HBase, MongoDB

    Jon Jensen · March 12, 2013

    SFTP virtual users with ProFTPD and Rails: Part 1

    Brian Gadoury · December 20, 2012

    Detecting table rewrites with the ctid column

    Greg Sabino Mullane · November 26, 2012

    Postgres alter column problems and solutions

    Greg Sabino Mullane · November 9, 2012

    An Encouraging LinuxFest

    Josh Williams · October 29, 2012

    Postgres system triggers error: permission denied

    Greg Sabino Mullane · October 25, 2012

    Case Sensitive MySQL Searches

    Brian Buchalter · October 18, 2012

    The Real Cost of Data Roundtrip

    Szymon Lipiński · October 3, 2012

    Enforcing Transaction Compartments with Foreign Keys and SECURITY DEFINER

    Mark Johnson · September 4, 2012

    PL/Perl multiplicity issues with PostgreSQL: the Highlander restriction

    Greg Sabino Mullane · September 4, 2012

    Postgres log_statement='all' should be your default

    Greg Sabino Mullane · June 30, 2012

    You shall not pass! Preventing SQL injection

    Marina Lohova · June 14, 2012

    Detecting Postgres SQL Injection

    Greg Sabino Mullane · June 10, 2012

    UTOSC Recap

    Josh Tolley · May 10, 2012

    Integrating Propel ORM

    Terry Grant · April 18, 2012

    The Mystery of The Zombie Postgres Row

    Greg Sabino Mullane · March 14, 2012

    Tracking down PostgreSQL XYZ error: tablespace, database, and relfilnode

    Greg Sabino Mullane · February 14, 2012

    RailsAdmin Import: Part 2

    Steph Skardal · February 1, 2012

    Protecting and auditing your secure PostgreSQL data

    Greg Sabino Mullane · January 30, 2012

    Interchange loops using DBI Slice

    Richard Templet · January 13, 2012

    Some great press for College District

    Ron Phipps · January 5, 2012

    Interchange Search Caching with “Permanent More”

    Mark Johnson · January 2, 2012

    Finding PostgreSQL temporary_file problems with tail_n_mail

    Greg Sabino Mullane · November 10, 2011

    Viewing schema changes over time with check_postgres

    Greg Sabino Mullane · October 5, 2011

    A comparison of Jaspersoft iReport and Pentaho Reporting

    Josh Tolley · October 2, 2011

    PostgreSQL Serializable and Repeatable Read Switcheroo

    Greg Sabino Mullane · September 28, 2011

    Bucardo PostgreSQL replication to other tables with customname

    Greg Sabino Mullane · September 5, 2011

    PostgreSQL log analysis / PGSI

    Greg Sabino Mullane · August 19, 2011

    Changing postgresql.conf from a script

    Greg Sabino Mullane · August 10, 2011

    Announcing pg_blockinfo!

    David Christensen · July 14, 2011

    Page 1 of 2 • Next page