TypeScript BLOBs with Knex and PostgreSQL An example of how to use the pg-large-object package with Knex to allow for streaming Large Objects from a PostgreSQL database in a Node.js program.
Platforms & Languages Level up your PostgreSQL Skill with Lateral Joins Referencing calculated columns in Postgres can be quite tricky. But lateral joins are a convenient way to reuse calculations within a query.
Platforms & Languages Finding Records that Don’t Exist in PostgreSQL Using PostgreSQL value lists and set operations to find records that do not actually exist in our database and identify problems in our dataset.
Software Science An Introduction to PostgreSQL Materialized Views What materialized views are, when you should consider using them, and what we learned from bringing them into our Postgres database project.