Re: [sqlite] bug in SQLITE_CHECKPOINT_PASSIVE?

> I double-checked and it is possible that the checkpoint thread is > sharing an sqlite3* with a writer thread. That was the problem. I gave the SQLITE_CHECKPOINT_PASSIVE it's own sqlite3*, and it is now working fine. Thanks much. ___ sqlite-users

Re: [sqlite] bug in SQLITE_CHECKPOINT_PASSIVE?

> Are each of your threads using their own handles or do they all share the > same handle? I double-checked and it is possible that the checkpoint thread is sharing an sqlite3* with a writer thread. If so, that would account for the problem, I think. I'll look into this further and post a

Re: [sqlite] bug in SQLITE_CHECKPOINT_PASSIVE?

> > sqlite3_busy_timeout(db, 0x7000) > If you want to turn timeouts off, specify zero or a negative number. My understanding is that timeouts off means the functions immediately return BUSY. I don't want timeouts off, I want them set to infinity, so the functions never in my lifetime return

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

I have my ancient Galaxy S (Original ) Android hanging here on my desk, and I pulled up the draft page, and it looks good. With respect, Dr. Hipp, I really do hope you weren't REALLY pressured into this (And the analogy between the

[sqlite] schema_version and Vacuum or Backup API

I'm updating one of my units in Delphi to automatically output the schema of any database I'm attempting to open while in the debugger for two purposes. One reason that when a user does a FILE> NEW, the most recent database is created based on the SQL commands found in sqlite_master, and the

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

At first blush, looks good on my Zenfone 2 under android 5.0 with chrome and on laptop with Windoze 10 and chrome. In the interest of "dotting all the i's" I noted a misspelling in the initial sentence: "SQLite is a high-reliablity," for reliability.

Re: [sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference (Tcl'2016)

> On 9/5/16, akupr...@shaw.ca wrote: > > > > Hello SQLite Users, fyi ... > > > > 23rd Annual Tcl/Tk Conference (Tcl'2016) > > http://www.tcl.tk/community/tcl2016/ > > > To clarification the relevancy and appropriateness of Andreas's post > above: SQLite is a TCL extension

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

The site seems to be quite readable - I did notice that the text appears larger in landscape mode but it seems to appear quite readable in portrait mode (I viewed it with an iPhone 4S and an iPod Touch. -Original Message- From: sqlite-users

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

For my current website, I tested various techniques so that my website renders properly on a phone and a large desktop monitor. Most smart phones have a landscape resolution of at least 1024 pixels, most newer phones are much higher. I found that 950 pixel fixed centered width for a website

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

On 2016-09-05 1:55 PM, Richard Hipp wrote: Most of the world views the internet on their phone now, I am told, and websites are suppose to be "responsive", meaning that they reformat themselves to be attractive and useful for the majority who view them through a 320x480 pixel soda-straw. In an

[sqlite] "Responsive" website revamp at www.sqlite.org

Most of the world views the internet on their phone now, I am told, and websites are suppose to be "responsive", meaning that they reformat themselves to be attractive and useful for the majority who view them through a 320x480 pixel soda-straw. In an effort to conform to this trend, I have made

Re: [sqlite] bug in SQLITE_CHECKPOINT_PASSIVE?

Sorry I can't solve your problem (too technical for me) but I have notes on the testing code. On 5 Sep 2016, at 8:54pm, Allen wrote: > sqlite3_busy_timeout(db, 0x7000) Please don't do this. It makes things hard to read and dependent on architecture details, i.e. the

Re: [sqlite] bug in SQLITE_CHECKPOINT_PASSIVE?

On 09/06/2016 02:54 AM, Allen wrote: I'm doing some stress testing of an app that uses sqlite-amalgamation-3140100 compiled under gcc 4.8.5 (x86_64-posix-seh-rev0, Built by MinGW-W64 project) on Windows 7 x64 with the compile options: #define SQLITE_MAX_MMAP_SIZE0 #define

[sqlite] bug in SQLITE_CHECKPOINT_PASSIVE?

I'm doing some stress testing of an app that uses sqlite-amalgamation-3140100 compiled under gcc 4.8.5 (x86_64-posix-seh-rev0, Built by MinGW-W64 project) on Windows 7 x64 with the compile options: #define SQLITE_MAX_MMAP_SIZE0 #define SQLITE_OMIT_AUTORESET1 #define

Re: [sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference (Tcl'2016)

On 9/5/16, akupr...@shaw.ca wrote: > > Hello SQLite Users, fyi ... > > 23rd Annual Tcl/Tk Conference (Tcl'2016) > http://www.tcl.tk/community/tcl2016/ > To clarification the relevancy and appropriateness of Andreas's post above: SQLite is a TCL extension that has "escaped"

[sqlite] 3rd Call For Papers - 23rd Annual Tcl/Tk Conference (Tcl'2016)

Hello SQLite Users, fyi ... 23rd Annual Tcl/Tk Conference (Tcl'2016) http://www.tcl.tk/community/tcl2016/ November 14 - 18, 2016 Crowne Plaza Houston River Oaks 2712 Southwest Freeway, 77098 Houston, Texas, USA [[ 7...6...5...4...3...2...1... Attention! One week to the paper deadline ]] [[

Re: [sqlite] Question about Memsys5 Internals

Hi Richard, Our library runs in video games (on both consoles and mobile devices), and many game developers detest calls to malloc/free at run-time but they are happy to give me a sizable chunk in one go. So I'm using memsys5 as an optional memory pool in an attempt to reduce the number of

Re: [sqlite] Question about Memsys5 Internals

On 9/5/16, Philip Bennefall wrote: > > I am using [memsys5] as a general purpose > memory pool in my application. There is a strong feeling in some parts of the open-source community that nobody should ever attempt to build their own memory allocator. The malloc/free from

Re: [sqlite] Question about Memsys5 Internals

Thanks, Richard. I actually arrived at that by experimenting, but I had no idea whether I was doing it right. Thanks for the explanation - it confirms that I've got it set up correctly. Kind regards, Philip Bennefall On 9/5/2016 12:13 PM, Richard Hipp wrote: On 9/5/16, Philip Bennefall

Re: [sqlite] Question about Memsys5 Internals

On 9/5/16, Philip Bennefall wrote: > Hi all, > > First, if this is the wrong place to ask this question, please let me > know and I will ask elsewhere. > > I have a question about memsys5, which I am using as a general purpose > memory pool in my application. I am allocating

Re: [sqlite] Question about Memsys5 Internals

This should be computable from the base addresses returned when allocating successive objects. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Philip Bennefall Gesendet: Montag, 05. September 2016 08:22 An: General

[sqlite] Question about Memsys5 Internals

Hi all, First, if this is the wrong place to ask this question, please let me know and I will ask elsewhere. I have a question about memsys5, which I am using as a general purpose memory pool in my application. I am allocating fixed size objects, and I have set mReq to the size of that