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.
Referencing calculated columns in Postgres can be quite tricky. But lateral joins are a convenient way to reuse calculations within a query.
Using PostgreSQL value lists and set operations to find records that do not actually exist in our database and identify problems in our dataset.
What materialized views are, when you should consider using them, and what we learned from bringing them into our Postgres database project.