Web Apps Do You Really Need Redis? How to Get Away with Just PostgreSQL It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but PostgreSQL may be capable of everything you use Redis for.
Developer Tools Setting up GitHub Actions for a React/Node Project How to set up GitHub Actions for a React, Node, Postgres, Yarn, and Typescript project running on Heroku. And why I won't be going back to CircleCI.
TypeScript Helper Functions for Testing a PostgreSQL Database Writing tests for a node.js server? You should test the database too. Here are a few helper functions for testing a postgres database, using knex.
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.
