Posted inAI
Machine Learning Directly in PostgreSQL: Train and Predict Using SQL
Stop moving data. Learn how to train and deploy XGBoost and Scikit-learn models directly inside PostgreSQL using PostgresML and standard SQL queries.
Posted inDatabase
ERD Design with dbdiagram.io: From Concept to Auto-Generated SQL
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.
Posted inDatabase
DBeaver Guide: Manage PostgreSQL, MySQL, and SQL Server from One Interface
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.
Posted inDatabase
PostgreSQL Encryption at Rest: Protecting Sensitive Data with pgcrypto and Column-level Encryption
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.
Posted inDatabase
Stop Drawing ER Diagrams: How to Automate Database Documentation with SchemaSpy and dbdocs
Stop wasting hours manually drawing ER diagrams that go out of date instantly. Learn how to use SchemaSpy and dbdocs to automate your database documentation directly from your code.
Posted inDatabase
SQLFluff on Linux: Automate SQL Linting and Code Standards in Your CI/CD Pipeline
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.
Posted inDatabase
PostgreSQL Data Tiering: Moving Cold Data to S3 to Slash Costs
Is historical data clogging your PostgreSQL instance? Discover how to use Data Tiering with S3 and Foreign Data Wrappers to reduce costs and maintain high performance.
Posted inDatabase
Postgres Without the Server: Running PGlite in the Browser and Node.js
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.
Posted inDatabase
PostgreSQL Database Design Patterns: Polymorphic Association vs EAV vs JSONB for Flexible Schema
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.
Posted inDatabase
PostgreSQL as a Graph Database: 6 Months with Apache AGE
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.