{"repo":"Brick-Abode/pldotnet","free":true,"listed":false,"github":"https://github.com/Brick-Abode/pldotnet","clone":"git clone https://github.com/Brick-Abode/pldotnet.git","description":"Build PostgreSQL functions, procedures, and triggers in C# and F#","language":"C#","stars":164,"topics":["csharp","dotnet","dotnet-core","fsharp","postgresql","postgresql-extension","sql"],"license":"PostgreSQL","category":"databases-storage","readme_excerpt":"PL/.NET pl/dotnet adds full support for C# and F# to PostgreSQL. 0.99 is our public beta release. - In our benchmarks, pl/dotnet is the fastest PL in PostgreSQL - We support all Procedural Language (PL) operations: functions, procedures, DO, SPI, triggers, records, SRF, OUT/INOUT, table functions, etc - We natively support 38 out of 46 standard user types, the most of any non-native PL - We are the only PL using the native database API; our database access(SPI) is fully NPGSQL-compatible - We support both SQL-embedded code blocks and also loading functions from DLLs - We have extensive testing, with 1065 unit tests across both C# and F# - 100% free software under the PostgreSQL license Our white paper has extensive discussion of all of these items; check it out. Usage examples Here is an example that returns a set of records in C#: The same example in F#: The tests/ folder has a complete suite of unit tests in both C# and F#; we encourage you to consult it for examples of SQL code for your favorite datatype or SQL feature. Major features We support all SQL function modes: - normal procedures and functions - full support for trigger functions: trigger arguments, old/new row, row rewriting (where allowed), and all the standard trigger information - set-returning functions, nicely mapped to iterators in C# and sequences in F# - table functions, as well as functions returning records or sets of records - full support for IN/OUT/INOUT functions - full support for trigger functions","default_branch":null,"files":null,"tree":[],"storefront":"/r/Brick-Abode","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Brick-Abode/pldotnet/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."}