I can see that being true in the general case, and at some point i will start working with a serious database, but at the moment i am working on a prototype (in which db persistance is maybe a quarter of the work), still have a long list of items to implement and was hoping to abstract away from sql and database specifics with sqlalchemy.
Cheers, Lars On Feb 28, 11:30 am, Chris Withers <ch...@simplistix.co.uk> wrote: > On 25/02/2012 11:07, lars van gemerden wrote: > > > Actually, now I think about it, i had a couple of reasons: > > > - easy to start with (no separeate installation is i remember > > correctly) > > ...but bear in mind that it's a very weak database in terms of > functionality... > > > - no decision required about which database (mysql, postgress) to > > learn > > That's not true, you're choosing to learn sqlite, which isn't likely to > be useful for any real world projects. > > > - no problem with removal of database (in memory), but that is between > > runs, not during unit testing > > There's no problem deleting databases with any rbms provided your user > has the right privileges. > > > Main reason that i want to remove the database, is that i create > > tables dynamically, from another database with table definitions. To > > run multiple tests I need to clear the database in between. > > I used to think that sqlite was good for testing too, it really isn't. > I've learned the error of my ways and you should too ;-) > > Do some research, decide which database you want to use and develop and > test against that. Yes, SQL is supposed to be the panacea that abstracts > away from the rdbms, but that's a lie... > > Chris > > -- > Simplistix - Content Management, Batch Processing & Python Consulting > -http://www.simplistix.co.uk -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.