-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 6 Oct 2010, at 12:38, Branko Vukelic wrote:
I've been experimenting with Store and Pylons. I'm new to Pylons, and
also to Storm threaded apps. I've installed an enabled middlestorm
middleware[1], and it seemed like it would work. However, when I
refresh a page what calls one of the controllers where storm retrieves
some data, SQLite comes back with an ProgrammingError, saying
essentially that
ProgrammingError: SQLite objects created in a thread can only be used
in that same thread.The object was created in thread id
139827750606608 and this is thread id 139827601196816
Has anyone dealt with this type of problem?
SQLite is not the best choice in a multi-threaded context. The issues
is discussed in the Storm manual:
https://storm.canonical.com/Manual#Managing%20stores
Most of which I cribbed for an article on Storm and Pylons:
http://bel-epa.com/notes/Pylons/StormandPylons.xml
Alternatively, you could try the Pylons-specific Zope tm-mediated
approach that Canonical suggest:
https://storm.canonical.com/PylonsRepoze.tm2
Or Vsevolod Balashov's "middlestorm" WSGI app
http://pypi.python.org/pypi/middlestorm/0.8.1
- --
Cheers,
Graham
http://www.linkedin.com/in/ghiggins
-----BEGIN PGP SIGNATURE-----
iEYEARECAAYFAkysuDUACgkQOsmLt1NhivxxPgCfYj0wvk7vz8oC+OYEERcDxufW
YJAAn2jwUFXOYP7pu9mNy4I0GwBrl4Q2iQCVAgUBTKy4NVnrWVZ7aXD1AQITOQP/
XguavOdmFQUBjEtjhKVODDEQqChHFVqieD6bPBBuYd4iHmppOw1Kzw5bRpfx9XD3
h3B9QVWRKANq8WTuUJAdnBEZPR13MMX6L3Jvd/wokf0YLTn8CUYUOfdzMIj2lXFy
MO6iIavEn2K/FkC2dcV8XB/KdKF+RsabsQlJsKIczQ8=
=DDez
-----END PGP SIGNATURE-----
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en.
