Migrating from Postgres to SQLite with Kent C. Dodds

Рет қаралды 15,447

Күн бұрын

Пікірлер: 33

@aarondfrancis 3 ай бұрын

You can also listen to this episode as a podcast on your favorite podcast player: databaseschool.transistor.fm/episodes/migrating-from-postgres-to-sqlite-with-kent-c-dodds

@zuma206 6 ай бұрын

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

@wesleycoder 6 ай бұрын

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 6 ай бұрын

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

@pookiepats 3 ай бұрын

Thank you for existing, breathing & eating!

@moodyhamoudi 6 ай бұрын

Positive energy overload with these two

@ajinkyax 6 ай бұрын

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

@sean_reyes 6 ай бұрын

does SQlite have good Json Column support?

@theplaintech 6 ай бұрын

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

@relaxwithai 6 ай бұрын

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

@benlevy1896 6 ай бұрын

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

@HideBuz 4 ай бұрын

@@theplaintech Why? How did they improve json in libsql?

@theplaintech 4 ай бұрын

@@HideBuz For full effect and edification, do your own research.

@popetgirl 6 ай бұрын

A podcast with pocketbase team. They are using sqlite.

@jit-r5b 6 ай бұрын

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

@MrDpof 6 ай бұрын

Yes!!!! It would awesome.

@pookiepats 2 ай бұрын

it is one dev lol the only thing he outsourced was the websites css 😂

@7ala9at 6 ай бұрын

can i use sqlite in production now?

@gregorywpower Ай бұрын

One thing I think would be even more bananas would be replacing that caching layer with DuckDB.

@PhilippeLoctaux 6 ай бұрын

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

@aarondfrancis 6 ай бұрын

It's here! databaseschool.transistor.fm

@PhilippeLoctaux 6 ай бұрын

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

@DanielTolentino42 6 ай бұрын

@@PhilippeLoctaux +1

@nexovec 6 ай бұрын

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

@FaraazAhmad 6 ай бұрын

So Kent is your Aaron Francis

@versaleyoutubevanced8647 6 ай бұрын

good to see other ecosystems have their own kent

@ordinarygg 6 ай бұрын

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 5 ай бұрын

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

@ordinarygg 5 ай бұрын

@@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

@Jason-xw2md 4 ай бұрын

@@ordinaryggthe vast majority of businesses are not going to have 10 billion rows. real 🤡 is acting like one tool is always the "correct" solution

@pookiepats 2 ай бұрын

@@antidegenerates7449exactly, either way you're going over the wire for geodata so his comment is pure cult driven criticism, as if "big projects" only use a single data store.