I got curious on the reasoning about disabling THREADSAFE and using ALLOCA (dynamic stack allocation, which is generally a bad idea. that's why linux avoid VLA's, which are just really bad). What about we're on a multithreaded environment and what happens to sqlite it alloca fails?
@MattCCrampton23 күн бұрын
I guess I’m missing something fundamental after listening to this talk, I have two servers that talk to the same database. As far as I can tell using SQLite in prod does not scale past a single server. Is there something here I didn’t understand?
@Dominik-K19 күн бұрын
That is true in itself, though offerings like Turso /LibSQL make it possible to have changes be synchronized between a central server and your web servers. Before Turso, I've deployed some applications that just redirected write traffic to a master server and used tools, like Litestream, to update the read replicas automatically. Using Sqlite with multiple databases and database files, one person tenant, made it possible to still distribute writes, since each server was the master of a few of those tenants. With tools like Turso the effort to implement such solutions goes down dramatically though
@TheRealCornPop17 күн бұрын
And now your vendor locked in to Turso when you could have just used Postgresql
@FranciscoQuintero4 ай бұрын
Good stuff. Very insightful from Xavier.
@mferminxt14 ай бұрын
Great talk. Thank you for sharing. How would you go about to convince clients to not impose deadlines?
4 ай бұрын
Great talk Stephen. Indeed, Sqlite is the next big thing (it always has been, but more "famous" now). And all of this is possible, all of this gets thr bigger picture, because of hardworking people like you. Thank you very much for all your work towards Sqlite and more specifically, onRails.
4 ай бұрын
Awesome talk, Josef! Looking forward to see more of your work. Kudos!
@strzibnyj3 ай бұрын
Thanks so much!
@BroileR20076 ай бұрын
28:18 How are rectangles simpler than silence or even sine? I don't get it.
@S5Dic09 Жыл бұрын
In social (broken?) systems like Germany being unemployed is a luxury