[sqlite] Feeds for sqlite releases

Hi ! I really missing having feeds to track sqlite releases. Currently I either have to go through the mailing list, which is not low traffic, or open the website. Would you consider having an rss feed for sqlite releases ? Thanks. ___ sqlite-users

Re: [sqlite] integer primary key autoincrement & sqlite_sequence

On , Pavel Ivanov wrote: > Hi, Richard! > > Could you explain why this scenario doesn't cause infinite call cycle > of the trigger by itself? Is there some protection in SQLite which > breaks such cycles? > Many dbms forbid recursive trigger calls that modify a table that

Re: [sqlite] Interrupting sqlite

On , Dan wrote: >> My doubt is the following: if from the progress callback (set with >> sqlite3_progress_handler) I return non 0 and therefore I get >> SQLITE_INTERRUPT from the call to sqlite3_step, is the sqlite3_stmt >> object still in a valid state and will the query

[sqlite] Interrupting sqlite

Hello! I developing an single threaded app (pre-established fact, can't change this), and to keep the UI usable, when sqlite is executing, between multiple calls to sqlite3_step, I just break away and let the main message loop run a bit more. If the query i executing has an "order by" clause,

Re: [sqlite] Reading pragma's results

Well, thank you all. I managed to solve the problem. It was some initialization problems with sqlite. On Mon, May 25, 2009 at 7:20 PM, João Eiras <joao.ei...@gmail.com> wrote: > Okay, but I'm using the latest sqlite source version 3.6 > > On Mon, May 25, 2009 at 7:17 PM,

Re: [sqlite] Reading pragma's results

Okay, but I'm using the latest sqlite source version 3.6 On Mon, May 25, 2009 at 7:17 PM, Derrell Lipman <derrell.lip...@unwireduniverse.com> wrote: > On Mon, May 25, 2009 at 1:10 PM, João Eiras <joao.ei...@gmail.com> wrote: >> Btw, the same happens with the comman

Re: [sqlite] Reading pragma's results

lite> Both pragmas don't return anything On Mon, May 25, 2009 at 6:55 PM, João Eiras <joao.ei...@gmail.com> wrote: > On Mon, May 25, 2009 at 6:48 PM, Igor Tandetnik <itandet...@mvps.org> wrote: >> "João Eiras" <joao.ei...@gmail.com> wrote >> in mess

Re: [sqlite] Reading pragma's results

On Mon, May 25, 2009 at 6:48 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > "João Eiras" <joao.ei...@gmail.com> wrote > in message > news:e72b1b360905250934h1b39c95eycab618faca87d...@mail.gmail.com >> Sorry, wrong url... >> http://pastebin.ca/1433959

Re: [sqlite] Reading pragma's results

Sorry, wrong url... http://pastebin.ca/1433959 On Mon, May 25, 2009 at 5:37 PM, João Eiras <joao.ei...@gmail.com> wrote: > Hi there. > I'm trying the following code > http://pastebin.ca/143395 > > Strangelly, both pragmas don't return any row at all ! > What am I missing ?

[sqlite] Reading pragma's results

Hi there. I'm trying the following code http://pastebin.ca/143395 Strangelly, both pragmas don't return any row at all ! What am I missing ? The same happens if I open a data file on disk. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Quotas

Well, i don't know enough of sqlite and I was told there was no such feature. But what you wrote might be enough. thank you. On Fri, Feb 27, 2009 at 2:31 PM, D. Richard Hipp <d...@hwaci.com> wrote: > > On Feb 27, 2009, at 8:17 AM, João Eiras wrote: > >> Howdy! >&

[sqlite] Quotas

Howdy! As you probably know, rendering engines are bundling SQLite to provide the HTML5 Database API to webpages and widgets. Then 3rd party webpages would access the database API to write data. There should be a way for the user agent to control quotas. I was told on IRC that currently such