sqlite is a thin wrapper for the SQLite library, which in turn is
"a C-language library that implements a small, fast, self-contained,
high-reliability, full-featured, SQL database engine."
Before you can use this module, you must first have the SQLite development library installed on your system.
Fedora 31:
sudo dnf -y install sqlite-devel
Ubuntu 20.04:
sudo apt install -y libsqlite3-dev
Windows:
- Download the source zip from SQLite Downloads
- Create a new
sqlitesubfolder insidev/thirdparty - Extract the zip into that folder
When performing a large amount of database calls (i.e. INSERTS), significant performance increase can be obtained by controlling the synchronization and journal modes.
For instance:
import db.sqlite
db := sqlite.connect('foo.db') or { panic(err) }
db.synchronization_mode(sqlite.SyncMode.off)!
db.journal_mode(sqlite.JournalMode.memory)!