Re: Python Database Apps
- From: Harry George <harry.g.george@xxxxxxxxxx>
- Date: Tue, 11 Sep 2007 12:56:12 GMT
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.
--
Harry George
PLM Engineering Architecture
.
- Follow-Ups:
- Re: Python Database Apps
- From: Jonathan Gardner
- Re: Python Database Apps
- From: Steve Holden
- Re: Python Database Apps
- References:
- Python Database Apps
- From: darien.watkins@xxxxxxxxx
- Re: Python Database Apps
- From: Tom Brown
- Python Database Apps
- Prev by Date: Re: Checking if elements are empty
- Next by Date: Re: shared memory pointer
- Previous by thread: Re: Python Database Apps
- Next by thread: Re: Python Database Apps
- Index(es):
Relevant Pages
|
