Run SQL on JSON files without any data loads

Re:Run SQL on JSON files without any data loads by caycep on Friday May 31, 2013 @01:41PM (#5800029)

actually, I might use this thread to ask a noob question - I've been trying to fiddle around with some data that is relatively schemaless (i.e. I have a list of medical research subjects, and each of them have varying numbers of prior medical conditions, medication allergies, and list of current and past medicines).

Naturally, I thought JSON was better than relational DB's for this, but I wasn't sure how best to store this data. The relation data that I do have is stashed in .csv files that I'm transitioning over to sqlite, so I was wondering if there was a sqlite-esque DB for JSON - I was assuming something like Couch or Redis. But am I missing something, and that JSON itself IS the database?

[ Parent | on HN ]

Re:Run SQL on JSON files without any data loads by femami on Friday May 31, 2013 @03:41PM (#5800901)

I think if your data is append-only, this should work good enough. You implement your data appending logic, and you use json_fdw for querying your data. But this requires starting PostgreSQL service, I'm not sure if this is acceptable in your application or not.

[ Parent | on HN ]