Re: [sqlite] FW: I'm trying to figure out how to ...

2014-09-18 Thread Simon Slavin
On 18 Sep 2014, at 9:38am, RSmith wrote: > Thanks Keith for taking the time, I imagine this is a topic you are > passionate about and I think it should be published somewhere as an article > because it will save lives of beginner DBA/Programmers for millenia to come - > I have certainly born

Re: [sqlite] FW: I'm trying to figure out how to ...

2014-09-18 Thread RSmith
On 2014/09/18 08:18, Keith Medcalf wrote: ...long article... Thanks Keith for taking the time, I imagine this is a topic you are passionate about and I think it should be published somewhere as an article because it will save lives of beginner DBA/Programmers for millenia to come - I have cer

[sqlite] FW: I'm trying to figure out how to ...

2014-09-17 Thread Keith Medcalf
Read only scrollable snapshot cursors can be easily implemented in the same way as they are implemented in other database engines. You just have to do the work yourself. Example: cn = sqlite3.connection(...) cr = cr.cursor() # create the scrollable cursor cr.execute('create temporary table