Database – ITFROMZERO – Share tobe shared!

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

Apache Doris Setup and Usage Guide: Building a Real-Time Data Warehouse and Analytics Dashboard

By IT From Zero October 3, 2026

A comprehensive guide to deploying a distributed data warehouse with Apache Doris. Learn MPP architecture, Aggregate/Unique table design, Stream Load ingestion, and real-time dashboard optimization.

Database

A Guide to pgBackRest for PostgreSQL: Parallel Backups, S3 Compression, and PITR

By IT From Zero October 2, 2026

Real-world incident response for accidental production data loss at midnight with pgBackRest: Multi-threaded S3 backups and precise Point-in-Time Recovery (PITR).

Database

Defeating SQL Injection in MySQL Production using ProxySQL Firewall

By IT From Zero September 26, 2026

A guide to configuring ProxySQL Firewall for MySQL Production. Learn how to use Query Rules to block SQL Injection and set up secure query whitelisting.

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.

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.

Database

10ms Search Autocomplete: Mastering Redis Sorted Sets

By IT From Zero September 20, 2026

Stop using SQL LIKE for search features. Learn how to leverage Redis Sorted Sets to build an autocomplete system with sub-10ms response times.

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

Bringing SQLite to Production: Optimizing WAL Mode and Synchronous for Real-World Loads

By IT From Zero September 16, 2026

SQLite is far from weak if you know how to configure it. Learn how to optimize WAL Mode, Synchronous, and Cache to handle thousands of transactions per second in production environments.