[Tutor] Instantiating classes

Danny Yoo dyoo@hkn.eecs.berkeley.edu
Sun, 31 Mar 2002 19:56:43 -0800 (PST)


> On Sunday, March 31, 2002, at 09:05  PM, Kirby Urner wrote:
>
> > so a next step towards
> > realism in a sandbox would be to use MySQL or something
> > similar (Python quite capable of serving as a front end)
>
> Two things:
>
> (1) Use PostgreSQL instead of MySQL if you're working with financial
> data, since it contains support for transactions and I think triggers --
> stuff I haven't experience with  yet

I'm learning how to use PostgreSQL right now, so perhaps we can share our
experiences with it sometime.  *grin*



> (2) I use and love MySQL (perfect for just about anything else, and I
> think transaction support is coming soon)

Transactions have been in MySQL for a while now via the 'InnoDB' table
type.  See:

http://mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB

for more details on transaction support in MySQL.



> what's the Python module that will provide me with functions to access
> it?

The 'MySQLdb' module is pretty good, and also supports transactions:

    http://sourceforge.net/projects/mysql-python



(Now if only adustman would respond to my bug fix...

http://sourceforge.net/tracker/index.php?func=detail&aid=536624&group_id=22307&atid=374932

*grin*)


Talk to you later!