[sqlite] Forthcoming release of SQLite 3.7.1

p;to=trunk&detail=1 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

Ping about the above. Or have the fixes already been made and we just need > to upgrade to new sqlite? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bi

Re: [sqlite] Sizeof tables

ements for each table so > that I can see which tables are the memory consumers? > > Regards, > Luke > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user

[sqlite] SQLite Version 3.7.1

from 3.7.0 is recommended. Please report any problems to the SQLite mailing list at sqlite-users@sqlite.org or directly to me. Thank you. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] SQLite Version 3.7.1

gt; http://pechnikov.tel/ > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-

[sqlite] Possible database corruption bug in SQLite

3.7.1, you might want to hold back for a day or two to see what our investigation of this new problem turns up. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] SQLite version 3.7.2

s to the sqlite-users@sqlite.org mailing list, or directly to me. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Precompiled binary for sqlite3_analyzer requires libicui18n.so.44?

any assistance and my apologies if my > ignorance has created "noise" on the list. > > -- > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D.

Re: [sqlite] Suggestion for project: Chat

With best wishes > > Artur Reilin > sqlite.yuedream.de > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] upstreaming Chromium patches for file handle passing support

lite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.7.2

sed > version, on OSX Tiger (10.4), results in an undefined reference to > gethostuuid. Is OSX 10.4 no longer supported? > > Thanks, > Jim > -- > HashBackup: easy onsite and offsite Unix backup > http://sites.google.com/site/hashbackup > > > On Mon, Aug 23, 2010 at 9:01 P

Re: [sqlite] Sqlite on NAND flash devices...

it from quick wear out? If no, how is the writes > to the main DB different from the writes to the journal? > > Thanks > Pankaj > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/

Re: [sqlite] upstreaming Chromium patches for file handle passing support

etter > within > SQLite's design? Please let me know if you have more questions about how we > currently use SQLite, the multi-process architecture of Chrome, etc. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] upstreaming Chromium patches for file handle passing support

On Tue, Aug 31, 2010 at 1:56 PM, Paweł Hajdan, Jr. wrote: > On Tue, Aug 31, 2010 at 10:51, Richard Hipp wrote: > > > My suggestion is that you make a copy of the os_unix.c source file (call > it > > chromium_vfs.c or anything else that you like) and apply your edits to &g

Re: [sqlite] sqlite 3.7.2 doesn't compile if SQLITE_OMIT_WAL is defined

ardless SQLITE_OMIT_WAL. > See http://www.sqlite.org/src/info/d1ed743b6e > > > > Best regards > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql

Re: [sqlite] Feature request: copying vacuum

greater than any savings seen through a reduction in disk FS fragmentation. > > Thanks, > Taras > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Tcl bindings are a little problematic.

k. > > Regards, > -- > Paweł Salawa > p...@bitrock.com > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] memory wasted shm mapped file (3.7.2)

the DB file. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] memory wasted shm mapped file (3.7.2)

er "Most" in the previous sentence. There are exceptions to the rule. We try to optimize for the common case.) > > Marcus > > > > > > > > > Il 02/09/2010 14.43, Richard Hipp ha scritto: > >> On Thu, Sep 2, 2010 at 8:34 AM, Michele Pradella< > michele.

[sqlite] Fwd: Question about SQLite

your computer* -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Altering primary key in trigger produces incorrect last_insert_rowid() value

sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Method to load Sqlite DB (disk) directly into memory

__ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Method to load Sqlite DB (disk) directly into memory

rs mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Detecting storage class from C

ed. It is flexibly typed. And all those other SQL database engines are "rigidly" typed. Flexible typing in SQLite is a Good Thing, for the same reason that it is a good thing in AWK, TCL, Perl, Python, Ruby, Lua, Javascript, etc. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Freelist walking and location of free blocks

so I am not sure how to > follow the free block list. > > Any help comments? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] SQLITE_ENABLE_ATOMIC_WRITE on windows, good or bad?

r be used. You might as well leave it turned off, to save code space, and a couple of branch instructions in the pager. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user

Re: [sqlite] memory wasted shm mapped file (3.7.2)

gt; or > >> system failure is higher and higher each day :) > >> > >> Max > >> ___ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinf

Re: [sqlite] Will a read-only transaction cause writes to the WAL?

here any statistics about actual writes I can query to analyze > write-behavior of my software? > > Thanks in advance! > > Best regards, > Martin > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlit

Re: [sqlite] VACUUM can actually increase the DB file?

gt; Kyle > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] IS [NOT] DISTINCT FROM

valuate to NULL then (expr1) IS (expr2) is true but (expr1)=(expr2) is NULL. > > ? > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] Trouble with constraints and triggers

ecipient WHERE recipient.recipient_id= message_recipient.recipient_id); > > -- > Igor Tandetnik > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cg

Re: [sqlite] How does xBestIndex know that a LIKE query is case insensitive?

t the collating sequence is NOCASE. > > Thanks, > Ben > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] [OS/2] Update OS/2 support in sqlite 3.7.x

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help: Required help/guidance for the segmentation fault in sqlite3 library to proceed further...

p of sq1lite3. > > Libdbi -0.8.3 version > > > > > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS3 MATCH syntax

cssoftware.com> > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Massive performance regression in 3.7.x

age_table on page_table.version=3 and page_table.objectid = > object_formats.objectid ; > > Thanks, > > Charles > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org

Re: [sqlite] Massive performance regression in 3.7.x

On Sat, Sep 25, 2010 at 10:54 AM, Max Vlasov wrote: > On Sat, Sep 25, 2010 at 6:35 PM, Richard Hipp wrote: > > > > > You have a very unusual data distribution in your tables. SQLite does > not > > know this and so it chooses a query plan (in 3.7.1 and later) that &g

Re: [sqlite] Massive performance regression in 3.7.x

rg > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] processing a sql script from the C API?

> of text and ask ``is this a query yet?'' > > See http://www.sqlite.org/c3ref/complete.html > -- > Dustin Sallings > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http:/

Re: [sqlite] SQLite B-tree API

program in assembly language when you have Python/Perl/Ruby/Tcl available? > > - sam > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/s

Re: [sqlite] bug in the ./configure script inside sqlite-3_7_2-tea.tar.gz

sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting unique years from a timestamp column

year > individually, but I don't want to hard-code the year that I'm looking for, > if you get my meaning. > > Any assistance on this would be appreciated. Thanks! > SELECT DISTINCT strftime('%Y',date) FROM data; > > Bobby > ___

Re: [sqlite] data consistency issues in WAL

__ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] data consistency issues in WAL

t; > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] errors after sqlite3_step

gt; sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] errors after sqlite3_step

__ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-user

Re: [sqlite] SQLite working with C++'s iostream

> > iEYEARECAAYFAkypa/EACgkQmOOfHg372QRugwCguKqqfXhf2+/jrwDYnYwid7CY > mjkAn1JnTYIhlKey7YW6QumIWe4oLwJR > =5hwL > -END PGP SIGNATURE- > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D.

Re: [sqlite] No error on UPDATE setting duplicated value on UNIQUE column.

the end is to ensure that other constraint violation raises > error > correctly. > Maybe you should remove the "ON CONFLICT IGNORE" clause at the end of the uniqueness constraint... > > Same behaviour takes place for tclsqlite extension. > > Regards, > -- > Paweł S

Re: [sqlite] [BUG] JOIN subquery in FROM with FTS3 table

ers@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and C++ in Linux

lem it'd be appreciated. I've searched > everywhere and i can't find any answers. > > Thank You, > Dan > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Tcl bindins problem, once again

nd with 2 calls mixed. First is "db eval > $query arr {...}" to collect list of result columns and second "set > results [db eval $query]" to get all values. > It works, but it causes additional query execution. It's a workaround, > not a solution. > Shou

Re: [sqlite] create_function_v2 destructor bug or doc issue

wk/v > MtAAnjXC04WWTVcWHz5NU3xxsX1mEHpK > =tJwO > -END PGP SIGNATURE- > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ s

Re: [sqlite] create_function_v2 destructor bug or doc issue

ence program crash when SQLite is dynamically linked. > Turns out there is a bug in sqlite3_create_collation_v2() which would cause it to return SQLITE_OK even if it failed to create a collation due to an OOM (out-of-memory) error. So apparently even the fastidious Binns-code can fail to

Re: [sqlite] Detach command in 3.7.1 gives "database is locked" error

> > Thanks, > Jim > -- > HashBackup: easy onsite and offsite Unix backup > http://sites.google.com/site/hashbackup > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] Lemon maintainer

er-priced. But it looks like you can get a used copy from Amazon for just a few bucks. http://www.amazon.com/Compilers-Principles-Techniques-Alfred-Aho/dp/0201100886 > > -- > --- You know you've achieved perfection in design, not when you have > nothing more to add, but when you

Re: [sqlite] handling of BLOB bound parameters

That only happens when you are using sqlite3_trace() to record the text of each SQL statement as it is evaluated. And that normally only happens during debugging. > > Thanks, > -jens > > _______

Re: [sqlite] Is the SYNTAX diagram wrong

de is correct. > > -- > Alan Chandler > http://www.chandlerfamily.org.uk > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sql

Re: [sqlite] is it really ok to allow non-aggregates in an aggregate line?

d I've > > > modified it so that when inserting/updating the time, its done with the > > > date('2010-10-18 04:08:04','utc') to do the conversion, and the math > > works > > > without using UTC or LOCALTIME in the strftime functions but I'd still > > like > > &g

Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

t; > Seems the planner has missed creating an index for the second nested > SELECT. > > The flock_owner table has an index on each of flock_no, owner_person_id > and owner_change_date. > > Pete > -- > Peter Hardman > Breeder of Shetland sheep and cattle > ___

Re: [sqlite] Collations, BLOB and index - strange output provided by EXPLAIN QUERY PLAN

a corresponding row in tmp using its >primary key > c) the loop over lol is complete, there is `COLLATE foobar` then >I call the cmp function... > > > Mathieu > ___ > sqlite-users mailing list > sqlite-users@sqlite.org

Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

g an index for the second nested > SELECT. > Should be fixed in http://www.sqlite.org/src/info/d30f7b2def -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL file growth concern

Are you *sure* you aren't accidentally holding a read transaction open somewhere? Do you have any other clues on how we can isolate the problem? A test case that will we can run here, perhaps? -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] WAL file growth concern

of the WAL where writes start to slow down. But the WAL got a little bigger so more writes go fast on the next cycle, and the WAL grows a little more. And so forth. Is that what you are seeing? Which filesystem are you using? -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] SQLite type question

usly for 292 years before you run out. > > Thank you for your time! > > Kind regards, > Kelly > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG

v. > http://pechnikov.tel/ > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG

t count(*) from test; > ---- > > -- > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compilation flags required for amalgamation

gt; > -- > Navaneeth > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

0/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > View this message in context: > http://old.nabble.com/iPhone-iPad-Database-Disk-Image-Malformed-tp30118432p30118566.html > Sent from the SQLite mailing list archive at Nabble.com. > > _

Re: [sqlite] filling an in-memory database from a byte stream?

emory database from a data stream. But you can write a really simple VFS (http://www.sqlite.org/c3ref/vfs.html) that implements a "filesystem" consisting of a single read-only file contained in memory, then register this VFS using sqlite3_vfs_register() then load your remote database into

Re: [sqlite] sqlite from fossil

ync off before you do the fossil update > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sqlite from fossil

On Thu, Nov 4, 2010 at 3:52 AM, Hakki Dogusan wrote: > Hi, > > 03/11/2010 23:51, Benjamin Peterson wrote: > > Richard Hipp writes: > >> Try setting: > >> > >> fossil setting autosync off > >> > >> before you do the > >&

Re: [sqlite] sqlite from fossil

e internet protocol supports such a concept. If you want to try to patch something, search for HTTP_SERVER_LOCALHOST in the Fossil source tree to find the relevant places in the code. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R*Tree module and double precision?

; Jeff Archer > Nanotronics Imaging > jsarc...@nanotronicsimaging.com > <330>819.4615 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > >

Re: [sqlite] To close or not to close

-trivial cost to opening and closing connections. > > > Thanks, > > Chris > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bi

Re: [sqlite] sqlite/fts3 feature request: select snippet() from fts3 where docid=1

e document to return? > > Thanks! > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] btreeInitPage() returns error code 11

urns error code 11 > Page 162228: btreeInitPage() returns error code 11 > Page 162229: btreeInitPage() returns error code 11 > Page 162230: btreeInitPage() returns error code 11 > Page 162231: btreeInitPage() returns error code 11 > Page 162232: btreeInitPage() returns error code

Re: [sqlite] uncertainty how load_extension is supposed to work

ot;libmylib.dll" on Windows, etc. > > Is that how it is? > > Can it be documented on this page? : > > http://www.sqlite.org/lang_corefunc.html#load_extension > > > Thanks, > > > -Chris > > > ___ > sqlite-users m

Re: [sqlite] SQLITE3 - sqlite3_step bug?

s. Could this > be? > If column is not indexed, then SQLite has to loop through all 11GB of your database file looking for the maximum value. That can take time (though measured in 10s of seconds, not hours). What does it say if you prepend EXPLAIN QUERY PLAN to the beginning of your qu

Re: [sqlite] WAL and multiple writers?

temp_store=memory",0,0,0); > > > > And obviously the following as well: "PRAGMA journal_mode=wal" > > Try /just/ the "PRAGMA journal_mode = WAL". Stick with just this PRAGMA > until you get it working in some shape or form. > > Simon. > ___

Re: [sqlite] uncertainty how load_extension is supposed to work

qlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] threads and last_insert_rowid()

ads are in play. There are merely differing levels of hazard. So the best solution to your problem, Ruslan, is to not use threads. Failing that, allocate a separate database connection for each thread. If you can't do that, then you are going to have con

Re: [sqlite] threads and last_insert_rowid()

> sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mai

Re: [sqlite] sqlite_sequence table

> Will Duquette -- william.h.duque...@jpl.nasa.gov > Athena Development Lead -- Jet Propulsion Laboratory > "It's amazing what you can do with the right tools." > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/c

Re: [sqlite] creating a sqlite db on raw disk ?

ng people has the tendency to make them > feel uncomfortable." -- Angela Johnson > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Command line client and Tcl interface behaves differently?

hat could be wrong? > > Thankful for all the help I could get on this. > > /Fredrik > > > -- > "Life is like a trumpet - if you don't put anything into it, you don't > get anything out of it." > ___ > sql

Re: [sqlite] Loading a FTS3 table into ram without reindexing

On Sun, Nov 21, 2010 at 7:49 PM, boscowitch wrote: > > or can i advise sqlite to load at least the whole pre generated index > into the ram to speed it up? > http://www.sqlite.org/backup.html -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Does sqlite uses xAccess to check the main db existence?

eck the filename before returning your answer, I think. > > Thanks > > Max Vlasov > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard

Re: [sqlite] Does sqlite uses xAccess to check the main db existence?

not impose any restrictions on the names of database files. On the other hand, SQLite doesn't make filenames up. It only uses the filenames you pass into sqlite3_open() or give to the ATTACH command. You control those interfaces, so you can determine which names are valid and which

Re: [sqlite] Pointers wanted for debugging an SQLITE_CORRUPT error

lt;http://www.avocent.com> > www.emersonnetworkpower.com > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL for single user database on nfs

at will be a safer approach. > > Thanks. > > Pete. > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.or

Re: [sqlite] Cppcheck error

please keep our team > in the loop and CC: supp...@datasplice.com > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] glob and like not using index in newest sqlite

lumn can result in an incorrect answer. See http://www.sqlite.org/cvstrac/tktview?tn=3901 Your fix is to declare column "word" to have type TEXT. > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.o

Re: [sqlite] Possible bug: wrong query result when using an index

_name IN ... > > Instead of: > > (entry_types.name = 'cli_command' AND entry_id IN ... > > So, we're back where we started. > > Regards, > > -- Gavrie > > ___ > sqlite-users mailing list > sqlite-users@sqlite.o

Re: [sqlite] need help on escaping the ']' character in the identifier

users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_CORRUPT when PRAGMA max_page_count is reached

saction in advance. The journal_mode=OFF parameter is not a recommended setting for applications that care about data preservation. > Thanks in advance, > > Andrei > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

sqlite3_analyzer there. Bummer. > -- > Marco Bambini > http://www.sqlabs.com > > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin

Re: [sqlite] occasional SQLITE_PROTOCOL on synchronous=normal with WAL

suggestions for digging a little deeper on this problem? > > -- Michael Barton > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.o

Re: [sqlite] occasional SQLITE_PROTOCOL on synchronous=normal with WAL

t > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

In Tue, Dec 7, 2010 at 7:15 PM, Richard Hipp wrote: > On Tue, Dec 7, 2010 at 6:22 PM, Marco Bambini wrote: >> Running sqlite3_analyzer on a MacOS X 10.6.5 results in the following issue: >> >> dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib >>  Referenced

Re: [sqlite] SQLite-3.7.4 Amalgamation?

autoconf- product contains sqlite3.c together with a configure script, ready to build on your unix-like machine. > > Rich > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqli

<    1   2   3   4   5   6   7   8   9   10   >