mySQLite_v1.0.0

Changelog for MySQLite

v1.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]
• Updated Get-MySqliteDB to handle database files stored in OneDrive. [Issue #27]

mySQLite_v0.14.0

Changelog for MySQLite

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 This may be a breaking change.

mySQLite_v0.13.0

Changelog for MySQLite

v0.13.0 - 2024-02-22 10:46:15

Changed

• Updated module code to load SQLite assemblies.
• Updated and reorganized SQLite assemblies.
• Updated Get-SQLiteVersion display operating system information derived from $PSVersionTable.
• Updated README.md.
• Documentation updates.

Added

• Added modules to support Linux. Issue #21 Thanks to jhoneill,rhubarb-geek-nz, and jhochwald

mySQLite_v0.12.0

Changelog for mySQLite

0.12.0

Changed

• Pull request #20 for better handling of SQL query errors. Thanks mavaddat.
• Updated SQLite assemblies.
• Updated README.md.

Added

• Added command Get-SQLiteVersion

mySQLite_v0.11.2

Changelog for mySQLite

0.11.2

Changed

• Fixed typo in Open-MySQLiteDB. Issue #18

mySQLite_v0.11.1

Changelog for mySQLite

0.11.1

This release is identical in files to v0.11.0 published on the PowerShell Gallery. This release corrects a problem pushing the 0.11.0 release to GitHub.

mySQLite_v0.11.0

Changelog for mySQLite

0.11.0

Added

• Added private functions Convert-ToXml and Convert-FromXML to use [System.Management.Automation.PSSerializer] instead of temp files. Thanks to @SeSeKenny for the suggestion and code. Issue #16)
• Added sample databases.

Changed

• Modified private build query function to use the new private serialization functions.

• Modify parameter validation checks on the database file to include all file name extensions as defined for SQLite in in Wikipedia. This addresses (Issue #17)

  • .sqlite
  • .sqlite3
  • .db
  • .db3
  • .s3db
  • .sl3

• Upgrade System.Data.SQLite.dll to version 1.0.117.0.

• General code clean up.

• Updated README.md.

• Help updates.

mySQLite_v0.10.1

Changelog for mySQLite

0.10.1

• Add missing online help links.
• Help updates.

mySQLite_v0.10.0

Changelog for mySQLite

0.10.0

• Updated New-MySQLiteDBTable to allow user to specify which column to use as the index. This also required an update to ConvertTo-MySQLiteDB. This should fix Issue #13
• Revised private function buildquery to enclose property names with dashes inside square brackets. Instead of using msDS-User-Account-Control-Computed in a SQL query, it will be entered as [msDS-User-Account-Control-Computed]. Dashes are not allowed as column headings. This should fix Issue #14
• Also updated queries to escape quotes when property values.
• Updated ConvertFrom-MySQLiteDB to better handle importing serialized data.Issue #15
• Added a public function, Convert-MySQLiteByteArray to convert blob bytes array back to the original object.
• Changed Write-Host commands to Write-Verbose in Import-MySQLiteDB.
• Help updates.

mySQLite_v0.9.2

Changelog for mySQLite

0.9.2

• Fixed typo Get-MySQLiteDB that was causing an error getting the database file creation time.