python sql query in django

[Philip Semanchuk]

On Feb 23, 2009, at 4:34 PM, Diez B. Roggisch wrote:

>> I may not stay with Django.  I am seriously looking for whether  
>> python
>> can read data from a relational database and send to an html template
>> or do I always need some kind of wrapper/interface such as Rails or
>> Django?  If this is the wrong group to ask that question could you
>> recommend another python group that could?
>
> Python itself comes neither with an ORM, nor with a HTML generating/ 
> mapping framework.
>
> So yes, if you want something like that, need something like rails  
> or django. Or TurboGears.
>
> For example, you can use SQLAlchemy as ORM, and RUM as frontend for  
> it. I'm not sure if it fullfills your requirements though.

And if you don't like ORMs, most databases have at least one adapter  
out there that allows one to send straight SQL to the DB engine and  
get results back in some useful form. For instance, there's the  
psycopg2 adapter for talking to Postgres. Python has a built-in  
wrapper for SQLite.