[sqlalchemy] Using TWO PHASE commit with SQLite database? NotImplementedError?

Hi there, I have seen some basic examples online showing that SQLAlchemy supports twophase = True for some databases. My question is I am needing to use this sort of functionality with 2 SQLite databases, does SQLAlchemy support SQLite two phase commits? So here is some basic code

[sqlalchemy] Re: Using TWO PHASE commit with SQLite database? NotImplementedError?

...@zzzcomputing.com wrote: Lynton Grice wrote: Hi there, I have seen some basic examples online showing that SQLAlchemy supports twophase = True for some databases. My question is I am needing to use this sort of functionality with 2 SQLite databases, does SQLAlchemy support SQLite two phase commits

[sqlalchemy] Re: Cannot delete SQLite '.db' using os.remove

Hi there, Thanks for the clarity, much appreciated ;-) Lynton On Mar 9, 5:25 pm, Michael Bayer mike...@zzzcomputing.com wrote: Lynton Grice wrote: Hi Michael, Can you paste the following code into your editor and try it out? Can you tell me what I would need to do to close

[sqlalchemy] Re: Cannot delete SQLite '.db' using os.remove

On Mar 8, 4:41 pm, Michael Bayer mike...@zzzcomputing.com wrote: Lynton Grice wrote: Hi there, I am using SQLAlchemy to build a custom based queue implementation. As part of the methods exposed I have a deletequeue that is meant to physically delete the SQLite database from the file

[sqlalchemy] Cannot delete SQLite '.db' using os.remove

Hi there, I am using SQLAlchemy to build a custom based queue implementation. As part of the methods exposed I have a deletequeue that is meant to physically delete the SQLite database from the file system. But whenever I try delete it I get the following error: WindowsError: (32, 'The process

[sqlalchemy] Problem installing SQLAlchemy as a dependency??

Hi there, I am trying to package a small Python lib I have created that has an install dependency on SQLAlchemy. I have created my setup.py file with the install_requires install_requires=[ 'SQLAlchemy', ], But whenever I try install my Python lib on a machine without SQLAlchemy

[sqlalchemy] Python Pickle Error - Can't pickle class 'sqlalchemy.orm.session.Session'

Hi there, I am writing a little persistant Queue class/s using sqlalchemy and sqlite. All is going fine with the development but now I have reached the stage where I would like to have each request spawned as a new process (from Python's muliprocessing module). The error I am getting is: Can't

[sqlalchemy] Re: Python Pickle Error - Can't pickle class 'sqlalchemy.orm.session.Session'

Thanks a lot for the suggestions, I will give it a much closer look now... Lynton On Dec 18, 7:19 pm, Michael Bayer mike...@zzzcomputing.com wrote: Lynton Grice wrote: Hi there, I am writing a little persistant Queue class/s using sqlalchemy and sqlite. All is going fine