Re: [PHP-DB] PHP with a XML database

2007-01-28 Thread Bastien Koert
I would tend to agree with this Bastien From: Edward Vermillion <[EMAIL PROTECTED]> To: Ritesh Nadhani <[EMAIL PROTECTED]> CC: PHP DB Subject: Re: [PHP-DB] PHP with a XML database Date: Fri, 26 Jan 2007 15:36:33 -0600 I would imagine that parsing the XML file you get once

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Christopher Jones
Oracle XML DB support (often called "XDB") is built into the Oracle database and therefore free once you have a DB. And the Oracle XE database is free. Best place to continue the discussion is on the forums http://www.oracle.com/technology/forums/xmldb.html and http://www.oracle.com/technolo

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Ritesh Nadhani
I just checked: http://www.oracle.com/technology/tech/xml/xmldb/index.html Is the solution free or we have to pay license cost? I dont see any information about that. Christopher Jones wrote: What computing power would that be? XE (and even other "editions" of Oracle DB) install fine on smal

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Daniel Krook
Hello Ritesh, "Ritesh Nadhani" <[EMAIL PROTECTED]> wrote on 01/26/2007 05:48:27 PM: > Writing our own parsing thing is out of question. The group has > finalised to use a proper DB rather then writing our own code. > > Moreover, we believe that the code written by a good DB engine would > be muc

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Ritesh Nadhani
Writing our own parsing thing is out of question. The group has finalised to use a proper DB rather then writing our own code. Moreover, we believe that the code written by a good DB engine would be much more efficient then writing our own module and we are no database experts :) So now its a qu

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Edward Vermillion
I would imagine that parsing the XML file you get once a month and storing the information in *some* kind of "real" database, whether it's oracle, mysql, postgresql or whatever would give you better performance than parsing the XML on each page request. Unless the XML is of a trivial size o

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Christopher Jones
What computing power would that be? XE (and even other "editions" of Oracle DB) install fine on small PCs with Linux or Windows. What performance you get will depend on your load. Best to benchmark it yourself, like you would benchmark the alternatives. On the use of PL/SQL, if you want to avoid

Re: [PHP-DB] PHP with a XML database

2007-01-26 Thread Ritesh Nadhani
Thank you. I dont think we have the computing power for this project to use Oracle 10g. Also, the system is too big and nobody out here has actual knowledge of Oracle but anyway I will keep it in mind. Ritesh [EMAIL PROTECTED] wrote: Ritesh, Don't know of a suitable XML database to use wit

RE: [PHP-DB] PHP with a XML database

2007-01-26 Thread N . A . Morgan
Ritesh, Don't know of a suitable XML database to use with PHP, but I could recommend using Oracle 10g. There are built in XML services that should help with your project. Furthermore, PHP has a well documented Oracle interface (OCI8) just for this. To handle the XML though, you would probably n