🐍💻 Fix Npgsql “Bad Protocol Version” on macOS & .NET 6

If you’re building .NET 6 apps on macOS and connecting to PostgreSQL using Npgsql, you might encounter:

🚫 Bad Protocol Version errors

This usually means a mismatch between client and server expectations, but it can be resolved.

Perfect for developers wrestling with cross-platform database connections.

👉 Resolve the error here:
https://sslinsights.com/fix-npgsql-bad-protocol-version-macos-net6/

#dotnet6 #Npgsql #macOSDev #PostgreSQL #DevOps #Programming #ErrorFix #SSLInsights

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)
https://www.mostlylucid.net/blog/efcore-hierarchical-data

#efcore #npgsql #csharp #ef

TIL you can't use both dataSourceBuilder.MapComposite<T> and NpgsqlConnection.GlobalTypeMapper.MapComposite<T> at the same time in #npgsql
docs: https://www.npgsql.org/doc/types/enums_and_composites.html?tabs=datasource

When you add mapping for composite type in GlobalTypeMapper - it replace datasource `UserTypeMapper` with global. Code here: https://github.com/npgsql/npgsql/blob/ab8e8db61617283603ac0350c1902222d710b92a/src/Npgsql/NpgsqlSlimDataSourceBuilder.cs#L423

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

👉 https://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