PSCsvSQLiteORM

3.1.3

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 CSV Database DataImport ActiveRecord QueryBuilder 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.3 - Fixed SQL parameter binding errors when column names contain spaces or special characters - Sanitize parameter names to use only alphanumeric characters and underscores - Improved compatibility with CSV files that have complex column naming

FileList

Version History

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