synedgy.PSSQlite

0.3.0-preview0001

A Sqlite module for PowerShell

Minimum PowerShell version

5.0

This is a prerelease version of synedgy.PSSQlite.
There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name synedgy.PSSQlite -RequiredVersion 0.3.0-preview0001 -AllowPrerelease

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name synedgy.PSSQlite -Version 0.3.0-preview0001 -Prerelease

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) SynEdgy. All rights reserved.

Package Details

Author(s)

  • Gael Colas

Functions

Get-PSSqliteDBConfig Get-PSSqliteDBConfigFile Initialize-PSSqliteDatabase Get-PSSqliteRow New-PSSqliteRow Remove-PSSqliteRow Set-PSSqliteRow Close-PSSqliteConnection Compare-PSSqliteDBVersion Get-ExpandedString Get-PSSqliteAbsolutePath Get-PSSqliteDBMetadata Invoke-PSSqliteQuery New-PSSqliteConnection

Dependencies

Release Notes

## [0.3.0-preview0001] - 2026-06-14

### Added

- Basic CRUD support with `Get-PSSqliteRow`, `New-PSSqliteRow`,
 `Remove-PSSqliteRow`, `Set-PSSqliteRow`.
- SQL generation for create table statements with `Initialize-PSSqliteDatabase`.
- Version comparing with built-in `_metadata` table and `Compare-PSSqliteDBVersion`.
- Added changelog PR.

### Changed

- Expanded README.md with the blog post reference and config-driven usage examples for schema, initialization, CRUD, and direct SQL queries.
- Added GitHub Copilot repository instructions, validation skill, and setup workflow.
- Documented and automated the SQLite NuGet-to-`source\lib` dependency refresh flow, and hardened native SQLite preloading.
- Added config-backed CRUD regression tests and fixed metadata version lookup plus `Set-PSSqliteRow` connection cleanup.
- Marked macOS native SQLite libraries as binary in `.gitattributes` and refreshed the shipped `.dylib` assets to avoid cross-platform line-ending corruption.

FileList

  • synedgy.PSSqlite.nuspec
  • synedgy.PSSqlite.psm1
  • lib\net461\SQLitePCLRaw.batteries_v2.dll
  • synedgy.PSSqlite.psd1
  • lib\runtimes\linux-arm64\native\libe_sqlite3.so
  • lib\runtimes\osx-x64\native\libe_sqlite3.dylib
  • en-US\about_synedgy.PSSqlite.help.txt
  • lib\runtimes\win-x86\native\e_sqlite3.dll
  • ScriptsToProcess\PreLoadTypes.ps1
  • lib\runtimes\linux-x64\native\libe_sqlite3.so
  • lib\netstandard2.0\SQLitePCLRaw.provider.e_sqlite3.dll
  • lib\runtimes\linux-musl-x64\native\libe_sqlite3.so
  • lib\netstandard2.0\SQLitePCLRaw.core.dll
  • lib\runtimes\win-arm\native\e_sqlite3.dll
  • lib\netstandard2.0\System.Memory.dll
  • lib\runtimes\linux-musl-arm64\native\libe_sqlite3.so
  • lib\netstandard2.0\SQLitePCLRaw.provider.dynamic_cdecl.dll
  • lib\runtimes\linux-musl-arm\native\libe_sqlite3.so
  • lib\netstandard2.0\System.Memory.xml
  • lib\runtimes\win-x64\native\e_sqlite3.dll
  • lib\netstandard2.0\SQLitePCLRaw.batteries_v2.dll
  • lib\runtimes\linux-x86\native\libe_sqlite3.so
  • lib\netstandard2.0\Microsoft.Data.Sqlite.xml
  • lib\runtimes\win-arm64\native\e_sqlite3.dll
  • lib\netstandard2.0\System.Runtime.CompilerServices.Unsafe.xml
  • lib\runtimes\osx-arm64\native\libe_sqlite3.dylib
  • lib\netstandard2.0\System.Runtime.CompilerServices.Unsafe.dll
  • lib\runtimes\linux-arm\native\libe_sqlite3.so
  • lib\netstandard2.0\Microsoft.Data.Sqlite.dll

Version History

Version Downloads Last updated
0.3.0-previe... 14 6/14/2026
0.3.0-previe... (current version) 4 6/14/2026
0.2.2 100 11/11/2025
0.2.2-previe... 4 11/11/2025
0.2.1 7 11/11/2025
0.2.1-previe... 5 11/11/2025
0.2.1-previe... 5 11/11/2025
0.2.1-previe... 5 11/11/2025
0.2.1-previe... 8 7/1/2025
0.2.0 34 7/1/2025
0.2.0-previe... 6 7/1/2025
0.2.0-previe... 6 6/27/2025
Show more