[Tutor] PySQLite vs SQLalchemy

[Jeff Younker]

On Sep 12, 2008, at 3:30 PM, Patrick wrote:

> I like SQLite, it's really easy to work with. I would like to model my
> database in it natively but I am having quite a bit of trouble mapping
> the variables in the SQLIte database via PySQLite. It appears that  
> this
> sort of thing is SQLalchemy's strong suit. However I would prefer  
> not to
> model my data base in it.

I'm curious why you feel that way?

> So, I am just wondering if anyone has any feedback with regard to
> PySQLite and SQLalchemy. Is mapping the variables from the a database
> via PySQLite a common problem? Is SQLalchemy being used for desktop
> Applications? I bought a book on SQLalchemy but PySQLite seems to have
> sparse documentation. We can build Python with SQLite built right in,
> why is there not more documentation?

I personally have never even considered PySQLite.  SQLAlchemy and
SQLObject have covered all my needs from the small to the large quite
handily.  It saves me from having to resort to learning a new interface
for each database, and it largely insulates my applications from changes
in the underlaying database.

[This isn't an academic possibility either.  Much of my code is unit- 
tested
against sqlite, but runs against mysql in production.]

-jeff