3 ms·
Interesting that he advocates MySQL. PostgreSQL can index and interact with the JSON stored in it's columns, which make it a better choice as a NoSQL replacemen
by JonahBraun 11y ago
Interesting that he advocates MySQL. PostgreSQL can index and interact with the JSON stored in it's columns, which make it a better choice as a NoSQL replacement.
http://www.postgresql.org/docs/9.4/static/datatype-json.html http://www.postgresql.org/docs/9.4/static/datatype-json.html
- javajosh 11y agoThe JSON datatype is only useful if you want to query on the blob, which is not the case in Wix's case.
- orf 11y agoYou can query on individual fields with the jsonb type
- staz 11y agoBut you tell to keep columns that need indexs outside of the JSON so you can query on them, which is not necessary with Postgres
- morgo 11y agoIt also provides validation and is often more space efficient :) the internal format also technically supports partial update, but that is not yet a supported feature. So I wouldn't suggest using text if you are not querying.
- bowersbros 11y agoI believe that MySQL 5.7 comes with JSON data types too. https://dev.mysql.com/doc/refman/5.7/en/json.html https://dev.mysql.com/doc/refman/5.7/en/json.html
- morgo 11y agoIndeed. To expand a little: it has a Json type, functions & virtual columns. So you can extract part of a Json document and index it. The optimizer can also match Json expressions to indexes