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!
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.
