Re: [sqlite] Are triggers the best way to store the modification time?

lumn in a separate table? It sounds like your triggering on ANY table update, not the specific table you're interested in. Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DB file locked when no other process using it - Found word(s) list error in the Text body

I'm not sure how to do this programmatically though, or how to find/release locks on other operating systems. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrew Wood Sent: 14 September 2010 14:46 To: General Discuss

[sqlite] sqlite3_open on non-DB files / corrupt DBs

of thing? Thanks, Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_open on non-DB files / corrupt DBs

> > > So... Assuming the above is how sqlite is meant to work, what would be > > the best way to ascertain if a successfully opened file is ok to use? > > Run "PRAGMA integrity_check" right after opening. Ah, that's what I was looking for! Thanks Igor, I'll

Re: [sqlite] sqlite3_open on non-DB files / corrupt DBs - Found word(s) list error in the Text body

t to be an issue, or the integrity of the database is more important than a delayed DB open (which happens in a seprate thread to my apps' main GUI, so the user won't notice an issue anyway). Thanks for all the help peeps, Nick. ___ sqlite-users mailing

Re: [sqlite] Compiler warnings in R-Tree code under Visual StudioExpress

on the file properties in Visual Studio, I get a ream of warnings, but they've yet to cause any problems at all (hence I compile with Level 3 warnings so I don't keep seeing them). Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

Re: [sqlite] can sqlite result be sorted by using "prepare-step" API

t;exec", "getTable" etc. retrieve dataset and sort by themselves after they call "prepare-step". Anybody has any idea about this? Nick Huang/Qingzhe Huang _ Stay in the

Re: [sqlite] can sqlite result be sorted by using "prepare-step" API

hi, Thanks for your reply. > nick huang wrote: > > For example, query statement is something like "select * from > > sometable order by somefield;" and we call prepare followed by step. > > And are all results returned from "step" in order o

Re: [sqlite] sqlite-users Digest, Vol 20, Issue 63

> > Message-ID: <20090824023306.gb1...@uiuc.edu> > Content-Type: text/plain; charset=us-ascii hi Jay, > > On Mon, Aug 24, 2009 at 01:55:41AM +, nick huang scratched on the wall: > > > > I am a kind of new to Sqlite and just wonder if the query result row &

Re: [sqlite] sqlite-users Digest, Vol 20, Issue 65

> > > I am currently involved in porting sqlite on mobile phone > > As an aside, you do realize that most smartphone OSes already have > SQLite available? WinCE, iPhone OS, Symbian, PalmOS, Pre, and Android > either have SQLite libs built-in to the SDK, or have a version of SQLite > that

[sqlite] Re: SQLite tests failures on Linux IA64

whereas on > an ix86 machine, a long long int is required. No biggie. Is there a patch that fixes this test failure, such that "make test" will pass on a x86_64 and x86? Cheers, Nick

Re: [sqlite] Running out of space

the vacuumed DB file out). If you do that regularly, as well as deleting unwanted records, you shouldn't run out of disk space. (Unless of course you really DO need all the data - in which case your disk needs to be bigger!) Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] sqlite3 is blocked by transaction when wanting to close the sqlite3 *

this other process, and call it from the main process when you shut down? Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of liubin liu Sent: 26 November 2009 02:29 To: sqlite-users@sqlite.org Subject: [sqlite] sqlite3

Re: [sqlite] Huge Table with only one field -- efficient way to create index ?

Out of interest, is all the data in the artnr field numeric? If so, why are you storing it as text and not an integer? Integer searching is much, much faster. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Thomas

Re: [sqlite] Huge Table with only one field -- efficientway to create index ?

) 4,294,967,296, or (signed) +/-2,147,483,648 - any higher and it's a 64 bit number. For info, 64 bit integers go up to (unsigned) 18,446,744,073,709,551,616 (20 digits) or (signed) +/-9,223,372,036,854,775,808 (19 digits). Thanks, Nick. -Original Message- From: sqlite-users-boun

Re: [sqlite] sqlite3 bind and insert double values

How different are they? Could this be [unavoidable] binary floating point storage limitations? Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Michael Lippautz Sent: 30 November 2009 13:50 To: sqlite-users@sqlite.org

Re: [sqlite] sqlite3 bind and insert double values

equations on your data set to work out such things as which GPS coordinates fall within a certain radius of a certain position (as many shop websites use on their "find your nearest store" page). Google API's website has some example functions to do just this on SQL data stored as GPS flo

Re: [sqlite] Possibly a bug in SQLite?

on the "id" column and see if it works after that. Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Brandon Wang Sent: 01 December 2009 17:06 To: sqlite-users@sqlite.org Subject: [sqlite] Possibly a bug

Re: [sqlite] Possibly a bug in SQLite?

Ok, my mistake. But would AUTOINCREMENT imply NOT NULL? Could you have an AUTOINCREMENT field with post-updated null values? Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich Sent: 02 December 2009 15:02

[sqlite] Effect of VACUUM when very low on disk space

, but does SqLite itself know the database file's size when it has the database open? It would seem more gracefully coded if I didn't have to open a separate handle to the database file just to get the file size out. Thanks, Nick. ___ sqlite-users

[sqlite] custom fts3 tokenizer, used in read-only?

table for a read-only query. Is it possible to change this behavior (or, is the tokenizer actually required for a read-only query?) If I register a dummy tokenizer with the same name in my read-only application, would that work? Nick Hodapp ___ sqlite

Re: [sqlite] custom fts3 tokenizer, used in read-only?

to the Porter tokenizer? And I can do that by registering a custom tokenizer-module in my read-only application that specifies the Porter functions, but has the name of the custom tokenizer I used to index the XHTML data. Does that seem reasonable? Nick Hodapp D. Richard Hipp wrote: > > &g

Re: [sqlite] a possible bug of select min(id) from...

uot;This amalgamation was generated on 2009-08-10 13:49:19 UTC." In sqlite3.h, there is a line @(#) $Id: sqlite.h.in,v 1.462 2009/08/06 17:40:46 drh Exp $ Some other details as following: Open DB with sqlite3_open. Open table with sqlite3_prepare/sqlite3_step Best regards, N

Re: [sqlite] a possible bug of select min(id) from...

: itandet...@mvps.org > Date: Wed, 16 Dec 2009 21:00:43 -0500 > Subject: Re: [sqlite] a possible bug of select min(id) from... > > nick huang <nickhuan...@hotmail.com> wrote: > > Say a table named "url" is created with "id" as primary key. Then a > &

Re: [sqlite] Vaccum with VB,NET

VACUUM is an SqLite SQL command, so just use it inside an sqlite3_exec() statement using "VACUUM" as the SQL string parameter. Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ernany Sent: 24 December

Re: [sqlite] speed, writing spends 30ms, reading spends 2ms, still slow

The read/write speed will depend quite a lot on disk access speed (unless you're using an in-memory DB of course), not just the database size/complexity/query. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of liubin

Re: [sqlite] sqlite3_prepare_v2

returns TRUE, you can now use MySqlite3LibVersion() to return the library version number. //... Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Teg Sent: 24 December 2009 00:57 To: General Discussion of SQLite

[sqlite] fts3 issue with tokenizing of content during a query

ns on the client, and to wrap search terms in dummy xml tags like this. But I feel I shouldn't have to do this... Any feedback appreciated... Nick Hodapp ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] mode is not changed

Depending on how you are calling sqlite3, you should be able to feed any list of commands into it. For example, under a typical Unix shell you could do sqlite3 mydb < .mode csv > .show > EOF echo: off explain: off headers: off mode: csv nullvalue: "" output: stdout

Re: [sqlite] SQLITE_ERROR with system usage

Have you run a memory test on your system? Random failings when working hard is a classic symptom of dodgy memory (launching Firefox may cause memory to be allocated for SQLite elsewhere than when there's nothing else running). I once had a system that would segfault in the C compiler in

Re: [sqlite] graphs and sql

Robert Citek wrote: > On Sun, Jan 10, 2010 at 8:06 PM, Dan Bishop wrote: >> Robert Citek wrote: >>> Does anyone have any recommendations for books or other resources that >>> deal with working with graphs (i.e. vertexes and edges) using sql? >>> >> I don't think that SQL is

Re: [sqlite] sqlite3_close ==> " library routine called out of sequence"

otherwise you may be calling sqlite3_errmsg() with a non-null invalid pointer (it'll be some random memory address if it's not nullified by sqlite3_open() on open failure), which sqlite3 attempts to use but fails, resulting in your "library routine called out of sequence" error? Nick. -

Re: [sqlite] [VB.Net] Working with SQLite?

interfaces. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault Sent: 24 February 2010 12:30 To: sqlite-users@sqlite.org Subject: [sqlite] [VB.Net] Working with SQLite? Hello I'm only getting started

Re: [sqlite] Fwd: Sqlite files in temp folder

I'd suggest Anita uses a file monitoring app (like SysInternals' DiskMon, if she's using Windows) to see what is writing those files. Then stop the app from doing it. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D

Re: [sqlite] [VB.Net] Working with SQLite?

Ah ok, in that case a 3rd party interface would probably be quickest for you. :) Good luck! Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault Sent: 24 February 2010 13:20 To: sqlite-users@sqlite.org

Re: [sqlite] [newbie/VB.Net + SQLite] Reliable file hashing?

ne by passing in a fixed string as the hash='@hash' value each time and check it does actually returns rows. My guess is there's something subtle wrong with the VB.NET code, but my VB.NET syntax knowledge is not up to the job of finding any problem I can see. :) Thanks, Nick. -Original Mess

Re: [sqlite] Executing SELECT and INSERT from C under Linux

/funclist.html. Thanks, Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Erik Kvernstad Sent: 12 April 2010 14:02 To: sqlite-users@sqlite.org Subject: [sqlite] Executing SELECT and INSERT from C under Linux I am writing a C

Re: [sqlite] Resolving Database locking issues in a multi-user environment

://www.sqlite.org/whentouse.html for specific details, as Simon Slavin recommended). Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Resolving Database locking issues in a multi-user environment

se at the same time, resulting in database corruption*." Seems pretty clear to me from that statement that SqLite would not suite your system's requirements as a central database. Nick. On Fri, Oct 19, 2012 at 4:21 PM, Nick Shaw <nick.s...@citysync.co.uk> wrote: > Richar

[sqlite] AFTER UPDATE trigger activated on INSERT?

reason the create_data_hisotry trigger is executed. Could someone explain this to me. Many Thanks Nick

Re: [sqlite] storing and comparing dates in sqlite

/1970)) - so in an INTEGER field, etc. Depends how you're going to use it. Either way I've suggested has pros/cons. Nick. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dotolee Sent: 23 January 2012 18:01 To: sqlite

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

f the file. I've got the exact same amalgamation in my VS2008 project and it builds fine. Can you check what you have for the LikeOp structure definition? Mine looks like this, and starts on line 107829: struct LikeOp { Token eOperator; /* "like&qu

[sqlite] Unicode problem when setting PRAGMA journal_mode

. Any ideas what could be wrong? We're using SqLite build v3.7.11. Thanks, Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unicode problem when setting PRAGMA journal_mode

Realised I made a typo below: should have said "PRAGMA journal_mode = DELETE" (though setting it to WAL or OFF causes the same problem). -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nick Shaw Sent: 05 April

Re: [sqlite] Unicode problem when setting PRAGMA journal_mode

it currently is (it *should* be DELETE) and see what it does. Thanks, Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unicode problem when setting PRAGMA journal_mode

. > > The results might reveal something. Oooh, good plan, thanks Dan, I'll try that. Nick. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unicode problem when setting PRAGMA journal_mode

l_mode = DELETE". I also did Simon's suggestion of setting the PRAGMA to what it already was set to (confirmed it was set to DELETE) - made no difference. Something seems amiss. I'll do some more debugging and get back to you all. Could be an error in my code which only occurs in Unico

Re: [sqlite] Unicode problem when setting PRAGMA journal_mode

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nick Shaw Sent: 11 April 2012 16:29 To: General Discussion of SQLite Database Subject: Re: [sqlite] Unicode problem when setting PRAGMA journal_mode -Original Message

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

On 12/07/2016 22:01, Richard Hipp wrote: OK. Another fix. Please try the latest trunk version. This version works for me. Thanks. Nick ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

[sqlite] Lemon doesn't reset `yyerrcnt` after error

, the error is reported for the first time. But subsequent errors aren't reported anymore. I presume this is because `yyerrcnt` should be reset to -1 somewhere in the code. Nick ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

No, this doesn't fix my problem. The check-in only changes the "#ifdef YYERRORSYMBOL" branch which I don't define. But if I add the change to the "YYERRORSYMBOL is not defined" branch as well, everything works as expected. Thanks for the quick response! Nick On 05/07/2016

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

r->yyerrcnt = -1; #endif ... #elif defined(YYNOERRORRECOVERY) ... #else /* YYERRORSYMBOL is not defined */ ... yypParser->yyerrcnt = -1; ... #endif (Another check for YYNOERRORRECOVERY isn't really needed in the third branch. It will al

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

On 08/07/2016 21:54, Richard Hipp wrote: Please try again with the latest version of Lemon. Thanks. This still doesn't work for me. I created a GitHub repo to demonstrate the problem: https://github.com/nwellnhof/lemon-bug Nick ___ sqlite

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

On 08/07/2016 21:54, Richard Hipp wrote: Please try again with the latest version of Lemon. Thanks. On 7/6/16, Nick Wellnhofer <wellnho...@aevum.de> wrote: On 05/07/2016 18:12, Richard Hipp wrote: Please try https://www.sqlite.org/src/info/2683b375ad129117 and verify that the c

Re: [sqlite] Lemon doesn't reset `yyerrcnt` after error

On 05/07/2016 17:15, Richard Hipp wrote: On 7/5/16, Nick Wellnhofer <wellnho...@aevum.de> wrote: No, this doesn't fix my problem. The check-in only changes the "#ifdef YYERRORSYMBOL" branch which I don't define. But if I add the change to the "YYERRORSYMBOL is not de

[sqlite] -Wsign-compare warning in lempar.c

With the latest Lemon code, I get a warning under GCC with -Wsign-compare: warning: comparison between signed and unsigned integer expressions [-Wsign-compare] assert( i>=0 && i+YYNTOKEN<=sizeof(yy_lookahead)/sizeof(yy_lookahead[0]) );

[sqlite] (no subject)

. The performance so far is perhaps adequate, but since it takes up almost 100% CPU to do it, it will of course tail off when I start to do anything with the data. Are there any other configuration options (per DB) that I should be considering, or other tips that might be relevant? Thanks, Nick

Re: [sqlite] perfomance optimisations on tmpfs file system

it takes up almost > 100% CPU to do it, it will of course tail off when I start to do > anything with the data. > > Are there any other configuration options (per DB) that I should be > considering, or other tips that might be relevant? > > Thanks, > Nick. _

<    1   2