Databases

Rails Composite Primary Keys Evolution

Explore how Rails evolved to support composite primary keys natively in Rails 8 and migration strategies from the CPK gem.

Fly Postgres Backup to S3 via GitHub Actions

Discover how GitHub Actions empowers automation to effortlessly backup Fly.io hosted postgres databases, saving backups to a designated S3 bucket.

Release of Postgres15 : A Complete Guide

Identify the perks and deprecated features of Postgres15

PostgreSQL data-types in Rails

With Rails, there are many built-in data types that PostgreSQL supports. It's a great addition to the developer's toolkit!

Condenser for Database Subsetting

Learn how to use Condenser for subsetting database and PII removal using Postgres and MySQL.

Remove PII Data Using AWS DMS Service

Remove Personal Identifiable Information ( PII ) from database with continuous changes

ACID transactions in every day applications

Breaking down the use of ACID transactions using real-life examples of systems that we employ every day.