RE: Open Source Quality

From: Popkin, Laird (WMG Corp) <"Popkin,>
Date: Mon May 10 2004 - 19:07:49 CDT

For the centralized components (which we haven't really touched on, to my
knowledge), I suspect that each locality will already have database
standards (e.g. Oracle, DB2, Sybase) that they will insist upon.

For the polling stations and voting machines, I hope that we could treat the
database as an embedded component of the software, the way the DRE vendors
treat Access, and only have to support a single database in order to
simplify the build, QA and packaging aspects.

For our purposes, I don't see a meaningful difference between MySQL or
PostgreSQL. If anything, both are probably overkill -- we could probably use
Berkley DB or some other embedded database, or even do everything in memory
(and text files). Of course, using a "real database" would make some people
a little more comfortable.

-----Original Message-----
From: owner-voting-project@afterburner.sonic.net
[mailto:owner-voting-project@afterburner.sonic.net]On Behalf Of Arthur
Keller
Sent: Monday, May 10, 2004 12:39 PM
To: voting-project@lists.sonic.net
Subject: Re: [voting-project] Open Source Quality

At 11:52 AM -0400 5/10/04, David Mertz wrote:
>>Also Sprach james_in_denver:
>>>For transactional security, and that seems to be a very high priority
>>>for this project, then Postgres would be the better choice. MySQL does
>>>not have any transaction mechanisms.
>>
>On May 10, 2004, at 11:02 AM, Jeff Almeida wrote:
>>This (about MySQL) is old information -- how long ago did you last work
>>with it? MySQL (currently in the 4.1.x line) has supported
>>transaction-capable table types and an ability to turn off auto-commit
>>since early in the 3.23.x releases.
>
>I was under the impression that PostgreSQL gives you complete
>ACID[*] guarantees, while MySQL still has more limited transactional
>support. Am I wrong in this?
>
>To Arthur and others: Both Free Software projects have long
>histories of supporting robust, widely-used databases. It's only a
>small exaggeration to say that MySQL is what "runs the web."
>PostgreSQL, in its current incarnation, is a Free Software release
>of a formerly closed, but widely used, RDBMS (formerly called
>Postrgres).

I used PostgreSQL for teaching database courses at UCSC and we found
it somewhat cranky. MySQL is more robust. ACID is certainly useful.

For the county and statewide systems, it may make sense to use a COTS
database system, because the recovery and backup tools are rather
important.

Best regards,
Arthur

-- 
----------------------------------------------------------------------------
---
Arthur M. Keller, Ph.D., 3881 Corina Way, Palo Alto, CA  94303-4507
tel +1(650)424-0202, fax +1(650)424-0424
==================================================================
= The content of this message, with the exception of any external 
= quotations under fair use, are released to the Public Domain    
==================================================================
Received on Mon May 31 23:17:31 2004

This archive was generated by hypermail 2.1.8 : Mon May 31 2004 - 23:18:16 CDT