Search the site

Every tutorial, series part and tool page — one box away.

12 results for “postgresql”

SQL Server → PostgreSQL · Part 1

SQL Server to PostgreSQL: Why Switch, and What to Expect

Thinking about moving from SQL Server to PostgreSQL? Why teams switch, what stays familiar, what changes, and how to get your first Postgres running. Aug 6, 2026 5 min read

SQL Server → PostgreSQL · Part 3

Data Types: The SQL Server → PostgreSQL Translation Table

The full SQL Server to PostgreSQL data-type table. NVARCHAR to text, DATETIME2 to timestamptz, UNIQUEIDENTIFIER to uuid, plus the powers of jsonb and arrays. Aug 6, 2026 6 min read

SQL Server → PostgreSQL · Part 4

The T-SQL → PostgreSQL Phrasebook

The everyday T-SQL to PostgreSQL translation guide. TOP to LIMIT, ISNULL to COALESCE, SCOPE_IDENTITY to RETURNING, MERGE to ON CONFLICT, worth bookmarking. Aug 6, 2026 7 min read

SQL Server → PostgreSQL · Part 7

Backup and Restore in PostgreSQL, for SQL Server DBAs

Every SQL Server backup type has a PostgreSQL equivalent. pg_dump, pg_basebackup and WAL archiving with point-in-time recovery, mapped to what you know. Aug 6, 2026 6 min read

SQL Server → PostgreSQL · Part 8

PostgreSQL with .NET and EF Core — and Your Migration Plan

Connect .NET to PostgreSQL with Npgsql and EF Core. Move the actual data, then wrap up the series with a practical switch-over checklist. Aug 6, 2026 6 min read

From Prompt to Production · Part 4

Spec to Schema: Designing PostgreSQL Tables with AI

Turn the spec into PostgreSQL DDL with AI. Then catch its mistakes in a schema review: the missing FK index, the naive timestamp, and the partial unique index. Aug 9, 2026 7 min read

Databases & Data

PostgreSQL vs SQL Server for .NET Developers: The Real Differences

PostgreSQL vs SQL Server, decided by someone who ran both. Licensing, EF Core support, tooling, hosting, JSON, full-text search, and what hurts in a migration. Sep 4, 2026 9 min read

SQL Server → PostgreSQL · Part 2

Instances, Databases, Schemas and Roles: Remapping Your Mental Model

Remap your SQL Server mental model for PostgreSQL. Instance vs cluster, dbo vs public, logins vs roles, and why cross-database queries do not work as expected. Aug 6, 2026 6 min read

SQL Server → PostgreSQL · Part 6

Indexes, MVCC and Performance: Unlearning the Clustered Index

PostgreSQL has no clustered index. Readers never block writers either, so here are MVCC, VACUUM, EXPLAIN ANALYZE and the new index types for SQL Server folks. Aug 6, 2026 7 min read

postgres:18 Docker container exits immediately: mount the volume at /var/lib/postgresql

The postgres:18 image stops right after starting. The data directory moved, so your old /var/lib/postgresql/data mount is the problem. Mount one level up. Sep 4, 2026 2 min read

SQL Server → PostgreSQL · Part 5

Stored Procedures, Functions and Triggers in PL/pgSQL

Rewrite T-SQL stored procedures in PL/pgSQL. Procedures vs functions, RAISE NOTICE, RETURNS TABLE and triggers, with a real procedure translated line by line. Aug 6, 2026 7 min read

From Prompt to Production · Part 5

Scaffold to Skeleton: Blazor Server, EF Core and Npgsql

From template to skeleton with an AI pair. The SQLite to PostgreSQL swap, the first migration, a seeder, and the rule that makes AI scaffolding safe. Aug 9, 2026 8 min read