🍯Sidebar UX improvements

Rearranged a few things in the sidebar to make it easier when creating tables & columns: 

  • Overhauled the table name edit component
  • Removed the drag handler for reordering the tables and columns. Instead, you can now just reorder by dragging anywhere within.
  • Hid secondary actions are in a Dropdown - this newfound 'space' for additional action buttons also paves way for the next upcoming features 👁️‍🗨️
  • Added a new dropdown within the top bar, especially useful for performing the common actions like adding a column or index without having to scroll to the bottom

📝Table comments, and for columns as well

One that has been a popular request since the beginning of times, today we've launched table and column notes.

This lets you leave comments for your teammates (or self) for any table and columns. 

Hopefully you'll find this one helpful and as always keen to hear any feedback.

⏫Lots of little improvements to import script for PostgreSQL

Looked through the logs top issues faced by users when importing, and made lost of improvements to the import script. 

All DBMS

  • Handle Aliases like int2, int4, int8, numeric etc.
  • Parse CREATE INDEX and CREATE UNIQUE INDEX statements
  • More instructive error logs for when the import fails

PostgreSQL

  • Added missing enum data type
  • Parse character varying data type (previously only understood varchar)
  • Differentiate timestamp and time with/without TIME ZONE

📺 Presentation mode

Sometimes it's useful to view a read-only version of your database diagram in full-screen with maximum screen real-estate. Useful for example when presenting In team discussion and tech meetings. This new presentation mode lets you do just that!

Works on your embeds too! We've used it in our recently launched template gallery, see this template of Laravel Spark for an example.


🖼️ Database schema gallery

This had been in the works for 2-months now, it's finally launched! The gallery is a collection of 200+ database schemas of open-source packages, useful as references when architecting your app's next feature. If you haven't seen it, check it out here. You can still suggest more diagrams, I plan to continuously grow the library with more schema diagrams.

Thanks to all of you that supported the launch, it went surprisingly well 🤯:

  • Featured on ProductHunt homepage for the day - Link
  • #3 on Hacker News - Link

Also gathered tons of feedback from the new users on the day, excited to work on them especially the popular ones. Presentation (full-screen) mode, and table notes would probably be next, stay tuned!

📥Clone into existing diagrams

Previously you could clone any of your diagrams to start a new diagram. With this update, you now have a new option to append the cloned diagram into any of your existing diagrams, even into a diagram of another team (as long as you have the right permissions there).

Works for any template diagrams in our template gallery (that's coming soon) as well! 

🆕Smarter positioning new tables

Another usability improvement, new tables added will always be positioned within the viewport next to the sidebar. Much easier to view changes as you go about creating your table columns etc.

This works regardless of the current pan/zoom-level of the diagram. Tiny improvement, but I've cursed 🤬 at having to zoom around to find that one new table, more times than I'd like to admit.


🔛Collapsible sidebar

Small usability improvement, you can now hide the sidebar to see more of your schema, especially useful in view-only or presentation mode.

It's the small details 🙂

👐Nicer (card) preview when sharing

Diagrams in DrawSQL gets shared around quite a bit on social channels (e.g. Slack, Twitter and face. Up until now it looks unpolished because of the missing Open Graph meta tags:

Much better now:

It also shows a screenshot preview for public diagrams.

Show Previous EntriesShow Previous Entries