JSON

JSON Streaming And The Future Of Data Ingest

As businesses continue to become technology focused, data is more prevalent than ever. In response, companies have adopted a handful of common formats to help manage this explosive growth in data. Data Formats Today For a long time, XML has been the giant in terms of data interchange formats. Recently, JSON has become popular, catching a wave of interest due to its lightweight streaming support, and general ease of use. JSON is a common format for web applications, logging, and geographical...


JSON as Column Type

Customer Guest Post: Learning the MemSQL JSON Column Type

This post originally appeared on the Novus Tech Blog More and more, companies are migrating from NoSQL databases back to relational, ACID-compliant databases that also offer high availability and horizontal scalability – aka “NewSQL.” Novus Partners is no exception, having recently completed our migration from MongoDB to MemSQL. Of course, NoSQL developers often come to depend on rapid development cycle and “schema-less” data models, which can make the transition back to relational...


Through a Table, Sparsely

Take a look at your database. What do you see? An alphabetic list of table names. Is that really the most important thing to know? Surely, other facts about your database are more interesting. Maybe you want to know how big the tables are. Database table sizes, like mountain heights and city populations and book sales, tend to follow a pattern casually called a power-law distribution. A minority of tables hold the majority of data. The rest are a long tail of necessary but small things, a kind...


MemSQL 2.5 Ships Today with JSON Datatype, Online Alter Table, and More

We are excited to announce that MemSQL 2.5 is now available for download.  Of the many new features and performance improvements, one of the most exciting is support for JSON analytics. With native support for the JSON datatype, MemSQL delivers a consolidated view across structured and semi-structured data in real-time. Using MemSQL 2.5, developers can use SQL to easily analyze JSON objects while quickly ingesting JSON data feeds. In addition, MemSQL 2.5 ships with support for ONLINE ALTER...