database Archives - Page 4 of 7

Deploying TiDB on Docker: Scaling HTAP with a Distributed NewSQL Database

May 12, 2026

Struggling with MySQL scaling or slow analytical queries? Learn how to deploy TiDB on Docker to leverage distributed NewSQL and HTAP capabilities, allowing you to handle transactions and real-time analytics in a single, MySQL-compatible database.

Database

Mastering Database Branching with Neon: No More 2 AM Production Disasters

May 10, 2026

Tired of production migrations failing due to 'data gaps'? Discover how Neon's database branching lets you test against real production data in isolated, instant environments.

Database

PostgreSQL Disaster Recovery: Why You Need Barman When Your Database Dies at 2 AM

May 10, 2026

A professional guide to PostgreSQL Disaster Recovery. Learn why pg_dump is insufficient for production and how to implement Barman for sub-minute data recovery.

Database

Ditch SQL ‘LIKE’: Building 50ms Search-as-you-type with Meilisearch

May 9, 2026

Is your web app's search dragging? Replace sluggish SQL LIKE queries with Meilisearch to build ultra-fast, typo-tolerant search-as-you-type experiences in minutes.

Database

Scaling IoT to Billions of Points: A 6-Month InfluxDB Field Report

May 9, 2026

Real-world lessons from migrating 1,200 IoT sensors from PostgreSQL to InfluxDB. Learn why B-Trees fail at scale and how downsampling can reduce your storage costs by 85%.

Database

Dolt Guide: SQL with Git Powers for Versioned Development

May 8, 2026

Dolt brings Git-like versioning to the SQL world. Learn how to branch, diff, and merge your data to prevent accidental loss and streamline collaborative development.

Database

PostgreSQL Materialized Views: Turning 15-Second Queries into 5ms Snapshots

May 4, 2026

Stop making your users wait for slow dashboards. This guide shows you how to cache complex PostgreSQL queries using Materialized Views, including concurrent refresh tricks and automation.

Linux

Linux Performance: Kill the TLB Bottleneck with Huge Pages

May 3, 2026

Slash Linux kernel overhead by 5% or more. This technical guide explains how to implement Static Huge Pages to boost performance for PostgreSQL, Redis, and AI workloads.

Database

PostgreSQL Logical Replication: Selective Data Sync Without Downtime (6-Month Production Review)

May 3, 2026

A 6-month production review of PostgreSQL Logical Replication. Learn how to offload 40% of database load, handle selective syncing, and avoid common schema and disk space pitfalls.

Database

Apache Cassandra Deployment Guide: NoSQL for High Availability and Write-Heavy Workloads

May 1, 2026

Apache Cassandra is the go-to database when you need to handle massive write throughput without a single point of failure. This guide walks through deploying a 3-node cluster, designing tables around your query patterns, and tuning Cassandra for real production workloads.