database Archives - Page 3 of 8

SQLFluff on Linux: Automate SQL Linting and Code Standards in Your CI/CD Pipeline

June 15, 2026

SQLFluff is a SQL linter and auto-formatter for Linux that catches style inconsistencies, enforces keyword casing, and integrates cleanly into GitHub Actions and GitLab CI pipelines. This guide walks through installation, configuration for MySQL/PostgreSQL dialects, CI/CD setup, and practical tips for rolling it out to an existing codebase.

Database

Postgres Without the Server: Running PGlite in the Browser and Node.js

June 15, 2026

Run a full PostgreSQL engine inside your browser or Node.js with PGlite. No server, no Docker, and sub-100ms startup times for local-first apps and testing.

Database

Scaling Real-time Leaderboards to 10M+ Users with Redis Sorted Sets

June 13, 2026

Is your database struggling with ranking millions of users? Learn how we migrated to Redis Sorted Sets to achieve sub-millisecond leaderboard updates at scale.

Programming

Type-safe SQL Queries with Kysely: The Lightweight Alternative to Bulky ORMs

June 9, 2026

Kysely offers the power of raw SQL with the safety of TypeScript. Learn how to replace heavy ORMs with a lightweight, type-safe query builder for your Node.js projects.

Database

Deploy FerretDB on Docker: MongoDB-Compatible Open Source Database Built on PostgreSQL

June 5, 2026

FerretDB is an open-source proxy that lets you use MongoDB drivers and tooling while storing data in PostgreSQL — Apache 2.0 licensed, no SSPL. This guide covers deploying FerretDB with Docker Compose, connecting via mongosh and PyMongo, and knowing when it's the right fit for your stack.

Database

Native MySQL High Availability: A Practical Guide to InnoDB Cluster and Router

June 4, 2026

Ditch the complex third-party HA tools. This guide shows you how to deploy a native MySQL InnoDB Cluster with MySQL Router for automated failover and zero data loss.

Database

Scaling Beyond Redis: A Hands-On Guide to DragonflyDB

June 2, 2026

Redis is fast, but its single-threaded nature wastes modern multi-core power. This guide shows you how to migrate to Dragonfly to achieve significantly higher throughput with less architectural complexity.

Database

SQL Joins in Production: How We Fixed Our 10-Second Query Problem

June 1, 2026

A production-focused guide to SQL Joins. Learn the differences between INNER, LEFT, and FULL OUTER joins, and discover how to optimize query performance using indexing and CTEs based on real-world experience.

Database

Turso and libSQL: Scaling Distributed Databases to the Edge

May 31, 2026

Reduce latency in Edge and Serverless apps by deploying Turso and libSQL. Learn about distributed database architecture, global replication, and native vector search.

Database

Why SurrealDB is the Only Database You Need for Your Next Project

May 30, 2026

Tired of syncing SQL and NoSQL? Learn how SurrealDB combines document, graph, and relational models into one ultra-fast database with built-in auth and real-time queries.