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

Minor change: Update Postgres datatypes, add JSON and JSONB #306

Closed limsammy closed 1 year ago

limsammy commented 2 years ago

Issue is currently open in #240. Enormously small changes, two additions to the db/postgresql/datatypes.xml.

More information regarding these field types can be found in the Postgresql 13 Docs -> Data Types -> JSON Types, located here: https://www.postgresql.org/docs/13/datatype-json.html

Also, in the issue (#240), a user mentions missing json fields for MySQL, which they have add locally. I am not familiar with MySQL, nor am I aware if a PR has already been made for MySQL, but I can append any additions for missing field types in this PR as well.

On a side note, there is not enough appreciation in the world for this wonderful tool you've created @ondras, I have been using it for years and it is an essential part of my toolkit :)

ondras commented 1 year ago

Thanks a lot, @limsammy ! And sorry for ignoring your PR for such a long time.