Home SQL Sqlite is amazing! Checkout this tutorial and summary from the inventor Richard Hipp!

Sqlite is amazing! Checkout this tutorial and summary from the inventor Richard Hipp!

I watched this 1-hour & 40 minute deep-dive video from Richard Hipp on SQLite.

It walked through when to use SQLite, the benefits, limits, etc.   If your expecing to have more than 281 terabytes, you’ll want to use an alternative.
One of my favorite stats was the following graph showing it is faster than accessing files on your computer!

Bar chart titled Faster Than The File System showing SQLite reads 100,000 blobs faster than direct file reads across platforms

 

Want a brief overview of the SQLite?  I took the intro of the above video and fed it to NotebookLM.  Below is the 22 minute summary of SQLITE.

And don’t forget you can grab our Sqlite AutoHotkey v2 class here

And you can watch the AutoHotkey v1 & SQLite webinar we did  here

Over the years we’ve done many videos on SQL which you can check out here.

BTW- This video was also fascinating.  It looks like you can possibly speed-up your queries by 10X by using Wal mode.

Joe Glines

Joe Glines spent 20 years as a corporate data scientist before going all in on automation. He now uses AI to build automation in AutoHotkey, Python and Rust, has made 1,500+ tutorials, and runs the-Automator with a small team that has shipped 450+ time-saving tools.

Comments are closed.