synedgy.PSSQlite

0.3.0-preview0002

A Sqlite module for PowerShell

Minimum PowerShell version

5.0

This is a prerelease version of synedgy.PSSQlite.

Installation Options

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

Install-Module -Name synedgy.PSSQlite -AllowPrerelease

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

Install-PSResource -Name synedgy.PSSQlite -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-preview0002] - 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.
- YAML-defined SQLite view support, including structured `Schema.Views` definitions and a raw `Sql` escape hatch for advanced views.

### Changed

- 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.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... (current version) 14 6/14/2026
0.3.0-previe... 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