mySQLite
1.0.0
A set of PowerShell commands for working with SQLite database files. This is a simple alternative to installing any version of SQL Server on your desktop. Note that this module will only work on x64 versions Windows and Linux platforms.
Minimum PowerShell version
5.1
Installation Options
Owners
Copyright
(c) 2019-2025 JDH Information Technology Solutions, Inc.
Package Details
Author(s)
- Jeff Hicks
Tags
Functions
Invoke-MySQLiteQuery New-MySQLiteDB New-MySQLiteDBTable ConvertTo-MySQLiteDB Get-MySQLiteTable ConvertFrom-MySQLiteDB Get-MySQLiteDB Open-MySQLiteDB Close-MySQLiteDB Export-MySQLiteDB Import-MySQLiteDB Convert-MySQLiteByteArray Get-SQLiteVersion
PSEditions
Dependencies
This module has no dependencies.
Release Notes
# Changelog for MySQLite
## v[1.0.0] - 2025-05-30 15:30:33
### Added
- Added assembly for ARM64 on Windows.
- Added new sample database ProcessData.db to the samples folder.
### Changed
- Updated Import-MySqliteDB and Export-MySqliteDB to better handle importing exported databases. __Breaking changes as the export process creates a different JSON file.__
- Changed Write-Verbose commands to 'Write-Debug in private helper functions.
- Revised the PRAGMA query Get-MySqliteDB to get all database information in a single query.
- UpdatedGet-MySqliteDB to display missing database information and extended the custom object to include a few more properties.
- Updated verbose messaging.
- Updated online help links.
- Updated README.md.
### Fixed
- Updated error handling in Invoke-MySqliteQuery to write errors instead of warnings. __This is a breaking change__. [[Issue #25](https://github.com/jdhitsolutions/mySQLite/issues/25)]
- Updated Get-MySqliteDB to handle database files stored in OneDrive. [[Issue #27](https://github.com/jdhitsolutions/mySQLite/issues/27)]
FileList
- mySQLite.nuspec
- changelog.md
- mySQLite.psd1
- ReleaseNotes.md
- docs\Convert-MySQLiteByteArray.md
- docs\Export-MySQLiteDB.md
- docs\Get-SQLiteVersion.md
- docs\New-MySQLiteDB.md
- en-us\mySQLite-help.xml
- functions\Close-MySQLiteDB.ps1
- functions\ConvertTo-MySQLiteDB.ps1
- functions\Get-MySQLiteTable.ps1
- functions\Invoke-MySQLiteQuery.ps1
- functions\Open-MySQLiteDB.ps1
- images\dbbrowser.png
- samples\sales.db
- assembly\archive\System.Data.SQLite.dll
- assembly\arm64\System.Data.SQLite.dll
- assembly\linux-arm64\SQLite.Interop.dll
- assembly\net20\SQLite.Interop.dll
- assembly\net46\SQLite.Interop.dll
- License.txt
- mySQLite.psm1
- assembly\SQLite.Interop.dll
- docs\ConvertFrom-MySQLiteDB.md
- docs\Get-MySQLiteDB.md
- docs\Import-MySQLiteDB.md
- docs\New-MySQLiteDBTable.md
- formats\mySQLiteDB.format.ps1xml
- functions\Convert-MySQLiteByteArray.ps1
- functions\Export-MySQLiteDB.ps1
- functions\Get-SQLiteVersion.ps1
- functions\New-MySQLiteDB.ps1
- functions\private.ps1
- samples\inventory.db
- samples\sysinfo.db
- assembly\archive\System.Data.SQLite.xml
- assembly\linux-arm64\libe_sqlite3.so
- assembly\linux-x64\SQLite.Interop.dll.so
- assembly\net20\System.Data.SQLite.dll
- assembly\net46\System.Data.SQLite.dll
- README.md
- docs\Close-MySQLiteDB.md
- docs\ConvertTo-MySQLiteDB.md
- docs\Get-MySQLiteTable.md
- docs\Invoke-MySQLiteQuery.md
- docs\Open-MySQLiteDB.md
- formats\mySQLiteTableDetail.format.ps1xml
- functions\ConvertFrom-MySQLiteDB.ps1
- functions\Get-MySQLiteDB.ps1
- functions\Import-MySQLiteDB.ps1
- functions\New-MySQLiteDBTable.ps1
- images\db.png
- samples\ProcessData.db
- assembly\archive\SQLite.Interop.dll
- assembly\arm64\SQLite.Interop.dll
- assembly\linux-arm64\readme.txt
- assembly\linux-x64\System.Data.SQLite.dll
Version History
Version | Downloads | Last updated |
---|---|---|
1.0.0 (current version) | 27 | 5/30/2025 |
0.14.0 | 10,555 | 8/22/2024 |
0.13.0 | 4,198 | 2/22/2024 |
0.12.0 | 1,712 | 9/29/2023 |
0.11.2 | 1,512 | 2/23/2023 |
0.11.0 | 15 | 2/21/2023 |
0.10.1 | 287 | 9/14/2022 |
0.10.0 | 135 | 9/12/2022 |
0.9.2 | 372 | 8/1/2022 |
0.9.1 | 177 | 8/1/2022 |
0.9.0 | 180 | 8/1/2022 |
0.8.0 | 177 | 8/1/2022 |
0.7.0 | 196 | 7/21/2022 |
0.6.0 | 191 | 7/20/2022 |