[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!