Does joomla store article/ modules text and image path in database?

Question

I wanted to create an iPhone app for a website which is created using Joomla 2.5. What I was thinking is to create RSS and pass that link in the iPhone app. However, for creating RSS, I was worried about from where should I get the articles text and images that are there?

Hence, I wanted to know: does Joomla store the article/ modules text and images path in a database? If yes, which table does it use to store all info?

Answer 1

Of course it's stored in the database ;-) You should find all the data in the table #__content (replace #__ with your prefix). The fields title, introtext, fulltext and images is probably what you need. Note that the images field is an JSON encoded string.