Database Archives - Page 4 of 15

Time Travel in SQL: Using Temporal Tables in MariaDB and PostgreSQL

July 12, 2026

Don't let accidental updates ruin your night. Discover how to implement 'Time Travel' queries in MariaDB and PostgreSQL to recover data instantly and automate your audit trails.

Database

Beyond Schema Migrations: Mastering MySQL Document Store with X DevAPI

July 12, 2026

Transform MySQL into a powerful NoSQL database. Learn how to use the X DevAPI to manage JSON collections, perform schema-less CRUD, and join NoSQL data with SQL tables.

Database

Fast, Typo-Tolerant Search with Typesense and Docker: The Lightweight Elasticsearch Alternative

July 12, 2026

Is Elasticsearch too heavy for your project? Discover how to set up Typesense with Docker for an ultra-fast, typo-tolerant search experience that won't crash your server.

Database

Hasura GraphQL Engine: Auto-Generate GraphQL API from PostgreSQL Without Writing Backend Code

July 1, 2026

After six months running Hasura GraphQL Engine in production, it's replaced the bulk of hand-written CRUD code in our PostgreSQL-backed projects. This guide covers setup with Docker, row-level security without middleware, and realtime subscriptions — all without writing a single backend resolver.

Database

pg_cron: Schedule PostgreSQL Tasks Inside the Database Without OS Cron

June 28, 2026

pg_cron is a PostgreSQL extension that schedules SQL jobs — VACUUM, data archiving, threshold notifications — directly inside the database as a background worker. No external cron, no credential sprawl, no silent failures. This guide covers installation, three real-world use cases, and the practices that keep pg_cron solid in production.

Database

PostgreSQL pg_trgm: Build Fuzzy Search, Typo-Tolerant Queries, and Autocomplete with Trigram Indexes

June 28, 2026

Learn how to use PostgreSQL's pg_trgm extension to build fuzzy search that handles typos, powers autocomplete, and accelerates LIKE queries with trigram indexes. Includes practical GIN index setup, similarity threshold tuning, and hybrid search patterns.

Database

Self-Hosting Apache Superset with Docker: Stop Exporting CSVs and Start Visualizing

June 25, 2026

Ditch expensive BI tools and manual SQL exports. This guide shows you how to deploy Apache Superset on Docker, connect your databases, and optimize performance for a professional dashboard experience.

Database

ERD Design with dbdiagram.io: From Concept to Auto-Generated SQL

June 24, 2026

Jumping straight into SQL without a plan leads to messy schemas that are painful to refactor later. This guide walks through designing an ERD with dbdiagram.io using DBML syntax, then automatically exporting production-ready SQL — no boilerplate required.

Database

DBeaver Guide: Manage PostgreSQL, MySQL, and SQL Server from One Interface

June 24, 2026

Managing PostgreSQL, MySQL, and SQL Server from separate native tools is fine until you're debugging across all three at 2 AM. This guide covers how to set up DBeaver as a single unified interface for all your databases — including SSH tunnels, connection organization, cross-database queries, and data export between database types.

Database

PostgreSQL Encryption at Rest: Protecting Sensitive Data with pgcrypto and Column-level Encryption

June 17, 2026

At 2 AM, database credentials leak far more often than hard drives get stolen — yet most teams rely on full-disk encryption and call it done. This guide walks through the four PostgreSQL encryption approaches, their real-world trade-offs, and a concrete implementation of column-level encryption using pgcrypto to protect sensitive fields even when someone has a valid database session.