Re: [sqlite] SQLite4 (don't scream)

on x64 Linux: libsqlite3.a 5214256 libsqlite4.a 3753496 but again, that is not necessarily any indication of what it will look like in 13 hours or 6 months. Nor does it give any hint about what the different will mean for clients linked to it. -- - stephan beal http://wanderinghorse.net/home/stepha

Re: [sqlite] database busy error

ockingv3.html Search for SQLITE_BUSY to see what can cause that. Other docs (which i can't seem to find at the moment) explain how to deal with BUSY in your app. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-user

Re: [sqlite] SQLite Provenance

ne in the UK(?). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Provenance

On Sat, Jul 7, 2012 at 12:24 AM, Gavin T Watt <gw...@raytheon.com> wrote: > BTW, do you know if the SQLite team runs any kind of static code analysis > on the source? > http://www.sqlite.org/testing.html -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://

Re: [sqlite] SQLite Provenance

t to compile without warnings than have been found by static analysis." -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] link error on dlopen dlerror reference undefined

d not taken good care of the order of the -lxxx flags relative to my own .o/.a files which use symbols from the -lxxx libraries. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] svn: SQLite compiled for 3.6.20, but running with 3.6.4

t; /lib/x86_64-linux-gnu/libc.so.6 (0x7f07c9da1000) /lib64/ld-linux-x86-64.so.2 (0x7f07ca396000) -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http:/

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

efile.linux-gcc. GNU make will prefer the file GNUmakefile over Makefile if it exists. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bi

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

or copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. stephan@tiny:~/cvs/fossil/sqlite4$ uname -a Linux tiny 3.0.0-12-generic #20-Ubuntu SMP Fri Oct 7 14:50:42 UTC 2011 i686 i686 i386 GNU/Linux -- - stephan beal http://wanderinghorse.net/home/ste

Re: [sqlite] How to build sqlite4? Which branches are expected to build?

t; the past year or so. That branch is needed to compile sqlite. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] C++ - WHERE clause

r programming language of choice. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Exec vs Prepare, step, finalize.

ry much preferred in most cases, but > wondered if those cases where SQL is application provided were an > exception. I'm leaning towards a no on that now. Thanks for your input and > in advance or any additional insight. > FWIW, internally, exec() is just a proxy for prepare/step/finalize

Re: [sqlite] [Spellfix] Inexplicable discrepancy concerning query results

nges the result, so it is not the > case, that SQLite does not process the scope operation via the > Python-SQLite interface. > > Any idea? > It sounds to me like your python and local sqlite shell are using different sqlite versions. -- - stephan beal http://wanderingho

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

gram (neither of which include a schema design tool). Server Explorer is a 3rd-party product. -- - stephan beal http://wanderinghorse.net/home/stephan/ "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect wo

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

creen the lines > of text stretch to the whole browser width, which is not very readable. > A counter-opinion, though apparently in the small minority: i _absolutely despise_ fixed-width web site layouts. -- - stephan beal http://wanderinghorse.net/home/stephan/ "Freedom is s

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

o business assuming they do. It's likely that assumption about my preferences/limits which annoys me more than the limitation itself does. -- - stephan beal http://wanderinghorse.net/home/stephan/ "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a

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

annot be done anywhere near reliably. They are free-form strings, often intentionally obfuscated (MSIE does this now, we recently discovered, presumably to try to keep people from implementing IE-specific workarounds). -- - stephan beal http://wanderinghorse.net/home/stephan/ "Freedom is s

Re: [sqlite] Why MMAP return ENOMEM in SQLite?

M, so you can't memmap 3.2G. In any case, as Simone said, _other apps_ require memory of their own as well. Your app does not have that whole 2G to itself. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ "Freedom is sloppy. But since tyranny's the only guaranteed byproduct

Re: [sqlite] Why MMAP return ENOMEM in SQLite?

On Wed, Aug 31, 2016 at 10:43 AM, Stephan Beal <sgb...@googlemail.com> wrote: > On Wed, Aug 31, 2016 at 10:39 AM, sanhua.zh <sanhua...@foxmail.com> wrote: > >> In my testcase, I can only [mmap] a db file at most 1.4GB size. But in >> this new way, I can map a file

Re: [sqlite] Why MMAP return ENOMEM in SQLite?

r more, bigger problems than the perceived performance problems you have right now. The chances that something breaks with that approach is, i suspect, very high. You will eventually corrupt a database and then write back to the list to ask why that approach corrupted it. -- - stephan beal ht

Re: [sqlite] Why MMAP return ENOMEM in SQLite?

akes 10ms or 800ms should, for such platforms, be irrelevant. i _suspect_ that you are overestimating the impact of your perceived performance problem on the end users. But that's all just my opinion based on experience - i have no facts or statistics to back it up. Maybe it will work well for you. --

<    2   3   4   5   6   7