Questions tagged [json]
JavaScript Object Notation (JSON) is an open, human and machine-readable standard that facilitates data interchange, and along with XML is the main format for data interchange used on the modern web.
670 questions
1 vote
1 answer
53 views
Safely update parts of JSON data stored in SQLite, OCC
So I’m experimenting with a lightweight way to track and safely update parts of JSON data stored in SQLite, using Python. The main goal is to: Keep JSON documents inside an SQLite database (in a TEXT ...
- 11
3 votes
1 answer
401 views
Why does a Json Path inequality over an array not work?
Given the following jsonb array, I want to filter it only for certain objects. [ { "id": "123" }, { "id": "456" }, { "id": "...
- 18.1k
1 vote
1 answer
69 views
Storing Application Options
I have always stored Application Options as an Ini file on windows as it has been faster to access than the database. Also, sometimes, you need to read some of them before accessing the database. The ...
- 2,158
1 vote
2 answers
216 views
How to concatenate multiple JSON arrays into a single array in MariaDB?
I'm working with a MariaDB database where I have a table with two columns: id and values, where values contains JSON arrays. Here is a simplified example of the data: id values 1 "[1, 2, 3]" ...
- 111
4 votes
1 answer
392 views
Do handling of JSON-format or anti-pattern (comma-delimited values etc.) in relational database introduces performance and maintainability issues
If... INSERT INTO TABLE_NAME SELECT STRING_AGG(COLUMN_NAME, ',') FROM TABLE_NAME introduces an anti-pattern (i.e., can cause poor performance, incorrect results (kindly verify ...
- 205
2 votes
1 answer
50 views
JSON_CONTAINS in HAVING clause adds extra closing brace to JSON_OBJECTAGG
I have a table with data we've collected from various sources. It's got the item name, the source and the source's value. The table looks like the following: id name source value 1 abc web 1 2 abc ...
- 121
5 votes
1 answer
707 views
PostgreSQL json testing (`is json`) and casting with null character (`\u0000`) work unexpectedly
I know something about null characters in PostgreSQL text types. But I cannot understand the strange behavior of json testing and casting: select '{"foo":"bar\u0000"}' is json; --...
0 votes
1 answer
145 views
Unable to retrieve data from Postgres json column
I have a Postgres table with json column as dataset_metadata. It stores an epoc time in array looks like: select event_type ,technology ,dataset_metadata->> 'intervals_epoch_seconds' ,add_ts ...
