GenXdev.Data
2.1.2025
A Windows PowerShell module with helpers for working with data and databases
Minimum PowerShell version
7.5.4
Installation Options
Owners
Copyright
Copyright 2021-2025 GenXdev
Requires License Acceptance
Package Details
Author(s)
- genXdev
Tags
DataScience Data SqlServer MWSQLServer SQLite
Cmdlets
Get-GenXdevPreference Get-GenXdevPreferenceNames Get-GenXdevPreferencesDatabasePath Get-KeyValueStoreNames Get-KeyValueStorePath Get-SQLiteSchema Get-SQLiteTableColumnData Get-SQLiteTableData Get-SQLiteTables Get-SQLiteTableSchema Get-SQLiteViewColumnData Get-SQLiteViewData Get-SQLiteViews Get-SQLiteViewSchema Get-SQLServerSchema Get-SQLServerTableColumnData Get-SQLServerTableData Get-SQLServerTables Get-SQLServerTableSchema Get-SQLServerViewColumnData Get-SQLServerViewData Get-SQLServerViews Get-SQLServerViewSchema Get-StoreKeys Get-ValueByKeyFromStore Initialize-KeyValueStores Invoke-SQLiteStudio Invoke-SSMS Remove-GenXdevPreference Remove-KeyFromStore Remove-KeyValueStore Set-GenXdevDefaultPreference Set-GenXdevPreference Set-GenXdevPreferencesDatabasePath Set-ValueByKeyInStore Sync-KeyValueStore
Functions
EnsureSQLiteStudioInstalled EnsureSSMSInstalled Get-SQLiteTransaction Get-SQLServerTransaction Invoke-SQLiteQuery Invoke-SQLServerQuery New-SQLiteDatabase New-SQLServerDatabase
PSEditions
Dependencies
-
- GenXdev.FileSystem (>= 2.1.2025)
- GenXdev.Helpers (>= 2.1.2025)
FileList
- GenXdev.Data.nuspec
- GenXdev.Data.Preferences.psm1
- GenXdev.Data.KeyValueStore.psm1
- GenXdev.Data.psd1
- GenXdev.Data.psm1
- GenXdev.Data.SqlServer.psm1
- License.txt
- README.md
- lib\GenXdev.Data.dll
- Functions\GenXdev.Data.KeyValueStore\Get-KeyValueStorePath.cs
- Functions\GenXdev.Data.KeyValueStore\Get-ValueByKeyFromStore.cs
- Functions\GenXdev.Data.KeyValueStore\Remove-KeyFromStore.cs
- Functions\GenXdev.Data.KeyValueStore\Set-ValueByKeyInStore.cs
- Functions\GenXdev.Data.Preferences\Get-GenXdevPreference.cs
- Functions\GenXdev.Data.Preferences\Get-GenXdevPreferencesDatabasePath.cs
- Functions\GenXdev.Data.Preferences\Set-GenXdevDefaultPreference.cs
- Functions\GenXdev.Data.Preferences\Set-GenXdevPreferencesDatabasePath.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteSchema.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteTableData.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteTableSchema.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteViewColumnData.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteViews.cs
- Functions\GenXdev.Data.SQLite\Invoke-SQLiteQuery.ps1
- Functions\GenXdev.Data.SQLite\New-SQLiteDatabase.ps1
- Functions\GenXdev.Data.SqlServer\Get-SQLServerSchema.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerTableData.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerTableSchema.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerViewColumnData.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerViews.cs
- Functions\GenXdev.Data.SqlServer\Invoke-SqlServerQuery.ps1
- Functions\GenXdev.Data.SqlServer\Invoke-SSMS.cs
- Functions\GenXdev.Data.SqlServer\New-SQLServerDatabase.ps1
- Tests\GenXdev.Data.KeyValueStore\Get-KeyValueStoreNames.Tests.ps1
- Tests\GenXdev.Data.KeyValueStore\Get-StoreKeys.Tests.ps1
- Tests\GenXdev.Data.KeyValueStore\Get-ValueByKeyFromStore.Tests.ps1
- Tests\GenXdev.Data.KeyValueStore\Remove-KeyFromStore.Tests.ps1
- Tests\GenXdev.Data.KeyValueStore\Remove-KeyValueStore.Tests.ps1
- Tests\GenXdev.Data.KeyValueStore\Set-ValueByKeyInStore.Tests.ps1
- Tests\GenXdev.Data.KeyValueStore\Sync-KeyValueStore.Tests.ps1
- Tests\GenXdev.Data.Preferences\Get-GenXdevPreference.Tests.ps1
- Tests\GenXdev.Data.Preferences\Remove-GenXdevPreference.Tests.ps1
- Tests\GenXdev.Data.Preferences\Set-GenXdevDefaultPreference.Tests.ps1
- Tests\GenXdev.Data.Preferences\Set-GenXdevPreference.Tests.ps1
- Tests\GenXdev.Data.SqlServer\Get-SQLServerTableData.Tests.ps1
- Tests\GenXdev.Data.SqlServer\Get-SQLServerTables.Tests.ps1
- Tests\GenXdev.Data.SqlServer\Get-SQLServerTableSchema.Tests.ps1
- Tests\GenXdev.Data.SqlServer\Get-SQLServerTransaction.Tests.ps1
- Tests\GenXdev.Data.SqlServer\Invoke-SQLServerQuery.Tests.ps1
- Tests\GenXdev.Data.SqlServer\New-SQLServerDatabase.Tests.ps1
- GenXdev.Data.csproj
- GenXdev.Data.SQLite.psm1
- LICENSE
- powershell.jpg
- lib\GenXdev.Data.deps.json
- Functions\GenXdev.Data.KeyValueStore\Get-KeyValueStoreNames.cs
- Functions\GenXdev.Data.KeyValueStore\Get-StoreKeys.cs
- Functions\GenXdev.Data.KeyValueStore\Initialize-KeyValueStores.cs
- Functions\GenXdev.Data.KeyValueStore\Remove-KeyValueStore.cs
- Functions\GenXdev.Data.KeyValueStore\Sync-KeyValueStore.cs
- Functions\GenXdev.Data.Preferences\Get-GenXdevPreferenceNames.cs
- Functions\GenXdev.Data.Preferences\Remove-GenXdevPreference.cs
- Functions\GenXdev.Data.Preferences\Set-GenXdevPreference.cs
- Functions\GenXdev.Data.SQLite\EnsureSQLiteStudioInstalled.ps1
- Functions\GenXdev.Data.SQLite\Get-SQLiteTableColumnData.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteTables.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteTransaction.ps1
- Functions\GenXdev.Data.SQLite\Get-SQLiteViewData.cs
- Functions\GenXdev.Data.SQLite\Get-SQLiteViewSchema.cs
- Functions\GenXdev.Data.SQLite\Invoke-SQLiteStudio.cs
- Functions\GenXdev.Data.SqlServer\EnsureSSMSInstalled.ps1
- Functions\GenXdev.Data.SqlServer\Get-SQLServerTableColumnData.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerTables.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerTransaction.ps1
- Functions\GenXdev.Data.SqlServer\Get-SQLServerViewData.cs
- Functions\GenXdev.Data.SqlServer\Get-SQLServerViewSchema.cs
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 2.1.2025 (current version) | 16 | 10/23/2025 |
| 2.0.2025 | 4 | 10/23/2025 |
| 1.3066.2025 | 12 | 10/21/2025 |
| 1.304.2025 | 3 | 10/21/2025 |
| 1.302.2025 | 9 | 10/20/2025 |
| 1.300.2025 | 33 | 10/9/2025 |
| 1.298.2025 | 5 | 10/8/2025 |
| 1.296.2025 | 19 | 10/7/2025 |
| 1.294.2025 | 11 | 10/7/2025 |
| 1.292.2025 | 5 | 10/7/2025 |
| 1.290.2025 | 32 | 10/1/2025 |
| 1.288.2025 | 6 | 9/29/2025 |
| 1.286.2025 | 11 | 9/23/2025 |
| 1.284.2025 | 5 | 9/23/2025 |
| 1.282.2025 | 10 | 9/22/2025 |
| 1.280.2025 | 7 | 9/22/2025 |
| 1.278.2025 | 5 | 9/22/2025 |
| 1.276.2025 | 9 | 9/18/2025 |
| 1.274.2025 | 6 | 9/17/2025 |
| 1.272.2025 | 5 | 9/17/2025 |
| 1.270.2025 | 5 | 9/16/2025 |
| 1.268.2025 | 5 | 9/16/2025 |
| 1.264.2025 | 11 | 9/16/2025 |
| 1.260.2025 | 46 | 8/24/2025 |
| 1.258.2025 | 9 | 8/24/2025 |
| 1.256.2025 | 7 | 8/23/2025 |
| 1.254.2025 | 8 | 8/22/2025 |
| 1.252.2025 | 12 | 8/21/2025 |
| 1.250.2025 | 10 | 8/20/2025 |
| 1.248.2025 | 8 | 8/20/2025 |
| 1.246.2025 | 8 | 8/20/2025 |
| 1.244.2025 | 8 | 8/20/2025 |
| 1.242.2025 | 7 | 8/20/2025 |
| 1.238.2025 | 13 | 8/14/2025 |
| 1.236.2025 | 15 | 8/8/2025 |
| 1.234.2025 | 13 | 8/6/2025 |
| 1.232.2025 | 13 | 8/5/2025 |
| 1.230.2025 | 7 | 8/4/2025 |
| 1.228.2025 | 29 | 8/2/2025 |
| 1.226.2025 | 6 | 8/2/2025 |
| 1.224.2025 | 23 | 7/30/2025 |
| 1.220.2025 | 13 | 7/27/2025 |
| 1.218.2025 | 12 | 7/26/2025 |
| 1.216.2025 | 17 | 7/25/2025 |
| 1.214.2025 | 5 | 7/24/2025 |
| 1.212.2025 | 12 | 7/24/2025 |
| 1.210.2025 | 8 | 7/23/2025 |
| 1.208.2025 | 27 | 7/19/2025 |
| 1.206.2025 | 7 | 7/19/2025 |
| 1.204.2025 | 15 | 7/18/2025 |
| 1.202.2025 | 12 | 7/17/2025 |
| 1.200.2025 | 36 | 7/2/2025 |
| 1.198.2025 | 9 | 6/30/2025 |
| 1.196.2025 | 8 | 6/29/2025 |
| 1.194.2025 | 6 | 6/29/2025 |
| 1.192.2025 | 6 | 6/28/2025 |
| 1.190.2025 | 9 | 6/24/2025 |
| 1.188.2025 | 7 | 6/23/2025 |
| 1.186.2025 | 6 | 6/22/2025 |
| 1.184.2025 | 9 | 6/20/2025 |
| 1.182.2025 | 7 | 6/19/2025 |
| 1.180.2025 | 7 | 6/18/2025 |
| 1.178.2025 | 7 | 6/16/2025 |
| 1.176.2025 | 13 | 6/8/2025 |
| 1.174.2025 | 47 | 5/9/2025 |
| 1.172.2025 | 35 | 4/3/2025 |
| 1.170.2025 | 7 | 4/3/2025 |
| 1.164.2025 | 7 | 4/3/2025 |
| 1.162.2025 | 10 | 3/29/2025 |
| 1.160.2025 | 7 | 3/27/2025 |
| 1.158.2025 | 6 | 3/27/2025 |
| 1.156.2025 | 8 | 3/27/2025 |
| 1.154.2025 | 6 | 3/26/2025 |
| 1.152.2025 | 7 | 3/25/2025 |
| 1.150.2025 | 6 | 3/24/2025 |
| 1.148.2025 | 14 | 3/22/2025 |
| 1.146.2025 | 6 | 3/22/2025 |
| 1.144.2025 | 6 | 3/22/2025 |
| 1.142.2025 | 10 | 3/21/2025 |
| 1.140.2025 | 10 | 3/20/2025 |
| 1.138.2025 | 8 | 3/19/2025 |
| 1.136.2025 | 6 | 3/19/2025 |
| 1.134.2025 | 7 | 3/17/2025 |
| 1.132.2025 | 6 | 3/17/2025 |
| 1.130.2025 | 11 | 3/14/2025 |
| 1.128.2025 | 7 | 3/14/2025 |
| 1.126.2025 | 10 | 3/11/2025 |
| 1.124.2025 | 12 | 3/11/2025 |
| 1.122.2025 | 6 | 3/10/2025 |
| 1.120.2025 | 12 | 3/10/2025 |
| 1.118.2025 | 8 | 3/9/2025 |
| 1.116.2025 | 70 | 2/15/2025 |
| 1.114.2025 | 11 | 2/15/2025 |
| 1.112.2025 | 9 | 2/12/2025 |
| 1.110.2025 | 9 | 2/11/2025 |
| 1.108.2025 | 7 | 2/11/2025 |
| 1.106.2025 | 13 | 2/10/2025 |
| 1.104.2025 | 10 | 2/8/2025 |
| 1.102.2025 | 15 | 2/2/2025 |
| 1.100.2025 | 8 | 2/2/2025 |
| 1.98.2025 | 11 | 2/1/2025 |
| 1.96.2025 | 7 | 2/1/2025 |
| 1.94.2025 | 6 | 2/1/2025 |
| 1.92.2025 | 8 | 2/1/2025 |