MySQL 5.7.8+ JSON type handling

[maligree]

How does node-mysql stand on the upcoming JSON data type? I'd be interested in helping out with an implementation if it's not in yet.

[dougwilson]

We should get it added to the type casting, but nothing has been done yet. Help is welcome!

[sidorares]

on a wire level there is nothing special - it's just a string with json data

[sidorares]

sidorares/node-mysql2@8c490d9

[matteocontrini]

Looking forward to this :)

[RWOverdijk]

👍

[crapthings]

+1

[lganet]

+1

[koeniglorenz]

+1

[sidorares]

Note everyone who +1d - it's already possible with typeCast option:

connection.query({
  sql: '...',
  typeCast: function (field, next) {
    if (field.type == 'JSON') {
      return (JSON.parse(field.string())); 
    }
    return next();
  }
});