카우치베이스 서버

JSON Modeling for RDBMS Users (video)

매슈 그로브스

|

1 분 읽기

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.

이 기사 공유하기
게시 카테고리: ,
태그: , , , ,

작가

게시자: Matthew Groves

Matthew D. Groves is a guy who loves to code. It doesn’t matter if it’s C#, jQuery, or PHP: he’ll submit pull requests for anything. He has been coding professionally ever since he wrote a QuickBASIC point-of-sale app for his parent’s pizza shop back in the 90s. He worked as a Senior Product Marketing Manager for Couchbase. His free time is spent with his family, watching the Reds, and getting involved in the developer community. He is the author of AOP in .NET, Pro Microservices in .NET, a Pluralsight author, and a Microsoft MVP.

모든 게시물

댓글 남기기

데이터베이스의 확장성을 과거의 일로 남겨두세요

각 스택 추가마다 추가 비용이 발생하고 관리해야 할 항목도 더 많아집니다. 2분 안에 절약할 수 있는 금액을 추산해 보세요.

지금 계산하기