Python Database Apps
bdesth.quelquechose at free.quelquepart.fr
Sun Sep 9 17:33:26 CEST 2007
Tom Brown a écrit :
> On Monday 10 September 2007 19:52, darien.watkins at gmail.com wrote:
>>Kindof a poll, kindof curiosity...
>>What is your favorite python - database combination? I'm looking to
>>make an app that has a local DB and a server side DB. I'm looking at
>>python and sqlite local side and sql server side.
> I have had a lot of good luck with PostgreSQL. It is easy to install and use.
Well... For an experimented (or opiniated) Unix user, at least !-)
But I can only second : PgSql is probably one of the best free RDBMS
around - one of my previous associates (and still friend !-), who has
quite a few years of experience as an Oracle DBA, consider it (pg) as
mostly as good as Oracle, and eventually better on some points. My own
experience with Pg for web applications is that it JustWorks(tm) - never
had a single problem with it. I wish I could say so about MySQL.
wrt/ sqlite, I've only used it for small web apps, and the only problem
I had was a strange incompatibility bug with first PHP5 versions
installed on the same machine. Since I doubt your users will have PHP5
installed on the client machines (!), this should not be a problem.
And, while it may takes some time to learn, SQLAlchemy is a very great lib.
More information about the Python-list