Harry George wrote: > Tom Brown <[EMAIL PROTECTED]> writes: > >> On Monday 10 September 2007 19:52, [EMAIL PROTECTED] 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. >>> >>> Any suggestions???? >> I have had a lot of good luck with PostgreSQL. It is easy to install and >> use. >> It is also very stable. It maybe overkill for a client side database. The >> psycopg package makes interfacing to PostgreSQL very easy and there is a >> package for Linux and Windows to make cross-platform development a breeze. >> >> -Tom > > I use postgresql as well. I wonder if Pythonistas do so out of > concern for rigor, clarity, and scalability. It works fine for a > quick one-off effort and still works fine after scaling to a DBMS > server supporting lots of clients, and running 10's of GBs of data. > > If an app comes already designed for mysql, oracle, sqlite, db2, dbm, > etc I'll use those. But for my own projects, it is postgresql, with > maybe SQLAlchemy (I'm back and forth on that. Mostly stay with > straight SQL). > > Of course, as long as you write DBI2 compliant code, your app doesn't > much care which DBMS you use. The postgresql payoff is in admin > functionality and scaling and full ACID. > I also have a tendency to prefer PostgreSQL over MySQL, though I run and use both from time to time as an exercise in application portability.
Don't forget, there is absolutely no need to use the same database technology for the client-side and the central repository - sqlite is hard to beat for its simplicity and ease of installations on the client side, and you could look at PostgreSQL for the repository as and when that became a practical proposition. regards Steve -- Steve Holden +1 571 484 6266 +1 800 494 3119 Holden Web LLC/Ltd http://www.holdenweb.com Skype: holdenweb http://del.icio.us/steve.holden --------------- Asciimercial ------------------ Get on the web: Blog, lens and tag the Internet Many services currently offer free registration ----------- Thank You for Reading ------------- -- http://mail.python.org/mailman/listinfo/python-list
