data access
PostgreSQL for C# and .NET Articles, Tutorials & News
PostgreSQL for C# and .NET articles, tutorials, and news from the DotNetNews archive.
50 articles Updated
PostgreSQL C# is the focus of this topic page. PostgreSQL for C# and .NET is part of the data-access layer most .NET apps rely on, whether the store is relational or document-oriented. Intermediate and senior .NET developers use this hub to scan practical writing without treating every link as an endorsement.
Recurring subtopics in recent issues include PostgreSQL C#, PostgreSQL .NET, Npgsql, and EF Core PostgreSQL. Those themes are drawn from titles and excerpts in the newest archive entries for this tag, not from a marketing outline.
Expect publisher tutorials, release notes, architecture write-ups, and field notes linked from DotNetNews issues. Start here is a short editorial shortlist for PostgreSQL for C# and .NET; the archive list is chronological and larger. Secondary angles such as PostgreSQL C# and PostgreSQL .NET appear when the archive actually covered them. Nearby reading often overlaps with Entity Framework Core and Dapper for C# and .NET.
Start here
Editor picks for PostgreSQL
-
Implementing Long-Term Memory for AI Agents with Semantic Kernel and PostgreSQL
c-sharpcorner.com Issue #500
Long-term memory is where many agent demos become actual applications; PostgreSQL makes this feel more grounded.
-
PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
Compare PostgreSQL vs SQL Server for .NET apps.
-
We Moved from SQL Server to PostgreSQL in a .NET
medium.com Issue #483
Real migration writeups are always more useful than abstract comparisons, especially when they include cost and operational reasons.
-
The Interval Is the Thing: Modelling Range Types as First-Class Domain Objects in .NET
medium.com Issue #476
Interesting domain modeling piece, especially for teams pairing rich types with PostgreSQL range support.
-
PostgreSQL Like a Pro: Build mission-critical apps at any scale with Azure HorizonDB
youtube.com Issue #439
This one leans cloud and data platform, with useful context for scaling PostgreSQL on Azure and thinking through hosting choices for AI agents.
-
Getting Started With PgVector in .NET for Simple Vector Search
milanjovanovic.tech Issue #423
pgvector in PostgreSQL is a nice reminder that vector search doesn’t have to mean a new database.
-
Supercharging GenAI Apps with PostgreSQL and Azure AI
visualstudiomagazine.com Issue #381
PostgreSQL plus Azure AI is a strong combo here, especially with PGVector and VS Code extensions in the mix.
-
Is Redis Overkill? Rethink SignalR Backplane with PostgreSQL
levelup.gitconnected.com Issue #314
Using PostgreSQL as a SignalR backplane is a smart reality check when Redis would be more infrastructure than you need.
Archive
Page 1 of 2
Newest first
-
PostgreSQL 19 Beta: Benchmarking JSONB Workloads from .NET APIs
c-sharpcorner.com Issue #529
Benchmark PostgreSQL 19 Beta JSONB workloads from .NET APIs and evaluate query performance, indexing strategies, EF Core behavior, and database scalability.
-
From 17ms to 0.04ms: How to Design the Right SQL Index
milanjovanovic.tech Issue #528
What does a good SQL index look like? I seeded Postgres with 1 million comments and measured every indexing decision with EXPLAIN ANALYZE: a 17ms sequential…
-
What Actually Happens When React Calls a .NET API?
medium.com Issue #528
Following one API request from a React button click to PostgreSQL and back.
-
PostgreSQL 19 Beta: Benchmarking JSONB Indexes with EF Core
c-sharpcorner.com Issue #528
Benchmark PostgreSQL 19 Beta JSONB indexes with EF Core by measuring query performance, indexing strategies, execution plans, storage, and application response times.
-
Benchmarking PostgreSQL 19 Beta Planner Changes with EF Core
c-sharpcorner.com Issue #527
Benchmark PostgreSQL 19 Beta query planner changes with EF Core using realistic workloads, execution plans, query latency, throughput, and database performance metrics.
-
PostgreSQL 18 OAuth Authentication with ASP.NET Core Identity
c-sharpcorner.com Issue #524
PostgreSQL 18 OAuth integrates with ASP.NET Core Identity for secure database authentication, enhancing layered security without replacement.
-
Benchmarking PostgreSQL 18 AIO with Real EF Core Workloads
c-sharpcorner.com Issue #523
Benchmark PostgreSQL 18 AIO with EF Core workloads. Measure impact on ASP.NET Core apps, storage I/O, and query performance.
-
PostgreSQL 18 AIO: Benchmarking .NET Database Workloads
c-sharpcorner.com Issue #520
Benchmark PostgreSQL 18 AIO with .NET workloads. Measure performance differences between sync, worker, and io_uring for optimal database I/O.
-
Relational Where It Helps, JSONB Where It Must: Persisting IIIF Presentation 3 in PostgreSQL with…
ahmadminoo.medium.com Issue #519
A proof of concept using the real IIIF Manifest object model, EF Core owned entities, Razor Pages, PostgreSQL, and careful JSONB
-
ASP.NET Web API CRUD with EF Core & PostgreSQL (Code First)
c-sharpcorner.com Issue #517
Build an ASP.NET Core Web API with EF Core and PostgreSQL using Code First. Master CRUD operations for robust data management.
-
Vector Databases with .NET: PostgreSQL pgvector vs Azure AI Search vs Qdrant
c-sharpcorner.com Issue #516
Compare PostgreSQL pgvector, Azure AI Search, and Qdrant for .NET AI apps. Choose the best vector database for RAG, semantic search, and more.
-
PostgreSQL 18 Performance Tuning for EF Core Applications
c-sharpcorner.com Issue #514
Optimize PostgreSQL 18 for EF Core apps. Learn to tune queries, use indexes, manage data loading, and implement a repeatable performance tuning process.
-
WSLC Meets Compose: Running a Full .NET 10 Stack Without Docker Desktop
medium.com Issue #512
A practical multi-container workflow for .NET 10, PostgreSQL, and Redis on Windows.
-
Building Semantic Search Applications with PostgreSQL pgvector and ASP.NET Core
c-sharpcorner.com Issue #505
Build intelligent search apps with PostgreSQL pgvector & ASP.NET Core. Understand meaning, not just keywords, for better user experiences.
-
How to Optimize SQL Queries: 20 Proven Best Practices
antondevtips.com Issue #505
Slow queries drag down every app. Learn 20 proven techniques to optimize SQL queries in PostgreSQL - indexes, covering indexes, sargable filters, smarter joins, materialized views, functions in where,
-
Implementing Long-Term Memory for AI Agents with Semantic Kernel and PostgreSQL
c-sharpcorner.com Issue #500
Unlock AI's potential with long-term memory using Semantic Kernel & PostgreSQL. Build context-aware, personalized agents.
-
PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
Compare PostgreSQL vs SQL Server for .NET apps. Explore licensing, performance, cloud, JSON, and scalability to choose the best fit.
-
We Moved from SQL Server to PostgreSQL in a .NET
medium.com Issue #483
We moved one of our .NET systems from SQL Server to PostgreSQL mainly to reduce licensing cost and simplify our cloud setup.
-
The Interval Is the Thing: Modelling Range Types as First-Class Domain Objects in .NET
medium.com Issue #476
A complete solution: expressive range types in your domain layer, full PostgreSQL translation in your data layer — no compromises at…
-
ASP.NET Core 10 Web API CRUD with EF Core - Complete .NET 10 Tutorial
codewithmukesh.com Issue #473
Build a production-ready .NET 10 Web API with EF Core 10 and PostgreSQL. CRUD operations, DDD, Minimal APIs, Scalar, code-first migrations, and best practices.
-
High-Performance Distributed Caching with .NET and Postgres on Azure
devblogs.microsoft.com Issue #449
Adding caching to your application architecture can significantly improve key performance metrics, cut latency, and reduce load across downstream systems. In this walkthrough, we highlight the latest ...
-
Just Use Postgres as a Queue?
codeopinion.com Issue #443
I’ve noticed a trend, and a lot of people are saying the same thing: just use Postgres as a queue. No Kafka, no Redis, no RabbitMQ, just one database for everything. And I totally get it. I get the ap...
-
PostgreSQL Like a Pro: Build mission-critical apps at any scale with Azure HorizonDB
youtube.com Issue #439
Choosing the Right Azure Hosting Model for AI Agents: A Deep Dive into Foundry Hosted Agents
-
Getting started with PgVector in .NET for simple vector search
csharpdigest.net Issue #432
not every AI feature needs a dedicated vector database
-
Getting Started With PgVector in .NET for Simple Vector Search
milanjovanovic.tech Issue #423
Vector search doesn't require a dedicated vector database. PostgreSQL with pgvector gives you similarity search right next to your relational data. Here's how to set it up in .NET with Aspire, Dapper,...