JSON modeling was covered in a previous blog post which was, in turn, based on a CSV import blog post that came before that. While writing the post on JSON modeling, it occurred to me that it might be useful to see all the data in motion: from relational, to CSV, to a staging bucket, and finally assembled with the new model.

JSON modeling video

[youtube https://www.youtube.com/watch?v=vVOumslyH4c&w=560&h=315]

A tool that I neglected to mention in any of these earlier posts is csvkit and specifically csvsql. This tool can pull CSV data from SQL Server, MySQL, Oracle, PostgreSQL, SQLite, Sybase, and Firebird directly into CSV.

Thanks for watching!

As always, find me on Twitter @mgroves, leave a comment, or post your questions into the Couchbase forums.

Posted by Matthew Groves, Developer Advocate

Matthew is a Developer Advocate for Couchbase, and lives in the Central Ohio area. He has experience as a web developer as a consultant, in-house developer, and product developer. He has been a regular speaker at conferences and user groups all over the United States, and he has written AOP in .NET for Manning Books. He has experience in C# and .NET, but also with other web-related tools and technologies like JavaScript and PHP. You can find him on Twitter at @mgroves.

Leave a reply