Hacker News Reader

Comment by SwellJoe | Hacker News Reader

Drupal and Joomla both have about 150 tables, and most modules add a few tables, so a working installation with reasonable functionality usually hits about 200 tables.

View on HN

Wait, really? You guys must be using many more modules than I am. I just checked a couple of nearby development boxes with various Drupal projects on them. The smallest had 41 tables. The largest had 92 tables. Most had fewer than 50. (These are primarily Drupal 5 deployments, maybe Drupal 6/7 add a lot of tables?)

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)

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.

+1 on Drupal. It also implements sequences, etc.

Reply on news.ycombinator.com