Blog
Announcements, engineering deep-dives, and tutorials for PostgreSQL schema design.
-
AnnouncementsIntroducing PgDesigner — A Modern Visual PostgreSQL Schema Designer
PgDesigner is a visual PostgreSQL schema designer with production-ready DDL generation, safe ALTER migrations with hazard detection, 66 lint rules, and a git-friendly format. Free for non-commercial use.
vmkteam • -
Engineering66 Lint Rules for PostgreSQL Schemas — What We Check and Why
PgDesigner validates your schema with 66 rules across 3 severity levels. Here's the reasoning behind the most impactful rules: missing FK indexes, type mismatches, serial vs identity, and more.
vmkteam • -
AnnouncementsPgDesigner v0.0.2 — DSN Introspection, Keyboard Shortcuts, and Project Settings
v0.0.2 brings DSN introspection to connect and import from live PostgreSQL, canvas hotkeys, full keyboard shortcuts, project settings, auto-save DDL, and 10 bug fixes.
vmkteam • - Tutorials
Migrating from MicroOLAP Database Designer to PgDesigner
MicroOLAP Database Designer for PostgreSQL hasn't been updated since 2021. Here's how to migrate your .pdd project files to PgDesigner in under 5 minutes.
vmkteam • -
EngineeringHow PgDesigner Generates Safe ALTER Migrations with Hazard Detection
A deep dive into PgDesigner's diff engine: two-phase algorithm, 6 hazard codes, compatible cast detection, and smart rename recognition. Learn how it prevents dangerous migrations.
vmkteam •
