home made oltp just tastes better than store bought
September 24, 2026 at 8:52 PM
home made oltp just tastes better than store bought
October 26, 2025 at 7:51 PM
I wanted to go through the rest of the disaggregated OLTP papers in detail, as I'd missed a few, so I'm re-reading everything and incrementally filling in more papers on transactional.blog/notes-on/dis...
Recent additions are overviews for Aurora Serverless and PolarFS.
Recent additions are overviews for Aurora Serverless and PolarFS.
Notes On: Disaggregated OLTP Systems
Aurora, Socrates, PolarDB, and Taurus.
transactional.blog
February 8, 2025 at 9:03 PM
I wanted to go through the rest of the disaggregated OLTP papers in detail, as I'd missed a few, so I'm re-reading everything and incrementally filling in more papers on transactional.blog/notes-on/dis...
Recent additions are overviews for Aurora Serverless and PolarFS.
Recent additions are overviews for Aurora Serverless and PolarFS.
Why settle for slow?
Our latest interactive blog covers the history of IO devices, how storage works in the cloud, and why separation of storage and compute is bad for OLTP databases.
Our latest interactive blog covers the history of IO devices, how storage works in the cloud, and why separation of storage and compute is bad for OLTP databases.
March 13, 2025 at 4:09 PM
Why settle for slow?
Our latest interactive blog covers the history of IO devices, how storage works in the cloud, and why separation of storage and compute is bad for OLTP databases.
Our latest interactive blog covers the history of IO devices, how storage works in the cloud, and why separation of storage and compute is bad for OLTP databases.
Attending the Rows & Columns Summit in San Francisco today?
*THE* @hannes.muehleisen.org, co-creator of #DuckDB, will give a talk on “Nobody Knows What OLTP Is: DuckDB Moves to the Middle” at 1:30 p.m. (today, Sept 22nd)
We hope to see you there! 🦆 🦆
Sassy abstract and more info here:
*THE* @hannes.muehleisen.org, co-creator of #DuckDB, will give a talk on “Nobody Knows What OLTP Is: DuckDB Moves to the Middle” at 1:30 p.m. (today, Sept 22nd)
We hope to see you there! 🦆 🦆
Sassy abstract and more info here:
Nobody Knows What OLTP Is: DuckDB Moves to the Middle
DuckDB is an in-process SQL database management system focused on analytical query processing. It is designed to be easy to install and easy to use. DuckDB has no external dependencies. DuckDB has bin...
duckdb.org
September 22, 2026 at 4:00 PM
Attending the Rows & Columns Summit in San Francisco today?
*THE* @hannes.muehleisen.org, co-creator of #DuckDB, will give a talk on “Nobody Knows What OLTP Is: DuckDB Moves to the Middle” at 1:30 p.m. (today, Sept 22nd)
We hope to see you there! 🦆 🦆
Sassy abstract and more info here:
*THE* @hannes.muehleisen.org, co-creator of #DuckDB, will give a talk on “Nobody Knows What OLTP Is: DuckDB Moves to the Middle” at 1:30 p.m. (today, Sept 22nd)
We hope to see you there! 🦆 🦆
Sassy abstract and more info here:
Time flies, when you are
Powering OLTP—
TigerBeetle, three!
Powering OLTP—
TigerBeetle, three!
August 29, 2025 at 3:00 PM
Time flies, when you are
Powering OLTP—
TigerBeetle, three!
Powering OLTP—
TigerBeetle, three!
Some folk from software internals discord and I read the series of disaggregated oltp papers and met to talk about them. I wrote an informal overview of the papers and a summary of some of the discussion after each paper: transactional.blog/n...
Notes On: Disaggregated OLTP Systems
Aurora, Socrates, PolarDB, and Taurus.
transactional.blog
December 7, 2024 at 5:52 AM
Some folk from software internals discord and I read the series of disaggregated oltp papers and met to talk about them. I wrote an informal overview of the papers and a summary of some of the discussion after each paper: transactional.blog/n...
Postgres wins as the OLTP database
SQLite wins as the embedded OLTP
DuckDB wins as the embedded OLAP
Perhaps, Postgres wins as the OLAP database?
SQLite wins as the embedded OLTP
DuckDB wins as the embedded OLAP
Perhaps, Postgres wins as the OLAP database?
November 5, 2024 at 4:52 PM
Postgres wins as the OLTP database
SQLite wins as the embedded OLTP
DuckDB wins as the embedded OLAP
Perhaps, Postgres wins as the OLAP database?
SQLite wins as the embedded OLTP
DuckDB wins as the embedded OLAP
Perhaps, Postgres wins as the OLAP database?
OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck
www.cs.cit.tum.de/fi...
www.cs.cit.tum.de/fi...
January 3, 2025 at 7:53 PM
OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck
www.cs.cit.tum.de/fi...
www.cs.cit.tum.de/fi...
Today's Postgres vs. World Seminar Speaker: Marc Brooker (@marcbrooker.bsky.social) will present the architecture of Amazon's Aurora DSQL Postgres-compatible serverless OLTP DBMS. Zoom talk open to public at 4:30pm ET. YouTube video available after: db.cs.cmu.edu/events/pg-vs...
Aurora DSQL: Serverless, Scalable, Global OLTP (Marc Brooker) - Carnegie Mellon Database Group
Amazon Aurora DSQL is a distributed SQL database, designed to make it... Read More +
db.cs.cmu.edu
February 9, 2026 at 1:59 PM
Today's Postgres vs. World Seminar Speaker: Marc Brooker (@marcbrooker.bsky.social) will present the architecture of Amazon's Aurora DSQL Postgres-compatible serverless OLTP DBMS. Zoom talk open to public at 4:30pm ET. YouTube video available after: db.cs.cmu.edu/events/pg-vs...
This paper proposes co-design across the entire stack for modern OLTP engines—from the client and apps, through transaction models and query execution, down to the OS. The main finding is that modern databases often bottleneck on network stack (even for Postgres).
🔗 www.vldb.org/cidrdb/paper...
🔗 www.vldb.org/cidrdb/paper...
March 9, 2025 at 8:13 PM
This paper proposes co-design across the entire stack for modern OLTP engines—from the client and apps, through transaction models and query execution, down to the OS. The main finding is that modern databases often bottleneck on network stack (even for Postgres).
🔗 www.vldb.org/cidrdb/paper...
🔗 www.vldb.org/cidrdb/paper...
Vector database companies will become one of the three
a. Search platforms (e.g., Elastic)
b. AI platform (inference/training/pipeline)
c. OLTP provider (e.g., MongoDB, Postgres)
Hard for vector databases to be a separate offering/company
a. Search platforms (e.g., Elastic)
b. AI platform (inference/training/pipeline)
c. OLTP provider (e.g., MongoDB, Postgres)
Hard for vector databases to be a separate offering/company
December 2, 2024 at 4:44 PM
Vector database companies will become one of the three
a. Search platforms (e.g., Elastic)
b. AI platform (inference/training/pipeline)
c. OLTP provider (e.g., MongoDB, Postgres)
Hard for vector databases to be a separate offering/company
a. Search platforms (e.g., Elastic)
b. AI platform (inference/training/pipeline)
c. OLTP provider (e.g., MongoDB, Postgres)
Hard for vector databases to be a separate offering/company
Read the "BIG DEAL" CIDR'24 paper by Pat Helland. A Snapshot Isolation semantic contract between the database and applications is the BIG DEAL for making OLTP scalable. I really like the core idea of co-optimizing the database and applications.
🔗 www.cidrdb.org/cidr2024/pap...
🔗 www.cidrdb.org/cidr2024/pap...
January 26, 2025 at 8:12 PM
Read the "BIG DEAL" CIDR'24 paper by Pat Helland. A Snapshot Isolation semantic contract between the database and applications is the BIG DEAL for making OLTP scalable. I really like the core idea of co-optimizing the database and applications.
🔗 www.cidrdb.org/cidr2024/pap...
🔗 www.cidrdb.org/cidr2024/pap...
isolation levels em bancos relacionais eh uma feature ANIMAL!! 🙅🏻♀️
mas a GRANDE maioria das aplicações OLTP vivem tranquilamente bem com READ_COMMITED e features como:
- pessimistic locking
- optimistic locking
- atomic UPDATEs e INSERTs
- constraints
- types + indexes
- advisory locks
mas a GRANDE maioria das aplicações OLTP vivem tranquilamente bem com READ_COMMITED e features como:
- pessimistic locking
- optimistic locking
- atomic UPDATEs e INSERTs
- constraints
- types + indexes
- advisory locks
October 18, 2024 at 3:28 AM
isolation levels em bancos relacionais eh uma feature ANIMAL!! 🙅🏻♀️
mas a GRANDE maioria das aplicações OLTP vivem tranquilamente bem com READ_COMMITED e features como:
- pessimistic locking
- optimistic locking
- atomic UPDATEs e INSERTs
- constraints
- types + indexes
- advisory locks
mas a GRANDE maioria das aplicações OLTP vivem tranquilamente bem com READ_COMMITED e features como:
- pessimistic locking
- optimistic locking
- atomic UPDATEs e INSERTs
- constraints
- types + indexes
- advisory locks
Hmm, would there be any value in a shared observability platform for public infra providers on atproto?
Tracking uptime, metrics, etc. OLTP endpoint to sling metrics to? Public dashboards and webhooks for alarms?
Just thinking if aggregating this is valuable and one less thing to maintain.
Tracking uptime, metrics, etc. OLTP endpoint to sling metrics to? Public dashboards and webhooks for alarms?
Just thinking if aggregating this is valuable and one less thing to maintain.
March 30, 2026 at 4:48 PM
Hmm, would there be any value in a shared observability platform for public infra providers on atproto?
Tracking uptime, metrics, etc. OLTP endpoint to sling metrics to? Public dashboards and webhooks for alarms?
Just thinking if aggregating this is valuable and one less thing to maintain.
Tracking uptime, metrics, etc. OLTP endpoint to sling metrics to? Public dashboards and webhooks for alarms?
Just thinking if aggregating this is valuable and one less thing to maintain.
Summer of OLTP continues...
- databricks acquires neon for $1B
- snowflake acquires @crunchydata.com for $250M
- mariaDB (re)acquires @skysql.bsky.social
- temporal acquires crystaldba
- vector (PE firm) buys @singlestore.com
- @supabase.com raising at $5B
turns out everyone needs txns 🙂
- databricks acquires neon for $1B
- snowflake acquires @crunchydata.com for $250M
- mariaDB (re)acquires @skysql.bsky.social
- temporal acquires crystaldba
- vector (PE firm) buys @singlestore.com
- @supabase.com raising at $5B
turns out everyone needs txns 🙂
September 11, 2025 at 4:24 AM
Summer of OLTP continues...
- databricks acquires neon for $1B
- snowflake acquires @crunchydata.com for $250M
- mariaDB (re)acquires @skysql.bsky.social
- temporal acquires crystaldba
- vector (PE firm) buys @singlestore.com
- @supabase.com raising at $5B
turns out everyone needs txns 🙂
- databricks acquires neon for $1B
- snowflake acquires @crunchydata.com for $250M
- mariaDB (re)acquires @skysql.bsky.social
- temporal acquires crystaldba
- vector (PE firm) buys @singlestore.com
- @supabase.com raising at $5B
turns out everyone needs txns 🙂
"...we revisit these assumptions and demonstrate that communication overhead is now the dominant factor affecting OLTP performance" 🚨
OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck
www.cs.cit.tum.de/fi...
www.cs.cit.tum.de/fi...
January 4, 2025 at 2:47 AM
"...we revisit these assumptions and demonstrate that communication overhead is now the dominant factor affecting OLTP performance" 🚨
SQLiteをRustで再実装するプロジェクトらしい。
GitHub - tursodatabase/limbo: Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.
Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite. - tursodatabase/limbo
github.com
December 28, 2024 at 4:05 PM
SQLiteをRustで再実装するプロジェクトらしい。
Today's Postgres vs. World Seminar Speaker: Adam Prout will present the architecture of Microsoft Azure HorizonDB database service based on PostgreSQL. Zoom talk open to public at 4:30pm ET. YouTube video available after: db.cs.cmu.edu/events/pg-vs...
HorizonDB: Co‑Designing PostgreSQL and Azure for Cloud‑Native OLTP (Adam Prout) - Carnegie Mellon Database Group
Azure HorizonDB is a new PostgreSQL service that improves the OLTP performance... Read More +
db.cs.cmu.edu
February 23, 2026 at 12:57 PM
Today's Postgres vs. World Seminar Speaker: Adam Prout will present the architecture of Microsoft Azure HorizonDB database service based on PostgreSQL. Zoom talk open to public at 4:30pm ET. YouTube video available after: db.cs.cmu.edu/events/pg-vs...
Databricks unifies OLTP and OLAP, depending on what counts as a copy
Databricks unifies OLTP and OLAP, depending on what counts as a copy
LTAP architecture does some clever engineering beneath a debatable marketing pitch
www.theregister.com
July 5, 2026 at 4:33 PM
Databricks unifies OLTP and OLAP, depending on what counts as a copy
#LookAndSee #MusicChallenge 🎵🎶
Jour 79 : 𝙅𝙚𝙖𝙣-𝙅𝙖𝙘𝙦𝙪𝙚𝙨 𝙂𝙤𝙡𝙙𝙢𝙖𝙣 "𝙀𝙣𝙫𝙤𝙡𝙚-𝙢𝙤𝙞"
www.youtube.com/watch?v=oltp...
Jour 79 : 𝙅𝙚𝙖𝙣-𝙅𝙖𝙘𝙦𝙪𝙚𝙨 𝙂𝙤𝙡𝙙𝙢𝙖𝙣 "𝙀𝙣𝙫𝙤𝙡𝙚-𝙢𝙤𝙞"
www.youtube.com/watch?v=oltp...
March 5, 2025 at 6:01 AM
#LookAndSee #MusicChallenge 🎵🎶
Jour 79 : 𝙅𝙚𝙖𝙣-𝙅𝙖𝙘𝙦𝙪𝙚𝙨 𝙂𝙤𝙡𝙙𝙢𝙖𝙣 "𝙀𝙣𝙫𝙤𝙡𝙚-𝙢𝙤𝙞"
www.youtube.com/watch?v=oltp...
Jour 79 : 𝙅𝙚𝙖𝙣-𝙅𝙖𝙘𝙦𝙪𝙚𝙨 𝙂𝙤𝙡𝙙𝙢𝙖𝙣 "𝙀𝙣𝙫𝙤𝙡𝙚-𝙢𝙤𝙞"
www.youtube.com/watch?v=oltp...