News for hackers. Stuff that matters.

A comment on ToroDB – Document-oriented JSON database on top of PostgreSQL. Parent comment

Re:ToroDB – Document-oriented JSON database on top of Postgr... by ch on Thursday October 30, 2014 @08:25AM (#8532497)
This is a pretty interesting approach, and it doesn't seem to be tied to any particular database implementation.

Would it be possible to factor this up into a JSON -> SQL translation function, which could than be used by various backends (effectively consume the JSON and spit out the CREATE TABLE and INSERT statements)?

[ Parent | on HN ]
Re:ToroDB – Document-oriented JSON database on top of Postgr... by ahachete on Thursday October 30, 2014 @09:19AM (#8532712)
Indeed.

It's more than a JSON to SQL translation, but it could definitely use various backends. It has some plpgsql Postgres code and some data types to speed operations (saving some round trips to the database), but it won't be hard to port it to other backends :)

[ Parent | on HN ]