Articles on json
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…
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…
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…
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…
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…
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…
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…