RE: when will mysql 4.1 be released?

2002-06-11 Thread Svensson, B.A.T. (HKG)

 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




when will mysql 4.1 be released?

2002-06-10 Thread harm de laat

Hi all,

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?

Many Thanks,

Harm de Laat
Informatiefabriek
The Netherlands


-
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?

2002-06-10 Thread harm de laat

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?

2002-06-10 Thread Svensson, B.A.T. (HKG)

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?

2002-06-10 Thread Dana Diederich

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