port.80.cz
Zbyněk Vanžura's blog — practical insights from more than 20 years of experience, mostly about PostgreSQL, software development, and AI, but occasionally also about other topics worth reflecting on.
Latest posts
- Photoshop Overnight? What AI Can Do in a Few Hours (and What It Can't) Oct 7, 2026
I took an abandoned open-source editor, miniPaint, and let AI add Photoshop- and GIMP-inspired features overnight. By morning I had a PWA that resembles Photoshop. Free, MIT licensed.
- Sandboxed Apps: When Isolation Cuts the Database Off From .pgpass Sep 9, 2026
How I moved OmniDB into the macOS Sandbox and hit an unreachable .pgpass file — and what a safe, on-demand permission UX looks like on macOS, Linux and Windows.
- The End of the Python Era? How AI Helped Me Rewrite a 10-Year-Old Tool in Go Aug 26, 2026
Rewriting OmniDB from Python to Go as a case study — why in the AI era it no longer makes sense to sacrifice runtime performance for the sake of convenient coding.
- When an Archived Tool Refuses to Die: pgAdmin III and the Case for Native GUIs Jul 22, 2026
Why pgAdmin 4 never became the beloved successor to pgAdmin III, how a community fork keeps it alive on macOS with the help of AI, and why native desktop GUIs still have a place next to web apps in 2026.
- Why SQL Formatting Is Still the Wild West — and How pg_procrustes Changes It Jul 14, 2026
How pg_procrustes tackles the age-old problem of formatting PostgreSQL SQL code with a native parser and fine-grained configuration — and why it aims to become the gofmt of the database world.