SQLite π¦
SQLite is a file-based database. The database is stored in a file such as users.db
and queried using SQL.
To run SQL, either use sqlite3 users.db
to open a prompt, or directly run a query using sqlite3 xxx.db some_query
.
- SQLite version v1 π:
file users.db
- SQLite version v2 π:
select sqlite_version()
- Help π:
.help
βοΈ You can use sqlitebrowser (19.7k β) to visualize the database.
Common commands:
- Dump database ποΈ:
.dump
- List tables π§:
.tables
- List columns π«:
PRAGMA table_info(some_table);
- Schema βοΈ:
select sql from sqlite_master
π» To-do π»
Stuff that I found, but never read/used yet.
Open An SQLite Database On Windows Using PSSQLite (1.0k β)
PS> Set-ExecutionPolicy Bypass -Scope Process
PS> Import-Module .\PSSQLite.psd1
PS> $db = '.\test.sqlite'
PS> Invoke-SqliteQuery -Database $db -Query "<query here>" | ft -wrap