Radim @ boringSQL
boringsql.com
Radim @ boringSQL
@boringsql.com
Straightforward PostgreSQL and SQL tips, tricks, and tools to get stuff done (no fluff).
Can't believe it's 5 years since my first pull request. Now sharing RegreSQL as my own fork.

boringsql.com/posts/regres...
RegreSQL: Regression Testing for PostgreSQL Queries
Stop deploying broken SQL queries. RegreSQL provides regression testing for PostgreSQL queries with performance baselines and automated warnings.
boringsql.com
November 14, 2025 at 2:08 PM
Reposted by Radim @ boringSQL
“Early in our company’s life, we built everything around modern data frameworks — until we realized the simplest, most reliable tool had been in front of us all along”

blog.sturdystatistics.com/posts/sql/
The Quiet Power of SQL – Sturdy Statistics Blog
blog.sturdystatistics.com
November 14, 2025 at 12:14 PM
Range types are one of PostgreSQL’s most underutilized features — let’s change that boringsql.com/posts/beyond...

#postgresql
Beyond Start and End: PostgreSQL Range Types
Discover PostgreSQL range types for cleaner schemas and atomic conflict detection. Use tstzrange, daterange, and int4range to enforce data integrity with exclusion constraints.
boringsql.com
November 3, 2025 at 6:48 PM
Back after the summer break with a new article on PostgreSQL security: performing common maintenance tasks without distributing SUPERUSER privileges.

boringsql.com/posts/postgr...
PostgreSQL maintenance without superuser
Learn about PostgreSQL maintenance without superuser privileges. Predefined roles like pg_monitor and pg_maintain provide secure database administration.
boringsql.com
September 14, 2025 at 4:56 PM
Attending ViennaDB meet up
April 7, 2025 at 4:58 PM
A good way to end 2024 - migrating personal servers to FreeBSD
December 31, 2024 at 8:35 PM
Meet me and other PostgreSQL enthusiasts in London (UK) next week www.meetup.com/london-postg...
Elephants At The Watering Hole, Wed, Dec 11, 2024, 6:30 PM | Meetup
**HI Everybody** Come along and talk about PostgreSQL with fellow PostgreSQL users, specialists, developers and all round enthusiasts of PostgreSQL. This is a relaxed soci
www.meetup.com
December 4, 2024 at 2:55 PM
Impostor syndrome always hits me hard when something gets this much exposure 🙈
DELETEs Are Difficult (notso.boringsql.com)

Main Link | Discussion
December 1, 2024 at 3:31 PM
You can probably guess where this leads. Since transactions are already a pain for developers, imagine the chaos when issues hits the production. Locks and a growing queue of waiting statements are inevitable… Fun starts in 3, 2, 1.
December 1, 2024 at 10:03 AM
Preparing a draft for the next article, which touches on transaction isolation (not the main topic though). This means the text needs to be super clear and include plenty of examples. Transactions are the number one source of pain for the majority of developers (unfortunately).
December 1, 2024 at 10:00 AM
Reposted by Radim @ boringSQL
ORM are evil. SQL is meant to be handcrafted.
November 28, 2024 at 6:32 PM
Not really doing anything for optimising SEO and stuff like that, but it's surprising to see ChatGPT as referrer for boringSQL more and more 🤔
November 28, 2024 at 9:17 AM