Re: [sqlite] Literature on the information theory behind SQL(lite)?

FWIW, these titles and many more are all available in the Safari Books collection. http://www.safaribooksonline.com/ I am not affiliated with Safari Books Online -- just a long time subscriber ... On Thu, 18 Jul 2013 17:14:34 + Konrad Hambrick wrote: >> -Original

Re: [sqlite] Literature on the information theory behind SQL(lite)?

> -Original Message- > On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich wrote: > > > > If you want to learn more about the theory and concepts behind SQL, I > > would strongly recommend these two books: > > > > SQL and Relational Theory (2nd Ed) by C.J. Date > >

Re: [sqlite] Guidance with Python and nested cursors

> It is perfectly allowed to open multiple cursors against a single connection. > You can only execute one > statement per cursor at a time, but you can have multiple cursors running > from the same connection: > > cr1 = cn.cursor() > cr2 = cn.cursor() > > cr1.execute('select ...') > while

Re: [sqlite] Literature on the information theory behind SQL(lite)?

On Thu, Jul 18, 2013 at 2:31 PM, Richard Hipp wrote: > On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich wrote: > > If you want to learn more about the theory and concepts behind SQL, I > > would strongly recommend these two books: > > > > SQL and

Re: [sqlite] Can we execute a query after preparing statement for different other query?

Thanks Hipp. On Thu, Jul 18, 2013 at 5:36 PM, Ashok Pitambar wrote: > Hi All, > > I trying to run a query it is crashing before that I have created > two prepared statements which are not finalized yet and after that I tried > run a query (done

Re: [sqlite] Literature on the information theory behind SQL(lite)?

On Tue, Jul 9, 2013 at 9:27 PM, Jay A. Kreibich wrote: > > If you want to learn more about the theory and concepts behind SQL, I > would strongly recommend these two books: > > SQL and Relational Theory (2nd Ed) by C.J. Date >

Re: [sqlite] Can we execute a query after preparing statement for different other query?

On Thu, Jul 18, 2013 at 8:06 AM, Ashok Pitambar wrote: > Hi All, > > I trying to run a query it is crashing before that I have created > two prepared statements which are not finalized yet and after that I tried > run a query (done sqlite3_prepare_v2) it is

[sqlite] Can we execute a query after preparing statement for different other query?

Hi All, I trying to run a query it is crashing before that I have created two prepared statements which are not finalized yet and after that I tried run a query (done sqlite3_prepare_v2) it is crashing while doing sqlite3_step(). Is there any problem with this kind of operation? How

Re: [sqlite] function auxiliary data

On Wed, Jul 17, 2013 at 11:19 PM, Roger Binns wrote: > On 17/07/13 04:03, Riccardo Vianello wrote: >> I'm not sure I can do the same with pysqlite), > > pysqlite forces a minimum statement cache size of 5. ok.. thanks for the additional information.. >> but since