Transactions...

2001-03-01 Thread Gorjan Todorovski

Hi,

So does mySQL support transactions or not? There are transaction safe tables but they 
are not actually implemented?

How people cope without transactions when there is a need for multiple UPDATEs or 
INSERTs...and they need to be implemented as a whole atomic operation?

Thanx



-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: XML support under mySQL

2001-02-22 Thread Gorjan Todorovski

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.

About the education I think that is not the problem here since the guy that
posted the thing about XML support in mySQL has Master's degree in computer
science and begins a doctorate thesis in database systems...so :)


on 2/22/01 3:34 PM, Cal Evans at [EMAIL PROTECTED] wrote:

> 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 about  the
> subject before posting.
> 
> 2: The discussion started with someone stating that MySQL should be extended
> to accept XML statements, not a wrapper.  I think everyone against embedding
> XML in MySQL has advocated a wrapper.
> 
> 3: Never claim stupidity, it gives 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 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 doesn't mean that the
> application is responsible for generating XML.
> 
> Due to the fact I don't have my computer science degree like Ed Carp said we
> all should. I'm going to claim stupidity and yet still say my $0.02.
> 
> We all know that the database is not responsible, nor should it be
> responsible for only making it's data accessible through XML. This is not at
> all what people need, nor are they asking for this. All people want is a way
> to put this wrapper on MySQL to be able to send queries to and have the
> output be in XML. There is no problem with this, nor should there be months
> of debate on whether or not this is a database function because it's
> obviously not. What people want is to have MySQL, an Open Source Database
> that is pretty damn good, take the initiative and make this wrapper to
> distribute with MySQL. Now if someone else wants to do this that's no big
> deal, let's just give MySQL a copy so that they distribute it with MySQL.
> You can't preach to me about how hard this is. If it wasn't for the fact
> I've been stuck working on Microsoft the past year I would do it in a couple
> days, I've already dome similar to create an XML feed manually for Microsoft
> SQL using ASP.
> 
> 
> Aaron Weiker
> 
> 
> -Original Message-
> From: Ed Carp [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.
> 
> 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'm stuck - I
> have to strip off the XML.
> 
> *MUCH* cleaner to have the database return just data - then you can use
> something else to wrap the data in anything you want - XML, HTML, PHP,
> whatever.  We use this approach in Escapade - it outputs just data - you
> decide how you want it wrapped.  The idea of dec
oupling data and metadata is
> a powerful one and has strong, compelling arguments in its favor - ane one
> usually taught in first-year computer science classes.
> --
> Ed Carp, N7EKG   [EMAIL PROTECTED]  940/367-2744 cell phone
> http://www.pobox.com/~erc  [EMAIL PROTECTED] - text pager
> 
> I sometimes wonder if the American people deserve to be free - they seem
> so unwilling to fight to preserve the few freedoms they have left.
> 
> -
> 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 unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> -
> 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 unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mys

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 result will be XML which together with some XSLT specs. can be made in
some human usefull format like HTML, WML or just plain application
interface. So tyhe database can be one more service offered and will not be
different from other services like web server, or even COtaRBA.

And you cannot say that Oracle has just good marketing not a deisgn, since u
first should be very familiar with the Oracle server to knowiate to
appricciate it's design.


on 2/22/01 5:32 AMhange data and is protocol/platform Ed Carp at
[EMAIL PROTECTED] wrote:

> 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 formulated for my 1998 Ford Taurus".
> 
> If Java doesn't do what you want, maybe it's time to look at other options.
> --
> Ed Carp, N7EKG   [EMAIL PROTECTED]  940/367-2744 cell phone
> http://www.pobox.com/~erc  [EMAIL PROTECTED] - text pager
> 
> I sometimes wonder if the American people deserve to be free - they seem
> so unwilling to fight to preserve the few freedoms they have left.
> 
> -
> 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 unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




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:

> 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
> normalized, relational model.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878Fax: (408) 530-5454
> Cell: (408) 439-9951
>
> -
> 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 unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php