📂Folders to organize diagrams

We now have folders!

Building on the recent revamp of the dashboard, we've added folders as a way to logically group related diagrams.  This was actually the first-ever suggestion received when our suggestion board was launch exactly a year ago! Pretty stoked to have this shipped, should be useful with the growing number of diagrams for each team.

Of course, you can easily move a diagram between folders too. If you've started using folders, let me know what you think!

🖥️ Brand new dashboards

Fresh release for the brand new year

This first release is a design refresh of the dashboard (the first screen you see upon login). As the number of diagrams you have documented within DrawSQL grows, this redesign should allow better visibility when browsing them. 

More importantly, this is the first step towards unlocking future features that helps with organizing your diagrams, e.g. Folders

Happy New Year 2021!

New design:

Previous design:

🔺⃤ Export to AdonisJs migrations

Next export type launched! Users of the AdonisJS framework can now transition from database designs to creating those tables and columns more seamlessly.

AdonisJs is a Node.js web framework that's heavily inspired by Laravel, and supports many of the concepts featured in Laravel, including migrations for database schemas.

Similar to the Laravel export, each table in the diagram is exported into its own migration class. Of course, file names are also set to match the convention in AdonisJS:

{timestamp}_{table_name}_schema.js

You'll find this in the export modal:

For now, the export is in AdonisJS v4 format. Support for the v5 migration format that's in preview is already in the works, and should be launched next!

🛑Unsigned column option for MySQL

Closing following the previous update, another column option is available for these MySQL integer types: 

  • BIGINT
  • INT
  • MEDIUMINT
  • SMALLINT
  • TINYINT

This can be used to specify that a column will only take non-negative numbers, thus increasing the upper numeric range. This is not part of the SQL standard, hence is only available for MySQL.

🔺Auto-increment option for MySQL columns

For MySQL diagrams, you can now specify columns as Auto-Increment. This column option will appear for these MySQL integer types: 

  • BIGINT
  • INT
  • MEDIUMINT
  • SMALLINT
  • TINYINT

AUTO_INCREMENT support for FLOAT or DOUBLE columns has intentionally been left out, since these can cause weird behaviours, and they've been deprecated in the latest MySQL versions.



BINARY datatype for MySQL

The missing BINARY datatype has been added for MySQL diagrams now. 

👩‍💻 Bit of tech background: The default set of datatypes was dependant on what's supported in Laravel migration's blueprint schema. By default, Laravel converts the -'binary()' definition to BLOB in it's MySQL driver, hence the missing BINARY datatype. We've now added custom logic to support additional data types (outside of Laravel defaults), and this is one of the first ones added.


Show Previous EntriesShow Previous Entries