femami
LibreSSL with Bob Beck (BSDCan 2014)
Rust for C++ programmers – part 5: borrowed references
Compiling OpenSSH No Longer Requires Linking in OpenSSL
PostgreSQL 9.3 Beta 2 Now Available
Turkey Is Now Arresting Dozens for Using Twitter
IBM to Acquire SoftLayer
Re:Run SQL on JSON files without any data loads
on Friday May 31, 2013 @03:56PM (#5800998)
Is this useful? http://www.esuli.it/software/amazon-reviews-downloader-and-p...
Re:Run SQL on JSON files without any data loads
on Friday May 31, 2013 @03:52PM (#5800975)
json_fdw to Citus DB or any other PostgreSQL based distributed database, is like json serde to Hive.
So, I think you should probably compare the json_fdw to json serde, and Citus DB to Hive.
Re:Run SQL on JSON files without any data loads
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.
Re:Run SQL on JSON files without any data loads
on Friday May 31, 2013 @03:29PM (#5800830)
Loading into database usually means transforming the data such that the data is stored as database's internal format. For example, using "LOAD DATA ..." in MySQL or "COPY ... FROM ..." in PostgreSQL.
Here, you aren't storing the data in the database. You don't have to take any additional action to sync the file and db when you add rows to the file, so it's not loaded into the database.