4 ms·
When the benchmark shows postgres can do the same as mongo, only faster, then why aren't we seeing more hybrid solutions? Online retailers would be better off u
by thomasfl 14y ago
When the benchmark shows postgres can do the same as mongo, only faster, then why aren't we seeing more hybrid solutions? Online retailers would be better off using relational storage for monetary transactions and time series, and json storage for document like data.
- malkia 14y agoMaybe sharding?
- ProblemFactory 14y agoThe great thing about PostgreSQL is that it is hybrid. With http://www.postgresql.org/docs/9.1/static/hstore.html http://www.postgresql.org/docs/9.1/static/hstore.html you can put schemaless documents into the same database, even into the same table row as your usual relational data. You could start with a schema that's only a primary key and hstore for all other data (like a fully schemaless database), but over time extract important fields from the hstore into columns to add indexes, constraints or joins.
- rurounijones 14y agoThat is... I am not sure, either madness or genius. But an intriguing idea either way.