Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#1

Post by thenorthbay » Thu, Apr 25, 2024, 11:41 AM UTC

Wouldn't it be cool to have a Supabase for SQLite?

The core idea here is: let SQLite run next to your application on the server; but have all features a client-server database give you.

What's the spec for this?

- SQLite runs next to server as production database

- That way, reads and writes are very fast

- In dev, some sort of worker auto-copies the prod DB to the local repo. Production bugs can be reproduced easily and code fixed quickly

- Have an interface that lets you access, view, and modify data in the production DB, kind of like Firebase. Might need a server of its own... or couldn't that just be the app server itself?

- SQLite auto-backs up to a bucket (like Litestream)

I kinda really want this, but haven't found anything quite like it. I've seen Turso, but it seems they focus more on global replication instead of the OSS developer experience I'm looking for.

What do you think? What am I missing?

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#2

Post by 0x_rs » Thu, Apr 25, 2024, 11:50 AM UTC

It's an obvious question, but have you looked into Pocketbase?

https://github.com/pocketbase/pocketbase

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#3

Post by thenorthbay » Thu, Apr 25, 2024, 12:03 PM UTC

0x_rs wrote: post #2

It's an obvious question, but have you looked into Pocketbase? https://github.com/pocketbase/pocketbase

that's pretty cool! Would be great to have it for TS to configure my own backend

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#4

Post by ruslan_talpa » Thu, Apr 25, 2024, 1:21 PM UTC

Exactly what you describe but not free [1]

1. https://subzero.cloud/

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#5

Post by adius » Thu, Apr 25, 2024, 1:54 PM UTC

Working on it! => https://www.airsequel.com

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#6

Post by endisneigh » Thu, Apr 25, 2024, 2:05 PM UTC

You can do all of this with Postgres.

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#7

Post by [deleted] » Thu, Apr 25, 2024, 2:23 PM UTC

[deleted]

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#8

Post by [deleted] » Thu, Apr 25, 2024, 2:36 PM UTC

[deleted]

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#9

Post by whodev » Thu, Apr 25, 2024, 2:38 PM UTC

All the features you requested Turso can do, no?

> - SQLite runs next to server as production database

Embedded Replicas[1]

> - In dev, some sort of worker auto-copies the prod DB to the local repo. Production bugs can be reproduced easily and code fixed quickly

Maybe not exactly this, but you can replicate a DB from another with the CLI tool. Then just use that as a dev db.

> - Have an interface that lets you access, view, and modify data in the production DB, kind of like Firebase. Might need a server of its own... or couldn't that just be the app server itself?

I don't use their web interface, but I think it does allow this? I don't know for sure though.

> - SQLite auto-backs up to a bucket (like Litestream)

Turso does have point-in-time recovery[2]

[1] https://docs.turso.tech/features/embedded-replicas/introduct... [2] https://docs.turso.tech/features/point-in-time-recovery

Re: Ask HN: Wouldn't it be cool to have a Supabase for SQLite?

#10

Post by PurpleRamen » Thu, Apr 25, 2024, 2:45 PM UTC

So like a normal SQL-server (PostgreSQL, MariaDB..), but with SQLite as backend. Which makes moving data simpler, as you only need to copy a file and can thus utilize the whole shell scripting-power. Well, seems like a nice idea for the dev, but how well can SQLite perform in a real production-environments with parallel writing? The only solutions I've seen so far are either relative poor, or "cheat" by using a separate file for each customer, which is not working with all use cases.

Anyway, there is a new generation of database-systems/frontends, like Grist, NocoDB, Airtable, etc. But they are more focused on a user-friendly all round experience, not so much a good experience. But some of them do support working with SQLite.