PSSQLite

PSSQLite copied to clipboard

You should fix Line 8 of `PSSQLite.psm1` `if ($PSEdition -like 'core')` The Powershell Core x64 Global Variable `$PSEdition` on Linux delivers `"core"` instead of `"Core"`. Because you asking explicit for...

Gill-Bates

Invoke-SqliteQuery : Exception calling "Fill" with "1" argument(s): "String was not recognized as a valid DateTime."

2

The SQLite db I am attempting to get date from has columns that are in a Date/Time format like this `2019-07-02 04:59:18.578 +00:00` . It seems my queries all fail...

boochkn

I tried installing PSSQLlite 1.1.0 but there is a conflict as can be seen below: ``` PackageManagement\Install-Package : The following commands are already available on this system:'Out-DataTable'. This module 'PSSQLite'...

DyJohnnY

Running PS7 Core on a Rasperry Pi 3+: `PS /root> $PSVersionTable` ``` Name Value ---- ----- PSVersion 7.1.3 PSEdition Core GitCommitId 7.1.3 OS Linux 5.10.17-v7+ #1403 SMP Mon Feb 22...

Gill-Bates

Unable to find type [DBNullScrubber].

3

I am having a handful of Windows 10 1909 machines out of 2,500 that seem to dislike Invoke-SqliteQuery when returning data as a PSObject. I get this error: Unable to...

DonMWyatt

Invoke-SqliteQuery Fails when there is Rank() used in views

4

Invoke-SqliteQuery is failing if we have used Rank(), or in fact any analytic function in view queries. Below is the error that I am getting. "database disk image is malformed...

manikandancr

To fix #29 Change the import logic for .dlls for windows to always point to the new binaries implemented as part of the PS core port. Tested on: windows PS5,...

bgwdotdev

PowerShell 7: CREATE table works, SELECT table doesnt

4

Works fine in Windows PowerShell 5, doesnt work in 7 Works: CREATE table Customers Doesnt work: SELECT * from Customers InvalidOperation: \PowerShell\Modules\PSSQLite\1.0.3\Invoke-SqliteQuery.ps1:518:25 Line | 518 | [DBNullScrubber]::DataRowToPSObject($row) | ~~~~~~~~~~~~~~~~ |...

slashd

it is a minor, but I personally think we should follow the same style for commands, not like this: Get-Command -Module PSSQLite CommandType Name Version Source ----------- ---- ------- ------...

clatze

In a number of different areas where I use PSSQLite I use script analyzer before things to go production. This was a problem because in a number of areas it...

evetsleep