Re: FN-FORUM: php, XML, content and searching

date posted 4th September 2007 11:39


> Hi Guys
>
> Looking for some advice regarding using XML as a data source for website/s.
>
> Currently all site data for a site builder CMS I have developed is held in
> mySQL but I would prefer if it was stored in xml documents in the file
> system and so I could do away with the database as primary content data
> source.
>
> My question is about searching the xml data, the sites have a search
> facility using php/mySQL but I know very little about how to search through
> an XML document or if there is a nice way of doing it via php.
>
> My concerns are that all the xml data would have to be loaded into memory to
> do the search is there an elegant way to do it? Or even a prebuilt xml
> search component specific to the task etc maybe something that indexes a
> defined set of xml data periodically or triggered from php and uses that
> index as the data source much like it would in a mySQL database search.
>
> The system would be used on 100's of websites at the same time so loading
> all website content into memory for each site is not an option I don't
> think.
>

Sorry to come in late on this. Given what you're after I recommend you
look at Berkeley DB.

http://www.oracle.com/technology/products/berkeley-db/index.html

There's now an XML version with a PHP binding.

The Berkeley DB family is open source and really nice to work with. I've
often thought it would be a good choice for the back end of many of the
projects I see discussed on this list, especially for people who are not
concerned with normalising their data.

Graham

> I'm just researching options ATM so if anyone has any other cool ideas about
> how to do this then I'm open to suggestions.
>
> Regards
> Sam Morgan
> WiredEyes Media / ServWise Advanced Hosting
>
> tel (Uk): +44 (0)20 7100 2178
> tel (Italy): +39 070 773 6543
> web : www.wiredeyes.com / www.servwise.com
> ----
> umop ap!sdn w,! aw dlaH
> ----
> ====================================
> Summer Sale 50% off all ServWise
> hosting, use coupon code : HALFPRICE
> ====================================
>
>
>
>