Just sittin' here, writing raw SQL like it's 1994.
July 10, 2025 at 11:04 AM
Just sittin' here, writing raw SQL like it's 1994.
Looking for ARM64 Windows users to test the PostgreSQL DDEX provider for Visual Studio - github.com/npgsql/npgsq...
Npgsql PostgreSQL Integration Doesn't support Microsoft Visual Studio Community 2022 (ARM 64-bit) · Issue #5855 · npgsql/npgsql
Microsoft Visual Studio Community 2022 (ARM 64-bit) - Preview Version 17.12.0 Preview 2.1 When I try to install the extension, I got an VSIX Installation Error: View Install Logs: 9/27/2024 1:32:26...
github.com
March 2, 2025 at 8:27 AM
Looking for ARM64 Windows users to test the PostgreSQL DDEX provider for Visual Studio - github.com/npgsql/npgsq...
🐍💻 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
👉 Full Article: sslinsights.com/fix-npgsql-b...
#dotnet6 #Npgsql #macOSDev #PostgreSQL #DevOps #Programming
If you’re building .NET 6 apps on macOS and connecting to PostgreSQL using Npgsql, you might encounter:
🚫 Bad Protocol Version errors
👉 Full Article: sslinsights.com/fix-npgsql-b...
#dotnet6 #Npgsql #macOSDev #PostgreSQL #DevOps #Programming
How to Fix Npgsql "Bad Protocol Version" on macOS (.NET 6)
Learn how to fix Npgsql “Bad Protocol Version” error on macOS when using .NET 6. Quick steps to restore PostgreSQL connection compatibility.
sslinsights.com
February 19, 2026 at 4:59 AM
🐍💻 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
👉 Full Article: sslinsights.com/fix-npgsql-b...
#dotnet6 #Npgsql #macOSDev #PostgreSQL #DevOps #Programming
If you’re building .NET 6 apps on macOS and connecting to PostgreSQL using Npgsql, you might encounter:
🚫 Bad Protocol Version errors
👉 Full Article: sslinsights.com/fix-npgsql-b...
#dotnet6 #Npgsql #macOSDev #PostgreSQL #DevOps #Programming
Also I really like PostgreSQL and the Npgsql library.
July 10, 2025 at 11:07 AM
Also I really like PostgreSQL and the Npgsql library.
Marten 8.0 work so far:
* Dropped .NET 6/7
* Upgraded to Npgsql 9
* Consolidated underlying dependencies
* Removed all synchronous database APIs except for LINQ synchronous operator support
* STJ is the new default serializer
* Dropped .NET 6/7
* Upgraded to Npgsql 9
* Consolidated underlying dependencies
* Removed all synchronous database APIs except for LINQ synchronous operator support
* STJ is the new default serializer
February 20, 2025 at 2:08 PM
Marten 8.0 work so far:
* Dropped .NET 6/7
* Upgraded to Npgsql 9
* Consolidated underlying dependencies
* Removed all synchronous database APIs except for LINQ synchronous operator support
* STJ is the new default serializer
* Dropped .NET 6/7
* Upgraded to Npgsql 9
* Consolidated underlying dependencies
* Removed all synchronous database APIs except for LINQ synchronous operator support
* STJ is the new default serializer
Dipping my toes into other database engines today and it's made me appreciate PostgreSQL *and* Npgsql more.
February 4, 2026 at 4:16 AM
Dipping my toes into other database engines today and it's made me appreciate PostgreSQL *and* Npgsql more.
Release 10.0.1 · 5432-fr/powershell-npgsql
PowerShell Npgsql version 10.0.1
github.com
January 2, 2026 at 3:26 PM
checkout this awesome F# type provider, adding for example NPGSQL nuget package and pointing to the right .dll for resolution will give you a functioning superpowered ORM in F# with close to zero lines of code (DB first approach) > #dotnet #orm #sql #fsharp fsprojects.github.io/SQLProvider/ 💕🦔
SQLProvider
fsprojects.github.io
April 16, 2025 at 8:41 AM
checkout this awesome F# type provider, adding for example NPGSQL nuget package and pointing to the right .dll for resolution will give you a functioning superpowered ORM in F# with close to zero lines of code (DB first approach) > #dotnet #orm #sql #fsharp fsprojects.github.io/SQLProvider/ 💕🦔
List.Add plus SaveChanges on a jsonb column: 20 concurrent appends, 3 survived. One UPDATE with || kept all 21.
https://startdebugging.net/2026/09/how-to-atomically-append-to-a-postgresql-jsonb-array-with-ef-core-and-npgsql/?utm_source=bluesky&utm_medium=social&utm_campaign=auto
https://startdebugging.net/2026/09/how-to-atomically-append-to-a-postgresql-jsonb-array-with-ef-core-and-npgsql/?utm_source=bluesky&utm_medium=social&utm_campaign=auto
September 21, 2026 at 6:24 AM
List.Add plus SaveChanges on a jsonb column: 20 concurrent appends, 3 survived. One UPDATE with || kept all 21.
https://startdebugging.net/2026/09/how-to-atomically-append-to-a-postgresql-jsonb-array-with-ef-core-and-npgsql/?utm_source=bluesky&utm_medium=social&utm_campaign=auto
https://startdebugging.net/2026/09/how-to-atomically-append-to-a-postgresql-jsonb-array-with-ef-core-and-npgsql/?utm_source=bluesky&utm_medium=social&utm_campaign=auto
What works out-of-the-box? ASP.NET/ASP.NET Core, HttpClient, SqlClient, Npgsql, Redis, gRPC; plus log correlation via ILogger. Zero-code traces in most cases; metrics/logs vary by library. #dotnet #Observability
October 18, 2025 at 4:46 AM
What works out-of-the-box? ASP.NET/ASP.NET Core, HttpClient, SqlClient, Npgsql, Redis, gRPC; plus log correlation via ILogger. Zero-code traces in most cases; metrics/logs vary by library. #dotnet #Observability
Huh, I guess I feel better about the Marten 8 approach of dropping synch APIs because Npgsql would have just forced us to anyway:
www.npgsql.org/doc/release-...
www.npgsql.org/doc/release-...
Npgsql 9.0 Release Notes | Npgsql Documentation
www.npgsql.org
November 29, 2024 at 11:25 PM
Huh, I guess I feel better about the Marten 8 approach of dropping synch APIs because Npgsql would have just forced us to anyway:
www.npgsql.org/doc/release-...
www.npgsql.org/doc/release-...
But it is part of a bigger effort github.com/ErikEJ/EFCor...
Investigate support for ARM64 in Power Pack components · Issue #2845 · ErikEJ/EFCorePowerTools
EF Core Power Tools VisualStudio.Data.Sqlite (in progress- bricelam/VS.Data.Sqlite#47 ) Npgsql PostgreSQL Integration (in progress npgsql/npgsql#5855 (comment) ) DgmlPowerTools 2022 (in progress cl...
github.com
March 2, 2025 at 1:05 PM
But it is part of a bigger effort github.com/ErikEJ/EFCor...
Npgsql driving me nuts. Does it only work when I expose myself to SQL injection?
November 20, 2024 at 2:11 PM
Npgsql driving me nuts. Does it only work when I expose myself to SQL injection?
I was tentatively planning on trying to enhance the EF Core integration w/ Wolverine over the holidays and early January. So far all I've accidentally learned is that EF Core & Npgsql extensions for this and that are horrible diamond dependency friction when you multi-target
December 30, 2024 at 6:40 PM
I was tentatively planning on trying to enhance the EF Core integration w/ Wolverine over the holidays and early January. So far all I've accidentally learned is that EF Core & Npgsql extensions for this and that are horrible diamond dependency friction when you multi-target
Personal stuff is completely fine with EF, even large projects are completely fine. Our usecase is just a multinational application that has to handle millions of requests. If speed is an issue, handrolled sql and dedicated connectors (eg Npgsql) do the trick.
December 4, 2024 at 8:31 AM
Personal stuff is completely fine with EF, even large projects are completely fine. Our usecase is just a multinational application that has to handle millions of requests. If speed is an issue, handrolled sql and dedicated connectors (eg Npgsql) do the trick.
PSA: pgbouncer now supports prepared statements in transaction pooling mode
db.prepare("plus_one", "select $1::int + 1")
10.times { db.exec_prepared("plus_one", [41]) }
Remember to set max_prepared_statements when using
github.com/pgbouncer/pg...
db.prepare("plus_one", "select $1::int + 1")
10.times { db.exec_prepared("plus_one", [41]) }
Remember to set max_prepared_statements when using
github.com/pgbouncer/pg...
Support protocol-level named prepared statements (#845) · pgbouncer/pgbouncer@6070802
This implements the often requested feature of supporting named prepared statements. This makes clients like JDBC and Npgsql work without any client side configuration changes if you set max_pre...
github.com
August 27, 2026 at 11:08 PM
PSA: pgbouncer now supports prepared statements in transaction pooling mode
db.prepare("plus_one", "select $1::int + 1")
10.times { db.exec_prepared("plus_one", [41]) }
Remember to set max_prepared_statements when using
github.com/pgbouncer/pg...
db.prepare("plus_one", "select $1::int + 1")
10.times { db.exec_prepared("plus_one", [41]) }
Remember to set max_prepared_statements when using
github.com/pgbouncer/pg...
📰 New article by Ken Zhang
Migrate SQL Server multi-result-set procedures to PostgreSQL
#AWS #Databases
Migrate SQL Server multi-result-set procedures to PostgreSQL
#AWS #Databases
Migrate SQL Server multi-result-set procedures to PostgreSQL
SQL Server stored procedures can return multiple result sets from one call, but PostgreSQL cannot. This post presents two PostgreSQL-native alternatives to refcursors, session-scoped temporary tables and JSON aggregation, compares both against a refcursor baseline, and shows how to implement and validate each in .NET and Npgsql.
aws.amazon.com
September 21, 2026 at 4:51 PM
📰 New article by Ken Zhang
Migrate SQL Server multi-result-set procedures to PostgreSQL
#AWS #Databases
Migrate SQL Server multi-result-set procedures to PostgreSQL
#AWS #Databases
Funnily enough most of the EF improvements comes from the great Npgsql team 🙂 It’s intriguing how the „tradition” biases choices
November 20, 2024 at 12:55 PM
Funnily enough most of the EF improvements comes from the great Npgsql team 🙂 It’s intriguing how the „tradition” biases choices
postgreSQLのC#ラッパー、NpgsqlでSQLインジェクションの対策でリプレースホルダ使ってるんですけど、あれってテーブル名はリプレースできないんですね。
November 10, 2025 at 12:01 PM
postgreSQLのC#ラッパー、NpgsqlでSQLインジェクションの対策でリプレースホルダ使ってるんですけど、あれってテーブル名はリプレースできないんですね。
Still dealing with some last nagging issues with .NET 9, mostly Nuget dependency hell stuff. Just to find out there's a new Npgsql release. Ugh.
November 19, 2024 at 1:03 PM
Still dealing with some last nagging issues with .NET 9, mostly Nuget dependency hell stuff. Just to find out there's a new Npgsql release. Ugh.
📣 New Podcast! "353 - TimescaleDB: quando PostgreSQL incontra le serie temporali" on @Spreaker #dotnet #npgsql #postgresql #timescaledb
353 - TimescaleDB: quando PostgreSQL incontra le serie temporali
Dopo aver parlato di PostgreSQL, continuo il viaggio con TimescaleDB, l’estensione pensata per gestire serie temporali, metriche e telemetria. Vediamo come funziona, perché può essere interessante in un progetto .NET e quali sono le principali differenze rispetto a InfluxDB.
- https://github.com/timescale/timescaledb
- https://timescaledb.org/
- https://www.tigerdata.com/
#TimescaleDB #PostgreSQL #InfluxDB #TimeSeries #Database #DotNet #CSharp #Npgsql #Dapper #EntityFrameworkCore #IoT #Telemetry #SoftwareDevelopment #DotNetInPillole #podcast
www.spreaker.com
July 20, 2026 at 5:00 AM
📣 New Podcast! "353 - TimescaleDB: quando PostgreSQL incontra le serie temporali" on @Spreaker #dotnet #npgsql #postgresql #timescaledb
Seq 2026.1 previews are rolling out!
Today's fresh build includes percentiles over metric histograms, `ContributingEventsUrl` in alert notifications, and a bunch of other updates.
datalust/seq:preview, or datalust.co/download 😎
Today's fresh build includes percentiles over metric histograms, `ContributingEventsUrl` in alert notifications, and a bunch of other updates.
datalust/seq:preview, or datalust.co/download 😎
May 28, 2026 at 4:22 AM
Seq 2026.1 previews are rolling out!
Today's fresh build includes percentiles over metric histograms, `ContributingEventsUrl` in alert notifications, and a bunch of other updates.
datalust/seq:preview, or datalust.co/download 😎
Today's fresh build includes percentiles over metric histograms, `ContributingEventsUrl` in alert notifications, and a bunch of other updates.
datalust/seq:preview, or datalust.co/download 😎
I need to stop jumping on latest .net releases. Each release needs time to for the third party packages to catch up. I’m getting “missing method” exceptions with my Npgsql packages. 😂
November 13, 2024 at 10:46 PM
I need to stop jumping on latest .net releases. Each release needs time to for the third party packages to catch up. I’m getting “missing method” exceptions with my Npgsql packages. 😂
📣 New Podcast! "352 - PostgreSQL e .NET: quando il database modella il dominio" on @Spreaker #dotnet #npgsql #postgresql
352 - PostgreSQL e .NET: quando il database modella il dominio
In questa puntata parlo di PostgreSQL dal punto di vista di uno sviluppatore .NET, concentrandomi sui suoi tipi custom (che ritengo una delle sue potenzianlità): enum, domain, composite type e range.
Non un confronto con SQL Server, ma uno sguardo a come PostgreSQL possa aiutare a modellare meglio il dominio (con i vari pro e contro).
#PostgreSQL #DotNet #CSharp #AspNetCore #Database #SQL #SQLServer #EntityFrameworkCore #Npgsql #BackendDevelopment #podcast #dotnetinpillole
www.spreaker.com
July 13, 2026 at 5:00 AM
📣 New Podcast! "352 - PostgreSQL e .NET: quando il database modella il dominio" on @Spreaker #dotnet #npgsql #postgresql
Popular packages like Automapper, Npgsql, and SixLabors.ImageSharp have already gone .NET 6+ only (dropping .NET Standard/Framework support), and I applaud that. The longer we leave crutches in place, the less motivation people have to upgrade. Same problem that harmed the Python community with 2.x
December 5, 2024 at 3:26 PM
Popular packages like Automapper, Npgsql, and SixLabors.ImageSharp have already gone .NET 6+ only (dropping .NET Standard/Framework support), and I applaud that. The longer we leave crutches in place, the less motivation people have to upgrade. Same problem that harmed the Python community with 2.x