I am a PHP/MySQL application developer, but I am relatively new to Drupal. Naturally I am inclined to looking under the hood (hee hee), and am wanting to know where does Drupal store data content--the kind of content such as paragraphs of copy on pages. I've noticed that in a few tables in the database, there exist data in the data type of BLOB (particularly in the "cache" tables). I am wondering whether these are the places where the paragraphs of content copy is stored. If not, then where does things like paragraphs of copy reside?

Thanks for the anticipated insights :)


cog.rusty’s picture

Content is stored in the node revisions table and in the comments table. Cache is transient.

jcWebDev’s picture

Oh, I see . . .

Thanks so much for the enlightenment!


rkarajgi’s picture

If you plan to look under the hood, then life will be easier if you use the api - that is getting neatly documented here http://api.drupal.org/

In particular, if you want to access the database and tables, using the simple database abstraction layer will save you the hassle of worrying about database connection, etc. It is available here : http://api.drupal.org/api/group/database/6 . You can directly use db_query and db_result in your custom php code.

I hope this makes it easier. Thanks

- Rajeev Karajgikar, Drupaler in South Bay Area

- R Karajgikar