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
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
