Radim @ boringSQL
@boringsql.com
Straightforward PostgreSQL and SQL tips, tricks, and tools to get stuff done (no fluff).
It's gonna be cold, grey, and dark, but thanks to Postgres community events, there's something to look forward to. My evenings are busy next week, but in a good way - are you going to join me?
Mon, 24 Nov in Prague - lnkd.in/dP5es2Nc
Thu, 27 Nov in Malmo - www.meetup.com/malmo-postgr...
Mon, 24 Nov in Prague - lnkd.in/dP5es2Nc
Thu, 27 Nov in Malmo - www.meetup.com/malmo-postgr...
November 20, 2025 at 7:28 PM
It's gonna be cold, grey, and dark, but thanks to Postgres community events, there's something to look forward to. My evenings are busy next week, but in a good way - are you going to join me?
Mon, 24 Nov in Prague - lnkd.in/dP5es2Nc
Thu, 27 Nov in Malmo - www.meetup.com/malmo-postgr...
Mon, 24 Nov in Prague - lnkd.in/dP5es2Nc
Thu, 27 Nov in Malmo - www.meetup.com/malmo-postgr...
Can't believe it's 5 years since my first pull request. Now sharing RegreSQL as my own fork.
boringsql.com/posts/regres...
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
Can't believe it's 5 years since my first pull request. Now sharing RegreSQL as my own fork.
boringsql.com/posts/regres...
boringsql.com/posts/regres...
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/
blog.sturdystatistics.com/posts/sql/
The Quiet Power of SQL – Sturdy Statistics Blog
blog.sturdystatistics.com
November 14, 2025 at 12:14 PM
“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/
blog.sturdystatistics.com/posts/sql/
Range types are one of PostgreSQL’s most underutilized features — let’s change that boringsql.com/posts/beyond...
#postgresql
#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
Range types are one of PostgreSQL’s most underutilized features — let’s change that boringsql.com/posts/beyond...
#postgresql
#postgresql
Back after the summer break with a new article on PostgreSQL security: performing common maintenance tasks without distributing SUPERUSER privileges.
boringsql.com/posts/postgr...
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
Back after the summer break with a new article on PostgreSQL security: performing common maintenance tasks without distributing SUPERUSER privileges.
boringsql.com/posts/postgr...
boringsql.com/posts/postgr...
Attending ViennaDB meet up
April 7, 2025 at 4:58 PM
Attending ViennaDB meet up
Reposted by Radim @ boringSQL
Time to Better Know the Time in PostgreSQL Article URL: https://notso.boringsql.com/posts/know-th...
https://notso.boringsql.com/posts/know-the-time-in-postgresql/
Event Attributes
https://notso.boringsql.com/posts/know-the-time-in-postgresql/
Event Attributes
Time to Better Know The Time in PostgreSQL | boringSQL
Deep dive into SQL & PostgreSQL to build reliable, rock-solid solutions with tips and tricks that keep business online. Data is everything. Explore, learn and innnovate to get them where you need faster and more efficiently.
notso.boringsql.com
April 7, 2025 at 3:25 AM
Time to Better Know the Time in PostgreSQL Article URL: https://notso.boringsql.com/posts/know-th...
https://notso.boringsql.com/posts/know-the-time-in-postgresql/
Event Attributes
https://notso.boringsql.com/posts/know-the-time-in-postgresql/
Event Attributes
Back with "VIEW inlining in PostgreSQL" notso.boringsql.com/posts/view-i...
VIEW inlining in PostgreSQL | boringSQL
Deep dive into SQL & PostgreSQL to build reliable, rock-solid solutions with tips and tricks that keep business online. Data is everything. Explore, learn and innnovate to get them where you need fast...
notso.boringsql.com
February 9, 2025 at 1:43 PM
Back with "VIEW inlining in PostgreSQL" notso.boringsql.com/posts/view-i...
A good way to end 2024 - migrating personal servers to FreeBSD
December 31, 2024 at 8:35 PM
A good way to end 2024 - migrating personal servers to FreeBSD
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
Meet me and other PostgreSQL enthusiasts in London (UK) next week www.meetup.com/london-postg...
Impostor syndrome always hits me hard when something gets this much exposure 🙈
December 1, 2024 at 3:31 PM
Impostor syndrome always hits me hard when something gets this much exposure 🙈
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
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.
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
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).
Reposted by Radim @ boringSQL
ORM are evil. SQL is meant to be handcrafted.
November 28, 2024 at 6:32 PM
ORM are evil. SQL is meant to be handcrafted.
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
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 🤔