Recently I found on my search for standard database patterns this great website. I write this small article about this, for I forgot to bookmark it and after clearing my browser cache I lost it. It took me quite a while to find it back, for I even forgot its name. But with some fortune I found it back and decided to share it in this article and never loose it again.
What is dbpatterns.com
Dbpatterns is a service that allows you to create, share, explore database models on the web. It is also available on Github. It is open source and it can use some donations (so donate a few bucks if you like it), for it is free to use for everyone. But for those that are only interested in making database patterns, the software is great to use. Maybe the power of it all is in the lack of complex features. Recently a feature was added that you can authorize other users on dbpatterns.com to edit your patterns. This makes some form of collaboration on the concepts possible.
Creating and sharing database patterns
The idea behind this web service is pretty simple. You can draw database patterns with a very nice interface, export them and, if you like, share it with other users of this website.
It is not a database modeling tool, for the options are pretty straight forward. You can also fork patterns of other users and you can like (star) them. It is also possible to follow other dbpatterns.com users. Then you would never miss their new creativities. Last but not least you add comments to other peoples patterns. This makes it easy to ask questions of give suggestion for improvement.
You can create a schema (table) and it properties and by defining the foreign keys, create a link with other schemes in the model (pattern).
What is missing?
Given the slick functionality of this web service we should not want to demand functionality that belongs in rich data modeling software. But lets stay close to the setup and purpose of this web service. What I miss definitely is a function where you can add notes to model and schemes. A simple text area would already be fine, but it would give the designer some hands to explain the model and the schemes. There is maybe more that one can wish for, but I like it already very much as it is.
When you’re done, you can export the model to different formats. Supported are MySQL, PostGreSQL, Oracle and SQLite. It is pretty straight forward, but the idea behind it I like very much. So check it out, and bookmark it, before you loose it.