• 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 by

    David Christensen

    Detecting gaps in time-series data in PostgreSQL

    October 26, 2020

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

    October 2, 2020

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

    June 30, 2020

    Bucardo 5.6.0 Released

    March 1, 2020

    Cloudflare and Vue SSR; Client Hydration Failures

    June 11, 2019

    Vue, Font Awesome, and Facebook/​Twitter Icons

    July 12, 2018

    Instant TLS Upgrades Through Proxy Magic!

    June 14, 2018

    PostgreSQL Point-in-time Recovery: An Unexpected Journey

    January 15, 2016

    PgConf 2015 NYC Recap

    April 6, 2015

    PGConf.US NYC: "Choosing a Logical Replication System"

    January 22, 2015

    MySQL to PostgreSQL Migration Tips

    November 26, 2014

    Significant Whitespace in an Interchange UserTag

    March 18, 2014

    Slony Migration experience version 1.2 to version 2.2

    November 6, 2013

    PostgreSQL Autovacuum Issues In EOL Postgres

    July 17, 2013

    Postgres Open 2012

    July 31, 2012

    Integration Experiences

    June 13, 2012

    Byte-swap an entire file using perl

    April 20, 2012

    PG West 2011 Re-cap

    October 7, 2011

    Headed out to PgWest next week

    September 20, 2011

    Remove specific CGI variables using Apache

    August 10, 2011

    Announcing pg_blockinfo!

    July 14, 2011

    DBD::Pg moves to Git!

    June 14, 2011

    Presenting at PgEast

    March 11, 2011

    SSH: piping data in reverse

    March 1, 2011

    GNU Screen + SSH_AUTH_SOCK; my new approach

    February 23, 2011

    Pausing Hot Standby Replay in PostgreSQL 9.0

    February 12, 2011

    Using nginx to transparently modify/debug third-party content

    February 6, 2011

    Character encoding in perl: decode_utf8() vs decode('utf8')

    December 31, 2010

    Using “diff” and “git” to locate original revision/source of externally modified files

    December 18, 2010

    PostgreSQL 9.0 High Performance Review

    November 30, 2010

    PostgreSQL odd checkpoint failure

    September 14, 2010

    PostgreSQL: per-version .psqlrc

    July 28, 2010

    PostgreSQL: Dynamic SQL Function

    July 27, 2010

    PostgreSQL: Migration Support Checklist

    July 22, 2010

    PostgreSQL 8.4 on RHEL 4: Teaching an old dog new tricks

    May 19, 2010

    Continuing an interrupted git-svn clone

    May 13, 2010

    PostgreSQL startup Debian logging failure

    May 5, 2010

    Make git grep recurse into submodules

    April 26, 2010

    Tip: Find all non-UTF-8 files

    April 9, 2010

    PostgreSQL tip: arbitrary serialized rows

    March 8, 2010

    PostgreSQL tip: dump objects into a new schema

    February 16, 2010

    GNU diff: changing the output filenames

    February 15, 2010

    PostgreSQL tip: using pg_dump to extract a single function

    January 31, 2010

    Slony: Cascading Subscriptions

    January 28, 2010

    Postgres SQL Backup Gzip Shrinkage, aka Don’t Panic!!!

    January 9, 2010

    Look Ma, I made an iPhone Enterprise Application!

    August 3, 2009

    Subverting Subversion for Fun and Profit

    April 7, 2009

    Interchange jobs caveat

    March 10, 2009

    Emacs Tip of the Day: ediff-revision

    March 9, 2009

    Know your tools under the hood

    September 11, 2008

    Stepping into version control

    September 5, 2008