search

ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

feature request: json and jsonb field types #240

Open ChangePlaces opened 7 years ago

ChangePlaces commented 7 years ago

Postgresql has native support for json in two data types, json and jsonb. The newer one is the latter and allows adding indexes to the json keys.

kristakis commented 2 years ago

mySQL also supports a JSON type. I found I could add it in db/mysql/datatypes.xml in the docker image and it worked a treat.

ondras commented 2 years ago

Great, feel free to send a Pull request then :+1:

limsammy commented 2 years ago

I have created a PR for this issue here: #306