TWCore.Data.PostgreSQL 3.1.0

.NET 5.0 .NET Core 2.1 .NET Standard 2.0 .NET Framework 4.7.2 
dotnet add package TWCore.Data.PostgreSQL --version 3.1.0
NuGet\Install-Package TWCore.Data.PostgreSQL -Version 3.1.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="TWCore.Data.PostgreSQL" Version="3.1.0" />
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
#r "nuget: TWCore.Data.PostgreSQL, 3.1.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 TWCore.Data.PostgreSQL as a Cake Addin
#addin nuget:?package=TWCore.Data.PostgreSQL&version=3.1.0

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

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

Serializer Graph

Created by Tony Redondo

Powered By

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. 
.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 216 10/22/2023
3.1.0-beta2 109 10/20/2023
3.1.0-beta1 80 10/19/2023
3.0.0-beta5 487 9/8/2019
3.0.0-beta4 396 9/8/2019
3.0.0-beta3 393 8/20/2019
3.0.0-beta2 383 8/18/2019
3.0.0-beta1 405 8/18/2019
2.1.181 738 7/24/2019
2.1.181-beta5 441 7/16/2019
2.1.181-beta4 402 5/10/2019
2.1.181-beta3 437 3/16/2019
2.1.181-beta2 456 3/8/2019
2.1.181-beta 462 3/3/2019
2.1.180 658 3/1/2019
2.1.180-rc1 445 2/28/2019
2.1.180-beta9 498 2/14/2019
2.1.180-beta8 522 2/14/2019
2.1.180-beta7 538 2/8/2019
2.1.180-beta6 496 2/7/2019
2.1.180-beta5 533 2/6/2019
2.1.180-beta4 507 2/5/2019
2.1.180-beta3 525 2/4/2019
2.1.180-beta2 519 2/4/2019
2.1.180-beta1 501 2/4/2019
2.1.180-alpha8 537 1/30/2019
2.1.180-alpha7 528 1/22/2019
2.1.180-alpha6 522 1/21/2019
2.1.180-alpha5 564 1/18/2019
2.1.180-alpha4 525 1/17/2019
2.1.180-alpha3 557 1/16/2019
2.1.180-alpha2 523 1/16/2019
2.1.180-alpha1 519 1/15/2019
2.1.179 725 1/9/2019
2.1.179-beta9 531 1/3/2019
2.1.179-beta8 558 1/2/2019
2.1.179-beta7 587 1/2/2019
2.1.179-beta6 526 12/21/2018
2.1.179-beta5 479 12/19/2018
2.1.179-beta4 497 12/19/2018
2.1.179-beta3 500 12/19/2018
2.1.179-beta2 520 12/18/2018
2.1.179-beta12 539 1/8/2019
2.1.179-beta11 539 1/7/2019
2.1.179-beta10 554 1/4/2019
2.1.179-beta1 540 12/18/2018
2.1.179-alpha9 511 12/18/2018
2.1.179-alpha8 580 11/28/2018
2.1.179-alpha7 555 11/22/2018
2.1.179-alpha6 556 11/20/2018
2.1.179-alpha5 563 11/20/2018
2.1.179-alpha4 548 11/20/2018
2.1.179-alpha3 595 11/19/2018
2.1.179-alpha2 567 11/16/2018
2.1.179-alpha 604 11/16/2018
2.1.178 781 11/6/2018
2.1.178-beta2 566 11/6/2018
2.1.178-beta1 560 10/29/2018
2.1.178-alpha7 586 10/22/2018
2.1.178-alpha6 568 10/19/2018
2.1.178-alpha5 558 10/17/2018
2.1.178-alpha4 606 10/14/2018
2.1.178-alpha3 600 10/13/2018
2.1.178-alpha2 559 10/9/2018
2.1.178-alpha 574 10/9/2018
2.1.177 790 9/27/2018
2.1.177-rc4 586 9/26/2018
2.1.177-rc3 582 9/26/2018
2.1.177-rc2 567 9/26/2018
2.1.177-rc1 575 9/25/2018
2.1.177-beta 568 9/25/2018
2.1.177-alpha 586 9/24/2018
2.1.176 773 9/20/2018
2.1.175 826 9/19/2018
2.1.174 823 9/16/2018
2.1.173 825 9/12/2018
2.1.173-beta 594 9/12/2018
2.1.172 800 9/11/2018
2.1.171 808 8/27/2018
2.1.171-rc1 617 8/27/2018
2.1.171-beta 588 8/27/2018
2.1.170 869 8/15/2018
2.1.169 862 8/14/2018
2.1.168 839 8/10/2018
2.1.167 865 8/9/2018
2.1.166 943 8/9/2018
2.1.165 904 8/9/2018
2.1.164 921 8/8/2018
2.1.163 870 8/8/2018
2.1.162 864 8/8/2018
2.1.161 886 8/8/2018
2.1.160 913 8/7/2018
2.1.159 863 8/3/2018
2.1.158 847 8/2/2018
2.1.157 836 8/1/2018
2.1.156 866 7/30/2018
2.1.155 854 7/29/2018
2.1.154 874 7/19/2018
2.1.153 983 7/12/2018
2.1.152 984 7/11/2018
2.1.151 988 7/11/2018
2.1.150 1,007 7/11/2018
2.1.149 983 7/10/2018
2.1.148 943 7/4/2018
2.1.147 932 7/3/2018
2.1.146 966 7/1/2018
2.1.145 837 7/1/2018
2.1.144 988 6/28/2018
2.1.143 859 6/25/2018
2.1.142 958 6/19/2018
2.1.141 877 6/19/2018
2.1.140 1,057 6/18/2018
2.0.149 922 7/10/2018
2.0.148 860 7/4/2018
2.0.147 982 7/3/2018
2.0.146 977 7/1/2018
2.0.145 1,008 7/1/2018
2.0.144 849 6/28/2018
2.0.143 1,024 6/25/2018
2.0.142 986 6/19/2018
2.0.141 865 6/19/2018
2.0.140 973 6/18/2018
2.0.139 892 6/18/2018
2.0.138 881 6/15/2018
2.0.137 1,004 6/15/2018
2.0.136 861 6/12/2018
2.0.135 885 6/11/2018
2.0.134 989 6/11/2018
2.0.133 914 6/11/2018
0.2.132 921 5/25/2018
0.2.131 852 5/21/2018
0.2.130 1,010 5/20/2018
0.2.129 869 5/20/2018
0.2.128 1,002 5/14/2018
0.2.127 896 5/11/2018
0.2.126 1,007 5/10/2018
0.2.125 993 5/8/2018
0.2.124 1,048 4/30/2018
0.2.123 896 4/29/2018
0.2.122 1,096 4/27/2018
0.2.121 1,056 4/26/2018
0.2.120 1,014 4/25/2018
0.2.119 1,022 4/25/2018
0.2.118 1,050 4/25/2018
0.2.117 1,003 4/24/2018
0.2.116 1,004 4/24/2018
0.2.115 996 4/19/2018
0.2.114 963 4/19/2018
0.2.113 1,028 4/19/2018
0.2.112 975 4/18/2018
0.2.111 995 4/18/2018
0.2.110 1,050 4/18/2018
0.2.109 946 4/17/2018
0.2.108 948 4/17/2018
0.2.107 1,023 4/9/2018
0.2.106 1,077 4/6/2018
0.2.105 1,008 4/3/2018
0.2.104 1,045 4/2/2018
0.2.103 1,010 3/28/2018
0.2.102 981 3/28/2018
0.2.101 1,009 3/28/2018
0.2.100 960 3/27/2018
0.2.99 1,107 3/24/2018
0.2.98 1,142 3/23/2018
0.2.97 998 3/19/2018
0.2.96 992 3/16/2018
0.2.95 994 3/15/2018
0.2.94 1,034 3/13/2018
0.2.93 1,019 3/12/2018
0.2.92 998 3/12/2018
0.2.91 988 3/12/2018
0.2.90 987 3/11/2018
0.2.89 1,002 3/6/2018
0.2.88 1,041 3/2/2018
0.2.87 993 3/1/2018
0.2.86 1,005 2/28/2018
0.2.85 1,000 2/28/2018
0.2.84 873 2/28/2018
0.2.83 907 2/27/2018
0.2.82 970 2/26/2018
0.2.81 974 2/23/2018
0.2.80 989 2/22/2018
0.2.79 1,000 2/21/2018
0.2.78 1,005 2/16/2018
0.2.77 969 2/14/2018
0.2.76 1,047 2/14/2018
0.2.75 925 2/9/2018
0.2.74 990 2/9/2018
0.2.73 1,000 2/1/2018
0.2.72 914 1/31/2018
0.2.71 995 1/30/2018
0.2.70 914 1/29/2018
0.2.69 953 1/26/2018
0.2.68 925 1/23/2018
0.2.67 1,013 1/22/2018
0.2.66 966 1/22/2018
0.2.65 984 1/19/2018
0.2.64 996 1/17/2018
0.2.63 925 1/16/2018
0.2.62 1,019 1/15/2018
0.2.61 929 12/18/2017
0.2.60 967 12/6/2017
0.2.59 908 12/5/2017
0.2.58 922 12/4/2017
0.2.57 945 12/1/2017
0.2.56 944 11/30/2017
0.2.55 944 11/28/2017
0.2.54 935 11/28/2017
0.2.53 889 11/28/2017
0.2.52 890 11/26/2017
0.2.51 905 11/24/2017
0.2.50 977 11/23/2017
0.2.49 908 11/17/2017
0.2.48 903 11/17/2017
0.2.47 896 11/16/2017
0.2.46 931 11/15/2017
0.2.45 899 11/13/2017
0.2.44 942 11/7/2017
0.2.43 952 11/7/2017
0.2.42 932 11/6/2017
0.2.41 899 10/31/2017
0.2.40 943 10/31/2017
0.2.39 938 10/26/2017
0.2.38 939 10/26/2017
0.2.37 926 10/25/2017
0.2.36 974 10/23/2017
0.2.35 955 10/20/2017
0.2.34 952 10/13/2017
0.2.33 936 10/10/2017
0.2.32 941 10/9/2017
0.2.31 910 10/7/2017
0.2.30 950 10/6/2017
0.2.29 908 9/29/2017
0.2.28 942 9/27/2017
0.2.27 931 9/25/2017
0.2.26 948 9/22/2017
0.2.25 947 9/20/2017
0.2.24 904 9/19/2017
0.2.23 901 9/13/2017
0.2.22 900 9/13/2017
0.2.21 883 9/13/2017
0.2.20 945 9/13/2017
0.2.19 892 9/12/2017
0.2.18 954 9/12/2017
0.2.17 945 9/11/2017
0.2.16 892 9/11/2017
0.2.15 938 9/8/2017
0.2.10 946 9/8/2017
0.2.9 945 8/29/2017
0.2.6 1,002 8/25/2017
0.2.5 959 8/16/2017
0.2.1-alpha 718 8/16/2017