Table of contents

Database Modelling

Database Modelling is one of the key abilities of any Software Architecture Platform. Modelling allows architects and developers to create database schema and validate it before first line of code is written. Pistacy.io offers simple yet complex Database Modelling module, that helps you create and validate your next Database Schema.

Key features:

  • Relations between columns (with column types validation)
  • Unique indexes using multiple columns
  • Import from: JSON, MySQL query
  • Export to: JSON, MySQL query

Supported Database Platforms

Pistacy.io supported following Database Platforms:

  • MySQL 9.0
  • MySQL 8.4
  • MySQL 8.0

Known Limitations

There are some known limitations (because of early age of the tool) that you need to keep in mind.

  • Import limitations
    • Not validating length and decimals for specific column types - when you select varchar or decimal column type you need to type length and/or decimals, but for now system does not validate the value itself. Please refer to MySQL documentation page of specific MySQL version for more details.
    • Foreign keys with multiple columns are not supported yet.
    • Indexes are not supported yet: INDEX, FULLTEXT, SPATIAL, BTREE, HASH
    • Unsupported column types: SET, VECTOR
    • Unsupported column constraints: CHECK
    • Unsupported column options: ZEROFILL (as it is deprecated in MySQL), GENERATED ALWAYS AS, STORED, VIRTUAL
  • UI limitations
    • Rendering performance - JS library used to render tables suffers when there is a lot of data to render. Please keep that in mind during operating on large schemas.

Use Pistacy.io in your project today!

Try Pistacy.io platform - no credit card required!

Start for free!
We use cookies to ensure that we give you the best experience on our website. You can check what cookies we use in our Privacy Policy.