PostgreSQL

Single-Server Deployments with Terraform, Docker Compose, and GitHub Actions

Apr 30, 2023 18 min read Github Actions

A single cloud server can affordably power a range of services. In many cases, the vertical scalability capabilities of a single host are enough to cover the needs of many business applications for

Automating Partitioned Table Migrations with GitHub Actions

Jul 26, 2022 7 min read PostgreSQL

PostgreSQL supports table partitioning, which splits rows into multiple partitions for improved query performance and easier bulk data transfers. Partitioned tables are useful when data are regularly inserted into a table and only