MySQLite
MySQLite copied to clipboard
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,...