The original URL was <a href="http://dbpatterns.com/" rel="nofollow">http://dbpatterns.com/</a>, which no longer points to the right content, so we replaced it with an archive.org copy.
Wow, very clean UI, great work.<p>On a related note, if anybody is looking for a mature source but with a substantially worse UI, I've been referencing the Library of Free Data Models [1] for years.<p>[1] <a href="http://www.databaseanswers.org/data_models/" rel="nofollow">http://www.databaseanswers.org/data_models/</a>
A great interface, but I see one huge omission - a place to discuss or comment the patterns. A pattern doesn't live in vacuum, it is good under certain circumstances and bad in others. So the pattern is only valuable to me if it comes with an explanation of what it's trying to achieve and why it looks the way it does. Link it up to Stackoverflow or at least throw in some basic commenting function and this would be a useful tool.
Nice idea but needs a comment system. For example, I know a pattern like this has problems:
<a href="http://dbpatterns.com/show/5072096089cbad6a389867c7/" rel="nofollow">http://dbpatterns.com/show/5072096089cbad6a389867c7/</a><p>Change the price of a product then calculate last months revenue.<p>I'd also like to see a brief about what the pattern is trying to solve and why it is the way it is. I've used patterns for sortable hierarchical categories before which is more complex than a parent/position relationship. That would take a bit of explaining with regards to querying, sorting, inserting, removing records.<p>But all in all, I like it. Nice clean UI and can see it growing.
If you are looking for good books on data modeling patterns, I recommend these:<p>David Hay's <i>Enterprise Model Patterns</i> (and his earlier ones). This is a beast of a book, but has some great patterns.
<a href="http://www.amazon.com/dp/1935504053/" rel="nofollow">http://www.amazon.com/dp/1935504053/</a><p>Len Silverston's <i>Data Model Resource Book</i> Vols. 1, 2, 3. Good case studies by industry in the last 2 books.
<a href="http://www.amazon.com/dp/0471380237/" rel="nofollow">http://www.amazon.com/dp/0471380237/</a><p>Michael Blaha's <i>Patterns of Data Modeling</i> . This one has some interesting temporal, graph, and tree models.
<a href="http://www.amazon.com/dp/1439819890/" rel="nofollow">http://www.amazon.com/dp/1439819890/</a><p>Martin Fowler's <i>Analysis Patterns</i>. This one skims some of the other patterns, but gives accounting a solid treatment.
<a href="http://www.amazon.com/dp/0201895420/" rel="nofollow">http://www.amazon.com/dp/0201895420/</a><p>They are all well-rated on Amazon and I have read them and they are all very good. A few are available on Safari too.
Great idea and nice design. If anything, I can find it useful as a starting point. But it would be good to put some requirements behind the designs. Meaning here is what was required designed to allow us expand this or that direction, etc.
Site went down while I was using it, however, this could be very interesting (coming from a database noob). Definitely will keep my eye on the site as long as it's up ;P<p>EDIT: Noticed you also use jsPlumb. How was your experience with that and did you ever consider other options? I had a few smaller projects that used jsPlumb, but it seemed pretty limiting once my diagrams needed a little more functionality.
I used <a href="http://dbdsgnr.appspot.com/" rel="nofollow">http://dbdsgnr.appspot.com/</a> for something like this. It has sql export and it supports a few database engines. If it would allow better forking it would be awesome.
It looks cool, but I don't see the utility just yet. Are there patterns that are very useful, but difficult to come up with just by following one of the normal forms?
Site is down at the moment. Maybe this is a demonstration of the "Crash and burn under load, even though it worked so well when nobody else was using it" database pattern? I run into that pattern way too often, i.e. more than zero times.