News for hackers. Stuff that matters.
Re:Show HN: create, share, explore database patterns by dang on Wednesday October 02, 2019 @08:12PM (#21142212)
The original URL was http://dbpatterns.com/, which no longer points to the right content, so we replaced it with an archive.org copy.
Re:Show HN: create, share, explore database patterns by rlander on Monday October 15, 2012 @05:57PM (#4657348)
Wow, very clean UI, great work.

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.

[1] http://www.databaseanswers.org/data_models/

Re:Show HN: create, share, explore database patterns by Renaud on Tuesday October 16, 2012 @03:57AM (#4658826)
This is a great resource!
Re:Show HN: create, share, explore database patterns by ripperdoc on Monday October 15, 2012 @10:07PM (#4658149)
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.
Re:Show HN: create, share, explore database patterns by Renaud on Tuesday October 16, 2012 @03:56AM (#4658823)
this. The db pattern repository is a great idea but there must be a place to discuss or at least be able to list pro and cons, intended usage, and pitfalls.

Just providing a schema and a name for the pattern is a way to get started, but it doesn't tell me why this pattern is a good fit for what I'm trying to achieve.

Re:Show HN: create, share, explore database patterns by martin-adams on Tuesday October 16, 2012 @06:12AM (#4659067)
Nice idea but needs a comment system. For example, I know a pattern like this has problems: http://dbpatterns.com/show/5072096089cbad6a389867c7/

Change the price of a product then calculate last months revenue.

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.

But all in all, I like it. Nice clean UI and can see it growing.

Re:Show HN: create, share, explore database patterns by fatiherikli on Tuesday October 16, 2012 @07:21AM (#4659231)
Thanks for your feedback. I'm thinking about comment functionality for each entity on the pattern.
Re:Show HN: create, share, explore database patterns by 3amOpsGuy on Monday October 15, 2012 @05:47PM (#4657308)
Any plans for NoSQL patterns? I'd be happy to share some useful schemas for column stores like Cassandra.
Re:Show HN: create, share, explore database patterns by vosper on Tuesday October 16, 2012 @01:40AM (#4658579)
I'd love to see something like that.
Re:Show HN: create, share, explore database patterns by elchief on Monday October 15, 2012 @06:03PM (#4657374)
If you are looking for good books on data modeling patterns, I recommend these:

David Hay's Enterprise Model Patterns (and his earlier ones). This is a beast of a book, but has some great patterns. http://www.amazon.com/dp/1935504053/

Len Silverston's Data Model Resource Book Vols. 1, 2, 3. Good case studies by industry in the last 2 books. http://www.amazon.com/dp/0471380237/

Michael Blaha's Patterns of Data Modeling . This one has some interesting temporal, graph, and tree models. http://www.amazon.com/dp/1439819890/

Martin Fowler's Analysis Patterns. This one skims some of the other patterns, but gives accounting a solid treatment. http://www.amazon.com/dp/0201895420/

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.

Re:Show HN: create, share, explore database patterns by modarts on Monday October 15, 2012 @07:21PM (#4657627)
Looks good; it'd be great to have a SQL generation feature which will allow you to generate scripts from the design surface.
Re:Show HN: create, share, explore database patterns by baddox on Monday October 15, 2012 @07:33PM (#4657660)
It would be cool to have sample SQL queries for certain common inquiries and some more complex ones. How to find all articles tagged as "programming"? What about all articles that have both "programming" and "timesaving" tags? What's the average amount of time between a friend request being sent and accepted?
Re:Show HN: create, share, explore database patterns by salimmadjd on Monday October 15, 2012 @09:44PM (#4658068)
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.
Re:Show HN: create, share, explore database patterns by simonw on Tuesday October 16, 2012 @05:46AM (#4659016)
Suggestion: support sign in with GitHub. It's really easy to do (they have a very clean oauth implementation) and would fit your target audience well.
Re:Show HN: create, share, explore database patterns by fatiherikli on Tuesday October 16, 2012 @07:19AM (#4659225)
Thanks for suggestion. I will implement as soon as possible.
Re:Show HN: create, share, explore database patterns by ineedtosleep on Monday October 15, 2012 @05:11PM (#4657178)
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

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.

Re:Show HN: create, share, explore database patterns by fatiherikli on Monday October 15, 2012 @05:26PM (#4657240)
Yes, i'm sorry. It's HN effect.

jsPlumb is cool, but the API is terrible. I don't like. I will rewrite all the connections.

Re:Show HN: create, share, explore database patterns by dplesca on Tuesday October 16, 2012 @08:06AM (#4659365)
I used http://dbdsgnr.appspot.com/ 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.
Re:Show HN: create, share, explore database patterns by DLarsen on Monday October 15, 2012 @04:17PM (#4656962)
I like the idea. Would love to have authenticated with my GitHub account.
Re:Show HN: create, share, explore database patterns by krichman on Monday October 15, 2012 @11:21PM (#4658314)
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?
Re:Show HN: create, share, explore database patterns by ceol on Monday October 15, 2012 @11:47PM (#4658374)
I think it's useful for other people to make sure what they're doing alines with convention. For instance, I had no idea about the Library of Free Data Models linked further down the page, so most of the model logic I'm unsure of has been confirmed via Stackoverflow posts. Sometimes, it can be hard to find the exact situation I'm looking for.
Re:Show HN: create, share, explore database patterns by fusiongyro on Monday October 15, 2012 @05:16PM (#4657199)
Very impressive. Of course, some sort of SQL export would be very helpful (I couldn't find one before it went down, if there is one).
Re:Show HN: create, share, explore database patterns by quadrant6 on Monday October 15, 2012 @10:58PM (#4658264)
I should be able to start creating a pattern without having to register. Ask me for that if I want to save.
Re:Show HN: create, share, explore database patterns by ecesena on Monday October 15, 2012 @05:59PM (#4657360)
Nice work! I've noticed in Friendship model that some ids are strings...
Re:Show HN: create, share, explore database patterns by pjscott on Monday October 15, 2012 @07:06PM (#4657580)
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.
Re:Show HN: create, share, explore database patterns by jfaucett on Monday October 15, 2012 @05:21PM (#4657223)
can't even get to the site, but the idea sounds good, will definately check back in a day or two, once the load on the servers goes back to normal.
Re:Show HN: create, share, explore database patterns by fatiherikli on Monday October 15, 2012 @05:28PM (#4657246)
Thanks, I did not anticipate this.
Re:Show HN: create, share, explore database patterns by chris_wot on Tuesday October 16, 2012 @04:57AM (#4658926)
What is tastypie?
Re:Show HN: create, share, explore database patterns by chrishan on Tuesday October 16, 2012 @10:37AM (#4659997)
Re:Show HN: create, share, explore database patterns by jaequery on Monday October 15, 2012 @11:28PM (#4658329)
this is definitely cool