Migrating from Postgres to SQLite with Kent C. Dodds

Join the waitlist for my SQLite course launching in June: highperformancesqlite.com/
Get production ready SQLite with Turso: turso.tech/tryhard.
In this interview, I talk to Kent C. Dodds about SQLite, LiteFS and the React ecosystem.
Carl: / kentcdodds
EpicWeb: www.epicweb.dev/
The Epic Stack: www.epicweb.dev/epic-stack
Fly.io: fly.io/
LiteFS: fly.io/docs/litefs/
Litestream: litestream.io/

[@zuma206]

this series really is liquid gold. just took kent's litefs/global distribution course, now he's on the podcast. love it

[@ajinkyax]

I was looking for Kent C. Dodds talk about Remix and SQLite at production 1 year old talk and I found this. :)

[@wesleycoder]

Aaron and Kent: such a chill duo, love to see it. I liked the name "database schools" sounds interesting, and I bet it will attract attention. I'll be spending the rest of my day now thinking about the curse of knowledge...

[@MrDadidou]

Aaron, thank you so much for your enthusiasm, your work and your positivity!

[@moodyhamoudi]

Positive energy overload with these two

[@popetgirl]

A podcast with pocketbase team. They are using sqlite.

[@LV-md6lb]

Team? Wasn't it one amazing dev from Bulgaria that built it?

[@MrDpof]

Yes!!!! It would awesome.

[@PhilippeLoctaux]

i would love to be able to subscribe to this show in my podcast client, when is the rss feed coming? :)

[@aarondfrancis]

It's here! databaseschool.transistor.fm

[@PhilippeLoctaux]

thanks! you might want to put it in the description so more people can find it!

[@DanielTolentino42]

​@@PhilippeLoctaux +1

[@7ala9at]

can i use sqlite in production now?

[@nexovec]

This is really silly, but I need LISTEN/NOTIFY.

[@FaraazAhmad]

So Kent is your Aaron Francis

[@versaleyoutubevanced8647]

good to see other ecosystems have their own kent

[@sean_reyes]

does SQlite have good Json Column support?

[@theplaintech]

Yes, however, libsql is a better choice, especially for JSON.

[@relaxwithai]

Kinda, from my understanding, you can use the TEXT datatype and perform json operations on it

[@benlevy1896]

It has both json that is stored as text and jsonb that gets stored as binary.

[@ordinarygg]

Geodata and a lot of missing features unfortunately SQLite is not for big production. SQLIte is great for single server projects and hobby one.

[@antidegenerates7449]

Not every big project needs geodata 🤡 and for geodata theres dedicated solutions

[@ordinarygg]

@@antidegenerates7449 I think 🤡 is using half-compatible databases for any complex data, for example JSON. Do you really think single file will be faster in random access data then inode splited where OS proper cache is. Imaginary ponies that don’t have 10bil table in their lives, calling something “big projects” lol