Proxx.SQLite

SQLite PowerShell CmdLets

CommandType     Name                                               Version    Source
-----------     ----                                               -------    ------
Cmdlet          Complete-SQLiteTransaction                         1.1.1.1    Proxx.SQLite
Cmdlet          Compress-SQLite                                    1.1.1.1    Proxx.SQLite
Cmdlet          Connect-SQLite                                     1.1.1.1    Proxx.SQLite
Cmdlet          Disconnect-SQLite                                  1.1.1.1    Proxx.SQLite
Cmdlet          Get-SQLite                                         1.1.1.1    Proxx.SQLite
Cmdlet          Invoke-SQLiteFill                                  1.1.1.1    Proxx.SQLite
Cmdlet          New-SQLiteTable                                    1.1.1.1    Proxx.SQLite
Cmdlet          New-SQLiteTransaction                              1.1.1.1    Proxx.SQLite
Cmdlet          Out-SQLiteTable                                    1.1.1.1    Proxx.SQLite
Cmdlet          Undo-SQLiteTransaction                             1.1.1.1    Proxx.SQLite
Cmdlet          Write-SQLite                                       1.1.1.1    Proxx.SQLite

PowerShell Gallery

changelog:

• cloned function Read-SQLite to Get-SQLite
• added support for parameter to Get-SQLite
• add support for sqlite paramters to Write-SQLite
• updated aliasses
• change ReturnObject to ReturnDataTable
• added comments to Get-SQLite

todo:

• see if Write-SQLite could support SQLiteDataAdapter INSERTS,UPDATES,DELETES

• more useage of verbose messages.

• add function Update-SQLiteTable.ps1

  • use SQLiteDataAdapter to upload datatable to sqlite