From owner-freebsd-stable Thu May 10 9:31:18 2001 Delivered-To: freebsd-stable@freebsd.org Received: from flood.ping.uio.no (flood.ping.uio.no [129.240.78.31]) by hub.freebsd.org (Postfix) with ESMTP id 68C0B37B422 for ; Thu, 10 May 2001 09:31:14 -0700 (PDT) (envelope-from des@ofug.org) Received: (from des@localhost) by flood.ping.uio.no (8.9.3/8.9.3) id SAA65970; Thu, 10 May 2001 18:31:09 +0200 (CEST) (envelope-from des@ofug.org) X-URL: http://www.ofug.org/~des/ X-Disclaimer: The views expressed in this message do not necessarily coincide with those of any organisation or company with which I am or have been affiliated. To: Mike Meyer Cc: "JL" , , Subject: Re: Oracle, References: <003b01c0d872$733f8d30$060aa8c0@celery> <15098.39238.25226.854963@guru.mired.org> From: Dag-Erling Smorgrav Date: 10 May 2001 18:31:08 +0200 In-Reply-To: <15098.39238.25226.854963@guru.mired.org> Message-ID: Lines: 19 User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Mike Meyer writes: > I never had much problems with reliability of MySQL, beyond the > problems created by bugs in the code I had to provide to work around > the lack of transactions. That was sufficient to convince me to never > again use an RDBMS that doesn't have transaction support. I've been > told MySQL has since acquired support for transactions, but haven't > checked. If it's still missing referential integrity, I'd still look > elsewhere. MySQL 3.23 supports transactions if you use the (non-default) Sleepycat DB 3 as backing store. It also has row-level locking. I'm not sure how well either of these features work; they're both very new. It still doesn't support referential integrity, non-trivial constraints (i.e. anything more advanced than NULL and UNIQUE) or stored procedures. DES -- Dag-Erling Smorgrav - des@ofug.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message