From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mail-qy0-f172.google.com (mail-qy0-f172.google.com [209.85.221.172]) by speech.braille.uwo.ca (Postfix) with ESMTP id 14D2810DBB for ; Fri, 23 Oct 2009 22:33:22 -0400 (EDT) Received: by qyk2 with SMTP id 2so6464517qyk.21 for ; Fri, 23 Oct 2009 19:33:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:from:to:subject :in-reply-to:references:comments:date; bh=anEW5s7MqtNq5mhdY0FDaW/W/Nd+n89TnRC1VNJFatM=; b=Qp9MvW5gN5YJUnPGlW0gklBrJbw/oPWGrgS8vjHeR3m4DIqbwRTxIcG1iHzP32xRyA if8J1AwTcJRdkHjl4EpzBA5LoX29STmCn2/0uBPS+N4sicCxjaKnMi7KUSciYL/eN0TV rt/jeDy/OIResdFzf5haApYMNe0tekFpv9f0E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:subject:in-reply-to:references:comments:date; b=hxpDUEz1mNFz59ZXlgS22HRx8nkvAmLPeLn575A3djADAKD85mNvpcdMa9B6qnQ3T8 UqIqq9xx8zdI5bL4jtyySwUVTEagst2VorDu5Duamz5UeG+N+WpENn5TmUxF87fGN58S x/yxCRJDATsl2vLF9kY21+ZdTpDhunGNUpzj8= Received: by 10.224.41.75 with SMTP id n11mr5920455qae.76.1256351601668; Fri, 23 Oct 2009 19:33:21 -0700 (PDT) Received: from localhost (ip24-253-221-18.ok.ok.cox.net [24.253.221.18]) by mx.google.com with ESMTPS id 22sm3300263qyk.6.2009.10.23.19.33.20 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 23 Oct 2009 19:33:20 -0700 (PDT) Message-ID: <4ae26770.9653f10a.07b3.358b@mx.google.com> From: Chris Brannon To: "Speakup is a screen review system for Linux." , Liz Hare Subject: Re: Database software In-reply-to: <4AE23E24.2070104@earthlink.net> References: <20091023135626.GA4007@Betsy> <4ae1bb5d.1608c00a.4630.1aae@mx.google.com> <4AE23E24.2070104@earthlink.net> Comments: In-reply-to Liz Hare message dated "Fri, 23 Oct 2009 18:37:08 -0500." Date: Fri, 23 Oct 2009 21:33:24 -0500 X-BeenThere: speakup@braille.uwo.ca X-Mailman-Version: 2.1.12 Precedence: list Reply-To: "Speakup is a screen review system for Linux." List-Id: "Speakup is a screen review system for Linux." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 24 Oct 2009 02:33:22 -0000 > > I prefer it to MySQL for several reasons. Please do investigate both, if > > you haven't already done so. > > Would you mind telling us what those are? I might be about to take on a > big database project myself. Hi Liz, I had to check the documentation, because it's been almost half a decade since I've seriously looked at MySQL. Most of my biggest complaints aren't quite valid anymore. For a long time, MySQL didn't support foreign key constraints. It accepted the syntax, but it wouldn't check them. In other words, using FOREIGN KEY in a CREATE TABLE statement was a no-op. One of MySQL's several storage engines, InnoDB, does support foreign key constraints. It has done so for a few years now. The other storage engines do not. You probably want to use InnoDB. Also, some of the engines don't support transactions. Thankfully, InnoDB does. Prior to version 5.0, MySQL didn't have stored procedures. All of these things have always just worked out of the box for me with PostgreSQL. Be careful about identifiers when using MySQL. Table names are case-sensitive on Unix and case-insensitive on Windows. Trigger names are case sensitive. Et cetera. There's a MySQL variable called "lower_case_table_names". When set to 1, table names are stored on disk in lowercase. Comparisons convert both operands to lowercase as well. You get the benefit of case-insensitivity, but it is not case-preserving. The reference manual has the gory details. That is a fair explanation of what I omitted earlier today. Hope it helps. -- Chris