i’m sorry but trying to do distributed systems properly makes me hate sqlite so so much 😭
November 6, 2026 at 1:52 AM
i’m sorry but trying to do distributed systems properly makes me hate sqlite so so much 😭
distributed systems is when you put sqlite in ceph
November 6, 2026 at 3:14 AM
distributed systems is when you put sqlite in ceph
sqlite-backed shell history
oppi.li/stinkpot
sqlite-backed shell history
tangled.org
November 6, 2026 at 2:19 AM
sqlite-backed shell history
C vs Rust SQLite extension, AI-optimized
A benchmark showed an AI-optimized custom C function for a SQLite extension beat Rust in speed (19ns vs 41-47ns) while staying tiny (14 KB).
C can still win, especially with an LLM's help.
A benchmark showed an AI-optimized custom C function for a SQLite extension beat Rust in speed (19ns vs 41-47ns) while staying tiny (14 KB).
C can still win, especially with an LLM's help.
November 9, 2026 at 10:03 AM
C vs Rust SQLite extension, AI-optimized
A benchmark showed an AI-optimized custom C function for a SQLite extension beat Rust in speed (19ns vs 41-47ns) while staying tiny (14 KB).
C can still win, especially with an LLM's help.
A benchmark showed an AI-optimized custom C function for a SQLite extension beat Rust in speed (19ns vs 41-47ns) while staying tiny (14 KB).
C can still win, especially with an LLM's help.
his programming language stores programs in sqlite instead of files
November 5, 2026 at 5:12 AM
his programming language stores programs in sqlite instead of files
it also handles conflicting edits, including situations where two people or AI agents change different parts of the same document. works with SQLite, PostgreSQL, and Supabase. www.everydev.ai/tools/sqlit...
SQLite-Sync - SQLite CRDT Offline Sync Tool | EveryDev.ai
SQLite-Sync is a multi-platform SQLite extension that turns any local SQLite database into a conflict-free, offline-first replica. Built by SQLite…
www.everydev.ai
November 9, 2026 at 1:24 AM
it also handles conflicting edits, including situations where two people or AI agents change different parts of the same document. works with SQLite, PostgreSQL, and Supabase. www.everydev.ai/tools/sqlit...
sqlite is literally what made me start vibecoding 😭😭
November 6, 2026 at 3:40 AM
sqlite is literally what made me start vibecoding 😭😭
【ブログ更新・おすすめ記事】
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
November 8, 2026 at 12:04 PM
【ブログ更新・おすすめ記事】
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
【ブログ更新・おすすめ記事】
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
November 8, 2026 at 4:04 AM
【ブログ更新・おすすめ記事】
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
sqlite
sqliteは高負荷には耐えられない
#新ブログ #ブログ #zip358 #Web開発
https://zip358.com/blog/20260725160858
I love that we’re hating on SQLite today
I love SQLite
But I also hate it
I love SQLite
But I also hate it
November 2, 2026 at 1:14 PM
I love that we’re hating on SQLite today
I love SQLite
But I also hate it
I love SQLite
But I also hate it
sqlite solves all your problems. you will certainly not regret running 50m sqlites
it's funny that this is like, Veteran Wisdom, but as a general rule postgres is fine, and if you are using something that is not postgres you had better have a good reason why it's not postgres.
sqlite is fine as long as you know it's small
sqlite is fine as long as you know it's small
there is no reason to make a new database. postgres can do it. if you think postgres can't do it, you just haven't found the right way to enable it in pg_settings yet
November 2, 2026 at 9:40 AM
sqlite solves all your problems. you will certainly not regret running 50m sqlites
i love sqlite but this is sloppy lol
November 3, 2026 at 3:33 AM
i love sqlite but this is sloppy lol
"Most of them won’t call themselves programmers. They won’t know Python. They won’t care whether their app uses React or SQLite. Many of them will never look at the source code. They’ll have an idea, tell a computer what they want, and the computer will make it.
That’s programming."
That’s programming."
What happens when a billion more people can build software?
AI is making programming easier. But building something shouldn't mean giving up control over where it runs or who owns it.
Our CEO @apenwarr.ca on what comes next: tailscale.com/blog/100x-more-programmers?…
AI is making programming easier. But building something shouldn't mean giving up control over where it runs or who owns it.
Our CEO @apenwarr.ca on what comes next: tailscale.com/blog/100x-more-programmers?…
100x more programmers
AI could create a billion new programmers. But who controls what they build? Explore why open infrastructure, simpler networking, and freedom from AI vendor lock-in matter.
https://tailscale.com/blog/100x-more-programmers?…
November 5, 2026 at 6:23 PM
"Most of them won’t call themselves programmers. They won’t know Python. They won’t care whether their app uses React or SQLite. Many of them will never look at the source code. They’ll have an idea, tell a computer what they want, and the computer will make it.
That’s programming."
That’s programming."
jazz-tools v2 alpha.60 is out! 🎷
- Jazz is now based on SQLite
- 20x-600x faster reads
- 4x-30x faster writes
- 10x-35x less RAM use
it’s also the first step of our new goal to make Jazz the easiest modern db to self-host. see our new homepage at jazz.tools for details!
- Jazz is now based on SQLite
- 20x-600x faster reads
- 4x-30x faster writes
- 10x-35x less RAM use
it’s also the first step of our new goal to make Jazz the easiest modern db to self-host. see our new homepage at jazz.tools for details!
November 7, 2026 at 7:52 PM
jazz-tools v2 alpha.60 is out! 🎷
- Jazz is now based on SQLite
- 20x-600x faster reads
- 4x-30x faster writes
- 10x-35x less RAM use
it’s also the first step of our new goal to make Jazz the easiest modern db to self-host. see our new homepage at jazz.tools for details!
- Jazz is now based on SQLite
- 20x-600x faster reads
- 4x-30x faster writes
- 10x-35x less RAM use
it’s also the first step of our new goal to make Jazz the easiest modern db to self-host. see our new homepage at jazz.tools for details!
Interesting… [PDS on SQLite] 🤔
That has actually been pretty bad for us. It’s made the machines hard to move and the backup story is more brittle than a native distributed storage would offer
November 2, 2026 at 1:16 PM
Interesting… [PDS on SQLite] 🤔
You might be able to get away with a fairly straightforward local setup that keeps you away from any complicated storage/retrieval besides backing up a SQLite file
November 9, 2026 at 4:18 PM
You might be able to get away with a fairly straightforward local setup that keeps you away from any complicated storage/retrieval besides backing up a SQLite file
GRDB's `ValueObservation` connects a query to relevant SQLite changes, then fetches fresh values after a matching commit. My article explores how that can drive a UI without extra notifications.
#SwiftLang
https://ivantokar.com/posts/grdb-turning-sqlite-queries-into-live-application-state/
#SwiftLang
https://ivantokar.com/posts/grdb-turning-sqlite-queries-into-live-application-state/
GRDB: Turning SQLite Queries into Live Application State
A source-level look at how GRDB turns SQLite query regions and transaction events into live application state.
ivantokar.com
November 7, 2026 at 7:00 PM
GRDB's `ValueObservation` connects a query to relevant SQLite changes, then fetches fresh values after a matching commit. My article explores how that can drive a UI without extra notifications.
#SwiftLang
https://ivantokar.com/posts/grdb-turning-sqlite-queries-into-live-application-state/
#SwiftLang
https://ivantokar.com/posts/grdb-turning-sqlite-queries-into-live-application-state/
I just published a post going into detail about how the @milieu.cloud sync engine works.
From the server to SQLite to reactive Svelte state
How Milieu starts you on the server, moves into SQLite in your browser without missing a beat, and feeds every query into deeply reactive Svelte state. Offline-first on the web, from the first page lo...
www.milieu.cloud
November 7, 2026 at 5:25 PM
I just published a post going into detail about how the @milieu.cloud sync engine works.
"Most of [people] won’t call themselves programmers. They won’t know Python. They won’t care whether their app uses React or SQLite. Many of them will never look at the source code. They’ll have an idea, tell a computer what they want, & the computer will make it. That’s programming." - @apenwarr.ca
What happens when a billion more people can build software?
AI is making programming easier. But building something shouldn't mean giving up control over where it runs or who owns it.
Our CEO @apenwarr.ca on what comes next: tailscale.com/blog/100x-more-programmers?…
AI is making programming easier. But building something shouldn't mean giving up control over where it runs or who owns it.
Our CEO @apenwarr.ca on what comes next: tailscale.com/blog/100x-more-programmers?…
100x more programmers
AI could create a billion new programmers. But who controls what they build? Explore why open infrastructure, simpler networking, and freedom from AI vendor lock-in matter.
https://tailscale.com/blog/100x-more-programmers?…
November 5, 2026 at 3:30 PM
"Most of [people] won’t call themselves programmers. They won’t know Python. They won’t care whether their app uses React or SQLite. Many of them will never look at the source code. They’ll have an idea, tell a computer what they want, & the computer will make it. That’s programming." - @apenwarr.ca
I still swear by sqlite for one off services that aren't geo-dependent. Our notifications fan-out and email delivery service (deliberi) runs off a sqlite.
Our old appview famously ran on sqlite as well -- but it meant we'd have to do all kinds of clever things to make it run in other geos.
Our old appview famously ran on sqlite as well -- but it meant we'd have to do all kinds of clever things to make it run in other geos.
That has actually been pretty bad for us. It’s made the machines hard to move and the backup story is more brittle than a native distributed storage would offer
November 2, 2026 at 1:08 PM
I still swear by sqlite for one off services that aren't geo-dependent. Our notifications fan-out and email delivery service (deliberi) runs off a sqlite.
Our old appview famously ran on sqlite as well -- but it meant we'd have to do all kinds of clever things to make it run in other geos.
Our old appview famously ran on sqlite as well -- but it meant we'd have to do all kinds of clever things to make it run in other geos.
I rebuilt Aurora-Locus, a Rust PDS, from the ground up. Kryphocron posting is built-in. If you're running the reference PDS, you can switch without your users noticing: same accounts, same passwords, even still logged in.
GitHub - dollspace-gay/Aurora-Locus: Rust ATProto PDS: Kryphocron posting, built-in admin panel, SQLite or Postgres. Imports an existing reference PDS in place, with passwords, logins and firehose pos...
Rust ATProto PDS: Kryphocron posting, built-in admin panel, SQLite or Postgres. Imports an existing reference PDS in place, with passwords, logins and firehose position intact. - dollspace-gay/Auro...
github.com
November 9, 2026 at 1:02 AM
I rebuilt Aurora-Locus, a Rust PDS, from the ground up. Kryphocron posting is built-in. If you're running the reference PDS, you can switch without your users noticing: same accounts, same passwords, even still logged in.
It’s so funny that SQLite is genuinely faster than most traditional filesystems.
I wish there were more experimental operating systems using dbs for the backend. Not many people playing around in this space...
I wish there were more experimental operating systems using dbs for the backend. Not many people playing around in this space...
November 3, 2026 at 1:49 AM
It’s so funny that SQLite is genuinely faster than most traditional filesystems.
I wish there were more experimental operating systems using dbs for the backend. Not many people playing around in this space...
I wish there were more experimental operating systems using dbs for the backend. Not many people playing around in this space...
Release notes:
- Switched from jsDelivr to esm.sh for consistent version resolution. observablehq.com/@observableh...
- Plot has some new options. github.com/observablehq...
- Expanded DuckDB and SQLite support, etc. observablehq.com/@observableh...
- Switched from jsDelivr to esm.sh for consistent version resolution. observablehq.com/@observableh...
- Plot has some new options. github.com/observablehq...
- Expanded DuckDB and SQLite support, etc. observablehq.com/@observableh...
November 6, 2026 at 10:47 PM
Release notes:
- Switched from jsDelivr to esm.sh for consistent version resolution. observablehq.com/@observableh...
- Plot has some new options. github.com/observablehq...
- Expanded DuckDB and SQLite support, etc. observablehq.com/@observableh...
- Switched from jsDelivr to esm.sh for consistent version resolution. observablehq.com/@observableh...
- Plot has some new options. github.com/observablehq...
- Expanded DuckDB and SQLite support, etc. observablehq.com/@observableh...
So, I told SQLite to `mmap_size`
#Sqlite #Performance #Olcum #Guide
https://mustafaerbay.com.tr/en/blog/tutorials/mmap-size-a-8-gib-yazdim-dort-kutuphane-iki-sayi-dondurdu/
#Sqlite #Performance #Olcum #Guide
https://mustafaerbay.com.tr/en/blog/tutorials/mmap-size-a-8-gib-yazdim-dort-kutuphane-iki-sayi-dondurdu/
I Set mmap_size to 8 GiB and Four Libraries Returned Two Numbers
I tried mmap_size on a 52 MiB snapshot of my blog's content.db. I asked for 8 GiB; four SQLite libraries on one machine returned two numbers, and no error.
mustafaerbay.com.tr
November 8, 2026 at 2:16 PM
So, I told SQLite to `mmap_size`
#Sqlite #Performance #Olcum #Guide
https://mustafaerbay.com.tr/en/blog/tutorials/mmap-size-a-8-gib-yazdim-dort-kutuphane-iki-sayi-dondurdu/
#Sqlite #Performance #Olcum #Guide
https://mustafaerbay.com.tr/en/blog/tutorials/mmap-size-a-8-gib-yazdim-dort-kutuphane-iki-sayi-dondurdu/