Support JSON for Postgres about sqlx HOT 5 CLOSED

JSON for Postgres is in master. Thanks @oeb25! I'll spin out another issue for MySQL.

from sqlx.

Postgres has first class JSON support, but technically you can store JSON in text blobs in mysql as well - Indeed we actually do exactly that at my work.

from sqlx.

We could serialize JSON to text for MySQL but the query!() macro couldn't possibly know to read out a varchar field as JSON.

We could make it work with query_as!() but it'd be difficult to discover serendipitously; we'd need an example showing it.

from sqlx.

I'm not an expert in MySQL, but why this isn't suiting? https://dev.mysql.com/doc/refman/8.0/en/json.html

from sqlx.

It depends on the MySQL version. We're still using 5.6. because of some other tooling requirements, so it's not available there. If you're on a new enough version then that would make it a lot easier though :)

from sqlx.