Monthly Archives: February 2022

The Recap Of The Chicago PUG February Meetup

On February 15, Chicago PUG welcomed Robert Haas with his talk titled Improving pg_basebackup In Version 15 and Beyond. As far as I can tell, it was the first event of that kind: the community members had an opportunity to learn first-hand what was in the works for the next PostgreSQL version. 

Unfortunately, this exciting event was disturbed by a Zoom-bomber, who started to interfere with the presenter using the annotation feature. And unfortunately, it took us a while to regain control. We reported the incident (we could provide screenshots since the meeting was recorded). The Chicago PUG leadership team discussed the incident and the measures that we will put in place to prevent future incidents from happening. 

A part of our challenge is the “personnel shortage” – putting some of the measures in place requires more people monitoring the situation, and we are planning to work on that.

However, there is one thing I wanted to bring to everybody’s attention. For all of our previous meetups, we always used a secure virtual events setup provided by meetup.com – links to the events were never published in the open access and were only available when somebody registered for this meetup. 

The February meetup was an exception. I wanted to use this unique opportunity to help other user groups, possibly less active than the Chicago PUG, resume their activities in the post-pandemic era. That was why I sent a zoom link directly to several people to use it for their meetups. In some cases, the link was resent further. 

Now, it’s extremely unlikely that somebody would intercept random emails. This makes me think that the link was posted somewhere on a publically accessible website. The meeting was password-protected; thereby, it could not be a random web-wonderer.

In conclusion, I just wanted to say:

  • Please be careful with zoom links!
  • Thank you for your support of the Chicago PUG!
  • Special thanks to Robert Haas for his presentation!
  • Please join us virtually on March 16 – the event will be announced shortly
  • Please help us to keep our meetings safe!!!!

Leave a comment

Filed under events, talks

One More NYC PG Conf talk

A video recording of my other talk is now available. After this presentation, I am officially retiring this version of the NORM talk – the next one will be different – stay tuned!

Leave a comment

Filed under events, talks

How my DIFF is different from other DIFFs

Important note which I didn’t include in my previous post about DIFF. Immediately after that post went live, people started to comment about dozens of other “diffs” which already exist, including the schema compare in pgAdmin. That made me realize I didn’t explain what’s the difference between my DIFF and others.

The problem I was trying to solve can be described as “how you can compare what is actually in two databases” without comparing the source code, without GitHub diff, etc., because, at large, a database exists “without” the source code.

This DIFF compares the catalogs, which are the only source of truth for all databases, so there is no question of “extra spaces” or case sensitivity.

Hope that helps 🙂

Leave a comment

Filed under Development and testing

DIFF is here!

On December 3, 2021, at NYC PG Conf I promised I will publish this repo “by the end of the year” (see here). OK… by the end of the Lunar Year? Maybe?

I was so ashamed of myself that I am breaking my promise, that I finally did it! The DIFF repo is now available, and I even produced a REAM.me, which is not very typical of me :).

What you can do with this tool? It provides a fast and easy way to find out what’s the difference between your production and staging environments, or between your local copy and QA. Not only which tables are missing (or extra), but also whether the column type, or default, or nullability differed, which constrains are different (or whether they are the same, just named differently).

Not only that, but it will also generate a patch for you to mitigate this difference (in any of the two directions you want :)).

And last but not least, you can finally get a clear picture of permissions: what was explicitly granted to each user and what is the resulting set of permission.

Please check it out!

1 Comment

Filed under Development and testing

Postgres Person of the Week

Usually, I reblog from this platform to LinkedIn, but today it’s the opposite. My interview with Postgres Life was published on Monday (yet another Valentine’s Day gift), and was already publicized on LinkedIn before I knew, so I had to reply on LinkedIn directly,

Still want to keep this link though 🙂

Person of the Week Interview

1 Comment

Filed under People, talks

My Talk at NY Pg Conf 2021

This talk was so unprepared! I was scared to look at the recording, but to my surprise, I liked it!

Good news: I will deliver the same talk in Helsinki at Nordic Pg Day, and I promise it will be much better! The code for the DIFF utility is almost ready; I didn’t outsource it before the end of 2021, but I will outsource it before I come to Helsinki. Meanwhile – check out my December talk.

2 Comments

Filed under talks