Postgres Extensions Day 2025 Montreal: Registration and Call for Speakers
Postgres Extensions Day 2025 Montreal: Registration and Call for Speakers On May 12th, 2025, Postgres Extension Developers Coalition (PGEDC) will host [Po...
Yurii Rashkovskii
Writings on software development and work practices, entrepreneurship, tech in general.
Latest posts
Omnigres Developer Experience
Omnigres Developer Experience Software developer's job is not an easy one; anything that makes it less frustrating and makes developers more productive is highly sought for. This is why the most successful developer tools are usually the ones that have an amazing developer experience. Omnigres turns Postgres into a complete Application Platform, and by doing that, we must focus on Development,…
Structured Postgres Regression Tests
Structured Postgres Regression Tests I've been using pg_regress tests for a while. It's generally a great way to ensure the behavior of your Postgres code works and continues working as expected. However, as my tests became larger, I started getting lost in them; and there are limits as to what you can test by having a psql session.
Avoiding Postgres Extensions Limitations
Avoiding Postgres Extensions Limitations Postgres extensions are great. They enable fantastic use cases and bring new capabilities to one of the most loved open source databases. But there are edges in some of its features and this can be heard in conversations: limitations of the upgrade system, lack of parameterized initialization, search path/OID resolution issues, hard-wired dependency on…
Sum Types in Postgres
Sum Types in Postgres At times, representing the variety of types a value can take through multiple tables can taxing, both in terms of development complexity as well as, potentially, performance. You must just need a value to be of any of the given variants. I've set out to build a generalized mechanism for defining these.
PL/Rust Just Shipped: Easy Way to Try It Out
PL/Rust Just Shipped: Easy Way to Try It Out As a Rust enthusiast and a contributor to a sister project I am stoked about the release of PL/Rust 1.0.0 that was just announced . However, its setup instructions are rather long and it takes time to build it. So I took the time to prepare a build for you to try.
Make Postgres an Application Server, Gamified
Make Postgres an Application Server, Gamified Have you ever wondered if Postgres can be a fully self-sufficient platform for your application? Learn how to make it become an application server and win some prizes, too!
What happens if you put HTTP server inside Postgres?
What happens if you put HTTP server inside Postgres? Benchmarks and performance claims are attention-grabbers, but that's not what drew me to work on Omnigres. When I first built a prototype of its HTTP server, I didn't foresee the desire to share the numbers. As we all know, getting benchmarks right is hard, and everybody's mileage may vary. But I'll show you some numbers here anyway. It'll be…
Why not Rust for Omnigres?
Why not Rust for Omnigres? Omnigres is a new project to turn Postgres into a complete development and production deployment platform. I've started it to reflect on the complexity and inefficiencies plaguing modern business software development. As an aging (and sometimes cranky!) developer, I crave simplicity. But that's a topic for another post. Here I wanted to address a common question: Why…
Solving Problems, One Commit at a Time
Solving Problems, One Commit at a Time If you have been following some of my projects in the past year or so, you might have noticed that the my commit messages changed considerably and they no longer look typical. Take a look at this one:
Team Uncommunication
Team Uncommunication The art of silence Last year, my friends and I spent a few days by a lake on Vancouver Island. The house we were renting came with two canoes and, naturally, one of my friends and I ended up paddling one. Being quite new to canoes, we were at first struggling to keep the thing straight and move swiftly.