On: Launch HN: Regatta Storage (YC F24) – Turn S3 into...

[mikecwang]

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 → mikecwang]

Yes! 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 → huntaub]

That's some real tech in YC these days!

[hades32 → huntaub]

Wouldn't that limit the concurrency of the lambdas to 1? Since they would hold a lock on the db file

[datadeft → hades32]

Well these are the details that many of us is interested.

[huntaub → datadeft]

This 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 → mikecwang]

Curious as to why you would want to build that yourself when so many solutions already exist (Supabase, NeonDB, AWS Aurora or RDS, etc.)?

[huntaub → jedberg]

One 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 → huntaub]

That 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.