Samuel
@samuel.fm
so close to using SQLite in production 6 million times
10 5 115
James Felix BlackNothing wrong with this
4
🍁 thankful frood 🦃I thought PDS’s ran SQLite?
1 4
Liberty BetaI mean for a local cache db or android....
1 1Samuelnope, on the server as a primary database
1 4Liberty BetaWith hand coded nodejs sqlite query builder that runs everything as process.exec?
1 2Samuelnope, kysely I think
2 5Liberty BetaYeap, but that looks not horrible, whereas my solution was 'le suck'.
2
mary🐇have you heard about our new lord and savior drizzle
1 1Liberty BetaUgh. Orm .
1 1mary🐇more of a query builder with optional ORM stuff, I've never actually used the latter
1Liberty BetaThe push for ORM is one thing I hate about the corpo software.
1
Michel Bestaatbut is bluesky a polycule...
2
Toni Alatalo 🇫🇮💚Did ATProto accidentally become a way to do SQLite sharding 😮
1
WillI prefer SQL Zero Sugar myself
somebenor just use Redis. That’ll be worse / faster / better.
1
greg abbott’s tearsYou don’t need to keep every post of every user in memory at all times to run this site. Reading/writing to disk is fast enough for archival data.