Explains how to use PostgreSQL's CTEs (WITH clauses) to write more readable, composable, and maintainable SQL queries.
A guide to using JSON operators and functions in PostgreSQL 9.3, covering data extraction and manipulation from stored JSON.
An analysis of PostgreSQL's documentation strengths and gaps, proposing improvements for onboarding, tutorials, and developer guides.
Explains how to use PostgreSQL Foreign Data Wrappers (FDWs) to query and join data from external sources directly within a Postgres database.
Explains PostgreSQL's dollar quoting feature for handling string literals, including nested quoting and security considerations.
Explains how to use PostgreSQL's COMMENT feature to document tables, columns, and SQL for better data understanding and maintenance.
Compares hstore and JSON data types in PostgreSQL, discussing their features, limitations, and use cases for schema-less data storage.
A tutorial on using PostgreSQL's crosstab function to pivot data directly in SQL, enabling easier analysis without external tools.
A guide to using JavaScript functions within PostgreSQL for JSON data manipulation, featuring examples and code snippets.
A guide to using EXPLAIN and EXPLAIN ANALYZE in PostgreSQL, including JSON output and visualization tools for query execution plans.
A collection of practical tips and guides for effective indexing in PostgreSQL, covering unused indexes, costs, and performance considerations.
Explains how to use PostgreSQL expression and functional indexes to optimize queries using built-in functions or custom JavaScript functions.
A developer shares common SQL bad habits like using column numbers in ORDER BY, implicit joins, and lacking comments, with examples and better practices.
A guide to using PostgreSQL's array_agg function to efficiently aggregate and format data, avoiding manual application-level processing.
Explains how to fix Django's default per-request database connection behavior to improve performance via connection pooling.
A guide to scaling database reads in Rails using replica databases and the ar-octopus gem, avoiding the complexity of full sharding.
A guide to customizing and enhancing the PostgreSQL command-line interface (psql) for improved productivity and workflow.
A developer shares his preferred method for working with PostgreSQL, advocating for the psql command-line tool and sharing key tips and configurations.
A guide to optimizing PostgreSQL queries using pg_stat_statements, focusing on analyzing query performance and improving indexes.
A guide to database sharding, explaining what it is, why it's needed, and how to implement logical and physical shards for scaling.
