N
N
Nikita Ivanov2016-04-30 01:04:59
Database
Nikita Ivanov, 2016-04-30 01:04:59

What is the difference between JSON and JSONB?

Googling didn't help
The wiki article doesn't say anything about JSONB, but PostgreSQL uses JSONB, I also saw it in the Laravel docs. It's
often "..JSON and JSONB.." with different contexts
. What's the difference?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
C
curator, 2016-04-30
@rekurt

JSONB is a binary variation of the JSON format in which spaces are removed, the sorting of objects is not preserved, instead they are stored in the most optimal way, and only the last value for duplicate keys is preserved. JSONB is generally the preferred format because it requires less space for objects, can be indexed, and is faster to process because it doesn't need to be re-parsed.
Source: https://habrahabr.ru/post/282764/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question