4 ms·
Does it mean I can use Lambda + SQLite + Regatta to build a real pay-as-you-go ACID SQL storage? Edit: an production-ready (high durability) ACID SQL storage
by mikecwang 2y ago
Does it mean I can use Lambda + SQLite + Regatta to build a real pay-as-you-go ACID SQL storage?
Edit: an production-ready (high durability) ACID SQL storage
- huntaub 2y agoYes! This is my expectation. Lots of the big companies have already done this with in-house architecture. With Regatta, we want to democratize building stateless applications that can take advantage of the low-cost storage of S3.
- mikecwang 2y agoThat's some real tech in YC these days!
- hades32 2y agoWouldn't that limit the concurrency of the lambdas to 1? Since they would hold a lock on the db file
- datadeft 2y agoWell these are the details that many of us is interested.
- huntaub 2y agoThis is super dependent on the application, and not something that I could answer without being an expert in SQLite. If SQLite only allows a single reader or writer, then yes. This could still be a good choice for applications which elect a “leader” to serve the database, though.
- jedberg 2y agoCurious as to why you would want to build that yourself when so many solutions already exist (Supabase, NeonDB, AWS Aurora or RDS, etc.)?
- huntaub 2y agoOne of my hopes for Regatta is that we're able to power the next generation of these data platforms. These things work because the designers had specialized storage knowledge that allowed them to carefully build serverless data products. I hope that Regatta is generic enough to allow anyone to build a serverless data product moving forward, without having to think about their storage infrastructure.
- jedberg 2y agoThat makes a lot of sense. If you eliminate the need for storage expertise the problem becomes a lot easier! BTW I sent you an email.