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
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.
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.
Small updates to the SQL exporter:
Before:
create table "participations" ( "user_id" bigint not null, "project_id" bigint not null, "start_date" datetime not null, "team_id" bigint not null, "department" varchar(255) not null, "employee_id" bigint not null ); alter table `participations` add primary key `participations_project_id_user_id_primary`(`project_id`, `user_id`); alter table `participations` add unique `participations_team_id_user_id_unique`(`team_id`, `user_id`); alter table `participations` add index `participations_department_employee_id_index`(`department`, `employee_id`)
Now:
CREATE TABLE `participations`(
`user_id` BIGINT NOT NULL,
`project_id` BIGINT NOT NULL,
`start_date` DATETIME NOT NULL,
`team_id` BIGINT NOT NULL,
`department` VARCHAR(255) NOT NULL,
`employee_id` BIGINT NOT NULL
);
ALTER TABLE
`participations` ADD PRIMARY KEY `participations_project_id_user_id_primary`(`project_id`, `user_id`);
ALTER TABLE
`participations` ADD UNIQUE `participations_team_id_user_id_unique`(`team_id`, `user_id`);
ALTER TABLE
`participations` ADD INDEX `participations_department_employee_id_index`(`department`, `employee_id`);You now have a new option for a more condensed view of your table comments.
Option 1: Collapsed
Some teams prefer to include extensive/longer-form notes for each of their tables. In this case, the collapsed option provides a more compact view in the diagram. The table comment will only show an icon by default which can be expanded on click.
Option 2: Always show
Always show the full table comment, useful if the included notes are usually brief and succinct. This is the default.
You can toggle this preference in file > diagram settings, as shown below:
Rearranged a few things in the sidebar to make it easier when creating tables & columns:
