A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
An interview discussing the importance of PostgreSQL extensions and how they transform it from a relational database into a versatile data platform.
A tutorial on setting up a minimal Django REST API microservice using Docker, PostgreSQL, and Gunicorn for development.
A talk on building a web service with Django and PostgreSQL to manage and aggregate YouTube channel revenue data via Google's APIs.
A guide to tuning PostgreSQL's autovacuum feature, covering internals, configuration, and providing a sample Docker setup.
Announcement and review of 'The Art of PostgreSQL', a book teaching how to replace complex application code with efficient SQL queries.
A technical guide on using SQL GROUP BY with window functions to retrieve the first or last value in a group, using a PostgreSQL event table example.
A technical guide comparing Python methods for efficiently loading and transforming large, messy datasets into a PostgreSQL database.
A technical guide covering PostgreSQL basics, including schemas, user/role management, and SQL commands for permissions.
Explains the index INCLUDE clause in SQL databases, covering its purpose, how it works with B-tree indexes, and when to use it for performance.
A guide to creating database indexes in Django without causing downtime, covering atomic migrations and raw SQL.
An article arguing that SQL is one of the most valuable and enduring technical skills across various roles like engineering and product management.
A tutorial on building a CRUD API using Node.js, gRPC, and PostgreSQL, covering service definition, server/client setup, and Protocol Buffers.
An overview of the backup and redundancy strategies used for the sr.ht software forge, focusing on PostgreSQL, ZFS, and data integrity.
A step-by-step tutorial for installing and setting up PostgreSQL 11 on a Windows operating system.
A technical deep dive into solving PostgreSQL disk space issues by optimizing a deduplication query, focusing on reducing sort key size.
A tutorial on building a REST API using Node.js, Express, and PostgreSQL, covering setup, database connection, and server configuration.
A critique of PostgreSQL's name change from Postgres to PostgreSQL, arguing it caused persistent pronunciation confusion and was a major mistake.
A preview of PostgreSQL 11's key new features, including usability improvements, safer column additions, and performance enhancements like JIT compilation.
Explains a performance pitfall with Common Table Expressions (CTEs) in PostgreSQL versions 11 and earlier, showing how they can disable query optimization.
