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.

  • Not validating length and decimals for specific column types - whe 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.
  • Indexes (except Primary KEY) are not yet implemented.
  • Lack of some column attributes:
    • UNSIGNED
    • ZEROFILL
    • COLLATE
    • CHARACTER SET
  • 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 - it is free of charge!

It's free - Try it!