SQL gets a lot of flack for not being new and updated and, well, fun. But the truth is it’s come a long way from what it was decades ago. Here’s a great deck which highlights some of the new and awesome things in the SQL standard.
Knowing you have wide range of skill demands in your role as a Postgres DBA, it pays to invest some time in learning effective techniques for performance tuning, an essential task that arises time and time again.
Last Thursday there were new releases of Postgres (above) addressing a few security issues among other items. Here’s a rundown of what’s included in the release which should help you know whether to update or not, though as always it’s a good practice to do.
Here’s a quick guide along with a video walk through of the basics of backing up and restoring your PG database. And pro-tip: as is always the case with backups, unless you test them by restoring them then you shouldn’t rely on your backups.
Foreign data wrappers provide the powerful ability for you to query to something else from within your Postgres database. Here’s a newer one that not only lets you query to Redis from inside Postgres, but also write data out to it.