TWCore.Data.PostgreSQL 3.1.0-beta1

This is a prerelease version of TWCore.Data.PostgreSQL.
There is a newer version of this package available.
See the version list below for details.
dotnet add package TWCore.Data.PostgreSQL --version 3.1.0-beta1                
NuGet\Install-Package TWCore.Data.PostgreSQL -Version 3.1.0-beta1                
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="TWCore.Data.PostgreSQL" Version="3.1.0-beta1" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add TWCore.Data.PostgreSQL --version 3.1.0-beta1                
#r "nuget: TWCore.Data.PostgreSQL, 3.1.0-beta1"                
#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 TWCore.Data.PostgreSQL as a Cake Addin
#addin nuget:?package=TWCore.Data.PostgreSQL&version=3.1.0-beta1&prerelease

// Install TWCore.Data.PostgreSQL as a Cake Tool
#tool nuget:?package=TWCore.Data.PostgreSQL&version=3.1.0-beta1&prerelease                

<img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/icon.png" alt="Potato" width="45px" height="45px" /> TWCore 3.1

Build status Nuget

A multipurpose framework library used to create microservices solutions on multiple platforms (runs on windows, linux, linux-arm [raspberry pi], and osx).

Compatible with

  • .NET Framework 4.7.2
  • netstandard2.0
  • netcoreapp2.1
  • netcoreapp2.2
  • netcoreapp3.1
  • net5.0
  • net6.0
  • net7.0
  • net8.0

Advantages

  • Easy development of microservices: With fewer code you can subscribe to a message broker and start to process messages as pub/sub or RPC architecture.
  • Completely agnostic and loosely coupled: All subsystems of the framework are registered with a dependency injector engine, so using only the configurations files you can switch between Messages brokers, Serialization formats, Rpc transports, Stream compressors, and many more.
  • Integrated Log, Trace, and Status engines: you can log on different storage, also use differents trace storages and you have an integrated status library to check your service health.
  • A bot subsystem to create bot services on Telegram and Slack
  • Extensions methods for objects, strings, and IEnumerables.
  • Aspnet Core object viewer and compiler developer tool.
Supported log storages
  • Console
  • File
  • Html File
  • MessageBroker
  • ElasticSearch
  • Mail
Supported trace storages
  • File
  • MessageBroker
Supported compressors
  • Gzip
  • Deflate
  • Brotli
Supported messages brokers
  • RabbitMQ
  • NATS
  • NSQ
  • Kafka
  • Redis (Pub/Sub)
Supported key/value cache storages
  • Custom TWCore
  • Redis
Supported bot connectors
  • Slack
  • Telegram
Supported serializers
  • Newtonsoft JsonNet
  • XmlSerializer
  • BinaryFormatter
  • Utf8Json
  • MsgPack
  • NSerializer (Custom binary serializer with object reference graph support and cyclic reference)
  • RawSerializer (Like NSerializer but without internal caching, faster, but serialized objects are bigger in bytes size.)

Simple Object Serializer Benchmark

BenchmarkDotNet=v0.11.3, OS=Windows 10.0.17134.523 (1803/April2018Update/Redstone4)\
Intel Core i7-4770R CPU 3.20GHz (Haswell), 1 CPU, 8 logical and 4 physical cores\
.NET Core SDK=2.2.101\
  [Host] : .NET Core 2.2.0 (CoreCLR 4.6.27110.04, CoreFX 4.6.27110.04), 64bit RyuJIT\
  Core   : .NET Core 2.2.0 (CoreCLR 4.6.27110.04, CoreFX 4.6.27110.04), 64bit RyuJIT\
Job=Core  Runtime=Core
Method N Mean Error StdDev Min Max Gen 0/1k Op Gen 1/1k Op Gen 2/1k Op Allocated Memory/Op
NewtonsoftJsonSerializerToStream 1 42.935 us 0.4296 us 0.4019 us 42.123 us 43.608 us 3.6621 0.1831 - 23296 B
NewtonsoftJsonDeserializerFromStream 1 78.432 us 1.5565 us 1.4560 us 76.154 us 80.546 us 3.5400 0.8545 - 22960 B
XmlSerializerToStream 1 45.512 us 0.3721 us 0.3299 us 44.858 us 46.154 us 1.8921 - - 12224 B
XmlDeserializerFromStream 1 91.809 us 1.4537 us 1.3598 us 89.874 us 94.327 us 4.5166 0.3662 - 28608 B
BinaryFormatterSerializerToStream 1 53.381 us 0.5491 us 0.5137 us 52.418 us 54.022 us 2.5635 - - 16504 B
BinaryFormatterDeserializerFromStream 1 44.802 us 0.5174 us 0.4840 us 43.914 us 45.613 us 3.6011 0.4883 - 22720 B
Utf8JsonSerializerToStream 1 7.609 us 0.1364 us 0.1276 us 7.429 us 7.832 us - - - -
Utf8JsonDeserializerFromStream 1 20.249 us 0.2015 us 0.1885 us 20.009 us 20.641 us 0.9460 0.1831 - 6016 B
MessagePackSerializerToStream 1 7.777 us 0.0682 us 0.0638 us 7.658 us 7.900 us - - - 96 B
MessagePackDeserializerFromStream 1 11.087 us 0.1592 us 0.1489 us 10.795 us 11.419 us 1.3123 0.3204 - 8272 B
NSerializerToStream 1 7.823 us 0.1440 us 0.1347 us 7.607 us 8.051 us - - - -
NDeserializerFromStream 1 7.301 us 0.0702 us 0.0657 us 7.106 us 7.405 us 0.4425 0.0458 - 2800 B
RawSerializerToStream 1 6.574 us 0.1298 us 0.1275 us 6.375 us 6.781 us - - - -
RawDeserializerFromStream 1 7.837 us 0.0655 us 0.0613 us 7.748 us 7.937 us 0.5569 0.0763 - 3520 B

<img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/serializer-deserializer1.png" alt="Serializer Graph" />

Created by Daniel Redondo

Powered By

<img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/rider.jpg" alt="Rider" width="50px" height="50px" /><img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/dotTrace.png" alt="dotTrace" width="50px" height="50px" /><img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/dotMemory.png" alt="dotMemory" width="50px" height="50px" />

Thanks to @jetbrains for helping on this development with the licenses for Rider, dotTrace and dotMemory

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 is compatible.  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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 is compatible.  netcoreapp2.2 is compatible.  netcoreapp3.0 was computed.  netcoreapp3.1 is compatible. 
.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 is compatible.  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. 
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
3.1.0 275 10/22/2023
3.1.0-beta2 144 10/20/2023
3.1.0-beta1 107 10/19/2023
3.0.0-beta5 520 9/8/2019
3.0.0-beta4 422 9/8/2019
3.0.0-beta3 420 8/20/2019
3.0.0-beta2 413 8/18/2019
3.0.0-beta1 432 8/18/2019
2.1.181 776 7/24/2019
2.1.181-beta5 472 7/16/2019
2.1.181-beta4 443 5/10/2019
2.1.181-beta3 469 3/16/2019
2.1.181-beta2 487 3/8/2019
2.1.181-beta 497 3/3/2019
2.1.180 695 3/1/2019
2.1.180-rc1 476 2/28/2019
2.1.180-beta9 531 2/14/2019
2.1.180-beta8 548 2/14/2019
2.1.180-beta7 570 2/8/2019
2.1.180-beta6 530 2/7/2019
2.1.180-beta5 562 2/6/2019
2.1.180-beta4 533 2/5/2019
2.1.180-beta3 564 2/4/2019
2.1.180-beta2 556 2/4/2019
2.1.180-beta1 531 2/4/2019
2.1.180-alpha8 563 1/30/2019
2.1.180-alpha7 556 1/22/2019
2.1.180-alpha6 552 1/21/2019
2.1.180-alpha5 599 1/18/2019
2.1.180-alpha4 565 1/17/2019
2.1.180-alpha3 587 1/16/2019
2.1.180-alpha2 546 1/16/2019
2.1.180-alpha1 548 1/15/2019
2.1.179 759 1/9/2019
2.1.179-beta9 556 1/3/2019
2.1.179-beta8 589 1/2/2019
2.1.179-beta7 615 1/2/2019
2.1.179-beta6 550 12/21/2018
2.1.179-beta5 509 12/19/2018
2.1.179-beta4 528 12/19/2018
2.1.179-beta3 527 12/19/2018
2.1.179-beta2 558 12/18/2018
2.1.179-beta12 568 1/8/2019
2.1.179-beta11 569 1/7/2019
2.1.179-beta10 588 1/4/2019
2.1.179-beta1 563 12/18/2018
2.1.179-alpha9 546 12/18/2018
2.1.179-alpha8 612 11/28/2018
2.1.179-alpha7 589 11/22/2018
2.1.179-alpha6 600 11/20/2018
2.1.179-alpha5 597 11/20/2018
2.1.179-alpha4 584 11/20/2018
2.1.179-alpha3 626 11/19/2018
2.1.179-alpha2 599 11/16/2018
2.1.179-alpha 637 11/16/2018
2.1.178 824 11/6/2018
2.1.178-beta2 596 11/6/2018
2.1.178-beta1 591 10/29/2018
2.1.178-alpha7 632 10/22/2018
2.1.178-alpha6 610 10/19/2018
2.1.178-alpha5 591 10/17/2018
2.1.178-alpha4 645 10/14/2018
2.1.178-alpha3 635 10/13/2018
2.1.178-alpha2 612 10/9/2018
2.1.178-alpha 612 10/9/2018
2.1.177 836 9/27/2018
2.1.177-rc4 632 9/26/2018
2.1.177-rc3 619 9/26/2018
2.1.177-rc2 605 9/26/2018
2.1.177-rc1 620 9/25/2018
2.1.177-beta 613 9/25/2018
2.1.177-alpha 627 9/24/2018
2.1.176 823 9/20/2018
2.1.175 869 9/19/2018
2.1.174 869 9/16/2018
2.1.173 868 9/12/2018
2.1.173-beta 638 9/12/2018
2.1.172 849 9/11/2018
2.1.171 863 8/27/2018
2.1.171-rc1 660 8/27/2018
2.1.171-beta 629 8/27/2018
2.1.170 919 8/15/2018
2.1.169 918 8/14/2018
2.1.168 889 8/10/2018
2.1.167 911 8/9/2018
2.1.166 994 8/9/2018
2.1.165 951 8/9/2018
2.1.164 969 8/8/2018
2.1.163 912 8/8/2018
2.1.162 907 8/8/2018
2.1.161 932 8/8/2018
2.1.160 957 8/7/2018
2.1.159 911 8/3/2018
2.1.158 891 8/2/2018
2.1.157 883 8/1/2018
2.1.156 913 7/30/2018
2.1.155 905 7/29/2018
2.1.154 919 7/19/2018
2.1.153 1,036 7/12/2018
2.1.152 1,031 7/11/2018
2.1.151 1,029 7/11/2018
2.1.150 1,049 7/11/2018
2.1.149 1,024 7/10/2018
2.1.148 986 7/4/2018
2.1.147 975 7/3/2018
2.1.146 1,009 7/1/2018
2.1.145 888 7/1/2018
2.1.144 1,034 6/28/2018
2.1.143 905 6/25/2018
2.1.142 1,007 6/19/2018
2.1.141 923 6/19/2018
2.1.140 1,111 6/18/2018
2.0.149 968 7/10/2018
2.0.148 906 7/4/2018
2.0.147 1,026 7/3/2018
2.0.146 1,036 7/1/2018
2.0.145 1,061 7/1/2018
2.0.144 892 6/28/2018
2.0.143 1,071 6/25/2018
2.0.142 1,035 6/19/2018
2.0.141 912 6/19/2018
2.0.140 1,028 6/18/2018
2.0.139 932 6/18/2018
2.0.138 933 6/15/2018
2.0.137 1,048 6/15/2018
2.0.136 906 6/12/2018
2.0.135 938 6/11/2018
2.0.134 1,031 6/11/2018
2.0.133 963 6/11/2018
0.2.132 970 5/25/2018
0.2.131 897 5/21/2018
0.2.130 1,057 5/20/2018
0.2.129 919 5/20/2018
0.2.128 1,045 5/14/2018
0.2.127 938 5/11/2018
0.2.126 1,058 5/10/2018
0.2.125 1,067 5/8/2018
0.2.124 1,095 4/30/2018
0.2.123 948 4/29/2018
0.2.122 1,139 4/27/2018
0.2.121 1,097 4/26/2018
0.2.120 1,059 4/25/2018
0.2.119 1,065 4/25/2018
0.2.118 1,097 4/25/2018
0.2.117 1,054 4/24/2018
0.2.116 1,050 4/24/2018
0.2.115 1,054 4/19/2018
0.2.114 1,010 4/19/2018
0.2.113 1,071 4/19/2018
0.2.112 1,024 4/18/2018
0.2.111 1,041 4/18/2018
0.2.110 1,091 4/18/2018
0.2.109 992 4/17/2018
0.2.108 1,006 4/17/2018
0.2.107 1,074 4/9/2018
0.2.106 1,124 4/6/2018
0.2.105 1,053 4/3/2018
0.2.104 1,086 4/2/2018
0.2.103 1,054 3/28/2018
0.2.102 1,031 3/28/2018
0.2.101 1,056 3/28/2018
0.2.100 1,009 3/27/2018
0.2.99 1,160 3/24/2018
0.2.98 1,199 3/23/2018
0.2.97 1,048 3/19/2018
0.2.96 1,023 3/16/2018
0.2.95 1,035 3/15/2018
0.2.94 1,091 3/13/2018
0.2.93 1,062 3/12/2018
0.2.92 1,045 3/12/2018
0.2.91 1,039 3/12/2018
0.2.90 1,030 3/11/2018
0.2.89 1,055 3/6/2018
0.2.88 1,088 3/2/2018
0.2.87 1,037 3/1/2018
0.2.86 1,043 2/28/2018
0.2.85 1,049 2/28/2018
0.2.84 918 2/28/2018
0.2.83 957 2/27/2018
0.2.82 1,014 2/26/2018
0.2.81 1,015 2/23/2018
0.2.80 1,032 2/22/2018
0.2.79 1,032 2/21/2018
0.2.78 1,053 2/16/2018
0.2.77 1,016 2/14/2018
0.2.76 1,092 2/14/2018
0.2.75 981 2/9/2018
0.2.74 1,043 2/9/2018
0.2.73 1,043 2/1/2018
0.2.72 969 1/31/2018
0.2.71 1,033 1/30/2018
0.2.70 969 1/29/2018
0.2.69 996 1/26/2018
0.2.68 966 1/23/2018
0.2.67 1,052 1/22/2018
0.2.66 1,017 1/22/2018
0.2.65 1,027 1/19/2018
0.2.64 1,043 1/17/2018
0.2.63 975 1/16/2018
0.2.62 1,062 1/15/2018
0.2.61 976 12/18/2017
0.2.60 1,026 12/6/2017
0.2.59 953 12/5/2017
0.2.58 966 12/4/2017
0.2.57 987 12/1/2017
0.2.56 987 11/30/2017
0.2.55 993 11/28/2017
0.2.54 985 11/28/2017
0.2.53 937 11/28/2017
0.2.52 942 11/26/2017
0.2.51 940 11/24/2017
0.2.50 1,020 11/23/2017
0.2.49 954 11/17/2017
0.2.48 947 11/17/2017
0.2.47 941 11/16/2017
0.2.46 972 11/15/2017
0.2.45 949 11/13/2017
0.2.44 991 11/7/2017
0.2.43 1,004 11/7/2017
0.2.42 976 11/6/2017
0.2.41 941 10/31/2017
0.2.40 991 10/31/2017
0.2.39 987 10/26/2017
0.2.38 987 10/26/2017
0.2.37 971 10/25/2017
0.2.36 1,043 10/23/2017
0.2.35 1,003 10/20/2017
0.2.34 1,009 10/13/2017
0.2.33 978 10/10/2017
0.2.32 998 10/9/2017
0.2.31 951 10/7/2017
0.2.30 998 10/6/2017
0.2.29 959 9/29/2017
0.2.28 992 9/27/2017
0.2.27 974 9/25/2017
0.2.26 986 9/22/2017
0.2.25 997 9/20/2017
0.2.24 958 9/19/2017
0.2.23 954 9/13/2017
0.2.22 950 9/13/2017
0.2.21 933 9/13/2017
0.2.20 995 9/13/2017
0.2.19 943 9/12/2017
0.2.18 995 9/12/2017
0.2.17 992 9/11/2017
0.2.16 941 9/11/2017
0.2.15 987 9/8/2017
0.2.10 989 9/8/2017
0.2.9 989 8/29/2017
0.2.6 1,044 8/25/2017
0.2.5 1,008 8/16/2017
0.2.1-alpha 761 8/16/2017