Re: XML support under mySQL

2001-03-07 Thread Florian G. Pflug
On Tue, Feb 27, 2001 at 01:21:52AM +, Peter Skipworth wrote: How is this superior to SQL? It includes the letters "XML", which, apparantly, can do everything from butter your toast to giving you an orgasm like no other you've had before. Don't you just *love* buzzwords! Sorry...I

Re: XML support under mySQL (Long rant)

2001-02-28 Thread Carsten Gehling
From: "Florian G. Pflug" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 1:31 AM I think XML support should not be just "sending the respone of an SQL-Queries written in a weird way as an XML Document as another weird XML Document to the client". It should make the DB-Server into a hugh

Re: XML support under mySQL

2001-02-27 Thread Patrick Goetz
On Mon, 26 Feb 2001, Colin Faber wrote: Don't forget, Microsoft and Oracle are behind it so it _MUST_ be the greatest thing to come along since sliced bread. You folks need to keep in mind that with the microsoft system the XML layer IS NOT part of the database it self but an additional

Re: XML support under mySQL

2001-02-27 Thread John Jensen
Re: Because it _might_ be the great, stable and matura language for storing and querying data of tomorrow.. I think not. XML is a standard being pushed by a few big corporations, but lacks serious grassroots development, or even adequate support from recent browser versions. PHP, on the

RE: XML support under mySQL

2001-02-27 Thread Cal Evans
. Pflug [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 7:10 PM To: Cal Evans Cc: Florian G. Pflug; Juergen Fey; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: How is this superior to SQL? Why replace a great, stable

RE: XML support under mySQL

2001-02-27 Thread Cal Evans
: Ed Carp; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Cal, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data

Re: XML support under mySQL

2001-02-26 Thread Florian G. Pflug
On Sun, Feb 25, 2001 at 10:37:10AM -0600, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data

Re: XML support under mySQL

2001-02-26 Thread Florian G. Pflug
On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Player FirstNameJoe/FirstName LastNameMontana/LastName Average Team="49ers"not bad at all/Average /Player If you got to

RE: XML support under mySQL

2001-02-26 Thread Cal Evans
PROTECTED]] Sent: Monday, February 26, 2001 6:31 PM To: Juergen Fey Cc: [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Player

Re: XML support under mySQL

2001-02-26 Thread Florian G. Pflug
On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: How is this superior to SQL? Why replace a great, stable and mature language for querying databases with a verbose one? Because it _might_ be the great, stable and matura language for storing and querying data of tomorrow.. By

RE: XML support under mySQL

2001-02-26 Thread Peter Skipworth
nt: Monday, February 26, 2001 6:31 PM To: Juergen Fey Cc: [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Player Fi

Re: XML support under mySQL

2001-02-26 Thread Colin Faber
ubject: Re: XML support under mySQL On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Player FirstNameJoe/FirstName LastNameMontana/LastName Average T

Re: XML support under mySQL

2001-02-25 Thread Jan Dvorak
Ed Carp wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you

RE: XML support under mySQL

2001-02-25 Thread Cal Evans
PROTECTED]]On Behalf Of Jan Dvorak Sent: Sunday, February 25, 2001 10:13 AM To: Ed Carp Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Ed Carp wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform

RE: XML support under mySQL

2001-02-25 Thread MichaelMonner
At 10:37 AM -0600 2/25/01, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data that will have to be

Re: XML support under mySQL

2001-02-25 Thread Jan Dvorak
Michael, Is anybody on this thread really rationally suggesting using XML instead of SQL? I hope not. It would no longer be an SQL database. Of course SQL is the language for committing data to the storage mechanism. What the data consists of is another matter. I'm suggesting there is a

Re: XML support under mySQL

2001-02-25 Thread Jan Dvorak
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Ed Carp wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out

Re: XML support under mySQL

2001-02-23 Thread John Jensen
I agree with Jeremy and Colin. Its one thing to add functionalities, in terms of modules and interfaces, but adding to the core program is limited in it practicality, because it will just slow down execution or load-time or both. This penalizes users who don't happen to need the capabilities

RE: XML support under mySQL

2001-02-22 Thread Opec Kemp \( Ozemail \)
*big snip* I agree with Cal, the XML module should really be sperated from the RDMB. XML is really great but, lets face it not everyone is going to use it so why force it down thier troat?. The really great thing about Open Source is that you do have a choice (unlike MS , Oracle). :) You have to

Re: RE: XML support under mySQL

2001-02-22 Thread Ed Carp
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just because you *can* doesn't mean you *should*. Suppose I want to translate the output to something else. Now

Re: XML support under mySQL

2001-02-22 Thread Michael Bacarella
XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't want Microsoft and Oracle to take over the world, do we? :) Their

RE: XML support under mySQL

2001-02-22 Thread Mehalick, Richard RE SSI-GRAX
] Subject: Re: XML support under mySQL Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata

RE: RE: XML support under mySQL

2001-02-22 Thread Aaron Weiker
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RE: XML support under mySQL Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And operating systems have been written in Java and Perl. So? Just becaus

RE: RE: XML support under mySQL

2001-02-22 Thread Cal Evans
Message- From: Aaron Weiker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 8:00 AM To: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: RE: XML support under mySQL For some reason I don't think this was understood of what I said earlier. THE "DAT

Re: XML support under mySQL

2001-02-22 Thread Jim Gillaspy @ bellsouth.net
Actually, in a relational database, you do store metadata in the database, along with the data it describes. - Original Message - From: "Ed Carp" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 7:18 AM Subject: Re: XML support u

Re: RE: RE: XML support under mySQL

2001-02-22 Thread Ed Carp
Cal Evans ([EMAIL PROTECTED]) writes: Top of the morning to ya Aaron, 1: Ed did not suggest that everyone has to have a CS degree. Not defending Ed because based on his posts this morning, someone pissed in his Cheerios but he simply stated that people should be a little more educated

Re: XML support under mySQL

2001-02-22 Thread Ed Carp
Jim Gillaspy @ bellsouth.net ([EMAIL PROTECTED]) writes: Actually, in a relational database, you do store metadata in the database, along with the data it describes. Huh? Can you be more explicit? Maybe I'm not understanding what you're saying here... -- Ed Carp, N7EKG [EMAIL

Re: XML support under mySQL

2001-02-22 Thread Gorjan Todorovski
'; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: RE: XML support under mySQL For some reason I don't think this was understood of what I said earlier. THE "DATABASE" ISN'T RESPONSIBLE FOR XML But, just because the database isn't responsible do

Re: XML support under mySQL

2001-02-22 Thread Colin Faber
lto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 7:42 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RE: XML support under mySQL Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Some relational databases return results in XML format. And

Re: XML support under mySQL

2001-02-22 Thread Jeremy D. Zawodny
On Fri, Feb 23, 2001 at 08:26:08AM +0100, Gorjan Todorovski wrote: To Ed: Why be so negative about adding new features to the DB server? Why not make things easier and make the DB more flexible by supporting more standards for TRANSPORTING data. I'm not Ed, but... The answer is simple: it

Re: XML support under mySQL

2001-02-21 Thread Gorjan Todorovski
By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is supported in Oracle 8i for eaxmple "Jeremy D. Zawodny" wrote:

XML support under mySQL

2001-02-21 Thread Gorjan Todorovski
Is there support for XML in mySQL? - 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] To

Re: XML support under mySQL

2001-02-21 Thread Jeremy D. Zawodny
On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to retreive data in XML format from some table. This is

Re: XML support under mySQL

2001-02-21 Thread Gerald L. Clark
D]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote: Some relational databases return results in XML format. The *database* does that, or an add-on query tool does that? It'd be trivial to implement an add-on

Re: XML support under mySQL

2001-02-21 Thread Doug Poland
On Wed, Feb 21, 2001 at 01:26:56PM -0500, Michael Bacarella wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride.

RE: XML support under mySQL

2001-02-21 Thread Mehalick, Richard RE SSI-GRAX
] - -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:48 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL

RE: XML support under mySQL

2001-02-21 Thread Eric Frazier
One thing I want. A Java way to save a data structure and recover it later. Easy in perl, not so easy in Java. But XML would be a great way to do it in Java. Eric At 10:42 AM 2/22/01 +1000, Opec Kemp \( Ozemail \) wrote: *big snip* I agree with Cal, the XML module should really be sperated

Re: RE: XML support under mySQL

2001-02-21 Thread Ed Carp
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes: Another reason, maybe even a better one, is that XML is less database specific. So too will be the data. So the result of a query is no longer tied to the database that produced it. Untrue. Data is data. The result of a query

Re: RE: XML support under mySQL

2001-02-21 Thread Ed Carp
Aaron Weiker ([EMAIL PROTECTED]) writes: application interface. XML is this magic layer in the middle that each party No it's not. XML is simply an emerging standard to describe metadata. No magic involved. about to get this Email). The solution would be to have this other middle tier

Re: XML support under mySQL

2001-02-21 Thread Ed Carp
Jeremy D. Zawodny ([EMAIL PROTECTED]) writes: On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote: By support for XML I mean that u can insert XML documents directly in the database, of course u need to have the table properlu craeted first. Also it should be possible to

Re: XML support under mySQL

2001-02-21 Thread Doug Poland
Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? This is a reasonable inquiry. MS-SQLSever 2k and Oracle are both implementing a lot of XML functionality in their RDBMS's. Oracle is ahead of SQLServer, I believe. Like it or not, these two RDBMS's are

Re: XML support under mySQL

2001-02-21 Thread Colin Faber
For someone like my self having a tool to export via XML is bloatware, Any XML handling should be delt with in the milddleware, where it will be utilized NOT the database it self. Michael Bacarella wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in

RE: XML support under mySQL

2001-02-21 Thread Mehalick, Richard RE SSI-GRAX
. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 1:20 PM To: Mehalick, Richard RE SSI-GRAX Cc: 'Ed Carp'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote: Some relational

Re: RE: XML support under mySQL

2001-02-21 Thread Ed Carp
Eric Frazier ([EMAIL PROTECTED]) writes: One thing I want. A Java way to save a data structure and recover it later. Easy in perl, not so easy in Java. But XML would be a great way to do it in Java. Why Java? That's like going to a gas station and saying "I want gas specifically

Re: XML support under mySQL

2001-02-21 Thread Doug Poland
On Wed, Feb 21, 2001 at 05:22:31PM -0500, Michael Bacarella wrote: XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't

Re: XML support under mySQL

2001-02-21 Thread Gorjan Todorovski
Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the database. For example the database server can offer HTTP services, so we don't need stuff like JDBC/ODBC and all that. It can be done through HTTP,