Re: [Twisted-Python] How to correctly run Sqlite with Twisted?

2017-09-20 Thread goffi
Le 2017-09-20 10:24, ex vito a écrit : On 2017-09-19, at 21:59, Goffi wrote: [SNIP] I would subscribe to Moshe's and Jean-Paul's suggestions of using higher-level tools to handle database interactions. [SNIP] A final thought, from the realm of intuition: if I were targeting heavily concu

Re: [Twisted-Python] How to correctly run Sqlite with Twisted?

2017-09-20 Thread ex vito
On 2017-09-19, at 21:59, Goffi wrote: > I'm using Sqlite3 module through Twisted's enterpirse.adbapi, I create the > ConnectionPool instance like this: > > self.dbpool = ConnectionPool("sqlite3", db_filename, > check_same_thread=False) > > You can see the code at > https://repos.goffi.org/

Re: [Twisted-Python] How to correctly run Sqlite with Twisted?

2017-09-19 Thread Jean-Paul Calderone
On Tue, Sep 19, 2017 at 4:59 PM, Goffi wrote: > Hello, > > I'm using Sqlite3 module through Twisted's enterpirse.adbapi, I create the > ConnectionPool instance like this: > >self.dbpool = ConnectionPool("sqlite3", db_filename, > check_same_thread=False) > > You can see the code at https://rep

Re: [Twisted-Python] How to correctly run Sqlite with Twisted?

2017-09-19 Thread Werner Thie
Aloha Goffi I'm using minimal code like the one below for MySQL interaction, should be easy to transition this to SQLite from twisted.internet import reactor, task, defer from store import Store #debugging func, printing the result on the console def _transformResult(result): ## print '###

Re: [Twisted-Python] How to correctly run Sqlite with Twisted?

2017-09-19 Thread Moshe Zadka
The best answer is probably https://github.com/alex/alchimia On Tue, Sep 19, 2017 at 1:59 PM Goffi wrote: > Hello, > > I'm using Sqlite3 module through Twisted's enterpirse.adbapi, I create the > ConnectionPool instance like this: > >self.dbpool = ConnectionPool("sqlite3", db_filename, > che

[Twisted-Python] How to correctly run Sqlite with Twisted?

2017-09-19 Thread Goffi
Hello, I'm using Sqlite3 module through Twisted's enterpirse.adbapi, I create the ConnectionPool instance like this: self.dbpool = ConnectionPool("sqlite3", db_filename, check_same_thread=False) You can see the code at https://repos.goffi.org/sat/file/tip/src/memory/sqlite.py Sometime, th