CODEWITHSUNDEEP
sqlschema-design
nclu
nclu

Reputation: 1059

Are there any open source resources for SQL schema design patterns?

I can barely count the number of times I've created a "users" table, similar for "computers" and "customers". I've tried looking around, but haven't ever seen a resource for modeling these schema that we see over and over again. It seems like some of these objects should be some-kind-of-solved by now. Is there anything like this?

Upvotes: 2

Views: 246

Answers (2)

Neil McGuigan
Neil McGuigan

Reputation: 48256

You could look at the source code of some popular open-source CRM/ERPs, such as OpenERP, though some of them are not great.

These are the top books on data modelling patterns:

Analysis Patterns, Fowler
Data Model Resource Book, vol. 1,2,3, Silverston
Enterprise Model Patterns, Hay
Patterns of Data Modeling, Blaha

Upvotes: 1

RustProof Labs
RustProof Labs

Reputation: 1277

I have never seen anything like this either and I'm not sure it's necessary. Yes, there are a lot of similarities but every application is different. At one point I had built an internal library of some of my more "standard" tables (user is a good example) to use as a jumping point, but I have yet to create two identical tables for different systems.

Thus, I have yet to ever use the library I built because I can write the new table quicker and more error free than I can modify another existing example to work for the current project.

Upvotes: 1

Related Questions