[Tutor] PySQLite vs SQLalchemy
jfabiani at yolo.com
Sat Sep 13 01:42:11 CEST 2008
On Friday 12 September 2008 03:30:13 pm Patrick wrote:
> I guess I am a Python framework burnout. I have tried so many of them
> over the past two months, they are just not right for me right now. I am
> trying to put together a program to generate my website offline via the
> MVC paradigm, all I need to deal with is lots of static data.
> 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.
> 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?
> Thanks in advance-Patrick
Have you taken a look at pylons? On the surface pylons sounds like a good
fit. I believe it uses SQLalchemy as it ORM. And if memory serves
SQLalchemy has a feature where it will read in the data structures and setup
the metadata for you. Which is what I think you are having trouble with.
More information about the Tutor