SQLite the only database you will ever need in most cases

Re:SQLite the only database you will ever need in most cases by irskep on Thursday February 16, 2023 @01:08AM (#34815646)

Interesting question. I think you could probably get those features by deploying Piku or Dokku for like $4/mo on a VPS, and the equivalent managed Postgres on Render would be like $20/mo (16GB SSD), so something like $6-10 seems like the right range to me. Maybe not a booming business, but a nice margin percentage and worth paying for good UX. And the cheap version doesn't need to be the only version if people want more RAM, etc.

I'd find such a product really appealing, especially with a dedicated backup strategy that uses the SQLite backup API to do hourly snapshots or uses Litestream to S3 by default.

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by azurelake on Thursday February 16, 2023 @02:25AM (#34816008)

Let's say the price was 12. If this idea is compelling enough for you at that price point to venmo me an advance for your first month, I have some ideas to explore that could actually make this viable. FWIW, I've worked professionally on a PaaS and a managed database offering.

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by canadiantim on Thursday February 16, 2023 @09:38AM (#34819188)

If you make it so I can have one SQLite database per user, I’d be a customer too

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by azurelake on Thursday February 16, 2023 @10:08AM (#34819640)

When you say per user, you mean per user of your app?

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by canadiantim on Thursday February 16, 2023 @12:20PM (#34821761)

yeah exactly. I want each user's data to be silo'd in their own sqlite database each. It's basically just a multi-tenant setup using sqlite.

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by azurelake on Thursday February 16, 2023 @01:51PM (#34823727)

Cool, thanks for the clarification!

[ Parent | on HN ]