Re: MySQL vs XML

2005-08-03 Thread SGreen
I get in any deeper, I'd like to ask about the differences between XML and MySQL. What are the pros and cons, and which would be better for an animal kingdom database? Or could I use both at the same time? I'm new to XML, too, but it looks like it might not be too complex. But it's hard

Re: MySQL vs XML

2005-08-03 Thread David Blomstrom
Wow, this is turning into quite a research project. Thanks for the tip about ontologies; it doesn't make much sense to me yet, but I'll take a closer look at the article. In the meantime, I'm thinking of using a content management system called Plone. Unfortunately, I've so far been unable to

Re: MySQL vs XML

2005-08-02 Thread Dr kamadjeu raoul
, and at least one reference seems to suggest that it's the superior choice. So, before I get in any deeper, I'd like to ask about the differences between XML and MySQL. What are the pros and cons, and which would be better for an animal kingdom database? Or could I use both at the same time? I'm new

Re: MySQL vs XML

2005-08-01 Thread David Blomstrom
Thanks for all the tips. That makes it much clearer. I think I'll stick with PHP and MySQL and gradually introduce a little XML if it fits in. I just downloaded a content management system called Plone, which is supposed to be a good choice for hierarchical databases.

Re: MySQL vs XML

2005-07-31 Thread Parag Agrawal
about the differences between XML and MySQL. What are the pros and cons, and which would be better for an animal kingdom database? Or could I use both at the same time? I'm new to XML, too, but it looks like it might not be too complex. But it's hard to envision how this all fits together

MySQL vs XML

2005-07-30 Thread David Blomstrom
be used in lieu of databases, and at least one reference seems to suggest that it's the superior choice. So, before I get in any deeper, I'd like to ask about the differences between XML and MySQL. What are the pros and cons, and which would be better for an animal kingdom database? Or could I use

Re: MySQL vs XML

2005-07-30 Thread Stephen Cook
deeper, I'd like to ask about the differences between XML and MySQL. What are the pros and cons, and which would be better for an animal kingdom database? Or could I use both at the same time? I'm new to XML, too, but it looks like it might not be too complex. But it's hard to envision how this all

RE: MYSQL to XML

2005-04-26 Thread Mikel -
- [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: RE: MYSQL to XML Date: Mon, 25 Apr 2005 17:41:47 +0200 MIME-Version: 1.0 X-Originating-IP: 213.41.126.253 Received: from lists.mysql.com ([213.136.52.31]) by mc5-f35.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 25 Apr 2005 08:44:24 -0700

RE: MYSQL to XML

2005-04-25 Thread Mikel -
and help Greetings From: mathias fatene [EMAIL PROTECTED] To: mysql@lists.mysql.com CC: mysql@lists.mysql.com Subject: RE: MYSQL to XML Date: Sun, 24 Apr 2005 21:39:14 +0200 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.52.31]) by mc3-f23.hotmail.com with Microsoft SMTPSVC(6.0.3790.211

RE: MYSQL to XML

2005-04-25 Thread mfatene
fatene [EMAIL PROTECTED] To: mysql@lists.mysql.com CC: mysql@lists.mysql.com Subject: RE: MYSQL to XML Date: Sun, 24 Apr 2005 21:39:14 +0200 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.52.31]) by mc3-f23.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Sun, 24 Apr 2005 12:42:26

RE: MYSQL to XML

2005-04-24 Thread mathias fatene
=Code2 required=true type=char(2)/ /table is this beautifull ? I will modify Describe2xml.pl to be more parametrized (user, db, pass, FK, ...) as soon as possible. Mathias Hi list, does it possible for MySQL to generate XML in the followin format: table name=ServiceType column name

MySQL to XML

2005-04-22 Thread Mikel -
Hi list, does it possible for MySQL to generate XML in the followin format: table name=ServiceType column name=idTipoServicio primaryKey=true required=true type=VARCHAR size=10/ column name=nombre required=true type=VARCHAR size=255/ column name=costo required=true type=FLOAT

Re: mysql and xml

2002-07-31 Thread Jeremy Zawodny
On Tue, Jul 30, 2002 at 10:34:36AM +0200, Inbal Ovadia wrote: Hi All Is MySQL works with XML? Yes. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 62 days, processed 1,313,326,706 queries (242/sec. avg

mysql and xml

2002-07-30 Thread Inbal Ovadia
Hi All Is MySQL works with XML? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Porting from MsSQL to MySQL (VERRY XML RELATED)

2002-02-18 Thread Marcelo Iturbe
Hello, Currently I have an aplication which stores the information in an MsSQL database in a straight forward manner, insert into blah blah However, I retrieve the information in XML format using the FOR XML EXPLICIT statements that come with MsSQL 2000. The select stament looks something like

Re: Porting from MsSQL to MySQL (VERRY XML RELATED)

2002-02-18 Thread Dan Nelson
with MsSQL 2000. You'll have to generate the XML in your application. Here are a couple links (picked from a google search on mysql xml select) to get you started: http://www.xml.com/pub/a/2000/12/13/perlxmldb.html http://www.nusphere.com/products/library/mysql_with_xml.pdf http://home.online.no

Re: Porting from MsSQL to MySQL (VERRY XML RELATED)

2002-02-18 Thread Tod Harter
format using the FOR XML EXPLICIT statements that come with MsSQL 2000. You'll have to generate the XML in your application. Here are a couple links (picked from a google search on mysql xml select) to get you started: http://www.xml.com/pub/a/2000/12/13/perlxmldb.html http

Re: MySQL and XML?

2001-03-22 Thread bill
I know Oracle has been modified to use XML files as the database, making queries directly to a flat file No, thats not how it works. They format the *output* with XML making it easier for an application that can parse XML to import the data.

Re: MySQL and XML?

2001-03-21 Thread Eric Fitzgerald
usage. - Original Message - From: "Bryan Coon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 2:23 PM Subject: MySQL and XML? Can anyone offer some insight into the following topic? I would like to provide web access to search a large database of i

RE: MySQL and XML?

2001-03-21 Thread Bryan Coon
more time :) Bryan -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 4:43 PM To: Bryan Coon; [EMAIL PROTECTED] Subject: Re: MySQL and XML? Well list, I think we have a new weekly dead horse to with which to use our sticks

Re: MySQL and XML?

2001-03-21 Thread Eric Fitzgerald
of my head. - Original Message - From: "Bryan Coon" [EMAIL PROTECTED] To: "'Eric Fitzgerald'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 4:48 PM Subject: RE: MySQL and XML? What are the advantages of flat files? I am having no speed issues at

Re: MySQL and XML?

2001-03-21 Thread Peter Skipworth
Bryan, You've given no indication of what "this structure" is - the fact that your data is rarely read or updated will have little bearing on whether an RDBMS is suitable for your needs. It would be a very rare case, however, where a simple flat text file gave you quicker access to a search of a

Re: MySQL and XML?

2001-03-21 Thread Rolf Hopkins
22, 2001 6:23 Subject: MySQL and XML? Can anyone offer some insight into the following topic? I would like to provide web access to search a large database of information. Currently, I am using MySQL to do this, and it works great. However, this database is almost entirely static, there are

Re: MySQL and XML?

2001-03-21 Thread Colin Faber
You need to read the mailing list archives, This has been discussed to death. Please try to follow the directions outlined when posting. See the 'http://lists.mysql.com/ (the list archive)' ? Bryan Coon wrote: Can anyone offer some insight into the following topic? I would

MySQL and XML?

2001-03-21 Thread Bryan Coon
Can anyone offer some insight into the following topic? I would like to provide web access to search a large database of information. Currently, I am using MySQL to do this, and it works great. However, this database is almost entirely static, there are virtually no inserts or updates done.

Re: MySQL and XML?

2001-03-21 Thread Rolf Hopkins
for it, but geez, it's very inefficient, wastes a lot of space and prone to errors. - Original Message - From: "Bryan Coon" [EMAIL PROTECTED] To: "'Eric Fitzgerald'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 8:48 Subject: RE: MyS