Re: [sqlite] Typos in the documentation

2017-11-09 Thread nomad
On Thu Nov 09, 2017 at 09:53:45PM +0100, Philip Newton wrote: > > https://www.sqlite.org/inmemorydb.html under "Testing Services" near > the end has this as its final sentence: > > "Hardware or system manufactures who want to have TH3 test run on > their systems can negotiation a service

Re: [sqlite] Does wal-file support MMAP？

2017-11-09 Thread Simon Slavin
On 10 Nov 2017, at 5:35am, advancenOO wrote: > In multi-thread scenario, I guess that threads may not use MMAP correctly > after one thread truncates wal-file. And that is the reason MMAP can not be > used together with WAL mode. Are the threads using the same

Re: [sqlite] Does wal-file support MMAP？

2017-11-09 Thread advancenOO
In multi-thread scenario, I guess that threads may not use MMAP correctly after one thread truncates wal-file. And that is the reason MMAP can not be used together with WAL mode. So, I am wondering if I can simply make the size of Wal-file a fixed size to support MMAP for wal-file. -- Sent

Re: [sqlite] Typos in the documentation

2017-11-09 Thread Richard Hipp
On 11/9/17, Peter Da Silva wrote: > Also perhaps “page cache” rather than “pager cache”? The "pager cache" is the cache that belongs to the "pager" module. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] Typos in the documentation

2017-11-09 Thread Peter Da Silva
Also perhaps “page cache” rather than “pager cache”? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typos in the documentation

2017-11-09 Thread Richard Hipp
On 11/9/17, Philip Newton wrote: > Hello, I would like to report two typos in the documentation on the > website - I hope this is the appropriate forum to do so. It is. Problems fixed now. Thanks. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Simple Search using LIKE or something else

2017-11-09 Thread Peter Da Silva
On 11/9/17, 2:51 PM, "sqlite-users on behalf of Stephen Chrzanowski" wrote: > I've added a simple filter function that uses SQLites LIKE operator, but I'd > like something a little bit more advanced. Right now, the

Re: [sqlite] Simple Search using LIKE or something else

2017-11-09 Thread Jens Alfke
> On Nov 9, 2017, at 12:50 PM, Stephen Chrzanowski wrote: > > Is there any trick I can use that'll return AbcRfeDef and FedRfeAbc if > the two keywords are Abc and Def from a SQL call? Use full-text search (FTS4 or FTS5). This is exactly what it’s for. Or as a hacky

[sqlite] Typos in the documentation

2017-11-09 Thread Philip Newton
Hello, I would like to report two typos in the documentation on the website - I hope this is the appropriate forum to do so. https://www.sqlite.org/inmemorydb.html under "Testing Services" near the end has this as its final sentence: "Hardware or system manufactures who want to have TH3 test

[sqlite] Simple Search using LIKE or something else

2017-11-09 Thread Stephen Chrzanowski
I've written Win32 desktop alarm clock that can store unlimited number of alarms (Pending drive space, of course). The problem I'm having is that right now, I've got about 20 alarms for things I need to do over the next couple of weeks that its getting harder to find what I need to update if

Re: [sqlite] Using .testcase and .check in continuous integration test

2017-11-09 Thread Dominique Devienne
On Tue, Oct 17, 2017 at 3:52 PM Dominique Devienne wrote: > On Tue, Oct 17, 2017 at 3:16 PM, Lodewijk Duymaer van Twist < > lodew...@adesys.nl> wrote: > >> Thank you for investigating. You're fix works. Should I repost this as a >> bug with your fix, or will this be picked

[sqlite] tiny doc suggestion for FTS5

2017-11-09 Thread Mark Summerfield
Hi, This page: https://www.sqlite.org/fts5.html has examples such as: SELECT * FROM email WHERE email = 'fts5'; I find this really confusing. Basically _any_ other text to search for would be better, e.g.: SELECT * FROM email WHERE email = 'target'; -- or 'findme' or 'some text' Best wishes,