Articles on json

Faster Operations with the JSONB Data Type in PostgreSQL

Faster Operations with the JSONB Data Type in PostgreSQL

Lucero Del Alba takes a look at how to get better performance out of jsonb data types in PostgreSQL in this Compose's Write S…

Guest Author
How to move data with Transporter - from disk to database

How to move data with Transporter - from disk to database

Compose's open-sourced Transporter is a powerful tool. In this article, we'll show you how to use it to upload data to a Mong…

Dj Walker-Morgan
Dj Walker-Morgan
MySQL for JSON: Generated Columns and Indexing

MySQL for JSON: Generated Columns and Indexing

MySQL doesn't have a way to index JSON documents directly, but it has given us an alternative: generated columns. One thing t…

Abdullah Alger
Abdullah Alger
MySQL for your JSON

MySQL for your JSON

Since the arrival of Compose for MySQL beta, we've been asking customers about how they use the database and what they'd like…

Abdullah Alger
Abdullah Alger
Could PostgreSQL 9.5 be your next JSON database?

Could PostgreSQL 9.5 be your next JSON database?

TL;DR: No, but that's not the right question. Just over a year ago we asked Is PostgreSQL Your Next JSON Database... Now, wit…

Dj Walker-Morgan
Dj Walker-Morgan
Transporter Driving 3: Restoring and Extracting

Transporter Driving 3: Restoring and Extracting

We've previously shown some examples of how to use the Compose Transporter for moving data around between databases, and how…

Dj Walker-Morgan
Dj Walker-Morgan
Is PostgreSQL Your Next JSON Database?

Is PostgreSQL Your Next JSON Database?

TL;DR: Betteridge's law applies unless your JSON is fairly unchanging and needs to be queried a lot. With the most recent ver…

Dj Walker-Morgan
Dj Walker-Morgan