mySQLite
0.14.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-2024 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
## v0.14.0 - 2024-08-22 09:48:22
### Changed
- Updated Import-MySqliteDB to use an existing database. The new parameter is called UseExisting with an alias of Append. _This may be a breaking change_.
- Updated functions with additional verbose output to capture PowerShell version and culture.
- Help updates
- Updated README.md
### Fixed
- Modified helper functions to store DateTime values as yyyy-MM-dd HH:mm:ss which should better handle culture-related problems. [Issue #23](https://github.com/jdhitsolutions/mySQLite/issues/23) _This may be a breaking change_.
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\Import-MySQLiteDB.ps1
- functions\New-MySQLiteDB.ps1
- functions\Open-MySQLiteDB.ps1
- samples\inventory.db
- samples\sysinfo.db
- assembly\archive\System.Data.SQLite.dll
- assembly\linux-x64\SQLite.Interop.dll.so
- 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\Invoke-MySQLiteQuery.ps1
- functions\New-MySQLiteDBTable.ps1
- functions\private.ps1
- samples\sales.db
- assembly\archive\SQLite.Interop.dll
- assembly\archive\System.Data.SQLite.xml
- assembly\linux-x64\System.Data.SQLite.dll
- 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
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 0.14.0 (current version) | 4,054 | 8/22/2024 |
| 0.13.0 | 4,181 | 2/22/2024 |
| 0.12.0 | 1,711 | 9/29/2023 |
| 0.11.2 | 1,507 | 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 |