MySQL without the MySQL: An introduction to the MySQL Document Store | Opensource.com https://opensource.com/article/18/6/mysql-document-store
This takes advantage of the json storage column feature available in MySQL 5.7+.
Did you know that MySQL 5.7 has a native JSON data type?
MySQL introduced a native JSON data type in MySQL 5.7. So like an integer, a char, or a real, there became a way to store an entire JSON document in a column in a table of a database—and this document in a column could be roughly a gigabyte in size! The server would make sure it was a valid JSON document and then save it in a binary format that’s optimized for searching. This new data type has probably been responsible for more upgrades of MySQL than any other feature.
The data type also comes with over 20 functions. These functions will extract key-value pairs from the document, update data, provide metadata about the data, output non-JSON columns in JSON format, and more. And it’s much easier on the psyche than REGEX.
Source: What you need to know about JSON in MySQL | Opensource.com
Well, I guess I really do need to update to MySQL 5.7 and keep track of what’s going on in version 8 development.
From the MySQL 5.7 docs on the JSON data type:
As of MySQL 5.7.8, MySQL supports a native
JSONdata type that enables efficient access to data in JSON (JavaScript Object Notation) documents. TheJSONdata type provides these advantages over storing JSON-format strings in a string column:
- Automatic validation of JSON documents stored in
JSONcolumns. Invalid documents produce an error.- Optimized storage format. JSON documents stored in
JSONcolumns are converted to an internal format that permits quick read access to document elements. When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The binary format is structured to enable the server to look up subobjects or nested values directly by key or array index without reading all values before or after them in the document.
I’ve got a number of project that would benefit from this right now.
Combining Posts From Multiple WordPress Sites Using The REST API
This article provides a detailed walkthrough on how to use the REST API to combine posts from multiple WordPress sites. It’s also a good example of how to use JavaScript promises and leverage the browser’s local storage API.
Source: Combining Posts From Multiple WordPress Sites Using The REST API
linkedin/rest.li: Rest.li is a REST+JSON framework for building robust, scalable service architectures using dynamic discovery and simple asynchronous APIs.
Rest.li is an open source REST framework for building robust, scalable RESTful architectures using type-safe bindings and asynchronous, non-blocking IO. Rest.li fills a niche for applying RESTful principals at scale with an end-to-end developer workflow for buildings REST APIs that promotes clean REST practices, uniform interface design and consistent data modeling.
https://github.com/linkedin/rest.li
From the folks at LinkedIn. I found it interesting that many tech based companies are open sourcing their architectures. These systems are like today’s assembly lines, everyone has one, each is a little different, and all produce.
PHP MySQL JSON Manager: Build and Execute SQL queries with results in JSON – PHP Classes
PHP MySQL JSON Manager: Build and Execute SQL queries with results in JSON – PHP Classes http://www.phpclasses.org/package/9512-PHP-Build-and-Execute-SQL-queries-with-results-in-JSON.html