Databases

• Hstore vs. JSON - Which to Use in Postgres
• Introducing Trinity: a modern, high performance, elegant IR(search) library
• Who Needs MongoDB? Capped Collections in Postgres
• How to migrate a Homebrew-installed PostgreSQL database to a new
• UUID Primary Keys in PostgreSQL
• TimescaleDB - a scalable time-series database on PostgreSQL
• You Are Not Google
• Postgres deadlocks debugging guidelines, tips and tricks
• UUID or GUID as Primary Keys? Be Careful!
• PostgreSQL CHECK Constraint
• PostgreSQL Window Function
• A Tale of Slow Pagination (Schneems)
• PostgreSQL’s Powerful New Join Type: LATERAL
• PostgreSQL Upsert Using INSERT ON CONFLICT statement
• Problems with PostgreSQL 10 for time-series data
• How to delete an enum type value in postgres? (this is not a fun)
• PostgreSQL NATURAL JOIN Explained By Examples
• PostgreSQL Cross Join By Example
• PostgreSQL 10 Queries Table Expressions
• Using Array_agg
• PostgreSQL’s LATERAL JOIN
• What is the difference between LATERAL and a subquery in PostgreSQL?
• The FILTER clause in Postgres
• Postgres Window Functions
• Window Functions in Action
• PostgreSQL: Window Functions
• Metrics Maven: Window Frames in PostgreSQL
• Understanding Window Functions
• Common mistakes: UNION vs. UNION ALL
• PostgreSQL: Views and the Rule System
• Postgres ‘distinct on’
• Postgres 9.3 feature highlight - \watch in psql
• Postgres 9.4 feature highlight - WITH ORDINALITY
• Datomic Data Model
• Postgres Hidden Gems
• Leading with commas — ugly or efficient? An investigation over 320 GB of SQL code
• How to Write a SQL Exclusion Join
• Fun with SQL: generate_series in Postgres
• How to find rows in one table that have no corresponding row in another table
• SELECT DISTINCT ON in PostgreSQL
• Track PostgreSQL Row Changes Using Public/Private Key Signing
• Full-Text Search and Phrase Search
• PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses
• PostGraphile - highly-performant GraphQL API for your PostgreSQL
• Selecting Top N Per Group in PostgreSQL
• Pivot tables using the crosstab()
• Crosstab Query
• Why do we install PostgreSQL as root?
• PostgreSQL 11: What’s New
• PostgreSQL 11: something for everyone
• Postgres 11 - a First Look
• How to Calculate Cumulative Sum/Running Total in PostgreSQL
• Selecting for Share and Update in PostgreSQL
• Materialized views vs. Rollup tables in Postgres
• Preventing SQL Injections (PostgreSQL protocol)
• PostgresSQL: Implicit vs. explicit joins
• Safe Operations For High Volume PostgreSQL
• PostgreSQL 10 identity columns explained
• Gentle Guide to JSONPATH in PostgreSQL
• Comparing Postgres JSONB with NoSQL (2019)
• PostgreSQL: Performance Advantages of C extensions
• PostgreSQL: NULL-Aware Comparison: is [not] distinct from
• A Faster, Lightweight Trigger Function in C for PostgreSQL
• Save PL/pgSQL output from PostgreSQL to a CSV file
• PostgreSQL: You might need to increase max_locks_per_transaction
• My GOTO Postgres Configuration for Web Services
• Isolation Repeatable Read in PostgreSQL versus MySQL
• PostgreSQL: ’text’ vs ‘varchar’ (character varying)
• Embedded SQL in C for PostgreSQL with ecpg
• Advisory Locks and How to Use Them (PostgreSQL)
• How do PostgreSQL advisory locks work
• Postgresql: multicolumn indexes vs single column index
• Understanding recursive queries in PostgreSQL
• Postgres doesn’t use index on integer array if intarray extension is installed
• Explaining Your Postgres Query Performance
• Running Postgres in Docker – why and how?
• Hosting SQLite databases on Github Pages
• Soft deletion with PostgreSQL
• Server-Side SQLite with Litestream
• Many Small Queries Are Efficient In SQLite
• LISTEN / NOTIFY: Automatic client notification in PostgreSQL
• RETURNING Modified Rows
• Query polymorphic tables easier using a view
• PostgreSQL: DELETE vs. TRUNCATE