{"repo":"mithrandyr/SimplySql","free":true,"listed":false,"github":"https://github.com/mithrandyr/SimplySql","clone":"git clone https://github.com/mithrandyr/SimplySql.git","description":"PowerShell module for querying various SQL databases","language":"Visual Basic .NET","stars":228,"topics":["powershell","sqlserver","sqlite","npgsql","postgresql","mysql","oracle"],"license":"MIT","category":"databases-storage","readme_excerpt":"SimplySql Introduction Update (2/8/2024): V2 is Released!!!. Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities. SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done. The basic pattern is to connect to a database, invoke one or more sql statements and then close your database connection. This module provides cmdlets that map to this basic pattern. Each Provider has its own 'Open- Connection' cmdlet, but the remaining cmdlets are provider agnostic (MSSQL: Open-SqlConnection, Oracle: Open-OracleConnection, SQLite: Open-SQLiteConnection, etc). You can have multiple connections open, just distinguish them through the use of the -ConnectionName parameter on every command (if no ConnectionName is specified, it defaults to 'default'). See the Wiki for more details Breaking Changes for 2.0 - UserName/Password parameters are no longer present on Open- Connection cmdlets. Instead, provide a PSCredential object. Status It has been released to PowerShellGallery. Installation is as simple as Install-Module SimplySql -Scope CurrentUser This module requires PowerShell Version 5.0 or greater Database Providers - Microsoft Sql Server : Microsoft.Data.SqlClient 5.2.2 - MySQL : MySqlConnector 2.4.0 - Oracle : Oracle.ManagedDataAccess.Core 2.19.250 (this is the latest version supporting .NET Standard 2.0) - S","default_branch":null,"files":null,"tree":[],"storefront":"/r/mithrandyr","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mithrandyr/SimplySql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}