MySQLite
MySQLite copied to clipboard
jdhitsolutions
A small set of PowerShell commands for working with SQLite database files.
I've got text similar to this in a json file that I am importing where it contains the single quotes. "Item": "Restrict user ability to access groups features in My...
The following code works for me: ```ps $Date = Get-Date '01/01/2000' $StateEntry = [PSCustomObject]@{ ID = (New-Guid).Guid Date = $Date } $DbPath = "$env:TEMP\state.db" [System.GC]::Collect() if (Test-Path -Path $DbPath) {...
I would love to be able to support non-Windows platforms using PowerShell 7. Unfortunately, I have not had any luck finding compatible libraries, i.e., `System.Data.SqLite.dll` and `SQLite.Interop.dll`. I am more...
When creating a database file it doesn't release the file until you close the terminal, is this expected behaviour? I was toying around and used the command and then tried...
https://stackoverflow.com/questions/1381264/password-protect-a-sqlite-db-is-it-possible
Hi, I really appreciate all the work put into this module. It's been overall easy to use and extremely useful. However, I am finding it difficult to properly error handle,...
_OneDrive_ files have a `ReparsePoint` and a `$null` `.Target` property. Would it be reasonable to support another check in the below `if` like `-and $null -ne $ThisDb.Target` otherwise `Get-Item` will...
Usage like the below throws a few errors and confusing warnings. The table `metada` is misspelled and should be `metadata`. ```pwsh New-MySQLiteDB .\t.db Invoke-MySqliteQuery .\t.db -Query 'select * from metadat;'...
I would think the `-pa` should be removed. Even though it would only fail on an arm system. Apparently, `pwsh`, will ignore the malformed code. https://github.com/jdhitsolutions/MySQLite/blob/1b77a2fb719309a965b30ce877665169b7ef6503/mySQLite.psm1#L19
Metadata
Owner
Metadata
A small set of PowerShell commands for working with SQLite database files.