PostgreSQL - Curated .NET Articles & Tutorials
Curated .NET news, articles, and tutorials about PostgreSQL, drawn from .NET News Daily issues.
27 curated issues
High-Performance Distributed Caching with .NET and Postgres on Azure
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 ...
Issue also covered: Azure, Cosmos DB, C#, GitHub Copilot, Kafka, Performance, Profiling, Visual Studio
Read this issue →Just Use Postgres as a Queue?
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...
Issue also covered: ASP.NET Core, Authentication, Blazor, C#, Design Patterns, .NET 10, EF Core, Minimal APIs
Read this issue →PostgreSQL Like a Pro: Build mission-critical apps at any scale with Azure HorizonDB
Choosing the Right Azure Hosting Model for AI Agents: A Deep Dive into Foundry Hosted Agents
Issue also covered: ASP.NET Core, Azure, Azure Functions, Clean Architecture, C#, Docker, EF Core, OpenAI
Read this issue →Getting started with PgVector in .NET for simple vector search
not every AI feature needs a dedicated vector database
Issue also covered: C#, Performance, Redis, Security
Read this issue →Getting Started With PgVector in .NET for Simple Vector Search
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,...
Issue also covered: ASP.NET Core, Azure, C#, Performance, Security
Read this issue →Optimizing Bulk Database Updates in .NET: From Naive to Lightning-Fast
Seven approaches to bulk-updating rows in PostgreSQL from .NET using Dapper and EF Core, from naive per-row updates to binary COPY. Each step cuts down on round-trips or removes dynamic SQL entirely.
Issue also covered: ASP.NET Core, Azure, C#, Dapper, EF Core, GitHub Copilot, OpenAI, Performance
Read this issue →How to Set Up Production-Ready Monitoring With ASP.NET Core Health Checks
Learn how to build a production-ready monitoring system using ASP.NET Core Health Checks. This guide covers adding health checks for Postgres, Redis, MongoDB, and MassTransit (RabbitMQ), creating cust
Issue also covered: AOT, ASP.NET Core, .NET Aspire, Authentication, Authorization, Azure, C#, .NET Core
Read this issue →PostgreSQL on Azure supercharged for AI
From GitHub Copilot AI assistance to built-in model management, Azure is helping devs and enterprises unlock the full potential of PostgreSQL. The post PostgreSQL on Azure supercharged for AI appeare...
Issue also covered: ASP.NET Core, Azure, Azure Functions, Blazor, Cosmos DB, CQRS, Docker, .NET 10
Read this issue →Supercharging GenAI Apps with PostgreSQL and Azure AI
Learn how to supercharge your GenAI apps with PostgreSQL and Azure AI. Lino Tadros shows how PGVector and AI Extensions in VS Code turn PostgreSQL into an intelligent foundation for high-performance G...
Issue also covered: .NET Aspire, Azure, C#, Design Patterns, .NET 10, ML.NET, Redis, Unit Testing
Read this issue →⚡ Extremely FAST Paging With Cursor Pagination & Index Seek
SQL Server • PostgreSQL • MySQL • MongoDB Compared — with Full .NET 9 Code (Part 1)
Issue also covered: ASP.NET Core, Azure, Clean Architecture, C#, Dapper, Domain-Driven Design, Design Patterns, .NET 10
Read this issue →Is Redis Overkill? Rethink SignalR Backplane with PostgreSQL
Redis isn’t always the right fit. Here’s how PostgreSQL can serve as a backplane for SignalR in distributed, low-throughput applications. Continue reading on Level Up Coding »
Issue also covered: ASP.NET Core, C#, .NET 10, EF Core, Performance, Visual Studio
Read this issue →Dapper + Entity Framework Core (EF Core) together against PostgreSQL in .NET 8
Combine the power of Entity Framework Core (EF Core) for schema management and Dapper for raw SQL performance in .NET 8 with PostgreSQL. This guide explores two approaches: using EF Core for CRUD and ...
Issue also covered: ASP.NET Core, C#, Dapper, Design Patterns, .NET Core, EF Core, Minimal APIs, Performance
Read this issue →Using Stored Procedures and Functions With EF Core and PostgreSQL
Learn how to use PostgreSQL stored procedures and functions with EF Core to handle complex queries, atomic operations with locking, and database-specific features while keeping the type safety and con...
Issue also covered: ASP.NET Core, Clean Architecture, C#, .NET Framework, EF Core, Performance, Source Generators
Read this issue →Updating and Deleting Tasks in Our .NET
In the previous post, we created new tasks and got our backend to communicate with PostgreSQL. By including Update (PUT) and Delete…
Issue also covered: AOT, ASP.NET Core, Azure, CQRS, Docker, .NET 9, .NET Core, GitHub Copilot
Read this issue →Boost Your EF Core Productivity in PostgreSQL With Entity Developer
Model-First approach: instead of hand-writing your models and configurations, you design them visually. Continue reading on CodeX »
Issue also covered: ASP.NET Core, .NET Aspire, Clean Architecture, C#, .NET 10, .NET 9, .NET Core, EF Core
Read this issue →Building a High-Performance API with .NET and PostgreSQL
When I started building APIs, I thought: “If it works, it’s good.” Then came my first production issue: API calls that took forever. I…
Issue also covered: ASP.NET Core, C#, EF Core, GitHub Copilot, Minimal APIs, OpenAI, Performance, Visual Studio
Read this issue →Build your own Static Code Analysis tool in .NET by knowing how Assembly, Type, MethodInfo, ParameterInfo work.
Why buy a whole tool when you can build your own? Learn how the Type system works in .NET, and create your own minimal type analyser.
Issue also covered: ASP.NET Core, C#, .NET 9, EF Core, Security, Web API
Read this issue →Postgres Full Text Search with EF Core 9
https://medium.com/@vosarat1995/postgres-full-text-search-with-ef-core-9-40da6805033e
Issue also covered: Azure, Docker, .NET 10, EF Core, Kubernetes
Read this issue →Data Access in ASP.NET Core: Combining Dapper, EF Core, and PostgreSQL
https://medium.com/@aamritbistaa/data-access-in-asp-net-core-combining-dapper-ef-core-and-postgresql-77e2e20615c0
Issue also covered: ASP.NET Core, Azure, C#, Dapper, .NET 10, .NET 9, EF Core, Kafka
Read this issue →Building a .NET 9 Web API with Entity Framework Core and PostgreSQL
https://semihtekin.medium.com/building-a-net-9-web-api-with-entity-framework-core-and-postgresql-103bd666917f
Issue also covered: ASP.NET Core, C#, Design Patterns, .NET 10, EF Core, GitHub Copilot, JWT, .NET MAUI
Read this issue →How To Deploy .NET Application to Azure using Neon Postgres and .NET Aspire
https://antondevtips.com/blog/how-to-deploy-dotnet-application-to-azure-using-neon-postgres-and-dotnet-aspire
Issue also covered: ASP.NET Core, .NET Aspire, Azure, C#, .NET 9, .NET Core, EF Core, .NET MAUI
Read this issue →