Database Archives - ITFROMZERO - Share tobe shared!

Securing PostgreSQL Server on Linux: Hands-on with pg_hba.conf, pgcrypto, and pgaudit

By IT From Zero October 6, 2026

Protect PostgreSQL on Linux across 3 layers: restrict IPs with pg_hba.conf, encrypt sensitive columns with pgcrypto, and audit logs for SOC2/PCI-DSS with pgaudit.

Database

Securing SQLite Data with SQLCipher: A Comprehensive Encryption Guide for Desktop and Mobile

By IT From Zero October 6, 2026

A comparison of 3 local database security approaches and a comprehensive guide to SQLite encryption using SQLCipher (AES-256), with Python code, key storage tips, and WAL optimization.

Database

Automating PostgreSQL Partitioning with pg_partman: A Lifesaver for Terabyte-Scale Tables

By IT From Zero September 26, 2026

Is your massive PostgreSQL table slowing down queries? Learn how to automate partitioning with pg_partman to manage billions of records and automate data cleanup.

Development

Kysely: A Query Builder Alternative to Prisma and TypeORM for TypeScript Projects

By IT From Zero September 21, 2026

Kysely is the perfect alternative to Prisma and TypeORM. Learn how to build a high-performance Type-safe SQL Query Builder, reduce server RAM, and optimize your Node.js development workflow.

Database

Mastering Database Seeding: Best Practices for Smart and Secure Mock Data

By IT From Zero September 21, 2026

Database Seeding is more than just generating junk data. Learn about Factory Patterns, Deterministic Seeding, and how to protect Production data for professional developers.

Database

Designing Polymorphic Relationships in SQL: 3 Architectures from Production Experience

By IT From Zero September 21, 2026

Learn how to design efficient Polymorphic relationships in SQL. Compare 3 common methods and discover index optimization tips for high-scale systems.

MySQL

Deploying MySQL NDB Cluster: A “Zero Downtime” Database Solution for 99.999% Uptime Systems

By IT From Zero September 18, 2026

Learn how to deploy MySQL NDB Cluster to achieve 99.999% uptime. This article provides a detailed guide from Docker setups and the 3-node architecture to RAM and network infrastructure tips for DevOps/DBA engineers.

Database

Odyssey: The Ultimate Solution to Save PostgreSQL from Bottlenecks at Scale

By IT From Zero September 17, 2026

Switch from PgBouncer to Odyssey to leverage multi-threaded power for PostgreSQL. A detailed guide on optimizing configurations to handle tens of thousands of concurrent connections in enterprise environments.

Database

Unit Testing for PostgreSQL with pgTAP: Don’t Let the Database Be a ‘Blind Spot’ During Deployment

By IT From Zero September 13, 2026

Don't let database errors ruin your project. Learn how to use pgTAP to professionally automate schema, function, and trigger testing for PostgreSQL.

Database

Dolt: When Databases Marry Git – An A-Z Guide to Data Version Control

By IT From Zero September 13, 2026

Dolt is the first SQL database that lets you commit, branch, and merge data just like Git. Learn how Dolt solves data versioning and safety challenges in this article.