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!
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:
Following up on https://announcekit.app/drawsql/changelog/export-to-adonisjs-migrations-3N7DRm
The export script has now been updated to support the latest Adonis v5 that's in preview.
Two new Adonis related database schemas have also been added to the template gallery
Small improvement to the Adonis Export script to auto collapse timestamp columns into the more succinct variant, so
Next export type launched! Users of the AdonisJS framework can now transition from database designs to creating those tables and columns more seamlessly.
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.jsYou'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!
A small handy improvement to the exporter, all export types now include the column comments in their generated output. Here's an example:
Diagram
Generated SQL
Closing following the previous update, another column option is available for these MySQL integer types:
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.
For MySQL diagrams, you can now specify columns as Auto-Increment. This column option will appear for these MySQL integer types:
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.
A small usability improvement to column comments, so you can now go crazy on leaving notes to describe your columns.
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.
