Re: [sqlite] Newbie questions regarding in-memory database.

Karthik <[EMAIL PROTECTED]> wrote: > is it possible to set a limit on the database size? PRAGMA max_page_count http://sqlite.org/pragma.html > how does sqlite > behave when database size reaches the threshold(the > default/configured one)? You get an error executing the statement that takes it

Re: [sqlite] Newbie questions regarding in-memory database.

Igor Tandetnik wrote: > "Karthik" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] > >> Newbie question regarding in-memory databases. I read in the wiki >> pages that it is not safe to use same db connection across multiple >> threads. >> > > It's actually safe with recent

Re: [sqlite] Newbie questions regarding in-memory database.

"Karthik" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Newbie question regarding in-memory databases. I read in the wiki > pages that it is not safe to use same db connection across multiple > threads. It's actually safe with recent SQLite versions. A lot of issues have been

RE: [sqlite] Newbie questions

>>The sqlite_compile/step/finalize paradigm allows (requires really ) >>forward browsing through a result set. The results from sqlite_get_table() allow random access, should this be required, and I have even had success using qsort() on the results to re-order them without needing to re-query

Re: [sqlite] Newbie questions

Kurt Welgehausen wrote: 2) use a cursor to browse a result set ? ... No. The sqlite_compile/step/finalize paradigm allows (requires really ) forward browsing through a result set.

RE: [sqlite] Newbie questions

I would be interested in the PDF file. Shawn -Original Message- From: Stéphane Rivière [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 10:22 AM To: D. Richard Hipp Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Newbie questions > place? What doe a descending index give you that

Re: [sqlite] Newbie questions

> ... why would anybody want a descending index in the first > place? What doe a descending index give you that you > don't have with an ascending index? I believe it's an optimization in some DBMSs for multi-column sorting: create index i on t (c1 asc, c2 desc); otherwise, I agree with you.

Re: [sqlite] Newbie questions

Kurt Welgehausen wrote: 1) create an index in descending order ? No. See . Read the paragraph after the syntax description. True. But ascending indices can be traversed in reverse order (if you put the DESC keyword on an ORDER BY). So why would

Re: [sqlite] Newbie questions

> 1) create an index in descending order ? No. See . Read the paragraph after the syntax description. > 2) use a cursor to browse a result set ? ... No. Regards - To unsubscribe,