What are some of the most simple database products to get started with?

I'm trying to start a new project and I see Theo often recoemnds cool new technologies that really simple to get started with. Most recently PostHog impressed me.

So I'm wondering what has he suggested for DBs? I'm looking for something REALLY simple to get started with and that I can start storing/reading from in just a couple of lines of code if possible, ideally with an online editor for the data.

Thanks.

Vincent Udén•12/23/23, 12:08 PM

Theo always recommends Planetscale. Supabase is a great alternative to. They've got a kv-store if you don't even want to mess around with sql. And they do have an online editor

Vincent Udén•12/23/23, 12:10 PM

If you're looking for sql then you should probably use prisma or drizzle, although the latter usually ends up with more code and setup imo if brevity is your no1 priority

zainiOP•12/23/23, 6:45 PM

thanks - had issues with Planetscale + Prisma in the past, due to relational db stuff. might look into that again.

although tbf, i was hoping there was something even simplier than these (which sounds like it might be Supabase tbh) where the DB provider is also the ORM

john•12/23/23, 6:46 PM

I've not tried Cloudflare D1, but it also works with Drizzle. SQLite is probably fine for really simple stuff.

Zzaini thanks - had issues with Planetscale + Prisma in the past, due to relational db ...

Vincent Udén•12/23/23, 7:16 PM

I mean this is not generally how databases work. Whats difficult about entering a DB url into a config file? Im really struggling to see the problem from your perspective but i do want to understand the issue

Vincent Udén•12/23/23, 7:20 PM

Especially if its like a kv-store which doesnt even have a schema