Home Posts tagged "SQLite3"

Tag: SQLite3

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.

AutoHotkey Webinar- SQLite3 with AutoHotkey

SQLite3 with AutoHotkeyIn today’s webinar Jean Lalonde, author of Quick Access Popup, lead us through a demonstration how to use SQLite with AutoHotkey.

Video Hour 1:  High level overview

Video Hour 2: Continue overview and Q&A

Script Highlight: This was actually a “website” highlight.  Skrommel’s 1-hour Software is a great site with 116 examples of scripts that can manipulate various tasks on Windows.  His code is available both as an executable as well as the AutoHotkey source files.

SQLite3 with AutoHotkey

Here is a link to the SQLite3 with AutoHotkey files Jean shared and reviewed below

–SQLite files:

–Class_SQLiteDB library (by just me)

–Utility DB Browser for SQLite

SQLite-First_Example.ahk

  • Open an existing database

–Display error report

  • Query the database
    • in a RecordSet with Query()
    • in a Table with GetTable()
  • Execute various commands
    • Insert rows into a table
    • Delete rows

 

BLOB_Sample.ahk

  • Store and retrieve binary large objects (BLOB)

SQLite-TheBeatles.ahk

  • Create a new database
  • Create table and indexes
  • Insert multiple rows (import)
  • Display in a ListView with GetTable
  • Execute various commands
    • Alter table (add columns)
    • Vacuum the database

Using transactions

  • BEGIN TRANSACTION;
  • ROLLBAK:
  • COMMIT: