Re: Python Database Apps

Harry George wrote:
Tom Brown <brown@xxxxxxxxxx> writes:

On Monday 10 September 2007 19:52, darien.watkins@xxxxxxxxx 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 -------------

.

Relevant Pages

  • Re: Access and Postgresql
    ... end on the same machine that is hosting the Postgresql program. ... If you have a split Access database with back-end (tables, data, and ... relationships) on the server, and the front-end (queries, forms, reports, ... the fact is they are _hoping_ that it is some other software interfering ...
    (comp.databases.ms-access)
  • Re: Prolog on a web server
    ... thrilled if you wanted to load it all into server VM:-/ ... rapidly build yourself a desktop app (Delphi? ... As for Prolog, it could surely be the basis of a decent ... grown-up database query language (an open standard dialect ...
    (comp.lang.prolog)
  • Re: Python Database Apps
    ... It's gonna be a desktop app. ... so that I don't need a database server on the client side. ... If you have an offline mode then the most important thing to work out ...
    (comp.lang.python)
  • Re: Python Database Apps
    ... What is your favorite python - database combination? ... make an app that has a local DB and a server side DB. ... I have had a lot of good luck with PostgreSQL. ... If an app comes already designed for mysql, oracle, sqlite, db2, dbm, ...
    (comp.lang.python)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.vb.com)