5 ms·
how does mysql's json type compare to postgres' jsonb? my biggest gripe with both of them is lack of partial update
by greenlet 10y ago
how does mysql's json type compare to postgres' jsonb? my biggest gripe with both of them is lack of partial update
- deleted 10y ago[deleted]
- Psyonic 10y agojsonb_set is available now in postgres 9.5: https://www.postgresql.org/docs/9.5/static/functions-json.html https://www.postgresql.org/docs/9.5/static/functions-json.ht...
- th3sly 10y agobut that's not partial update. this will update the entire document(blob).
- semiquaver 10y agoPostgres' MVCC architecture makes the idea of 'partial updates' kind of meaningless. An update to any postgres column is equivalent to a DELETE followed by an INSERT and will result in a new row on disk, leaving the old row to be vacuumed later.
- morgo 10y agoJust to clarify: s/architecture/implementation/ InnoDB is MVCC too, but does an update in place with relocation of the old row to UNDO space. There are pros and cons to both approaches.
- morgo 10y agoNo partial update yet, but we are working towards it - The json binary format spec allows for padding. Search in page for 'BLOB' for details: http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/ http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release...