Hello SuSE folkz, Could somebody tell me please if it's possible to store and retrieve XML documents using MySQL DB? I need to write dept. document storage system and I'm looking for XML solution. Thanks Alex
On Thursday 04 September 2003 04:26, Alex Daniloff wrote:
Hello SuSE folkz, Could somebody tell me please if it's possible to store and retrieve XML documents using MySQL DB? I need to write dept. document storage system and I'm looking for XML solution.
No, MySQL is purely a relational database. It has no direct XML capabilities as far as I know. Open scripting languages like Perl have excellent interfaces to SQL and XML, so most things are possible, but there's nothing in the open source world like Oracle's XML capabilities that I know of. --
eatapple core dump
On 3 Sep 2003 at 13:26, Alex Daniloff wrote: Date sent: Wed, 03 Sep 2003 13:26:30 -0700 To: suse-linux-e@suse.com From: Alex Daniloff <alex@daniloff.com> Subject: [SLE] XML handling in MySQL?
Hello SuSE folkz, Could somebody tell me please if it's possible to store and retrieve XML documents using MySQL DB? I need to write dept. document storage system and I'm looking for XML solution.
Thanks
Alex
Hi Alex, As some one else said, MySQL won't do what you want. Have a look at http://www.sleepycat.com/products/xml.shtml which might be of some use to you :) Regards, alan -- http://www.ibgames.net/alan Registered Linux user #6822 http://counter.li.org Winding Down - Weekly Tech Newsletter - subscribe at http://www.ibgames.net/alan/winding/mailing.html
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 04 September 2003 03:09 am, alan@ibgames.com wrote:
Could somebody tell me please if it's possible to store and retrieve XML documents using MySQL DB? I need to write dept. document storage system and I'm looking for XML solution.
As some one else said, MySQL won't do what you want. Have a look at
http://www.sleepycat.com/products/xml.shtml
which might be of some use to you :)
Also worth checking out: 4Suite, which contains a server and many processing tools - http://4suite.org/index.xhtml Xindice, from the Apache guys, which looks neat but doesn't do as much as 4Suite - http://xml.apache.org/xindice/ - -- James Oakley Engineering - SolutionInc Ltd. joakley@solutioninc.com http://www.solutioninc.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/V0GU+FOexA3koIgRAtc1AKCBLQIL/21dAiACPIGhnNxhwj5yugCgm4PU Lzd5t04Jphbg+Cbz2VLiWlk= =ff8i -----END PGP SIGNATURE-----
participants (4)
-
alan＠ibgames.com -
Alex Daniloff -
Derek Fountain -
James Oakley