Menu
Inshorts
For the best experience use inshorts app on your smartphone
inshortsinshorts
Manage unstructured data efficiently with relational database
short by Ashveen Bansal / on Monday, 18 March, 2024
PostgreSQL has a data type called JSONB, or JSON binary - JSON in binary form. This allows Postgres to know where every literal is in memory, making operations faster. Also, you can use a Generalized Inverted Index to index the JSON data itself, which can significantly improve query performance. JSONB queries can be just as efficient as equivalent NoSQL queries.
read more at Linkedin