New answers tagged

0 votes

MariaDB: inconsistent SELECT results involving JSON

So. After not even a day in the bug tracker for MariaDB I got the following back and the ticket was closed: It behaves as expected. MariaDB knows that the output of JSON_OBJECT() is a json. But when ...
Andreas Hinderberger's user avatar
0 votes

Does NoSQL databases have a common language like SQL?

Is there a common query language for the key-value type (JSON type) NoSQL databases, which can be used across multiple NoSQL databases? (just as SQL for relational databases) Nope. Just depends on ...
J.D.'s user avatar
  • 35.2k
0 votes

Cannot import JSON file into MySQL

You can troubleshoot it. Make sure MySQL version is newer than 5.7.8. Check the validity of the JSON file Check the field format
Lee Gilroy's user avatar
0 votes

Cannot import JSON file into MySQL

JSON data import using MySQL Workbench I am using MySQL and the Workbench, both with versions 8.0.34 and an example JSON document in a file, eg., "myfile.json". This has one object in an ...
prasad_'s user avatar
  • 426
1 vote

Should i care about field names in JSON datatypes?

For relational databases (RDBMS) like MySQL, MariaDB, PostgreSql it matters a lot, because they store the JSON as text. See the other answers. For a NoSQL database like MongoDB it looks a bit ...
Wernfried Domscheit's user avatar
1 vote

Should i care about field names in JSON datatypes?

Yes, the field names are stored in every JSON document. If you use long field names in the JSON document, the document uses more storage on every row of the table. I showed this in my presentation How ...
Bill Karwin's user avatar
  • 13.9k
1 vote

PostgreSQL bug with JSON type?

CTE doesn't seem to work anymore from version 15 of postgresql at least. A solution could be : select * from ( select case when jsonb_typeof(info->'vatids') = 'array' then ...
Passenger's user avatar
1 vote

Should i care about field names in JSON datatypes?

MySQL/MariaDB: The string is stored as a string. This takes space and slows down looking into the string. So, you should, in general, pull the useful columns out of the JSON and put them into columns ...
Rick James's user avatar
  • 77.1k

Top 50 recent answers are included