#npgsql

Scott Gallowayscottgal@hachyderm.io
2025-12-02

Now gotten my Saturday article published. (As my search is picking up since I fixed it it's worth doing). So you can find a lot of articles I haven't publicised on X / LinkedIn on the site. This one is on a LONG term obsession about hierarchies in SQL server.
This article presents 5 ways to do it in EF with PostgreSQL.
Data Hierarchies: Managing Hierarchical Data with EF Core and PostgreSQL (Part 1)
mostlylucid.net/blog/efcore-hi

#efcore #npgsql #csharp #ef

Brar Pieningbrar@floss.social
2025-11-23

Hi #dotNET folks,
yesterday, Roji released #Npgsql 10.0 the .NET data provider for #PostgreSQL that targets .NET 10.0 and #NpgsqlEFCorePG the corresponding #EFCore provider.
Please check out the release notes at npgsql.org/doc/release-notes/1 and npgsql.org/efcore/release-note for new features and breaking changes.

Tim Riemannoctoate
2025-11-12

Heute erstmal 2026 und die neue und Version installiert. Dabei einen Crash beim ersten Start von Rider gehabt und ihn an gemeldet. Danach dann unser Projekt auf .NET 10 umgestellt und dabei gemerkt, dass noch das Package fehlt, um komplett umzustellen. Also noch etwas warten... ansonsten hat alles funktioniert 😄!

2025-02-20

Resolving Npgsql FileNotFoundException in .NET: A Guide to Database Connectivity
Resolve Npgsql FileNotFoundException errors in your database connectivity. Learn common causes & practical solutions for smooth PostgreSQL interactions.
tech-champion.com/database/db2

2024-10-15

TIL you can't use both dataSourceBuilder.MapComposite<T> and NpgsqlConnection.GlobalTypeMapper.MapComposite<T> at the same time in #npgsql
docs: npgsql.org/doc/types/enums_and

When you add mapping for composite type in GlobalTypeMapper - it replace datasource `UserTypeMapper` with global. Code here: github.com/npgsql/npgsql/blob/

Brar Pieningbrar@floss.social
2024-05-09

Hi #dotNET folks,
today, we released multiple patch versions of #Npgsql, the .NET data provider for #PostgreSQL that fix cve.org/CVERecord?id=CVE-2024-
Nino, Nikita and Roji went out of their way and backported the fix to all versions back to 4.x to make sure that any version that might still be in reasonable use today gets patched.
Please make sure to upgrade to the latest patch version of Npgsql as soon as possible.
Versions containing the fix are:
≥ 8.0.3
≥ 7.0.7
≥ 6.0.11
≥ 5.0.18
≥ 4.1.13
≥ 4.0.14

Mogens Heller Grabe @ rebus.fmmookid8000@fosstodon.org
2024-04-15

Experiment: Outbox for .NET as a separate thing! 🤩

👉 github.com/rebus-org/Freakout

At the moment it supports Microsoft SQL Server and PostgreSQL.

Could it maybe be useful?

#sqlserver #mssql #postgres #postgresql #npgsql

Brar Pieningbrar@floss.social
2023-12-04

Hi #dotNET developers,
in case you have already upgraded to #Npgsql 8.0 and are affected by a bug, you may be happy that Npgsql 8.0.1 has been released.
See github.com/npgsql/npgsql/miles for the issues that have been closed in this release.
#NpgsqlEFCorePG the corresponding #EFCore provider has not been released yet but the existing release should be compatible with Npgsql 8.0.1

Brar Pieningbrar@floss.social
2023-11-28

@DO9XE ja, das hatten wir bei #Npgsql auch: github.com/npgsql/npgsql/issue

Man fragt sich viele Jahre warum man sich die ganze Zeit die Mühe macht, die Endianness zu berücksichtigen, wo doch ohnehin alles little endian ist und man big endian mit den eigenen Mitteln überhaupt nicht testen kann und dann kommt plötzlich einer aus einem Loch gekrochen, der mit BE-Architektur arbeitet und meldet einen Bug.
Das wertet die ganze Arbeit im Nachhinein auf.

Brar Pieningbrar@floss.social
2023-11-21

Hi #dotNET folks,
today, Roji released #Npgsql 8.0 the .NET data provider for #PostgreSQL that targets .NET 8.0 and #NpgsqlEFCorePG the corresponding #EFCore provider.
Please check out the release notes at npgsql.org/doc/release-notes/8 and npgsql.org/efcore/release-note for new features and breaking changes.
While the big new thing is a rewrite of the internal type handling system to reduce binary size in AOT, there are quite a few other improvments and fixes to long-standing issues coming along with this.

Brar Pieningbrar@floss.social
2023-09-14

Now that #PostgreSQL 16 has been released, Roji has also released the #Npgsql hotfixes 5.0.17, 6.0.10 and 7.0.6. They contain quite a few bugfixes and one replication-related compatibility fix for #PostgreSQL16, so make sure, you upgrade your #dotNET projects to the latest compatible version.

Brar Pieningbrar@floss.social
2023-08-29

@khalidabuhakmeh
you definitely should try #Npgsql 8 once we've released it.
Nino is currently pushing binary size to it's limits while rewriting our internal type handlers: nitter.net/NinoFloris/status/1

@maartenballiauw @haney

Brar Pieningbrar@floss.social
2023-03-03

Today Roji released #Npgsql 8.0.0-preview.1.
At the moment there are not many visible features added but Nikita, Nino and also Shay have have been hacking away with native AOT and reducing Npgsql's binary size, so if you're using AOT and care about binary size, it's probably worth to have some initial look at it and give feedback.
#dotNET
#PostgreSQL

Guillaume Lacasaglacasa@mamot.fr
2023-02-28

Use Postgresql as a Pub/Sub server in a .NET app

github.com/glacasa/PostgresPub

I thought I would need to do some hacky stuff to make this work, but it just works out of the box thanks to Npgsql

#dotnet #npgsql #Postgresql

(edit : you can open the repo now)

Brar Pieningbrar@floss.social
2022-12-17

Today Roji released #Npgsql 7.0.1 and 6.0.8.
Both are minor bugfix releases that shouldn't introduce any breaking changes and only fix a few bugs.
There's nothing in there, that I'd consider a big deal but if you're using Npgsql to connect your #dotNET application to #PostgreSQL and are hit by one of the bugs we've fixed, you might disagree and may want to upgrade your NuGet references.
See here for the fixed issues:
• github.com/Npgsql/Npgsql/issue
• github.com/Npgsql/Npgsql/issue

Brar Pieningbrar@floss.social
2022-11-26

@davidfowl It's still the middle of the night over here but I'll probably start with backporting github.com/npgsql/npgsql/pull/ and afterwards I'll start working on github.com/npgsql/npgsql/issue which requires quite a bit of internal refactoring and cleanup of #Npgsql

Brar Pieningbrar@floss.social
2022-11-19

Hey @oskardudycz,
thanks for doing the hard work of digging into parts of Npgsql that we haven't documented yet. I've responded in your PR.
You'll have to replace the call to Npgsql.Replication.Internal.LogicalReplicationConnectionExtensions.CreateLogicalReplicationSlot() at github.com/oskardudycz/Postgre with a call to Npgsql.Replication.PgOutputConnectionExtensions.CreatePgOutputReplicationSlot() and then everything should work without patching #Npgsql.

Brar Pieningbrar@floss.social
2022-11-10

Hi #dotNET folks,
yesterday, Roji released #Npgsql 7.0 the .NET data provider for #PostgreSQL that targets .NET 7.0 and #NpgsqlEFCorePG the corresponding #EFCore provider.
Please check out the release notes at npgsql.org/doc/release-notes/7 and npgsql.org/efcore/release-note for new features and breaking changes.
There's a lot of cool new stuff to try out!

Brar Pieningbrar@floss.social
2022-11-06

@danielwhite 👋
Maybe a bit less than others since I've been working with the prerelreases for months already because I'm working on stuff that is supposed to be released alongside with it.
#Npgsql

Brar Pieningbrar@floss.social
2022-10-31

I'm mostly writing code in C# but can read and write quite a few other languages.
My probably biggest contribution to the Open Source software community is being a part of the small team maintaining #Npgsql, the #dotNET data provider for #PostgreSQL.

Client Info

Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst