News for hackers. Stuff that matters.
Re:SQLite Is Serverless by notduncansmith on Sunday January 26, 2020 @12:58PM (#22153502)
This is exactly the style in which I build applications these days. Most of the time I just describe it as “hella caching” but it is a different paradigm from treating the database as the primary state engine. The speed and simplicity of working on in-memory structures are great. When you outgrow a single server’s RAM capacity, you can use Kafka or another durable message queue as your application’s WAL and shard your data across multiple servers.
Re:SQLite Is Serverless by wpietri on Sunday January 26, 2020 @07:00PM (#22155778)
Have you written up the systems you've built? I'd love to read more about the practical details. Feel free to email me or DM me on Twitter if that's better.
Re:SQLite Is Serverless by notduncansmith on Monday January 27, 2020 @01:50AM (#22157314)
I haven’t written up any of the production work I’ve done in this vein, but here’s a demo application I built as a hiring challenge (apologies for the broken demo link, it was hosted by the now-defunct Hyper.sh): https://github.com/notduncansmith/agree/blob/master/README.m...

Given no firm deadline, I timeboxed to 12 hours so it’s not fully fleshed-out but I like to think it illustrates the concept well.

Re:SQLite Is Serverless by wpietri on Monday January 27, 2020 @02:39PM (#22162951)
Ah, that's cool! I like your writeup; it makes the advantages of your approach clear. I hope you got the job!
Re:SQLite Is Serverless by notduncansmith on Monday January 27, 2020 @07:15PM (#22165200)
Thanks! I did, though now working at another co and spending my free time generalizing this into a library that makes this paradigm easier to adopt (basically Redux-ifying your backend but with end-to-end encryption on the stored event logs). The initial version should be ready to publish in the next few weeks :)
Re:SQLite Is Serverless by wpietri on Tuesday January 28, 2020 @01:37PM (#22172580)
If you remember, please email me or contact me on Twitter when it comes out! I'd love to check it out. And I'll definitely pass it along to the Prevayler community, who I'm sure will be tickled.