Overview of new PostgreSQL 9.4 features, focusing on the performance benefits of JSONB for document storage and the introduction of logical decoding.
A technical guide on using SQL window functions, specifically LAG, to calculate month-over-month revenue growth percentages for SaaS or recurring billing analysis.
A developer's perspective on missing features in PostgreSQL 9.4, focusing on upsert, JSON performance, and extension management.
A first look at PostgreSQL 9.4's new features, including pg_prewarm, concurrent materialized view refresh, and ordered set aggregates.
Explores how relational databases like PostgreSQL can adopt benefits from NoSQL, such as schemaless flexibility and JSON document storage.
A developer's side project to analyze PyPI download logs, extracting insights about Python versions, installers, and operating systems used by package consumers.
A guide to using PostgreSQL Foreign Data Wrappers (FDWs) to access remote data as if it were local tables, including setup and performance tips.
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.
