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

Top 3 Kafka Streams Challenges

VoltDB

We’ve been writing a lot about challenges lately. We recently wrote about API challenges – now we’re discussing challenges with Kafka Streams. Volt is very big on Kafka, as we specialize in complementing it in a really powerful way to allow enterprises to get the most out of it. That said, a lot of companies have now started to use Kafka Streams – and, as with any relatively new technology, there are some not-so-negligible growing pains.

Java 52
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.

Database 101