The Perfect Dependency - SQLite Case Study

[@lifelover69]

Came to learn about databases, got a life philosophy lesson. win-win. Thanks for the video. I hope Richard's mindset inspires younger programmers.

[@PanduPoluan]

SQLite is so lightweight, both in terms of LOC and dependencies (ZERO), that it becomes part of Python's stdlib. That's one reason (among many) why Python is so popular: Out of the box it has an honest-to-goodness relational database suitable for rapid development. And when the time comes to rely on external databases, it's a relatively painless process to replace.

[@ShodanR13]

Thank you. I've been looking for a documentary on Sqlite for a while and this was great.

[@violetsweet1660]

I was just thinking about how load-bearing sqlite is compared to its size the other day. It's hard not to be overawed a bit by the technology!

[@doyouwantsli9680]

A lot better concurrency than mongodb

[@chiffaonosu]

I like how even with an insanely thorough test harness SQLite has some bugs simply because of history reasons. Kinda shows that sometimes things squeak through and stay in the system because of backwards compatibility

[@not_herobrine3752]

step zero: be interested in PL theory?

[@PanduPoluan]

12:14 I love how humble the PostgreSQL people are. "Um, maybe you're not trying hard enough to make postgres fail?"

[@chillphil967]

cool video topic. funny graphics. i dig the original audio cut ins

[@FrankHarwald]

*sqlite pretending to be the most deployed software ever* Zlib: hold my beer. Minix hidden inside every intel CPU: i wonder how many people have even heard of me?

[@stylisttaps]

Would be fun to distinguish deployed as in: on device being used at any level of the software stack by a computer vs deployed as in: explicity choosen as a dependency by the developer of the ultimate application being used by end user Honestly sounds like a fun thing to try and measure Ive built a couple dozen apps that anyone uses other than me, but never once have I explicitly imported zlib - though of course its being used in the background a friggin gagillion times over

[@anon_y_mousse]

@@stylisttaps I would say being used at all is good enough, and towards that end, zlib is undoubtedly going to have far more deployment. It's used even where SQLite isn't and has been in use for far longer. It's also used on ARM and AMD based platforms, so even if Intel CPU's really do have an implementation of Minix inside, zlib would still have a much more universal deployment status. Not that my own personal experience matters, but I've got two of each processor type in computers around the house, Intel, AMD and ARM. Then I've got tablets and cell phones old and new which use ARM chips, regardless of whether you want to call such devices computers or not. Every device has zlib installed and it's used literally every time each device gets used, both with internet communications and beyond.

[@doyouwantsli9680]

Let's not talk about how our computers all have a closed source OS running on ring -7 that we have no control or insight into...

[@2Kaleb]

Amazing case study tom

[@ErikPelyukhno]

17:29 Does that expression refer to testing out your own code by using it?

[@insu_na]

I think the SQLite main dev is completely insane. In many ways it's a good kind of insane, but in other ways it's a pretty bad kind of insane. In any case I love the SQLite project and love using SQLite in my own projects.

[@doyouwantsli9680]

What's bad?

[@hansdietrich1496]

Finally, the database guys jumped on the idea and made the excellent duckdb.

[@RaaynML]

This guy not only built his own shed but also cut his own lumber, dug his own foundation, and forged the tools to build it

[@stylisttaps]

Lol me at 4am hacking together a mobile react native w/ SQLite version of an old desktop app I made years ago that relied on MySQL server. Great video. Love SQLite these days - wish I could tell my 18 yo prior self not to bother with the external db on desktop that was just not necessary for the use case.

[@PanduPoluan]

Me too! So many programs I made was built on MySQL (I blame LAMP/XAMPP), though later I migrated to PostgreSQL. Those are so painful I usually aborted just as my programs get interesting, because I just can't stand all the necessary maintenance and meta needed by external databases. I wish I could go back in time and have them all built on SQLite....

[@FobosLee]

Exactly! Library works perfectly 99% of time, and then 1% brings 99% of problems and pain

[@PanduPoluan]

11:51 PostgreSQL is indeed the king of RDBMS now... It shone especially well for GIS applications: The PostGIS extension is so well-designed and well-written that other databases just copy them ... code, interface, syntax, and all. Aaaand PostgreSQL is also deployed in LOTS of places where even talking about them may result in you being visited by Men in Uniform. It's such a workhorse RDBMS that probably dwarfs other RDBMSes in terms of deployment. Though we can't tell that with confidence as a sizable portion of the deployment is either NDA-ed, or classified, or both.

[@insu_na]

PostgreSQL is f-ing amazing, but it's not as widely deployed as it should be. Many junior developers learn on MySQL and many companies have huge contracts with Microsoft and Oracle for MSSQL and OracleDB or MySQL respectively. Postgres *will* eventually outpace all of them, but at this point in time it does not yet

[@Hellbending]

Squeal-light

[@doyouwantsli9680]

It's ess queue lite

[@alexandersemionov5790]

Sqlite as a file type - future

[@kodekata]

so wholesome

[@doyouwantsli9680]

SQlite is the best. Mongo is so slow with multiple users.

[@kellymoses8566]

I like to use sqlite tables as an alternative to Python dicts.

[@GoogleAIccount1]

very cool.

[@ChristopherPuzey]

SQLite not SQLlite

[@beagle989]

sequalite

[@PanduPoluan]

Squeal-lite

[@olegmakarikhin]

​@@beagle989😂😂😂

[@PanduPoluan]

That said, its creator pronounced the name like "ess cue ell-light" so there.

[@raph_5]

❤

[@JohnUrbanic-m3q]

The content is solid, but the non-stop memes are insufferable.

[@inmosh]

first

[@MrFoof82]

Raise your hand if you're a long-time database developer who dies inside every time someone says, "Ess-Queue-Ell" instead of, "Sequel". 🤚

[@joseoncrack]

No, I cringe when I hear Sequel.

[@pirate21]

Windows’ folks say “Sequel”, the rest of us says it correctly as “Ess-Queue-Ell”.

[@rdubb77]

Tomato tomahto

[@jacobmar2797]

🖖🏻

[@PanduPoluan]

I now pronounce it "squeal" and I refuse to change. In meetings people always got confused at first, but I am patient and have been able to infect them.