Collection of real world database schemas from open-source packages

by vincent_s • 5 years ago

79 10 5 years ago

dvh• 5 years ago

I remember installing WordPress 2 years ago. Default schema had 7 tables with 3 different naming conventions.

nkmnz3• 5 years ago

I once saw a huge website with hundreds of schemas, but I cannot find it anymore. It looked like straight from the 90s, but the examples seemed to recent. Does anyone know that place?

crunchbang123• 5 years ago

Maybe this[1] is what you're referring to?

I found it from this SO[2] answer.

[1] http://www.databaseanswers.org/data_models/ [2]: https://stackoverflow.com/questions/9993842/where-to-find-pr...

nkmnz3• 5 years ago

Yes, thank you!! Is stuff like that „timeless“ if one wanted to learn from it?

persona• 5 years ago

Perhaps this one: http://www.databaseanswers.org/data_models/

nkmnz3• 5 years ago

Yes, thanks a lot!

bartmika• 5 years ago

Thank you - this is amazing!

sunsetSamurai• 5 years ago

how accurate is this? It shows only 5 tables for Airbnb, seems like it should be much more.

Tanjreeve• 5 years ago

I could believe an application DB fora service architecture wouldn't be some hulking great data warehouse monstrosity capturing the entire business. Those tables could be TB large.

But some aren't real e.g the Twitter one is just someone's project attempting to model how Twitter works which in no way means it's correct.

ojosilva• 5 years ago

It's an useful resource. According to their features page, I think if you register you can export (download) the schema DDL.

It would be nice to get sample data too. It's quite hard to find good sample databases with data in them, and in tidily constrained schemas.

Supposedly you can get an Access Database (yuck) at http://www.databaseanswers.org/data_models/ by emailing the site owner (yuck2).

Collection of real world database schemas from open-source packages

Related Stories