search

fedora-infra / datanommer

Put all the messages in the postgres
GNU General Public License v3.0
15 stars 25 forks source link

Add a JSONB column to the database to make jsonpath queries #1312

Open abompard opened 3 months ago

abompard commented 3 months ago

This PR adds a JSONB-typed column for the message content, which will allow us to make jsonpath queries.

Example : https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH

The PR also adds a script to populate the column in the current DB.