Re:Ask HN: Open Source apps with lots of database tables?
by SwellJoe on Friday November 13, 2009 @06:22PM
(#941072)
My current Drupal install for Virtualmin.com has 184 tables. I don't think of it as a particularly big Drupal installation, but I don't have a lot to go on. It has forums, shopping cart (Ubercart), issue tracker and project modules, and a bunch of the usual suspects for analytics, search, etc. Two of the tables are for our custom modules for our license manager and shop integration, and a few more are legacy Joomla->Drupal migration data tables (which I planned to use to make old URLs work, but the URL stuff in Joomla was so insane that I gave up on it, and just leave them around for manual lookups just in case). We migrated from Drupal 5 to Drupal 6 before launching the site, and I'm pretty sure we had about 160 tables when it was Drupal 5, with roughly the same functionality as the Drupal 6 version, but none of the migration tables.
I guess maybe the Ubercart stuff is responsible for a lot of the disparity...I see a lot of "uc_" tables in my Drupal database.
This seems to be a list of the tables in a default Drupal 5 installation: http://webdevgeeks.com/schemaspy/index.html. It looks like Drupal 5 has around 40 tables out of the box.
Here's an ERD for CivCRM, which I believe is built on top of Drupal, so this would be additive to the base Drupal install and whatever modules CivCRM depends upon: http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+ER...
Here's an ERD for Joomla: http://www.oozman.com/oozing/ideas/archives/erd-joomla/ (v 1.0 and 1.5)