Thu.Apr 11, 2024

article thumbnail

JSON_TABLE() Will Be in PostgreSQL 17

Percona

JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last minute. We will get it shortly when PostgreSQL 17 is officially released this year! Please see this.Why is this important?JSON has become the data interchange format of choice for most developers.

article thumbnail

How to Replicate and Rename a Database in MariaDB

Percona

MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not dynamic, and you should be aware of that.