A Guide to PSQL
2026-06-19 • 10 min read • Steve Lloyd
The official command-line interface for PostgreSQL
SCM - Schema Change Manager
2026-05-15 • 12 min read • Steve Lloyd
Plain SQL Migrations for the Databases Everyone Else Ignores
MariaDB vs. MySQL
2026-04-17 • 9 min read • Steve Lloyd
A SQL Developer's Field Guide
PostgreSQL Treasures
2026-03-20 • 13 min read • Steve Lloyd
For developers who thought they knew Postgres.
PuppyGraph
2026-03-13 • 16 min read • Steve Lloyd
Graph Queries on Your Existing Data — No ETL Required
Apache Age
2026-02-20 • 16 min read • Steve Lloyd
The graph database extension that turns PostgreSQL into a multi-model powerhouse
SQL Query Optimization Techniques
2026-01-16 • 21 min read • Steve Lloyd
Rewriting queries for performance, avoiding common pitfalls, using statistics
Memgraph: A Crash Course
2025-12-19 • 13 min read • Steve Lloyd
The open-source, in-memory graph database built for real-time performance
Recursive Queries in SQL
2025-08-22 • 8 min read • Steve Lloyd
null
SQL Window Functions
2025-08-15 • 8 min read • Steve Lloyd
null
Common Table Expressions in SQL
2025-08-08 • 5 min read • Steve Lloyd
The answer to making complex SQL more readable and maintainable
PostgreSQL TOAST: Advanced Storage Optimization
2025-07-11 • 11 min read • Steve Lloyd
Understanding the hidden storage mechanism that could make or break your database performance
DuckDB Crash Course
2025-04-18 • 5 min read • Steve Lloyd
From Big Data to AI Insights: Why DuckDB is Your Essential Tool
Relational Database Differences
2025-04-11 • 5 min read • Steve Lloyd
Comparing MySQL, PostgreSQL, MSSQL, Oracle, Snowflake, SAP HANA, SQLite, and DuckDB
Advanced JSON Querying in PostgreSQL
2025-04-04 • 8 min read • Steve Lloyd
Sophisticated techniques for working with complex JSON structures efficiently
Querying Databases with Python
2025-03-07 • 7 min read • Steve Lloyd
SQLite, MySQL, MSSQL, PostgreSQL, Oracle, SAP HANA, Snowflake, MS Access, Firebird
Describe table in PostgreSQL? Yes we can.
2025-02-21 • 3 min read • Steve Lloyd
Build a custom Describe Table function in postgres using File FDW
Put your tables to REST with Postgres File DFWs
2025-01-31 • 5 min read • Steve Lloyd
Read REST services as a local table using PostgreSQL