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

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

RE: XML support under mySQL

2001-02-27 Thread Cal Evans
2001 12:58 AM To: Cal Evans Cc: 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

RE: XML support under mySQL

2001-02-27 Thread Cal Evans
From: Florian G. 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

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 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 ap

Re: XML support under mySQL

2001-02-26 Thread Colin Faber
; -Original Message- > > From: Florian G. Pflug [mailto:[EMAIL 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 a

RE: XML support under mySQL

2001-02-26 Thread Peter Skipworth
> From: Florian G. Pflug [mailto:[EMAIL 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 sup

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 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 > &

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 > > > Joe > Montana > not bad at all > > > If you got to handle a lot of these, than its easy to write an external XML > I/O

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 d

Re: XML support under mySQL

2001-02-25 Thread Jan Dvorak
; From: [EMAIL PROTECTED] [mailto:[EMAIL 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 PR

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 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 t

RE: XML support under mySQL

2001-02-25 Thread Cal Evans
EMAIL 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.

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 yo

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 t

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: i

Re: XML support under mySQL

2001-02-22 Thread Colin Faber
t; > 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 reaso

Re: XML support under mySQL

2001-02-22 Thread Gorjan Todorovski
[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. &

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 PROT

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 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 under mySQL

2001-02-22 Thread Jason Hall
Aaron Weiker wrote: > 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 doesn't mean that the > application is responsible for generating XML. > > > to put this wrapper o

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.

RE: RE: XML support under mySQL

2001-02-22 Thread Aaron Weiker
[mailto:[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. An

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, *no

Re: XML support under mySQL

2001-02-22 Thread Ed Carp
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 understand the difference?

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? :) The

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 I

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: 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, the

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? > > >

RE: XML support under mySQL

2001-02-21 Thread Cal Evans
Salutations Doug, >>My point is that XML is coming and it's a good thing. MySQL >>is an important part of the Open Source community and I >>don't want to see it trivialized or handicapped in relation >>commercial RDBMS. In the meantime, I'm willing to recommend >>it to clients and wait patientl

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 formul

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: > >

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

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

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 possi

Re: XML support under mySQL

2001-02-21 Thread Michael Bacarella
> > 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. This is all fine and good, but why does MySQL itself have to do this?

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: 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 sh

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 sperat

Re: XML support under mySQL

2001-02-21 Thread Ed Carp
Doug Poland ([EMAIL PROTECTED]) writes: > > Why would it be easier to write said layer if it was inside the DBMS > > instead of outside? > > > Speed is the reason to have it in the RDBMS. It doesn't belong in MySQL. By that logic, monolithic kernels are a Good Thing. > My point is that XML is

Re: XML support under mySQL

2001-02-21 Thread Jeremy D. Zawodny
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 for mysql (xmlmysql, a command-line tool maybe) which wou

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 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

Re: XML support under mySQL

2001-02-21 Thread Gerald L. Clark
y, 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 r

RE: XML support under mySQL

2001-02-21 Thread Aaron Weiker
web search: http://www.allthesites.com -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:18 PM To: Gorjan Todorovski Cc: [EMAIL PROTECTED] Subject: Re: XML support under mySQL On Wed, Feb 21, 2001 at 11:18:49AM +0100, Go

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. Thi

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: >

Re: XML support under mySQL

2001-02-21 Thread Ed Carp
Gorjan Todorovski ([EMAIL PROTECTED]) writes: > Is there support for XML in mySQL? No la comprende, senor - XML is a markup language, MySQL is a database. What does ne have to do with the other? -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com

Re: XML support under mySQL

2001-02-21 Thread Jeremy D. Zawodny
On Wed, Feb 21, 2001 at 09:38:23AM +0100, Gorjan Todorovski wrote: > > Is there support for XML in mySQL? What does your question mean? XML is about representing data in a structured and easily interchanged fashion. MySQL is all about *storing* and *retrieving* data which is stored in a normali

Re: XML support under mySQL

2001-02-21 Thread Marek Chlup
If you use perl try DBIx::XML_RDB: http://www.xml.com/pub/a/2000/12/13/perlxmldb.html (I don't tested this modul.) You can try my soft Maccess :-) (with XML output): http://www.meopta.com/products/software/maccess/ bye Marek - Original Message - From: "Gorjan Todorovski" <[EMAIL PROT