RE: when will mysql 4.1 be released?
I'm implementing a bridge between MySQL and Lotus Domino. In our application we realy need stored procedures (triggers). I saw that MySQL does not yet support stored procedures. (This will be one of the features of version 4.1). Is it worth to wait for version 4.1 or should we switch to some other database management system like postgresql (which does support stored procedures)? We realy would like to use mysql. Because the Lotus Domino bridge work perfectly with mysql, but it does not realy work with PostgreSQL. Any ideas here? The DECS (Domino Enterprise Connection Services) should work with: DB2, Cracle, EDA, Sybase and -- ODBC -- If postgres has a proper ODBC interface, it should work. Lotus prerequisites for ODBC: * The ODBC driver appropriate to the operating system * The driver must be 32-bit on NT and OS/2 * The ODBC driver must be thread-safe * The ODBC Administrator must be present * There must be correctly defined ODBC data sources in the ODBC Administrator - 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: when will mysql 4.1 be released?
First of all, let me apologize for repeaditly sending my e-mail message to the list. Roger Baklund wrote: I don't know. Not in the nearest future, they have just begun the coding. Oka I don't get it... does it work perfectly with mysql, or do you realy need stored procedures? And how come you consider postgresql, when it does not realy work with PostgreSQL? First you should decide if it works or not with mysql. If it does not, you can consider if it works with postgresql. If it does not, you can consider if it is worth waiting for 4.1, or if you should consider other products. The word worth implies some kind of economic considerations, it is hard to answer without the knowledge of your economic situation. How important is this application for you? Can you afford to not make the bridge in 6-12 months? Can you work on other projects in the meanwhile? (6-12 months is just me guessing, I feel safer with Not in the nearest future.) IBM (Vendor of Lotus Domino) provides a Lotus Notes module called DECS which purpose is to provide a 'bridge' to relational databases like MySQL, Sybase and Oracle. (This goes via ODBC) This 'bridge' seems to work fine with MySQL (and it's ODBC driver). But it does not work with postgreSQL (and the postges-ODBC driver). This is a known bug (and IBM is working on it). We could use MySQL and imlement stored procedures outselves. (Using some scriptlanguages like perl or python). But this is (ofcourse) a lot of work. If we could use stored procedures in MySQL that would realy help!. So I read that Mysql 4.1 would have stored procedures. But no release date was mentioned. - 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: when will mysql 4.1 be released?
Errata: We could use MySQL and imlement stored procedures outselves. (Using some scriptlanguages like perl or python). A stored procedure is by definition a collection of SQL statement stored and executed in the RDBMS, not an external script, etc. //Anders - sql, query - 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: when will mysql 4.1 be released?
I guess it's a question of semantics, but I would consider a stored procedure, in general, any series of commands to be executed 'in' the database engine. Postgres, for instance, allows stored procedures to be written in a number of different languages. Commercial engines have similar capabilities. I would think that a stored procedure would not be required to do much of anything with SQL. SQL would simply be a way of invoking it. Cheers. -Dana -Original Message- From: Svensson, B.A.T. (HKG) [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 8:40 AM To: [EMAIL PROTECTED] Subject: RE: when will mysql 4.1 be released? Errata: We could use MySQL and imlement stored procedures outselves. (Using some scriptlanguages like perl or python). A stored procedure is by definition a collection of SQL statement stored and executed in the RDBMS, not an external script, etc. //Anders - sql, query - 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 ** Notice: The area code for the Wal-Mart Bentonville General Office in the US has changed from 501 to 479. Please make sure that you are dialing 479 when making calls to any General Office location. ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Stores, Inc. Confidential ** - 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