4 ms·
Mongo is much more than a key-value store. Document sub-components and subarrays can be indexed and aggregated against. I don't see how you can do that with hst
by astral303 13y ago
Mongo is much more than a key-value store. Document sub-components and subarrays can be indexed and aggregated against. I don't see how you can do that with hstore.
Yes, I can totally see how Postgres and hstore can run circles around key-value storage.
And by "all that", I would love to know how to use the open-source versions of Postgres or MySQL to have transparently-sharded tables with joins AND have that be in a replicated environment where I can do real-time failover.
- fusiongyro 13y agoI think the partitioning and replication stories with Postgres will have to get a lot less manual before there can be automatic sharding. It doesn't sound beyond the pale to me, but I wouldn't expect it in the next five years.