Twitxy Saved

Pere Diaz

Verified account This account is verified. Learn more

@Peristocles1

Databases @ @supabase. prev @tursodatabase, @ibm and @redhat
cave github.com/pereman2 Joined July 2019
99 Following 251 Followers 660 Posts

Latest posts 5

Pere Diaz Verified account @Peristocles1
Today I'm giving a talk at #P99CONF at 11:45 am PT / 8:45 pm CEST here: p99conf.io.

Sneak peek 👇
Turso Verified account @tursodatabase Oct 22
SQLite allows one writer at a time. Turso’s MVCC engine with BEGIN CONCURRENT removes that limit, and v0.8 is where the performance shows.

p99.9 transaction latency at 32 connections:
SQLite: 1.2 s
Turso: 2.4 ms

@Peristocles1, walks through the architecture behind these numbers at @P99CONF today, 11:45 am PT / 8:45 pm CEST.
View quoted post on X
Pere Diaz Verified account @Peristocles1
I wrote a new blog post about MVCC in @tursodatabase . The post does not focus on one thing in the system but instead follows the life of a row. From birth up to ultimately its death turso.tech/blog/mvcc-row-….
turso.tech Birth and death of a row in Turso's MVCC Follow one row through Turso's MVCC: the INSERT bytecode, the in-memory version store, commit and fsync, log replay, checkpoints, and the final DELETE.
0 replies 7 reposts 59 likes 4.6K views View on X
Pere Diaz Verified account @Peristocles1
Turso v0.8 is out!

Completementary @penberg's post, I deep dived into why our commit path wasn't scaling properly in v0.7 and what it took to achieve 500x lower tail latency.

Check out turso.tech/blog/turso-gro…
0:05
Turso Verified account @tursodatabase Sep 29
1/ SQLite is fast. Until everyone writes at once.

Turso 0.8.0 is out: the performance release. Under concurrent writes, up to 500x lower tail latency and 7x higher write throughput than SQLite. 🧵
View quoted post on X
0 replies 2 reposts 20 likes 6.6K views View on X