magic.lambda.pgsql
17.2.0
dotnet add package magic.lambda.pgsql --version 17.2.0
NuGet\Install-Package magic.lambda.pgsql -Version 17.2.0
<PackageReference Include="magic.lambda.pgsql" Version="17.2.0" />
paket add magic.lambda.pgsql --version 17.2.0
#r "nuget: magic.lambda.pgsql, 17.2.0"
// Install magic.lambda.pgsql as a Cake Addin #addin nuget:?package=magic.lambda.pgsql&version=17.2.0 // Install magic.lambda.pgsql as a Cake Tool #tool nuget:?package=magic.lambda.pgsql&version=17.2.0
magic.lambda.pgsql - Using PostgreSQL from Hyperlambda
This is the PostgreSQL data adapter for Magic. This project allows you to provide a semantic lambda structure to its slots, which in turn will dynamically create a PostgreSQL dialect SQL statement for you, for all basic types of CRUD SQL statements. In addition, it provides slots to open a PostgreSQL database connection, and such allows you to declare your own SQL statements to be executed towards a PostgreSQL database. Slots this project contains are as follows.
- [pgsql.connect] - Connects to a database
- [pgsql.create] - Creates a single record in the specified table
- [pgsql.read] - Reads multiple records from the specified table
- [pgsql.update] - Updates a single record in the specified table
- [pgsql.delete] - Deletes a single record in the specified table
- [pgsql.select] - Executes an arbitrary SQL statement, and returns results of reader as lambda objects to caller
- [pgsql.scalar] - Executes an arbitrary SQL statement, and returns the result as a scalar value to caller
- [pgsql.execute] - Executes an aribitrary SQL statement
- [pgsql.transaction.create] - Creates a new transaction
- [pgsql.transaction.commit] - Explicitly commits an open transaction
- [pgsql.transaction.rollback] - Explicitly rolls back an open transaction
Notice - If you use any of the CRUD slots from above, the whole idea is that you can polymorphistically use the same lambda object, towards any of the underlaying database types, and the correct specific syntax for your particular database vendor's SQL syntax will be automatically generated. This allows you to transparently use the same lambda object, towards any of the database types Magic supports, without having to change it in any ways.
All of the slots in this project are documented in the documentation for the "magic.data.common" project. If you replace the [data.xxx] or [sql.xxx] slots with [pgsql.xxx], you will use the PgSQL specific slots, instead of the generic, and/or polymorphistic slots. Hence, please refer to the documentation for "magic.data.common" to see the complete documentation for this project. If you need for instance documentation about the [pgsql.connect] slot you should look for the documentation for [data.connect], since it's more or less the exact same documentation.
Magic's GitHub project page
Magic is 100% Open Source and you can find the primary project GitHub page here.
Project website for magic.lambda.pgsql
The source code for this repository can be found at github.com/polterguy/magic.lambda.pgsql, and you can provide feedback, provide bug reports, etc at the same place.
Copyright and maintenance
The projects is copyright Thomas Hansen 2023 - 2024, and professionally maintained by AINIRO.IO.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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 was computed. 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. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- magic.data.common (>= 17.2.0)
- Npgsql (>= 8.0.1)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on magic.lambda.pgsql:
Package | Downloads |
---|---|
magic.library
Helper project for Magic to wire up everything easily by simply adding one package, and invoking two simple methods. When using Magic, this is (probably) the only package you should actually add, since this package pulls in everything else you'll need automatically, and wires up everything sanely by default. To use package go to https://polterguy.github.io |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
17.2.0 | 357 | 1/22/2024 |
17.1.7 | 165 | 1/12/2024 |
17.1.6 | 132 | 1/11/2024 |
17.1.5 | 140 | 1/5/2024 |
17.0.1 | 178 | 1/1/2024 |
17.0.0 | 307 | 12/14/2023 |
16.11.5 | 274 | 11/12/2023 |
16.9.0 | 295 | 10/9/2023 |
16.7.0 | 498 | 7/11/2023 |
16.4.1 | 328 | 7/2/2023 |
16.4.0 | 340 | 6/22/2023 |
16.3.1 | 274 | 6/7/2023 |
16.3.0 | 288 | 5/28/2023 |
16.1.9 | 558 | 4/30/2023 |
15.10.11 | 418 | 4/13/2023 |
15.9.1 | 526 | 3/27/2023 |
15.9.0 | 408 | 3/24/2023 |
15.8.2 | 443 | 3/20/2023 |
15.7.0 | 307 | 3/6/2023 |
15.5.0 | 1,481 | 1/28/2023 |
15.2.0 | 593 | 1/18/2023 |
15.1.0 | 1,095 | 12/28/2022 |
14.5.7 | 640 | 12/13/2022 |
14.5.5 | 738 | 12/6/2022 |
14.5.1 | 606 | 11/23/2022 |
14.5.0 | 544 | 11/18/2022 |
14.4.5 | 648 | 10/22/2022 |
14.4.1 | 702 | 10/22/2022 |
14.4.0 | 587 | 10/17/2022 |
14.3.1 | 1,193 | 9/12/2022 |
14.3.0 | 577 | 9/10/2022 |
14.1.3 | 835 | 8/7/2022 |
14.1.2 | 595 | 8/7/2022 |
14.1.1 | 612 | 8/7/2022 |
14.0.14 | 605 | 7/26/2022 |
14.0.12 | 603 | 7/24/2022 |
14.0.11 | 585 | 7/23/2022 |
14.0.10 | 584 | 7/23/2022 |
14.0.9 | 574 | 7/23/2022 |
14.0.8 | 669 | 7/17/2022 |
14.0.5 | 715 | 7/11/2022 |
14.0.4 | 714 | 7/6/2022 |
14.0.3 | 644 | 7/2/2022 |
14.0.2 | 612 | 7/2/2022 |
14.0.0 | 810 | 6/25/2022 |
13.4.0 | 1,952 | 5/31/2022 |
13.3.4 | 1,351 | 5/9/2022 |
13.3.0 | 873 | 5/1/2022 |
13.2.0 | 1,084 | 4/21/2022 |
13.1.0 | 955 | 4/7/2022 |
13.0.0 | 685 | 4/5/2022 |
11.0.5 | 1,337 | 3/2/2022 |
11.0.4 | 679 | 2/22/2022 |
11.0.3 | 695 | 2/9/2022 |
11.0.2 | 725 | 2/6/2022 |
11.0.1 | 693 | 2/5/2022 |
10.0.21 | 690 | 1/28/2022 |
10.0.20 | 704 | 1/27/2022 |
10.0.19 | 686 | 1/23/2022 |
10.0.18 | 651 | 1/17/2022 |
10.0.16 | 679 | 1/14/2022 |
10.0.15 | 654 | 12/31/2021 |
10.0.14 | 505 | 12/28/2021 |
10.0.7 | 1,376 | 12/22/2021 |
10.0.5 | 665 | 12/18/2021 |
10.0.1 | 716 | 12/13/2021 |