On Fri, Dec 12, 2014 at 8:31 PM, Sayth Renshaw flebber.c...@gmail.com wrote:
And does that then lead you to use Fabric?
http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding
No, I've never used that. I just process the the data in python.
On Sat, 13 Dec 2014
- Original Message -
From: Sayth Renshaw flebber.c...@gmail.com
Subject: Xml data import
I have an xml data feed with xsd, it's complex in elements not size. Wray
are the best way to get data into mysql, do I have to hack with xquery?
That's going to depend on the complexity of
So it is definitely achievable, I see other db's converting xml2json etc to
get it in.
Sends odd that xml had done great document qualities but as a data format
it seems rather hard to work with.
Sayth
On Fri, 12 Dec 2014 9:55 PM Johan De Meersman vegiv...@tuxera.be wrote:
- Original
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com wrote:
So it is definitely achievable, I see other db's converting xml2json etc to
get it in.
I use this https://github.com/hay/xml2json
Sends odd that xml had done great document qualities but as a data format
it seems
And does that then lead you to use Fabric?
http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding
Sayth
On Sat, 13 Dec 2014 9:06 AM Larry Martell larry.mart...@gmail.com wrote:
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com
wrote:
So
approaches at the same time.
- Original Message -
From: Larry Martell larry.mart...@gmail.com
To: Steven Siebert smsi...@gmail.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Friday, 22 November, 2013 3:17:44 PM
Subject: Re: XML to RDB
Yes, I will need to query the data, and yes
: Larry Martell larry.mart...@gmail.com
To: Steven Siebert smsi...@gmail.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Friday, 22 November, 2013 3:17:44 PM
Subject: Re: XML to RDB
Yes, I will need to query the data, and yes, it's app specific to the
data.
The parent-node
-
From: Larry Martell larry.mart...@gmail.com
To: Steven Siebert smsi...@gmail.com
Cc: mysql mailing list mysql@lists.mysql.com
Sent: Friday, 22 November, 2013 3:17:44 PM
Subject: Re: XML to RDB
Yes, I will need to query the data, and yes, it's app specific to the
data.
The parent-node
PM
Subject: Re: XML to RDB
Yes, I will need to query the data, and yes, it's app specific to the
data.
The parent-node structure will meet my needs if I can figure out how to
preserver the unbound multi level nodes. There will be a higher level
table, which will have the file name
Hi Larry,
I'm trying to figure out what your wanting to do with the data once its in
mysql? At first it seemed you didn't want to put it in as a lob because
you might want to query on the data in different ways (kind of an
assumption on my part, but a common reason to do this). Then, you
On Fri, Nov 22, 2013 at 8:05 AM, Steven Siebert smsi...@gmail.com wrote:
Hi Larry,
I'm trying to figure out what your wanting to do with the data once its in
mysql? At first it seemed you didn't want to put it in as a lob because
you might want to query on the data in different ways (kind
Hi Adhiraj,
I am going to assume that the keys and values are not static. If they
are, then this is just a matter of parsing XML into key, value
combinations.
A simple, but often less than ideal way of solving a problem like this
is to use several tables:
# The entries table is the equivilant
PROTECTED]
Cc: MySQL
Subject: Re: --xml or --html output to file
Hi John -
using --xml or --html as an argument and redirecting to a file seems to
work
here. As in,
mysql -u me -psecret -D database --html -e select * from that_table
~/test_file.html
HTH,
Dan
On 5/8/07, John Kebbel [EMAIL
Dan and Paul,
I develop at home on Ubuntu Linux and deploy at work over FreeBSD Unix
(an iMac running OS 10.4). The command line tip you suggested worked
fine on Linux, so I'm assuming that I can get it to run here at work as
well when I get the time to try it. Thanks again.
John Another Brick
Hi John -
using --xml or --html as an argument and redirecting to a file seems to work
here. As in,
mysql -u me -psecret -D database --html -e select * from that_table
~/test_file.html
HTH,
Dan
On 5/8/07, John Kebbel [EMAIL PROTECTED] wrote:
When I try using the --xml or --html option
At 6:09 PM -0400 5/8/07, John Kebbel wrote:
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the
[snip]
I'm currently looking for a tool that will take XML and produce a
database
from it. Not really looking for anything in particular at this point,
just
sort of scoping around. Anyone know of such a tool?
[/snip]
MySQL kinda' has a built-in tool
Patrick Marquetecken wrote:
I seems not to figure out how to import a xml file into mysql 4.x
I'm working on, Linux, help would he fine.
XML is an hierarchical format, it does not map directly to a relational
database, which has a tabular format. I don't know if there are any
general purpose
Bernd Jagla wrote:
Hi everyone,
I have XML data with a corresponding DTD, and I want create the necessary tables and
load the data.
Does anyone has experience with this?
Are there any tools to help me?
Thanks for your advice.
I would use the XML module in Perl + DBD/DBI and write the loader if I
On Mon, Oct 13, 2003 at 11:45:33PM -0600, Prasad Budim Ram wrote:
Is it possible to direct xml support for queryiing a SQL statement and
get the result in also in xml?
Nope.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
--Sent: Friday, October 24, 2003 1:17 AM
--To: Prasad Budim Ram
--Cc: [EMAIL PROTECTED]
--Subject: Re: XML support for MySQL
I dont know about going in, but i wonder if there is an extension module to
do this for you. I currently have to use a class i built to extra the xml
from a query in php :\
Is it possible to direct xml support for queryiing a SQL statement and
get the result in also in xml?
Prasad
--
* [EMAIL PROTECTED]
geez mysql is an open source product you cannot expect so much too soon over
a very expensive commercial product which has been out for years , for xml i
usually generate it on the fly when i am extracting the data using the field
names as the xml tag nodes.
Converting a
- Original Message -
From: Jon Haugsand [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 23, 2003 2:57 AM
Subject: Re: XML in MySQL
* [EMAIL PROTECTED]
geez mysql is an open source product you cannot expect so much too soon
over
a very expensive commercial product which
Jeremy Zawodny wrote:
SOAP is one thing. But what about storing XML documents in the DB
(with validation on the way in) and querying them using XPath? Oracle
does that. MySQL does not.
And off-topic from the original question but to repeat myself from
before, using XML and MySQL together
On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote:
Hello,
What is the level of support for XML in MySQL. Is there any kit
similar to the Oracle XML Developper Kit or the XML features in SQL
Server 2000?
No. MySQL doesn't nativel deal with XML.
--
Jeremy D. Zawodny |
but see SOAP and WSDL support add ons which are freely available and
probably what you want anyway
-C
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Joel Amoussou [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 4:56 PM
Subject: Re: XML in MySQL
On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote:
but see SOAP and WSDL support add ons which are freely available and
probably what you want anyway
I don't buy that. If you've really looked at what Oracle is offering,
it's hard to argue that the MySQL addons really solve the same
PHP-SOAP,
PEAR SOAP,
NuSOAP
need more SOAP?
-C
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: chad pratt [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 5:04 PM
Subject: Re: XML in MySQL
On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote
On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote:
PHP-SOAP,
PEAR SOAP,
NuSOAP
need more SOAP?
SOAP is one thing. But what about storing XML documents in the DB
(with validation on the way in) and querying them using XPath? Oracle
does that. MySQL does not.
Jeremy
--
Jeremy
: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 7:55 AM
To: chad pratt
Cc: [EMAIL PROTECTED]
Subject: Re: XML in MySQL
On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote:
PHP-SOAP,
PEAR SOAP,
NuSOAP
need more SOAP?
SOAP is one thing. But what about storing XML
On Mon, Jun 23, 2003 at 07:58:51AM +1000, electroteque wrote:
geez mysql is an open source product you cannot expect so much too
soon over a very expensive commercial product which has been out for
years , for xml i usually generate it on the fly when i am
extracting the data using the field
: XML in MySQL
but see SOAP and WSDL support add ons which are freely available and
probably what you want anyway
-C
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Joel Amoussou [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 22, 2003 4:56 PM
Subject: Re
I am looking at a project using XML to import and export data into MySql
directly or using php. The datasets are quite large (40-50 million records)
XML is a metadata technology - you wrap data in XML. You don't use XML to import or
export data. You don't store XML in a
database, you store
Lovatt [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 7:10 PM
Subject: RE: XML
I am looking at a project using XML to import and export data into MySql
directly or using php. The datasets are quite large (40-50 million
records)
XML is a metadata
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote:
On the other hand, proclaimed native XML databases (eg, Software
AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the
database...no need to wrap and unwrap the metadata, document/data
structure from the data.
That
On the other hand, proclaimed native XML databases (eg, Software AG's
Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the database...no
need to wrap and unwrap the metadata, document/data structure from the data.
Isn't that more than a bit stupid? Databases are for storing data, not
PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 9:10 PM
Subject: Re: XML
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote:
On the other hand, proclaimed native XML databases (eg, Software
AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data
what did I miss?
Mike
- Original Message -
From: Ed Carp [EMAIL PROTECTED]
To: MikeParton [EMAIL PROTECTED]; Peter Lovatt
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 9:14 PM
Subject: RE: XML
On the other hand, proclaimed native XML databases
seem to get answered.
mysql, sql, xql, xquery, querywhat did I miss?
Mike
- Original Message -
From: Ed Carp [EMAIL PROTECTED]
To: MikeParton [EMAIL PROTECTED]; Peter Lovatt
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 9:14 PM
Subject: RE: XML
database.
- Original Message -
From: Ed Carp [EMAIL PROTECTED]
To: MikeParton [EMAIL PROTECTED]; Peter Lovatt
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 9:14 PM
Subject: RE: XML
On the other hand, proclaimed native XML databases (eg, Software AG's
Not sure there is much more metadata in an XML database than in a data
database.
In a standard database, the data and metadata are stored separately, not so with XML.
When the next new latest and greatest thing
comes along, you'll have to strip all that metadata out of your data. It also
. I hope to see it happen. --Aaron
-Original Message-
From: Matt Wagner [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 1:11 PM
To: James Cox
Cc: [EMAIL PROTECTED]
Subject: RE: xml
On Sat, 2002-03-09 at 13:13, James Cox wrote:
Matt,
Are you suggesting development
]
Subject: RE: xml
Well, I assume the server can do it too - - i haven't checked the C api
lately on that.
James
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 5:52 PM
To: James Cox
Cc: [EMAIL PROTECTED]; Javier Gonzalo
Gloria Medina [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: xml
Frankly, it sounds like this guy understands neither XML nor relational
databases.
XML is a general-purpose structured data format.
The term relational database also connotes a way of storing data, but is
usually used
Matt Wagner explained:
However, loading an XML file into your MySQL server (via the C API)
would be a more difficult and tricky task. DTDs would have to be
defined, some software would have to manage these DTDs so that the data
in the XML file could be correctly mapped into your database
On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier Gonzalo Gloria Medina wrote:
hi everybody:
i was talking with a developer and he told the next
thing:
if you have a database and you need to do joins to
make your quaries between tables... your database and
tables are not full
Anyhow,
Mysql can return data in XML.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 5:29 PM
To: Javier Gonzalo Gloria Medina
Cc: [EMAIL PROTECTED]
Subject: Re: xml
On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier Gonzalo
On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote:
Anyhow,
Mysql can return data in XML.
The client can, but not the server, right?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL
Well, I assume the server can do it too - - i haven't checked the C api
lately on that.
James
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 09, 2002 5:52 PM
To: James Cox
Cc: [EMAIL PROTECTED]; Javier Gonzalo Gloria Medina
Subject: Re
Frankly, it sounds like this guy understands neither XML nor relational
databases.
XML is a general-purpose structured data format.
The term relational database also connotes a way of storing data, but is
usually used to refer more to the way the data is organized and efficient
ways for
This 'developer' is feeding you some BS.
MySQL handles XML data as well as any other type of data. The functioanlity
of a particular database has a lot to do with the programmer who designs the
schema. Maybe this 'developer' doesn't know how to design an XML/MySQL
application ... but that
On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote:
On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote:
Anyhow,
Mysql can return data in XML.
The client can, but not the server, right?
Jeremy,
Correct, currently only the 'mysql' (-X option in MySQL 4.x) and
'mysqldump' (-X
]
Cc: James Cox; Javier Gonzalo Gloria Medina
Subject: Re: xml
On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote:
On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote:
Anyhow,
Mysql can return data in XML.
The client can, but not the server, right?
Jeremy,
Correct
Hi,
XML-DBMS (Open Source) is the best solution for storing 'XML' and
pulling 'XML' with RDBMS.
http://www.rpbourret.com/xmldbms/
This is bundled with JBuilder5 or JBuilder6.
"Sweeney, David" wrote:
Is there a way to import XML files into MySQL?
David Sweeney
Adaptive
Hello udayashankarl_n,
Thursday, January 03, 2002, 4:12:11 PM, you wrote:
There is no mechanism to manage it alike to SQL , for it needs many knowledge
such as schema discovery for semi-stru data and so on , and it
is more complex .
--
Best regards,
isp01ljl
At 10:16 PM -0800 11/4/01, Philip Hernandez wrote:
Is there any support for XML export from MySQL databases?
No, but you can do this relatively easily from within a program,
e.g., using the XML::Generator::DBI Perl module.
-
On Sun, Nov 04, 2001 at 10:49:55PM -0600, Paul DuBois wrote:
At 10:16 PM -0800 11/4/01, Philip Hernandez wrote:
Is there any support for XML export from MySQL databases?
No, but you can do this relatively easily from within a program,
e.g., using the XML::Generator::DBI Perl module.
The
Since this is an open source product, it could happen a lot sooner if you wrote it :)
I don't know of any plans to include that, at least in the near future.
Steve Meyers
-Original Message-
From: can [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 8:14 PM
To: [EMAIL
Gary Huntress ([EMAIL PROTECTED]) writes:
In the past few days 3 different people have asked me about xml support in
mysql. I was unsure what to tell them actually, beyond saying you can
easily export recordsets to xml documents.Obviously you can store
entire XML documents in a TEXT
Gary Huntress wrote:
In the past few days 3 different people have asked me about xml support in
mysql. I was unsure what to tell them actually, beyond saying you can
easily export recordsets to xml documents.Obviously you can store
entire XML documents in a TEXT field, but I'm not sure
Gary Huntress writes:
In the past few days 3 different people have asked me about xml support in
mysql. I was unsure what to tell them actually, beyond saying you can
easily export recordsets to xml documents.Obviously you can store
entire XML documents in a TEXT field, but I'm not sure
On Thu, May 31, 2001 at 12:40:45PM +0100, Steve Menday wrote:
I am trying to find out whether mysql has any support for xml? Can
anyone help me please? Please cc replies to [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
What sort of support?
XML is just text. You can store and retrieve text
I wrote a really cheesy tutorial that demonstrates a simple way to export
the results of a query to XML. It's located at
http://www.phpdeveloper.org/tutout.php?num=20
Would it be useful to add an option to mysqldump to also write an xml
document? I've considered trying to tackle that too :)
Check the archives, we had this argument 2 weeks ago.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 2:36 PM
To: [EMAIL PROTECTED]
Subject: XML
I've done some rudimentary snooping around on both MySQL's
Please drop the stick and back away from the dead horse, it has been beaten
enough. :)
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 12:35 PM
Subject: XML
I've done some rudimentary snooping around on both MySQL's site and on
google,
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
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
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:
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
. 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
: 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
does anyone know of an XML interface to MySQL which would enable me to
import or export data using the XML language definition?
Try http://www.xml.com/pub/a/2000/12/13/perlxmldb.html
(note that I have slept and done other things a few times since reading
the above, but I think it discusses
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
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
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
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
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
a verbose one?
Also, a database IS a huge archive of structured data. :)
salutations,
Cal
http://www.calevans.com
-Original Message-
From: Florian G. Pflug [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 6:31 PM
To: Juergen Fey
Cc: [EMAIL PROTECTED]
S
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
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
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
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
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
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
*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
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
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
]
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
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
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
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
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
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
'; [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
flamers more ammo to work with. :)
Cal
http://www.calevans.com
-Original 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
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
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:
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
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
1 - 100 of 112 matches
Mail list logo