[sqlalchemy] Re: Local disk database caching and Session subclasses

2009-09-01 Thread Dimitri Tcaciuc
An update on the above, I goofed with subclassing since I had various interesting things in PYTHONPATH which caused issues. My original architecture question still applies tho. Dimitri. On Aug 31, 4:43 pm, Dimitri Tcaciuc dtcac...@gmail.com wrote: I'm working with SQLite databases located

[sqlalchemy] Local disk database caching and Session subclasses

2009-08-31 Thread Dimitri Tcaciuc
I'm working with SQLite databases located on NFS mount which is proving to be too slow. However, since the access is mostly read-only, when local disk space allows for that, I can make a copy of the database in the temp space and work with it instead. I'd like to do it as nonintrusive as

[sqlalchemy] SQLite and foreign keys in attached schemas

2009-07-17 Thread Dimitri Tcaciuc
Hey everyone, I have a main database file x.db which contains some tables with the bulk of data I'm working with. Now, when the operating program connects to it, given a unique key, I'd like to cache some data. What I was going to do is to have the program connect to database y.db, which