[Twisted-Python] XML-RPC Service with Database Access

[Andy Fundinger]

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 at divmod.com> wrote:
>
> On Sat, 15 Sep 2007 14:41:34 +0200, Stefan Arentz <stefan.arentz at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://twistedmatrix.com/pipermail/twisted-python/attachments/20070915/385a219b/attachment.htm