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
@ajinkyax
3 ай бұрын
I was looking for Kent C. Dodds talk about Remix and SQLite at production 1 year old talk and I found this. :)
@MrDadidou
3 ай бұрын
Aaron, thank you so much for your enthusiasm, your work and your positivity!
@pookiepats
25 күн бұрын
Thank you for existing, breathing & eating!
@zuma206
3 ай бұрын
this series really is liquid gold. just took kent's litefs/global distribution course, now he's on the podcast. love it
@nexovec
3 ай бұрын
This is really silly, but I need LISTEN/NOTIFY.
@popetgirl
3 ай бұрын
A podcast with pocketbase team. They are using sqlite.
@jit-r5b
3 ай бұрын
Team? Wasn't it one amazing dev from Bulgaria that built it?
@MrDpof
3 ай бұрын
Yes!!!! It would awesome.
@pookiepats
5 күн бұрын
it is one dev lol the only thing he outsourced was the websites css 😂
@wesleycoder
3 ай бұрын
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...
@PhilippeLoctaux
3 ай бұрын
i would love to be able to subscribe to this show in my podcast client, when is the rss feed coming? :)
@aarondfrancis
3 ай бұрын
It's here! databaseschool.transistor.fm
@PhilippeLoctaux
3 ай бұрын
thanks! you might want to put it in the description so more people can find it!
@DanielTolentino42
3 ай бұрын
@@PhilippeLoctaux +1
@sean_reyes
3 ай бұрын
does SQlite have good Json Column support?
@theplaintech
3 ай бұрын
Yes, however, libsql is a better choice, especially for JSON.
@relaxwithai
3 ай бұрын
Kinda, from my understanding, you can use the TEXT datatype and perform json operations on it
@benlevy1896
3 ай бұрын
It has both json that is stored as text and jsonb that gets stored as binary.
@HideBuz
2 ай бұрын
@@theplaintech Why? How did they improve json in libsql?
@theplaintech
2 ай бұрын
@@HideBuz For full effect and edification, do your own research.
@7ala9at
3 ай бұрын
can i use sqlite in production now?
@moodyhamoudi
3 ай бұрын
Positive energy overload with these two
@FaraazAhmad
3 ай бұрын
So Kent is your Aaron Francis
@versaleyoutubevanced8647
3 ай бұрын
good to see other ecosystems have their own kent
@ordinarygg
3 ай бұрын
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
3 ай бұрын
Not every big project needs geodata 🤡 and for geodata theres dedicated solutions
@ordinarygg
3 ай бұрын
@@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
Ай бұрын
@@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
5 күн бұрын
@@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.
Пікірлер: 32