Re: [GENERAL] Postgres as key/value store

2014-09-29 Thread Jonathan Vanasco
On Sep 27, 2014, at 7:48 PM, snacktime wrote: > The schema is that a key is a string, and the value is a string or binary. I > am actually storing protocol buffer messages, but the library gives me the > ability to serialize to native protobuf or to json. Json is useful at times > especially

Re: [GENERAL] Postgres as key/value store

2014-09-28 Thread Thomas Kellerer
snacktime wrote on 28.09.2014 01:48: I'm looking for some feedback on the design I'm using for a basic key/value storage using postgres. Are you aware of Postgres' "native" key/value store: hstore? http://www.postgresql.org/docs/current/static/hstore.html Or Postgres JSON support? Especially

Re: [GENERAL] Postgres as key/value store

2014-09-27 Thread Gavin Flower
On 28/09/14 12:48, snacktime wrote: I'm looking for some feedback on the design I'm using for a basic key/value storage using postgres. Just some quick background. This design is for large scale games that can get up to 10K writes per second or more. The storage will be behind a distributed