Collection of real world database schemas from open-source packages

drawsql.app

79 points·vincent_s··10 comments

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).

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?

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...

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

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

Yes, thanks a lot!

Thank you - this is amazing!

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

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

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.

Reply on news.ycombinator.com