Tag: query data

In 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:

• https://www.sqlite.org/download.html
• In section « Precompiled Binaries for Windows », choose the 32-bit or 64-bit zip file
• Extract sqlite3.dll and sqlite3.def to your script folder
• SQLite Documentation https://www.sqlite.org/docs.html

–Class_SQLiteDB library (by just me)

• Forum: https://autohotkey.com/boards/viewtopic.php?t=1064 from just me
• Download: https://github.com/AHK-just-me/Class_SQLiteDB/archive/master.zip
• Save the library Class_SQLiteDB.ahk to your script folder (or your libraries folder)
• See SQLiteDB_sample.ahk for examples

–Utility DB Browser for SQLite

• http://sqlitebrowser.org

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: