Nov 04, 2022 |
Insight for DBAs, Insight for Developers, PostgreSQL
I was recently reading the PostgreSQL 15 release notes and stopped at “Allow unique constraints and indexes to treat NULL values as not distinct”. At first glance, it seems to be a minor change, but this feature may change many designs and make many lives a lot easier. The first thing here is to understand […]
Nov 18, 2021 |
Insight for DBAs, Insight for Developers, PostgreSQL
Welcome to a weekly blog where I get to answer (like, really answer) some of the questions I’ve seen in the webinars I’ve presented lately. If you missed the latest one, PostgreSQL Performance Tuning Secrets, it might be helpful to give some of it a listen before or after you read this post. Each week, […]
Aug 10, 2021 |
Insight for DBAs, Insight for Developers, PostgreSQL
We discussed how to install and create a simple class in the first part of this series where we ran a SELECT and returned one row with one column with a formatted text. Now it’s time to expand and see how to return multiple tuples. A little disclaimer here; I’m not going to comment much […]
Jul 29, 2021 |
Insight for DBAs, Insight for Developers, PostgreSQL
We’ve recently received some questions regarding PL/Java and I found it hard to get clear instructions searching on the internet. It’s not that there is no good information out there, but most of it is either incomplete, outdated, or confusing and I decided to create this short “how-to” and show how to install it and […]
Apr 23, 2021 |
Insight for DBAs, Insight for Developers, MySQL, Percona Software
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the cluster replicates the schema change query as a […]
Dec 04, 2020 |
MySQL, Open Source, Security
Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make MySQL validate the certificate signature against the authority public […]
Jan 10, 2019 |
Insight for DBAs, Open Source, PostgreSQL
Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this series of posts and walk through updatable views, INSTEAD OF Triggers, and the Rule […]