On 04/23/2014 07:43 AM, Alexander Korotkov wrote:
> I can propose contrib PostgreNoSQL providing following:
> 1) Table postgres as you proposed.
> 2) Functions: get_postgres(id intgeger) returns jsonb, set_postgres(id
> integer, data jsonb) returns void, search_postgres(query jsonb) returns
> setof postgres. search_postgres will have semantics of @> jsonb operator
> 3) Background workers which provides HTTP wrapper over those functions.
You're forgetting ... sharding/replication over multiple masters.
Also, the id should be a text value so that folks can use hash keys, or
whatever.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com