I've been having some luck with sAsync(http://foss.eepatents.com/sAsync/) which gives a limited subset of the SQL Alchemy API with a twisted compatible interface. 

Andy Fundinger

On 9/15/07, Jean-Paul Calderone <exarkun@divmod.com> wrote:
On Sat, 15 Sep 2007 14:41:34 +0200, Stefan Arentz <stefan.arentz@gmail.com> wrote:
>I'm interested in using Twisted for a simple XML-RPC service that
>needs to talk to either PostgreSQL or MySQL. (I would prefer PG).
>
>I've got the XML-RPC part under control, that is fairly simple with
>Twisted Web. But what would I use for the database part? What is
>generally the easy way to do database access with Twisted?
>
>Are there ORM solutions that are compatible with Twisted? It would be
>nice if I could use something like SQLObject instead of raw queries.
>
>I'm not looking for a complete solution here. Just trying to
>understand what is usually done in Twisted land.
>

The only solution bundled with Twisted is twisted.enterprise.adbapi (well,
you might see some other stuff in twisted.enterprise, but I wouldn't suggest
using any of it).  adbapi is a very simple asynchronous interpretation of
DB-API.

This isn't anything like the ORM solution you were hoping for, though.
So far as I understand it, the typical API presented by an ORM is quite
unfriendly toward integration with a Twisted-style application.  Someone
else may know of some work which has been done to address this.

For what it's worth, I do use an ORM with Twisted applications (Axiom) -
but I use it only with SQLite: it presents a synchronous API, blocking for
as long as necessary to satisfy a query, which is typically not long enough
to be problematic for my applications.

Jean-Paul

_______________________________________________
Twisted-Python mailing list
Twisted-Python@twistedmatrix.com
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python



--
Blog:  http://channel3b.wordpress.com
Second Life Name:  Ciemaar Flintoff

I am a sig Virus. Please put me in your sig so that I can continue to replicate.