48 messages in com.mysql.lists.javaRe: SubQueries and Temp Tables| From | Sent On | Attachments |
|---|---|---|
| Arul | 25 Jun 2002 21:04 | |
| Arul | 26 Jun 2002 02:30 | |
| Ralf Narozny | 26 Jun 2002 02:30 | |
| Dave Morse | 26 Jun 2002 07:16 | |
| Alexander Barkov | 26 Jun 2002 08:15 | |
| Paul DuBois | 26 Jun 2002 17:36 | |
| Dave Morse | 27 Jun 2002 07:12 | |
| Paul DuBois | 27 Jun 2002 08:03 | |
| Peter T. Abplanalp | 27 Jun 2002 08:06 | |
| Dave Morse | 27 Jun 2002 08:16 | |
| Andrew Houghton | 27 Jun 2002 09:09 | |
| Frank Gates | 27 Jun 2002 09:28 | |
| Timothy Bennett | 27 Jun 2002 10:16 | |
| Dave Morse | 27 Jun 2002 10:39 | |
| Frank Gates | 27 Jun 2002 10:48 | |
| Dave Morse | 27 Jun 2002 10:50 | |
| Dave Morse | 27 Jun 2002 10:55 | |
| Pål Arne Hoff | 27 Jun 2002 12:04 | |
| Arthur Fuller | 27 Jun 2002 14:34 | |
| Mark Matthews | 28 Jun 2002 06:27 | |
| Mark Matthews | 28 Jun 2002 06:37 | |
| Dave Morse | 28 Jun 2002 11:38 | |
| Frank Gates | 28 Jun 2002 12:16 | |
| Arthur Fuller | 28 Jun 2002 12:21 | |
| Arthur Fuller | 28 Jun 2002 12:28 | |
| mike markovich | 28 Jun 2002 12:49 | |
| Jeff Kilbride | 28 Jun 2002 13:04 | |
| Dave Morse | 28 Jun 2002 14:01 | |
| Scott Hodson | 28 Jun 2002 14:12 | |
| Jon Frisby | 28 Jun 2002 14:46 | |
| Dawn Wolthuis | 28 Jun 2002 16:06 | |
| Tim Endres | 28 Jun 2002 16:45 | |
| Mark Matthews | 30 Jun 2002 17:30 | |
| Mark Matthews | 30 Jun 2002 18:50 | |
| Tim Endres | 30 Jun 2002 19:05 | |
| Scott Hodson | 30 Jun 2002 20:35 | |
| Jeff Kilbride | 30 Jun 2002 21:19 | |
| Mark Matthews | 01 Jul 2002 06:13 | |
| Dave Morse | 01 Jul 2002 08:32 | |
| Dave Morse | 01 Jul 2002 18:46 | |
| Jeff Kilbride | 01 Jul 2002 18:49 | |
| Mark Matthews | 01 Jul 2002 19:23 | |
| Scott Hodson | 01 Jul 2002 21:01 | |
| Admin | 01 Jul 2002 23:21 | |
| Jon Frisby | 02 Jul 2002 11:59 | |
| Admin | 03 Jul 2002 11:52 | |
| Dave Morse | 03 Jul 2002 12:01 | |
| Arthur Fuller | 03 Jul 2002 12:23 |
| Subject: | Re: SubQueries and Temp Tables |
|---|---|
| From: | Arthur Fuller (art...@rogers.com) |
| Date: | 06/28/2002 12:21:48 PM |
| List: | com.mysql.lists.java |
From what I have gathered so far (we're dealing with impoverished gathering abilities not to mention an aging memory), the spec for 4.1 includes nested queries, sprocs and (please please please) views. Still missing is roles. I have figured a clumsy way to fake them, but I'm a worse programmer than everyone on the MySQL team, and would much prefer to use a built-in implementation than the clumsy one I wrote :-)
As to sprocs, Michael or Monty (I can't remember at the moment) wrote in an email to me that they were considering supporting both ANSI syntax and Oracle-style java syntax in their implementation of sprocs. As the developer of a JDBC driver, how do you feel about that? Is it what you would consider a step in the right direction? Or a waste of effort? Or...?
Arthur
----- Original Message ----- From: "Mark Matthews" <mmat...@thematthews.org> To: "Dave Morse" <dave...@attbi.com> Cc: <ja...@lists.mysql.com> Sent: Friday, June 28, 2002 9:27 AM Subject: Re: SubQueries and Temp Tables
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Dave Morse wrote: | Original Q was; Why do Java developers use C-based file systems to | develop applications? You can draw any point you want from it. | However, if the only answer is it doesn't matter from a connectivity | point of view then I don't think I'll get an answer. So what? | |
Find an academic definition of a relational database, read it and understand it, then tell me about _any_ widely-used commercial database that complies with everything in the definition.
Software is always a comprimise. The developers of MySQL chose speed over feature set, and are adding features gradually. They are only a short time away from having everything that other databases have, but they've covered 90% of what anyone needs in a database for quite a few years, now. They aren't ashamed to admit that they don't have certain features...They spell it out in the manual. If you can't live without those features, then there's nothing forcing you to use the product.
As the developer of the JDBC driver for MySQL, I wouldn't use a java-based database if I wanted to use SQL, unless I had to deeply embed it in an application. Java database servers are slower than c-based ones. They're immature, as they haven't been around long.
C lends itself to database system development. Java lends itself to application server and business logic development. It's always best to use the right tool for the job.
-Mark
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAj0cZFMACgkQlyjUJM+7nP5FGQCgiKYJWHlt4ZMWGmqCuTMxsBJI QdEAoIF4klpqvWgJFqqQryCA4PI/04Bc =DMVV -----END PGP SIGNATURE-----
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.