Relational databases with Postgres
111 items
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
2012IEEE Annals of the History of Computing
Paper
The story of pgAdmin
Dave Page
2014pgsnake.blogspot.com
Article
pgAdmin 3 is still better than pgAdmin 4
Vladimir Nicolici
2017postgresql.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
2015Lucidchart
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
2016Pearson
Book
EXPLAIN
Postgres documentation
Article
Meet the man behind the most important tool in data science
Dan Kopf
2017Quartz
Article
Scaling Postgres with Read Replicas & Using WAL to Counter Stale Reads
qz.com
Article
Monitoring Cassandra at Scale
Joseph Lynch
2016Monitoring Cassandra at Scale
Article
Why you should never, ever, ever use MongoDB
2015cryto.net
Article
Patterns of Distributed Systems
Unmesh Joshi
2021martinfowler.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
2020engineering.atspotify.com
Article
How Spotify Optimized the Largest Dataflow Job Ever for Wrapped 2020
2021engineering.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
2020Cockroach 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
1984SGMD
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
2018Making 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