c: json 2 csv

While json excels in storing unstructured data, it is used for structured data as well, for example in the twitter stream API. The fastest way to get data from the twitter stream api into a mysql-type relational database like mariadab is to use LOAD DATA, but that appears to require a CSV file. Because of the hype around mysqls new capabilities to mix structured and unstructed (json-based) data, it is hard to find good sources in how to import structured data in json-format to mysql/mariadb.

comments powered by Disqus

Back to the index

Blog roll

R-bloggers, Debian Weekly
Valid XHTML 1.0 Strict [Valid RSS] Valid CSS! Emacs Muse Last modified: oktober 12, 2017