en-US/about_Devolutions.Ahtola.Sqlite.help.txt
|
TOPIC about_Devolutions.Ahtola.Sqlite SHORT DESCRIPTION A SQLite module for PowerShell 7+, backed by the pure-managed Ahtola engine. LONG DESCRIPTION This module is a clone of the synedgy.PSSqlite C# port, adapted to use Ahtola.Data.Sqlite instead of Microsoft.Data.Sqlite / SQLitePCLRaw. Project/assembly: Devolutions.Ahtola.PowerShell Published module: Devolutions.Ahtola.Sqlite Cmdlets use the AhtolaSqlite noun to avoid collisions with other SQLite modules. There is no native SQLite companion binary; the engine is pure managed C#. Requires PowerShell 7.4+ (.NET 8). Windows PowerShell 5.1 is not supported because Ahtola targets net8.0/net9.0/net10.0 only. EXAMPLES Import-Module ./artifacts/powershell-modules/Devolutions.Ahtola.Sqlite $connection = New-AhtolaSqliteConnection -ConnectionString 'Data Source=app.db' Invoke-AhtolaSqliteQuery -Connection $connection -CommandText 'CREATE TABLE users (name TEXT)' Invoke-AhtolaSqliteQuery -Connection $connection -CommandText "INSERT INTO users VALUES ('Ada')" # Direct Turso Cloud connection (token is a SecureString). $token = Read-Host -AsSecureString $cloud = New-AhtolaSqliteConnection -TursoUrl 'libsql://example.turso.io' -AuthToken $token # Explicitly opt into standard Turso CLI environment variables. $replica = New-AhtolaSqliteConnection -UseTursoEnvironment -ReplicaPath ./replica.db Invoke-AhtolaSqliteReplicaSync -ReplicaConnection $replica Cloud credentials are not emitted, serialized, or included in connection descriptions. -UseTursoEnvironment is opt-in; it reads TURSO_REMOTE_URL and TURSO_AUTH_TOKEN only when explicitly specified. KEYWORDS SQLite, PowerShell, CRUD, Ahtola, Devolutions |