If you’re using a PostgreSQL database and need to backup the database schema, this article will walk through some of the handy scripts I use to backup and restore a database schema. I like to use Docker for everything, especially for my development environment. I can easily automate my …

If you’re using a database, any database really, and you need to track the number of something, have an incrementing counter might do the trick. Seems incredibly easy, so I’ll give some reasons for the solution. I’ve been building a lot of API services and need a way to track usage …

If you’re working with arrays of data in PostgreSQL this post will walk through a quick and simple solution to create dynamic WHERE IN database queries using arrays for PostgreSQL. Some of the syntax might be helpful for other databases and libraries as well. The Problem Here’s the …