Relational databases with Postgres
computing > software engineering > programming languages > SQL
, 
computing > databases > Postgres

Introduction to relational databases with the open source Postgres database server.
Postgres
The Difference Between WHERE and HAVING
sql-bits.com
ARTICLE
SQL injection
Randall Munroe
xkcd.com
ARTICLE
SQL Horror Stories
Reddit
ARTICLE
Sharding and IDs at Instagram
Instagram
ARTICLE
Is PostgreSQL good enough?
René Dudfield
renesd.blogspot.com
ARTICLE
The Art Of SQL
Stephane Faroult
OReilly
BOOK
Chapter 1: Before the Advent of Database Systems
opentextbc.ca
BOOK
A Timeline of Database History
Quickbase
ARTICLE
Databases and data capture
BBC
ARTICLE
History of Databases
Avant.org
ARTICLE
Early History of SQL
Donald D. Chamberlin
2012 IEEE Annals of the History of Computing
PAPER
The story of pgAdmin
Dave Page
2014 pgsnake.blogspot.com
ARTICLE
pgAdmin 3 is still better than pgAdmin 4
Vladimir Nicolici
2017 postgresql.org
ARTICLE
Querying a Table
Postgres documentation
ARTICLE
The Art Of PostgreSQL
Dimitri Fontaine
theartofpostgresql.com
BOOK
Architectural fundamentals
Postgres documentation
ARTICLE
Aggregate functions
Postgres documentation
ARTICLE
SELECT
Postgres documentation
ARTICLE
Sorting Rows (ORDER BY)
Postgres documentation
ARTICLE
The worst mistake of computer science
Paul Draper
2015 Lucidchart
ARTICLE
Data types
Postgres documentation
ARTICLE
SQL Outer Joins for Fun and Profit
Bill Karwin
slideshare.net
ARTICLE
PostgreSQL: Subqueries
techonthenet.com
ARTICLE
Subquery Expressions
Postgres documentation
ARTICLE
WITH Queries (Common Table Expressions)
Postgres documentation
ARTICLE
CREATE VIEW
Postgres documentation
ARTICLE
View (SQL)
Wikipedia
ARTICLE
CREATE INDEX
Postgres documentation
ARTICLE
VACUUM
Postgres documentation
ARTICLE
ANALYZE
Postgres documentation
ARTICLE
Fundamentals of Database Systems
Ramez Elmasri
2016 Pearson
BOOK
EXPLAIN
Postgres documentation
ARTICLE
Meet the man behind the most important tool in data science
Dan Kopf
2017 Quartz
ARTICLE
Scaling Postgres with Read Replicas & Using WAL to Counter Stale Reads
qz.com
ARTICLE
Monitoring Cassandra at Scale
Joseph Lynch
2016 Monitoring Cassandra at Scale
ARTICLE
Why you should never, ever, ever use MongoDB
2015 cryto.net
ARTICLE
Patterns of Distributed Systems
Unmesh Joshi
2021 martinfowler.com
ARTICLE
CockroachDB's consistency model
cockroachlabs.com
ARTICLE
I don't want to shard (MySQL)
hackmysql.com
ARTICLE
Postgres 15 improves UNIQUE and NULL
blog.rustprooflabs.com
ARTICLE
Column order in PostgreSQL does matter
Cybertec
ARTICLE
The History of Slonik, the PostgreSQL Elephant Logo
vertabelo.com
ARTICLE
What is the new LZ4 TOAST compression in PostgreSQL 14, and how fast is it?
postgresql.fastware.com
ARTICLE
PostgreSQL execution plan visualizer
explain.dalibo.com
ARTICLE
sql - Bulk/batch update/upsert in PostgreSQL - Stack Overflow
stackoverflow.com
ARTICLE
The Internals of PostgreSQL : Chapter 3 Query Processing
interdb.jp
ARTICLE
Postgres Indexes for Newbies
crunchydata.com
ARTICLE
The Internals of PostgreSQL : Introduction
interdb.jp
ARTICLE
HAVING, a less-understood SQL clause
smallthingssql.com
ARTICLE
Real-world case studies
What's the most complex SQL query you ever wrote?
Quora
ARTICLE
How we upgraded our Postgres database
retool.com
ARTICLE
Why Uber Engineering Switched from Postgres to MySQL
Uber
ARTICLE
A PostgreSQL response to Uber
Postgres
ARTICLE
How a race condition took down Flexcoin
vladmihalcea.com
ARTICLE
Spotify Unwrapped: How we brought you a decade of data
2020 engineering.atspotify.com
ARTICLE
How Spotify Optimized the Largest Dataflow Job Ever for Wrapped 2020
2021 engineering.atspotify.com
ARTICLE
Distributed systems
Some notes on the DynamoDB 2022 paper
_.0xffff.me
ARTICLE
How SQLite Scales Read Concurrency
fly.io
ARTICLE
SQL Critique 40 Years Later
carlineng.com
ARTICLE
Why CockroachDB and PostgreSQL Are Compatible
Raphael Poss
2020 Cockroach Labs
ARTICLE
A Critique of SQL, 40 Years Later | Hacker News
news.ycombinator.com
ARTICLE
How to build a dynamic distributed database with DistSQL
opensource.com
ARTICLE
How the SQLite Virtual Machine Works · Fly
fly.io
ARTICLE
How does database sharding work?
planetscale.com
ARTICLE
Transactions and Concurrency in Postgresql
doadm-notes.blogspot.com
ARTICLE
PostgreSQL Logical Replication Gotchas - pgDash
pgdash.io
ARTICLE
Transactions Are Not Locks
benburwell.com
ARTICLE
Optimistic concurrency control
en.wikipedia.org
ARTICLE
Consistency models
jepsen.io
ARTICLE
Designing a Distributed SQL Engine: Challenges & Decisions
en.oceanbase.com
ARTICLE
Opinion pieces
Does anyone else think SQL needs help?
Hacker News
ARTICLE
A Critique of SQL, 40 Years Later
Carlin Eng
carlineng.com
ARTICLE
A critique of the SQL database language
C. J. Date
1984 SGMD
PAPER
Debugging the Postgres query planner
gocardless.com
ARTICLE
The journey unifying data lake and data warehouse
medium.com
ARTICLE
Database as a Symbolic Form - Manovich
mfj-online.org
ARTICLE
Features I'd like in PostgreSQL | Gil's LotD
gilslotd.com
ARTICLE
Ask HN: Books on designing disk-optimized data structures?
Hacker News
ARTICLE
When did Postgres become cool?
crunchydata.com
ARTICLE
Explaining the Postgres meme
avestura.dev
ARTICLE
Advanced optimisation
Materialized View: SQL Queries on Steroids | Dinesh Gowda
dinesh.wiki
ARTICLE
Databases in 2022: A Year in Review - OtterTune
ottertune.com
ARTICLE
01 - Relational Model & Relational Algebra (CMU Intro to Database Systems / Fall 2022) - YouTube
youtube.com
VIDEO
Multithreaded Scatter-Gather Execution Model for Analytical Queries
puzpuzpuz.dev
ARTICLE
Looking back at Postgres
J. Hellerstein
2018 Making Databases Work
PAPER
The Design of Postgres
Stonebraker
PAPER
Use On-conflict to Upsert in PostgreSQL - Jon Meyers
jonmeyers.io
ARTICLE
Migrating from Relational Databases to Time Series Databases
itnext.io
ARTICLE
Understanding database Indexes in PostgreSQL
blog.mastermind.dev
ARTICLE
Working with a JSONB Array of Objects in PostgreSQL
levelup.gitconnected.com
ARTICLE
How Postgres Triggers Can Simplify Your Backend Development | The Mythical Engineer
themythicalengineer.com
ARTICLE
Nine ways to shoot yourself in the foot with PostgreSQL
philbooth.me
ARTICLE
The Part of PostgreSQL We Hate the Most | OtterTune
ottertune.com
ARTICLE
Announcing vector support in PostgreSQL services to power AI-enabled applications
cloud.google.com
ARTICLE
Postgres full text search engine
xata.io
ARTICLE
How to Check 2 SQL Tables are the Same
github.com
ARTICLE
Query Engines: Push vs. Pull
justinjaffray.com
ARTICLE
Jailer
github.com
ARTICLE
How we reduced the cost of building Twitter at Twitter-scale by 100x – Blog
blog.redplanetlabs.com
ARTICLE
WHAT IS THE N+1 QUERY PROBLEM AND HOW TO DETECT IT?
digma.ai
ARTICLE
Optimizing Postgres's Autovacuum for High-Churn Tables
tembo.io
ARTICLE
How Query Engines Work
howqueryengineswork.com
ARTICLE
Extensions
pg_bm25: Elastic-Quality Full Text Search Inside Postgres - ParadeDB
docs.paradedb.com
ARTICLE
Versioning data in Postgres? Testing a Git like approach
news.ycombinator.com
ARTICLE
Create a text search engine with Postgres
xata.io
ARTICLE
My PostgreSQL wishlist
ryanguill.com
ARTICLE
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service
gds.blog.gov.uk
ARTICLE
What is SKIP LOCKED for in PostgreSQL 9.5? - 2ndQuadrant | PostgreSQL
2ndquadrant.com
ARTICLE
Transaction Isolation Levels With PostgreSQL as an example
mkdev.me
ARTICLE
Choose Postgres queue technology :: Adriano Caloiaro's personal blog
adriano.fyi
ARTICLE
Choose Postgres queue technology | Hacker News
news.ycombinator.com
ARTICLE
Inngest - Build reliable products - Durable workflow engine
inngest.com
ARTICLE
When does Postgres stop being good enough for full text search?
blog.meilisearch.com
ARTICLE
[2312.00638] What if an SQL Statement Returned a Database?
arxiv.org
ARTICLE
Are You Sure You Want to Use MMAP in Your DBMS?
symas.com
ARTICLE
Database Fundamentals
tontinton.com
ARTICLE
Is something bugging you?
antithesis.com
ARTICLE
foundationdb.org
ARTICLE
An Overview of Distributed PostgreSQL... | Crunchy Data Blog
crunchydata.com
ARTICLE
My Notes on GitLab Postgres Schema Design – Shekhar Gulati
shekhargulati.com
ARTICLE
Revolutionizing PostgreSQL Schema Changes with pg_osc - Mydbops | Blog
mydbops.com
ARTICLE
tembo-io/pg_vectorize: The simplest way to orchestrate vector search on Postgres
github.com
ARTICLE
The CAP Theorem. The Bad, the Bad, & the Ugly | Dominik Tornow
blog.dtornow.com
ARTICLE
Unexplanations: sql is syntactic sugar for relational algebra
scattered-thoughts.net
ARTICLE
The Great Migration from MongoDB to PostgreSQL
infisical.com
ARTICLE
The Great Migration from MongoDB to PostgreSQL : r/programming
reddit.com
ARTICLE
Features I wish PostgreSQL had as a developer
bytebase.com
ARTICLE
great_tables - The Design Philosophy of Great Tables
posit-dev.github.io
ARTICLE
GitHub - stackframe-projects/pgmock: In-memory Postgres for unit/E2E tests
github.com
ARTICLE
Why Has Figma Reinvented the Wheel With PostgreSQL? | by Denis Magda | Mar, 2024 | Medium
medium.com
ARTICLE
Heath's Theorem • Buttondown
buttondown.email
ARTICLE
Robert Haas: Praise, Criticism, and Dialogue
rhaas.blogspot.com
ARTICLE
Robert Haas: Hacking on PostgreSQL is Really Hard
rhaas.blogspot.com
ARTICLE
How not to change PostgreSQL column type | boringSQL
notso.boringsql.com
ARTICLE
GitHub - fabianlindfors/reshape: An easy-to-use, zero-downtime schema migration tool for Postgres
github.com
ARTICLE
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
github.com
ARTICLE
GitHub - tembo-io/pgmq: A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
github.com
ARTICLE
Making a Postgres query 1,000 times faster - Mattermost
mattermost.com
ARTICLE
That time PostgreSQL said "no thanks, I don't need your index"
jaywhy13.hashnode.dev
ARTICLE
How to Collapse Your Stack Using PostgreSQL for Everything
timescale.com
ARTICLE
SQL is now 50! What is coming next to the query language?
coderoasis.com
ARTICLE
You'll regret using natural keys
blog.ploeh.dk
ARTICLE
How to Get the Most out of Postgres Memory Settings | Tembo
tembo.io
ARTICLE
SQL Workbench - Rapid prototyping SQL Queries & Data Visualizations
sql-workbench.com
ARTICLE
The Part of PostgreSQL We Hate the Most // Blog // Andy Pavlo - Carnegie Mellon University
cs.cmu.edu
ARTICLE
FireDucks : Pandas but 100x faster | *ฅ^•ﻌ•^ฅ* ✨✨  HWisnu's blog  ✨✨ о ฅ^•ﻌ•^ฅ
hwisnu.bearblog.dev
ARTICLE
Spanner: Always-on, virtually unlimited scale database | Google Cloud
cloud.google.com
ARTICLE
dbi Blog
dbi-services.com
ARTICLE
Glassdb: transactional object storage | mbrt blog
blog.mbrt.dev
ARTICLE
Consistency  |  Cloud Storage  |  Google Cloud
cloud.google.com
ARTICLE
What write skew looks like
cockroachlabs.com
ARTICLE
Demo - Exploring the TPC-DS Dataset | Trilogy
trilogydata.dev
ARTICLE
Announcing rust-query by LHolten
blog.lucasholten.com
ARTICLE
GitHub - circlemind-ai/fast-graphrag: RAG that intelligently adapts to your use case, data, and queries
github.com
ARTICLE
Database Architects: Advent of Code 2024 in pure SQL
databasearchitects.blogspot.com
ARTICLE
AdventureWorks Data Dictionary | Microsoft Learn
learn.microsoft.com
ARTICLE
lorint/AdventureWorks-for-Postgres: Set up the AdventureWorks sample database for use with Postgres
github.com
ARTICLE
Passing parameters to SQL queries - psycopg 3.3.0.dev1 documentation
psycopg.org
ARTICLE
How Does PostgreSQL Store Your Data?
stokerpostgresql.blogspot.com
ARTICLE
Build a Database in 3000 Lines with 0 Dependencies | Blog | build-your-own.org
build-your-own.org
ARTICLE
Best way to create a PostgreSQL replica for disaster recovery (on-premise)? : r/PostgreSQL
reddit.com
ARTICLE
file:
ARTICLE
marcelofern.com
ARTICLE
Use PASSING with JSON_TABLE() To Make Calculations
stokerpostgresql.blogspot.com
ARTICLE
Blade Runner Inspired Office Build: Deckard's Apartment | Page 29 | RPF Costume and Prop Maker Community
therpf.com
ARTICLE
Learning Pathways is a free service
Terms of use Privacy policy
Education Research
Contact us Join our mailing list