[Twisted-Python] Using sqlalchemy in twisted.

Valentino Volonghi dialtone at gmail.com
Wed Mar 4 13:29:30 MST 2009


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Mar 4, 2009, at 11:15 AM, Chris Foster wrote:

> I think SQLAlchemy's ORM might work fine with Twisted.  Check out http://foss.eepatents.com/sAsync/ 
>  .  sAsync doesn't appear to be widely used, but I got the examples  
> to run with some minor changes to the sqlite connection.  I'm hoping  
> to try something useful in the next week or two.


sAsync repository hasn't changed since about 1 or 2 years ago. Now  
sqlalchemy 0.5
changed quite a bit of the internals and so on. Notice however that  
the tests for
sAsync use sqlite that is limited essentially to 1 connection, which  
goes back to
your original discontent.

I tried to integrate sqlalchemy ORM in the past and it never worked  
right because
the code in the objects didn't know that it was dealing with twisted  
and because
sqlalchemy is mainly used in a single thread, it's thread safe but  
that doesn't mean
that you can share objects between threads.

- --
Valentino Volonghi aka Dialtone
Now running MacOS X 10.5
Home Page: http://www.twisted.it
http://www.adroll.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkmu5KoACgkQ9Llz28widGWBWwCglXIKPUFaGbk5tI9XmtrH8lH+
7woAnjrWWWEj2P78szZbNyLzSx0kgz4B
=9uZo
-----END PGP SIGNATURE-----




More information about the Twisted-Python mailing list