PSCsvSQLiteORM

3.1.1

A SQLite ORM for Windows PowerShell 5.1 with catalog, relationships, joins, upserts, and migrations.

Minimum PowerShell version

5.1

Installation Options

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

Install-Module -Name PSCsvSQLiteORM

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

Install-PSResource -Name PSCsvSQLiteORM

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) Joey A Miles. All rights reserved.

Package Details

Author(s)

  • Joey A Miles

Tags

SQLite ORM Database CSV Import Migration

Functions

Add-DbMigration Close-DbConnections Complete-DbTransaction Confirm-DbForeignKey ConvertTo-Ident Enable-ForeignKeysPragma Enable-UniqueIndex Enable-UpsertSupported Export-DynamicModelsFromCatalog Find-DbRelationships Get-AppliedMigrations Get-DbConnection Get-TableColumns Import-CsvToSqlite Initialize-Db Initialize-ORMVars Invoke-DbQuery New-DbQuery New-DynamicModel Set-DbLogging Set-DynamicORMClass Start-DbTransaction Test-ColumnTypes Undo-DbTransaction Update-DbCatalog Write-DbLog

PSEditions

Desktop

Dependencies

Release Notes

v3.1.1
- Fixed PowerShell 5.1 compatibility by replacing null-coalescing operator (??) with conditional statements
- Resolved module import errors on Windows PowerShell 5.1

v3.1.0
- Added AppendOnly schema mode
- RIGHT/FULL join emulation support
- Settings script support for configuration
- Improved error handling and logging

FileList

Version History

Version Downloads Last updated
3.1.1 (current version) 6 9/7/2025
3.1.0 11 9/2/2025