synedgy.PSSQlite

0.3.0

A Sqlite module for PowerShell

Minimum PowerShell version

5.0

Installation Options

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

Install-Module -Name synedgy.PSSQlite

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

Install-PSResource -Name synedgy.PSSQlite

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 Export-PSSqliteData Import-PSSqliteData Close-PSSqliteConnection Compare-PSSqliteDBVersion Get-ExpandedString Get-PSSqliteAbsolutePath Get-PSSqliteDBMetadata Invoke-PSSqliteQuery New-PSSqliteConnection

Dependencies

Release Notes

## [0.3.0] - 2026-10-08

### 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.
- YAML-defined SQLite view support, including structured `Schema.Views` definitions and a raw `Sql` escape hatch for advanced views.
- Timestamped JSON table-data export and schema-tolerant, foreign-key-aware import, with default data preservation and a complete database backup during overwrite migrations.

### Changed

- Avoided force-loading the bundled native `e_sqlite3` library when it is already loaded in the host process, including platforms that do not expose native handles through `Process.Modules`, preventing conflicts with hosts such as PowerShell Universal while retaining bundled-library loading when required.
- Aligned all packaged SQLitePCLRaw assemblies to version 2.1.10 and registered RID-specific native library resolution for Windows PowerShell and cross-platform compatibility.
- Expanded README.md with the blog post reference plus config-driven usage and getting-started examples for schema, initialization, CRUD, views, and direct SQL queries.
- Added a WikiSource page documenting a reusable PSSqlite Copilot skill for consumer projects.
- Extended `Get-PSSqliteRow` so config-backed read operations can resolve declared views as well as tables.
- Added GitHub Copilot repository instructions, validation skill, and setup workflow.
- Documented how to avoid `output\module` file locks during rebuild and validation loops.
- 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.psd1
  • lib\netstandard2.0\System.Runtime.CompilerServices.Unsafe.xml
  • lib\runtimes\linux-musl-arm\native\libe_sqlite3.so
  • synedgy.PSSqlite.psm1
  • lib\runtimes\linux-musl-arm64\native\libe_sqlite3.so
  • en-US\about_synedgy.PSSqlite.help.txt
  • lib\runtimes\win-arm\native\e_sqlite3.dll
  • ScriptsToProcess\PreLoadTypes.ps1
  • lib\runtimes\win-x64\native\e_sqlite3.dll
  • lib\net461\SQLitePCLRaw.batteries_v2.dll
  • lib\runtimes\linux-arm\native\libe_sqlite3.so
  • lib\netstandard2.0\Microsoft.Data.Sqlite.dll
  • lib\runtimes\linux-arm64\native\libe_sqlite3.so
  • lib\netstandard2.0\SQLitePCLRaw.batteries_v2.dll
  • lib\runtimes\win-arm64\native\e_sqlite3.dll
  • lib\netstandard2.0\SQLitePCLRaw.provider.e_sqlite3.dll
  • lib\runtimes\linux-musl-x64\native\libe_sqlite3.so
  • lib\netstandard2.0\System.Runtime.CompilerServices.Unsafe.dll
  • lib\runtimes\linux-x86\native\libe_sqlite3.so
  • lib\netstandard2.0\SQLitePCLRaw.core.dll
  • lib\runtimes\win-x86\native\e_sqlite3.dll
  • lib\netstandard2.0\System.Memory.dll
  • lib\runtimes\osx-x64\native\libe_sqlite3.dylib
  • lib\netstandard2.0\Microsoft.Data.Sqlite.xml
  • lib\runtimes\osx-arm64\native\libe_sqlite3.dylib
  • lib\netstandard2.0\System.Memory.xml
  • lib\runtimes\linux-x64\native\libe_sqlite3.so
  • lib\netstandard2.0\SQLitePCLRaw.provider.dynamic_cdecl.dll

Version History

Version Downloads Last updated
0.3.0 (current version) 16 10/8/2026
0.3.0-previe... 51 6/14/2026
0.3.0-previe... 5 6/14/2026
0.2.2 171 11/11/2025
0.2.2-previe... 5 11/11/2025
0.2.1 26 11/11/2025
0.2.1-previe... 6 11/11/2025
0.2.1-previe... 6 11/11/2025
0.2.1-previe... 6 11/11/2025
0.2.1-previe... 9 7/1/2025
0.2.0 35 7/1/2025
0.2.0-previe... 7 7/1/2025
0.2.0-previe... 7 6/27/2025
Show more