postgresql Archives - Page 4 of 9

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

PostgreSQL Database Design Patterns: Polymorphic Association vs EAV vs JSONB for Flexible Schema

June 13, 2026

Comparing Polymorphic Association, EAV, and JSONB in PostgreSQL for flexible schema design — from a real 2 AM production incident. Includes migration guide from EAV to JSONB and practical code examples.

Database

PostgreSQL as a Graph Database: 6 Months with Apache AGE

June 13, 2026

Ditch the complex recursive CTEs. Discover how to use Apache AGE to run openCypher graph queries directly inside your PostgreSQL database for better performance and cleaner code.

Database

Scaling PostgreSQL: A Practical Guide to Pgpool-II Load Balancing and HA

June 8, 2026

Build a resilient PostgreSQL cluster with Pgpool-II. This guide walks through configuring Load Balancing, Watchdog HA, and automated failover to handle traffic spikes without downtime.

Database

Scalable ELT: How We Replaced 2,500 Lines of SQL with dbt and Postgres

June 8, 2026

Ditch the broken stored procedures. Learn how we used dbt and PostgreSQL to turn a 2,500-line SQL nightmare into a modular, tested, and high-performance ELT pipeline.

Programming

Building a Production-Ready REST API with Spring Boot, Spring Security, JPA, and Docker

June 5, 2026

A step-by-step guide to building a secure, production-ready REST API with Spring Boot 3, Spring Security, Spring Data JPA, and Docker. Covers project setup, entity modeling, authentication configuration, Dockerization with multi-stage builds, and production monitoring with Actuator — drawn from real migration experience.

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

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

Scaling PostgreSQL: A Hands-on Guide to YugabyteDB Architecture and Setup

June 1, 2026

PostgreSQL scaling hitting a limit? This guide walks you through setting up YugabyteDB for horizontal scalability and high availability without losing SQL compatibility.

Database

Hardening Multi-tenant Apps: Why You Need PostgreSQL Row Level Security

May 28, 2026

Discover how PostgreSQL Row Level Security (RLS) provides a native, foolproof layer of protection for multi-tenant apps. Stop relying on manual filters and secure your data at the source.