We’ve previously talked about our masking feature but this is focused on masking the contents of an entire column. We’ve had some recent customer questions about masking json data in PostgreSQL. The ...

PG 9.2 gives you a JSON datatype, which will validate JSON automatically. Any version of PG that supports PL/V8 can be used but the functions will need to be adapted to use TEXT instead of JSON types.

jooq-postgresql-json does not include a transitive dependency on jooq, so you have to include that yourself as well. As for 4.0.0, this shows only which jOOQ versions are explicitly tested with this ...

PostgreSQL version 17 is available and promises significant improvements in performance, scalability, and ease of use. The popular open-source database, known as Postgres for short, now offers ...

One of the most interesting trends in the computer world during the past few years has been the rapid growth of NoSQL databases. The term may be accurate, in that NoSQL databases don't use SQL in ...

One of the most anticipated new features in PostgreSQL 17 is native support for incremental backups. Previously, you had to use third-party programs for this; now, it's baked into the server. This ...

a 2022 survey, it is the second most used database after MySQL. PostgreSQL expert engineer Craig Carstiens explains the history of how PostgreSQL has been developed and how the number of users has ...