Updated: 28 August 2023
We know this is a long-awaited and common feature for projects, so Iโm glad to finally share that dbdocs now supports inviting others to your projects.
Previously, to privately share a project with others, youโd need to use password-protected functionality, which is inconvenient when someone leaves your team and poses a security risk of password leakage.
With this release, there are different options to share projects with others:
This is one of our efforts to make dbdocs more secure and adaptable in teams and organizations.
Notes:
As always, we appreciate your comments and suggestions. Please give this feature a shot and let us know what you think.
Many users asked us about the dark-style ER diagrams from dbdiagram. And guess what? With this Dark Mode update, not only will it support dark-style ER diagrams, but we've also crafted a visually appealing color palette to help you reduce eye strain and improve reading. Whether you work with dbdocs for extended amounts of time or prefer to work at night, Dark Mode will improve your user experience.
Simply enable Dark Mode in the account drop-down menu to enjoy a more enjoyable and productive reading experience.
We value your feedback, so please share your thoughts on this latest addition to dbdocs. Thank you for using our products!
We're thrilled to announce an important update that will change your diagramming game. Confused between primary keys and foreign keys? Worried about those sneaky table/field notes and non-null fields? Worry not, weโve got your back with Iconic Empowerment and Enlightened Text Styling.
๐ Crystal-clear Visual Indicators: No more mixing up primary keys with foreign keys. Our feature introduces distinctive icons that catch your attention and clarify keys within your diagrams. Bid farewell to key confusion and enjoy precise understanding.
๐ก Note Visibility: Note-related anxiety is gone. With our enhanced feature, spotting tables and fields with attached notes is a breeze. Rest assured that no important details will slip through the cracks.
โจ Enlightened Text Styling: Improve the readability and comprehension of your diagram with text styling. Wave goodbye to the chaos of non-null fields and the risks of forgotten enum values.
No more guessing games or diagramming headaches. Itโs time to simplify and enhance your workflow.
We value your feedback, so please don't hesitate to share your thoughts and suggestions.
Weโve been listening closely to your feedback, and we understand how challenging it can be to work with diagrams containing hundreds of tables and thousands of columns. As a result, weโre pleased to present Diagram Detail Levels.
You can now toggle between displaying all columns, displaying only key (PK, FK) columns, or even hiding all columns, providing a global switching option for the entire diagram. Adjust the detail level to your needs, from a high-level overview of the entire database to specifics on individual tables.
This feature is immediately available to everyone. However, similar to dbdiagram, it may be moved to a paid offering when we introduce paid plans in dbdocs in the future.
We value your feedback, so please don't hesitate to share your thoughts and suggestions.
Many users asked us to link dbdocs and dbdiagram (our other product that allows you to draw ER diagrams by writing code) to improve the editing experience with online editing and collaboration features.
And we couldn't agree more. That's why we worked so hard to bring you our new feature: the ability to publish your database documents via dbdiagram.
In addition to editing your database definition (DBML) on your local machine and publishing it via the dbdocs CLI, you can now use dbdiagram as an online editor to quickly edit your database documentation.
FAQs
What happens if I update a diagram after publishing it to dbdocs? Will the dbdocs document automatically update?
Changes to your diagram will not automatically update the dbdocs document.
What if I don't already have a dbdiagram account?
Youโll need to log in to the dbdiagram using your email address to get the project list from the dbdocs account associated with your email.
As always, we appreciate your comments and suggestions. Please give this feature a shot and let us know what you think.
We heard you! Table Header Color and Table Group are now available in dbdocs! These two are well-loved features in dbdiagram, and are most requested by our dbdocs community.
With this, you can add a custom color to your table headers and group tables together to better organize your data models.
Choose a custom header color for each of your tables! This allows you to differentiate between tables and create more visually appealing documentation.
To set the header color for a table, use the following syntax:
Table ecomm_core.products [headercolor: #087f23] {
...
}
Group tables together into categories! Keep your data models organized and maintain clean, clear documentation.
To group tables, use the following syntax:
TableGroup product_group {
ecomm_core.products
ecomm_core.product_tags
}
These features are immediately available for everyone. However, similar to dbdiagram, they might be moved to a paid offering when we introduce paid plans in dbdocs in the future.
Give them a try and let us know what you think!
After registration, your username is strictly set to your email or GitHub username. The constant username could be a problem for users who need specific usernames for organizational usage.
Therefore, weโre introducing a new CLI command to change your username (as well as your organization name). From the dbdocs CLI version 0.6.4
, you can run dbdocs rename
and freely switch to an available username.
Feel free to show some love or feedback in the feature announcement on our community.
Today, our team is bringing in a new feature: Diagram Export. Users now have the option to download their diagrams as PDF and PNG files.
Simply hover on the download button at the top-right corner of diagram views, then choose either PDF or PNG as your desired format.
Feel free to show some love or feedback in the feature announcement on our community.
dbdocs now supports Many-to-many Relationships!
When drawing the many-to-many relationship, you no longer need to create an associative (join) table. Instead, just define it directly, such as:
Table books {
id int [pk]
...
}
Table authors {
id int [pk]
...
}
Ref books_authors: books.id <> authors.id // many-to-many
For more DBML syntax updates, please check out our docs!
Today we provide you with another powerful tool for documenting your database - Multiple Schemas.
Previously you could only define the table names, and when loaded into dbdocs it falls into the default โpublicโ schema.
Now, you can define the tables with full schema names:
Table ecommerce.products {
...
}
Moreover, you can make cross-schemas relationships and use enums from different schemas.
Table orders {
id int [pk, ref: < ecommerce.order_items.order_id]
status core.order_status
...
}
Enum core.order_status {
...
}
For more DBML syntax updates, please check out our docs!
The recent outbreak in our country is severe, but that doesn't stop us from improving dbdocs. This time, we bring you the Markdown support for the notes of tables & fields.
Now you can restructure your notes by styling your texts, adding code blocks for database scripts, related links, and so much more.
Manage better & view all your database projects via new project list views.
Simply run the dbdocs ls
command on the dbdocs CLI version 0.6.1
Or open your organization page by selectย "My Projects"ย in the account dropdown menu
Your savior, a.k.a save diagram's table positions, is here!
It's very time-consuming before to always move tables around at the beginning of each session.
Now you can sign in & modify the diagram's table positions in your projects. Then every time you & your guests visit, the arrangement in diagrams will stay still.
Due to the dbml syntax gap between our dbdocs
& dbml/core
, users couldn't use the composite foreign keys.
Guess what? Now you will have the ability to document relationships with composite keys, like the example below:
Ref: merchant_periods.(merchant_id, country_code) > merchants.(id, country_code)
Good news! You can search for fields, notes in dbdocs now.
Due to the lack of search capability, many users have got lost in large, complex databases. If you have too many fields, you won't find the one you want.
Besides lookup by table names, support search by field names, notes are our improvements in this release. We also support the case-insensitive search for getting better results.
Since login via GitHub is the single option, many users have to use theirs personal GitHub account or even create a new one for documentation purposes.
With the dbdocs CLI version 0.5.0
, feel free to connect dbdocs with your work email & improve the workflow now!
For better features awareness & roadmap tracking, it's time to release our documentations!
Previously you couldnโt set up CI/CD with Gitlab, GitHub Actions, or CI server to automatically generate the docs, because our login process required a web browser and UI.
The dbdocs CLI version 0.4.0
now supports you to build documentation with your unique access token
!
Read more about CI Integration in our docs.