https://15445.courses.cs.cmu.edu/fall2024/

Xanadu release also adds a Pro tier, along with lots more AI

B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.

Learn data modeling tips while transitioning from Postgres to ClickHouse. Discover how to leverage ClickHouse’s ReplacingMergeTree engine, handle duplicates, and optimize performance using the right Ordering Key and PRIMARY KEY strategies. This guide offe

Learn how we approached migrating our Wafris v1 client based on Redis to a new faster, easier to use SQLite architecture.

We've built a tool to help you compare improvements between Postgres versions: https://pgversions.com

See what you're missing out on by not running Postgres 17 👀

Understand the recommended data types, storage requirements, and pros and cons of each for various use cases

I had an idea... can we automatically infer parameter and return types from a raw SQL query 🤔
Yes we can using PGlite! 🤯
No ORM or query builder, just types generated straight from the SQL string. 🧵

Postgres analytics 10x faster with just an extension?!

Check out our first release of pg_duckdb, an open-source PostgreSQL extension by @hydradatabase & MotherDuck.

It's already packed with awesome features! 👀

https://motherduck.com/blog/pgduckdb-beta…

Web Analytics in the browser with @duckdb WASM: Filtering in milliseconds, instead of waiting for API responses

Key value store using the redis protocol with postgres as a backend.

(not that anyone asked for it)

https://github.com/tidwall/pgred