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