Matthew Bevan wrote:
I thoroughly searched the mailing list archives on Google and the
docs.turbogears.org site, but could not find any references to
creating a second database connection for use as an in-memory cache.
E.g. I wish to have an in-memory SQLite connection where I store a
single table containing one MD5 sum and integer per row. It's that
simple.
Has this been done before? Can anyone point me at useful
documentation or example code?
If you're not a slave to SQLObject or SQLAlchemy...
That sort of use-case is exactly why I wrote Dejavu [1]. It allows you
to mix and match stores from a variety of databases [2], shelve, or a
pure RAM object store. You can also use various kinds of caching
middleware, and even (with a little work) split a table over multiple
stores.
Robert Brewer
System Architect
Amor Ministries
[EMAIL PROTECTED]
[1] http://projects.amor.org/dejavu
[2] MS SQL, MySQL, PostgreSQL, MSAccess, SQLite (including :memory:),
and Firebird (almost--I'm having a hard time with thread-safety on that
one).
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
