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

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

Install-Module -Name mySQLite

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

Install-PSResource -Name mySQLite

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) 2019-2025 JDH Information Technology Solutions, Inc.

Package Details

Author(s)

  • Jeff Hicks

Tags

sqlite database linux

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

Desktop Core

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

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
Show more