Un caso real de importación masiva en PostgreSQL 17 con Npgsql: cifras reportadas, límites del benchmark y cuándo conviene dejar EF Core.

You told us that applications using Microsoft.Data.SqlClient can take too long to establish the database connections they need. When many requests need

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.

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...

Diskless high-throughput data ingestion server with local DuckDB caching. Writes optimised Parquet files onto Object Storages. - boilingdata/boilstream

Description After enabling Native AOT (<PublishAot>true</PublishAot>) and adding a root-assembly hint for Npgsql, the publish process hangs indefinitely during the IlcCompile step, consuming increa...

Description A user of Npgsql ran into garbled nullable values on his M2. The full context can be found here npgsql/npgsql#6058 (comment) Reproduction Steps using System; using System.Runtime.Compil...

Description Using Npgsql with EfCore locks up application, with pretty much all active threads held by System.Security.Cryptography.Rfc2898DeriveBytes.Pbkdf2, with the remaining active threads work...

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...

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...

Today we are announcing the release of Aurora DSQL connectors for .NET (Npgsql) and Rust (SQLx) that make it easy to build .NET and Rust applications on Aurora DSQL. The connectors streamline authentication and eliminate security risks associated with traditional user-generated passwords by automatically generating tokens for each connection, ensuring valid tokens are always used while maintaining full compatibility with existing Npgsql and SQLx features. The connectors handle IAM token generation, SSL configuration, and connection pooling, enabling customers to scale from simple scripts to production workloads without changing their authentication approach. They also provide opt-in optimistic concurrency control (OCC) retry with exponential backoff, custom IAM credential providers, and AWS profile support, making it easier to develop client retry logic and manage AWS credentials. To get started, visit the Connectors for Aurora DSQL documentation page. For code examples, visit our GitHub pages for the .NET connector and Rust connector. Get started with Aurora DSQL for free with the AWS Free Tier. To learn more about Aurora DSQL, visit the webpage.

PowerShell Npgsql version 10.0.1

Learn how to fix Npgsql “Bad Protocol Version” error on macOS when using .NET 6. Quick steps to restore PostgreSQL connection compatibility.