Database Archives - Page 2 of 13 - ITFROMZERO

Real-Time Without a Message Broker: Leveraging PostgreSQL LISTEN and NOTIFY with WebSockets

By IT From Zero October 15, 2026

Is your infrastructure overwhelmed by relentless polling and bulky message brokers? Leverage PostgreSQL's built-in LISTEN/NOTIFY alongside WebSockets to build a sleek, transaction-safe, and resource-efficient real-time notification system.

Database

Mastering Drizzle ORM with TypeScript and PostgreSQL: Type-Safe, Ultra-Lightweight, and High-Performance

By IT From Zero October 9, 2026

A practical guide to Drizzle ORM with TypeScript and PostgreSQL: designing type-safe schemas, configuring migrations with Drizzle Kit, and optimizing query performance.

Security

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.