|Free Database Schemas From DrawSQL|
|Written by Nikos Vaggalis|
|Friday, 08 May 2020|
DrawSQL, a SaaS platform for visualizing databases schemas, has made over a hundred database diagram templates available for free. The high quality collection comprises schemas by real world applications and open source packages like Django, Laravel or Wordpress.
We all know that great application infrastructure stands on the shoulders of a great Entity Relationship Diagram (ERD). And we also know that designing a good ERD is a fragile and tough process, hence many developers look for inspiration. or even basing theirs upon predefined examples of solid examples found in real world applications and scenarios.
Like not rolling your own authentication flow. but instead using a well-tested framework that sets the standards, the same goes for designing the database part of it. There are tried-and -tested schemas out there already. Don't break into a sweat, just go get one, use it as a basis to build on and benefit from industrial strength experience.
Certainly there are battle-tested sample databases like Sakila for MySQL or Microsoft's NorthWind and AdventureWorks, but those are limited in scope and are static.
DrawSQL goes two steps beyond - releasing specialized schemas in a varying range of applications, and presenting them beautifully and interactively since you can doodle with them, clone them or modify them for your own purposes.
There are a wide range of schemas on offer:
The diagrams range from those focused on a single part of the database such as the schema for Django's Push Notifications, to fully blown schemas that encompass the whole spectrum of the application such as BookStack's or this one for Airbnb.
While DrawSQL allows browsing the schemas for free, in order to clone them you must register for an account. Its free Hobbyist tier allows public diagrams, 15 tables per diagram and 1 user.
In conclusion, DrawSQL's Database schema templates
DrawSQL Database schema templates
Connecting To The Outside World with Perl and Database Events
The Enduring Influence Of Postgres
To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.
or email your comment to: firstname.lastname@example.org
|Last Updated ( Saturday, 09 May 2020 )|