Hi Ariel, > AKAIK it would be completely possible to develop a new sdbc driver to > connect *directly* to MySQL, just like the case you mention with > PostgreSQL, with no need to use ODBC or JDBC.
There is a preliminary version of such a driver for some years now ... unfortunately, for various reasons, the contact with the respective MySQL developer who implemented it broke from time to time, so I am uncertain of the current state of the driver. I'd bet that this topic will raise in the near future, again, now that he probably will get a @sun.com mail address ... > Well... now that Sun spend u$s 1 billion on MySQL I wonder if some MySQL > developers can work together with the Base team, as resources as few > (AFAIK only people working in Base are three: fs, oj, msc). *g* That's two developers and one QA engineer. Looking at our project page will reveal you one more name, and still your number would not be completely correct :) (which would not have been true 9 months or so ago) > And now that we are on this subject, MySQL can also work embedded on an > application. Here "embedded" means NOT as a server. > > I wonder if it could also live "embedded" inside an ODB. > If so, would it be a solution to OOoBase's performance issues? > > Besides the file-format-issue (unknown to the simple user), Base's > performance issues are often blamed to the Java-nature of HSQLDB, so > would a pure C++ application have a better performance than a Java-based > one? The crucial point still is the un/packing of the single files in the ZIP file (as you know, .odb is a ZIP file, effectively), so embedding MySQL into the odbs is not a solution. However, years ago we thought about integrating MySQL in its embedded mode (we have to be careful with terms here: What MySQL calls "embedded mode" in fact means you have the MySQL engine running in-process, and access the database files lingering somewhere on your hard disc. It is explicitly not the same as embedding the data files into another file, as we do when we say "embedded HSQLDB".). It never came to this, for various reasons. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
