PGSQL Phriday #004 Recap

Thank you to everybody who contributed to the January PGSQL Phriday topic! I suggested “Postgres and Software Development,” while being very well aware that this topic is not popular in the PostgreSQL community. To be completely honest, I thought that it was possible that only Ryan Booz would contribute! 

That being said – a big thank you to everyone who participated! Please find a summary of contributions below, and please let me know if I missed your post!

The first person to contribute was Andreas Scherbaum with his blog post PGSQL Phriday #004: PostgreSQL and Software Development. Andreas had a huge advantage as he could summarize the information from over 140 interviews he conducted for his “PostgreSQL person of the week” series. His blog post mainly focuses on what people are saying about the development for PostgeSQL – patch submissions and other details of how PostgreSQL as a project is maintained. While we can learn a lot about PostgreSQL development patterns from these observations, we still want to learn how the World of PostgreSQL interacts with the rest of the world.

Next, I want to mention two great “here is my toolbox” posts; a Sequence Survey from Gabrielle (Gorthx) and Don’t do this: creating useless indexes by Laeticia Avrot. (great read, and lots of helpful links!) Many thanks to both of you!

love the blog post by Dian Fay Scripting in the Industrial Age. I bookmarked this post for future rereading and citing since it resonates with many of my sentiments about automation, centralized code repo, sharing, and the ease (and what’s not) of finding what you need!

In his post Postgres and Software Development, Ryan Lambert addresses how he manages the code through the development process. He groups the code into mission-critical, not trivial, and trivial and explains how he handles all of these code types. I like such a systematic approach! Also, Ruan is one of the few who took my prompt on pgTAP and testing, and I am glad this topic has been discussed. 

And finally, here are two blog posts by authors who share the experience (and pains) of communicating with application developers!

When Pat responds to my prompt with, “I rarely have non-frustrating interactions with developers,” I know he feels my pain! And same as Pat, I believe that the problem originates in education or lack of that! Pat mentioned “1-2 semesters of how to write SQL,” but the truth is that a frightening majority of application developers’ degrees are not technical or mathematical and, more often than not, have nothing to do with their jobs. Most likely, you can expect a code boot camp, with not semesters but just hours of SQL. 

And finally, Ryan Booz’s post! I knew he would love my topic because that’s what he will present at Chicago PUG on January 17! And I know that he believes in a “database as a code” mindset. Read his blog post to learn about the principles he carries through in how he approaches database management.


  • Once again, THANK YOU to everyone who participated in #PGSQLPhriday #004! 
  • Special thanks to everyone who shared their scripts!
  • Unfortunately, our interactions with application developers are more often frustrating than not!
  • Unfortunately, although we would love to have a way to organize our toolboxes, we still do not have a straightforward way.
  • We all want to share our scripts, but the most common way of sharing is via blog posts.
  • And thus, the question remains:

Why an application developer says, “Let me share a library with you,” and a DBA (or a database developer) says, “let me give you a script”?!

P.S. I just found out that my talk “PostgreSQL and Software Engineers” has been accepted to PG Day Paris! Yay!


Filed under publications and discussions

2 responses to “PGSQL Phriday #004 Recap

  1. Hettie D.

    Reblogged this on Hettie's Reflections and commented:

    I am very thiankful for the opportunity to host the January edition of PGSQL Phriday series. I hope that this series will continue and more people will join the discussions!

  2. Pingback: PGSQL Phriday #004 – PGSQL Phriday

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s