🔍
gofirestoredatabasemigrationgcp

Building a Reusable Firestore Migration Runner in Go

A reusable Go library for Firestore collection migrations with cursor-based pagination, batch writes, checkpoint resume, rate limiting, and dry-run. Built for real production use.

29-Mar-2026 Read more →
pythongoogle-cloudfirestoredatabase

Simplifying Firestore Interactions with FSEntity Class

This article explores the FSEntity class, a Pythonic way to simplify interacting with and managing data in Google Firestore.

12-Jun-2024 Read more →
sqlitedatabasesqlmigrationschema

Schema Migration Script for SQLite to Rename and Change Column Type

Rename SQLite columns and change data types safely with migration scripts. Step-by-step guide with backup strategies. Preserve existing data during schema changes.

29-Jan-2024 Read more →
sqlitedatabasemigrationssqlzero-downtime

Zero-downtime Database Migrations in SQLite

Learn zero-downtime SQLite migrations with expand-migrate-contract pattern. Step-by-step guide with SQL examples. Keep your app running during schema changes.

16-Jan-2024 Read more →
sqlitedatabasesqldatetime

Dealing with datetime in SQLite

Handle datetime in SQLite efficiently with Unix epoch timestamps. Save storage space and convert to local timezone when needed. Complete examples included.

15-Jan-2024 Read more →
postgresqldatabasesqlpsqlcommand-line

Working with PostgreSQL from the Command Line

Harness the Full Potential of Postgres: Command-Line Mastery

10-Jun-2023 Read more →