• 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 ‘sql’

    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

    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