470,594 Members | 1,442 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

XML-Databases or Standard-SQL-Database with Add-ons? Asking for Recommendations!

Hi netters,

I am used in MYSQL + PHP. Sometimes POSTGRESQL + PYTHON/ZOPE was used.

Now I have to build a bibliography system that stores a lot of
XML-Files and I am not quite sure wether it is a good idea to stick to
the good old sql-databases and go ahead with the same old techniques I
am using all the time.

Well, let's see what's available:

POSTGRESQL has build in XML-Support since version 8. At least a few
commands like xpath_table, xpath_bool, xpath_string, xpath_number,
xpath_nodeset, xslt_process are supported. Besides of these one has all
the good old SQL commands for processing.

MYSQL has no XML support at all and one needs external tools for a lot
of data conversion...

Both are perfectly supported by pre-processors like PHP and other
languages from python to java. No Problem with ODBC-Drivers as well.

On the other hand there are native XML-DATABASES existing. Like
"XINDICE" and "eXist". They are native JAVA as well. And I never wanted
to go with java until today ;-)

If one uses these it is also necessary to install a servlet server like
"TOMCAT", "COCOON" and "JETTY".

Pretty much work at the beginning of a new project if you install all
that for the first time ;-)

And now the question: IS IT WORTH IT?

How much easier is it to work with a xml-database?
Will I miss SQL?
Can I process xml-data freely or is it just storing?
How do you solve such problems?

Any recommendations are greatly appreciated. I am feeling I am wasting
time in preliminaries.Perhaps I should have started with
mysql/postgresql and just ignore this xml-stuff ;-) What do you think?

Joachim Kleinhans
--------
http://www.arteam.org

Apr 22 '06 #1
0 1088

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Phil Powell | last post: by
8 posts views Thread by Robert J Egan | last post: by
2 posts views Thread by Simon Strandgaard | last post: by
6 posts views Thread by yzzzzz | last post: by
reply views Thread by Steve Whitlatch | last post: by
reply views Thread by melledge | last post: by
1 post views Thread by Srini | last post: by
3 posts views Thread by Leszek | last post: by
5 posts views Thread by laks | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.