Our Blog

Ongoing observations by End Point Dev people

Blog posts tagged ‘sql’

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

How to use regular expression group quantifiers in PostgreSQL

Selvakumar Arumugam · January 27, 2022

Ecommerce customer names with interesting Unicode characters

Jon Jensen · December 29, 2021

Database Design: Using Composite Keys

Emre Hasegeli · May 20, 2021

Database Design: Using Natural Keys

Emre Hasegeli · March 15, 2021

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

David Christensen · October 2, 2020

How to Migrate from Microsoft SQL Server to PostgreSQL

Selvakumar Arumugam · January 23, 2019

Building Rasters in PostGIS

Josh Tolley · September 12, 2018

Systematic Query Building with Common Table Expressions

Josh Tolley · June 12, 2018

Temporary tables in SQL query optimization

Jeff Boes · February 25, 2015

How to DRY out your Active Record queries with Squeel

Kamil Ciemniewski · October 24, 2013

Speedier column additions in PostgreSQL

Jeff Boes · July 17, 2013

Window functions in action

Josh Tolley · June 5, 2013

Foreign Data Wrappers

Josh Tolley · May 13, 2013

Postgres alter column problems and solutions

Greg Sabino Mullane · November 9, 2012

You shall not pass! Preventing SQL injection

Marina Lohova · June 14, 2012

SQL errors in Interchange

Jeff Boes · September 7, 2011

Bucardo multi-master for PostgreSQL

Greg Sabino Mullane · June 6, 2011

Saving time with generate_series()

Josh Tolley · May 31, 2011

Fun with SQL

Josh Tolley · October 10, 2009