OGA.Postgres.DAL 2.0.0

dotnet add package OGA.Postgres.DAL --version 2.0.0                
NuGet\Install-Package OGA.Postgres.DAL -Version 2.0.0                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="OGA.Postgres.DAL" Version="2.0.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add OGA.Postgres.DAL --version 2.0.0                
#r "nuget: OGA.Postgres.DAL, 2.0.0"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install OGA.Postgres.DAL as a Cake Addin
#addin nuget:?package=OGA.Postgres.DAL&version=2.0.0

// Install OGA.Postgres.DAL as a Cake Tool
#tool nuget:?package=OGA.Postgres.DAL&version=2.0.0                

OGA.Postgres.DAL

Data Access Layer for PostGres SQL

Description

This library provides a Data Access Layer (DAL) and a class of tools for managing PostGres SQL databases, tables, and users.

Postgres_DAL

Wraps the ceremony of using NpgSQL, to perform the following types of actions:

  • Tabular and Scalar Queries
  • Non Queries
    For sql commands, such as: database creations, role grants, table drops, etc...
  • Bulk Binary Importing
    Syntactical sugar for the NpgsqlBinaryImporter, which provides multi-row inserts without the need for string sanitization
  • Stored Procedures calls
    With RC return, and with/without Terminal Select
DatabaseLayout_Tool

Abstracts database/table structure management of a PostgreSQL database, into a serializable layout of POCOs.
This allows for database management in terms of JSON-serializable layout objects, instead of SQL scripts.
Using the layout abstraction of this class, allows the following use cases:

  • Create a database from a layout
  • Create a layout from a database
  • Serialize a layout (of a database) to and from json
  • Version a database layout in git, as json
  • Reconcile a database and layout, generating a list of differences
  • Reconcile differences between database instances... across environments, such as: dev/test/prod
  • Verify a database is compatible with a starting service, by performing a verification check with a json-serialized layout.
Postgres_Tools

This class includes lots of methods for management of hosts, databases, tables, users, and permissions, allowing the developer to work in terms of method calls, without SQL scripts.

  • Host Management:

    • Get_DataDirectory()
      Identifies the filesystem path where databases are stored
    • Get_Database_FolderPath()
      Locates the specific folder path for a database
  • Database Management:

    • Create_Database()
    • Is_Database_Present()
    • Drop_Database()
    • Get_DatabaseList()
    • GetDatabaseOwner()
    • ChangeDatabaseOwner()
    • Backup_Database() - Not yet implemented.
    • Restore_Database() - Not yet implemented.
    • Get_DatabaseSize()
  • Table Management:

    • Create_Table()
    • DoesTableExist()
    • Drop_Table()
    • Get_TableList_forDatabase()
    • Get_PrimaryKeyConstraints_forTable()
      Key_column, constraint_name, position_ordinal
    • Get_ColumnList_forTable()
      List of column names in a table.
    • Get_ColumnInfo_forTable()
      Columnname, datatype, length, isnullable, etc...
    • Get_TableSize()
    • Get_RowCount_for_Tables()
  • User Management:

    • GetUserList()
    • Does_Login_Exist()
    • CreateUser()
    • ChangeUserPassword()
    • DeleteUser()
  • Permissions Management:

    • GrantSuperUser()

    • IsSuperUser()

    • DenySuperUser()

    • GrantDBCreate()

    • HasDBCreate()

    • DenyDBCreate()

    • GrantCreateRole()

    • HasCreateRole()

    • DenyCreateRole()

    • GrantAllforUserOnDatabase()

    • GrantAllforUserOnTable()

    • GetTablePrivilegesforUser()

    • SetTablePrivilegesforUser()

Installation

OGA.Postgres.DAL is available via NuGet:

  • NuGet Official Releases: NuGet

Dependencies

This library depends on:

Building OGA.Postgres.DAL

This library is built with the new SDK-style projects. It contains multiple projects, one for each of the following frameworks:

  • NET 5
  • NET 6
  • NET 7

And, the output nuget package includes runtimes targets for:

  • linux-any
  • win-any

Framework and Runtime Support

Currently, the nuget package of this library supports the framework versions and runtimes of applications that I maintain (see above).
If someone needs others (older or newer), let me know, and I'll add them to the build script.

Visual Studio

This library is currently built using Visual Studio 2022 17.2.

License

Please see the License.

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.0.0 78 11/28/2024
1.3.4 78 11/28/2024
1.3.3 76 11/28/2024
1.3.2 80 11/28/2024
1.3.1 97 11/12/2024
1.3.0 99 6/18/2024
1.2.0 101 6/18/2024
1.1.10 80 6/10/2024
1.1.9 98 6/10/2024
1.1.8 100 6/10/2024