hstore for _extra_props (instead of JSON)

stripe-archive / mosql

MongoDB → PostgreSQL streaming replication

MIT License

1.62k stars 224 forks source link

hstore for _extra_props (instead of JSON) #27

Open kindrowboat opened 11 years ago

kindrowboat commented 11 years ago

I'm interested in implementing the hstore datatype for _extra_props in MoSQL.

Does anyone know if this has been worked on before?

Are there any foreseeable gotchas or roadblocks? I know that hstore only allows simple key/value storage (no nested "documents"), I'm not sure yet how I'll deal with that.

nelhage commented 11 years ago

I'd love to see someone play with this! I am not aware of any work in this direction, although we've thrown around the idea (but never implemented anything) at Stripe. Dealing with nested hashes in some way is indeed the first obvious issue I see, but should be resolvable in some way.

kindrowboat commented 11 years ago

Just an update. While we were looking work on this here, we ultimately decided to hold off because Postgres expanded their JSON datatype support in 9.3.