[Gllug] OT : Credit cards in a MySQL Database

[Paul Cupis]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 17 Jun 2003 12:00, Tethys <tet at accucard.com> wrote:

> If you're dealing with financial data, then MySQL is the
> wrong choice. You need a real ACID database.

MySQL is not ACID-compliant? News to me, and to the MySQL developers. 

http://www.mysql.com/doc/en/ANSI_diff_Transactions.html

"MySQL Server (version 3.23-max and all versions 4.0 and above) supports 
transactions with the InnoDB and BDB Transactional storage engines. 
InnoDB provides full ACID compliance"

By default, I believe that MySQL uses MyISAM tables, which are not 
Transaction-Safe (and not ACID-compliant), but MySQL is quite capable 
of being ACID-compliant if you want it to be.

Paul Cupis
- -- 
paul at cupis.co.uk

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE+75ihIzuKV+SHX/kRAj8bAJ9rVtu95C5L1DyfgKPP65gymWxCKQCdHC6A
PMBriWoTZ1EAoZgpLAyvUMs=
=4xH7
-----END PGP SIGNATURE-----

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug