Re: [sqlite] undefined reference to sqlite3_mutex_held

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel Mierswa wrote: > Couldn't it be done with something like a sqlite3.h.in which gets > preprocessed by autotools (relevant switches would be for example > --enable-debug or something) and set constants which can then be used to > opt in/out

Re: [sqlite] undefined reference to sqlite3_mutex_held

On 10.12.2009 06:32, Roger Binns wrote: > The header file has no idea what options you used when compiling the > library. This applies to much other functionality you can include/omit. > > Roger Couldn't it be done with something like a sqlite3.h.in which gets preprocessed by autotools (relevant

[sqlite] BUG: The FTS3 is broken in reliase 3.6.21

Hello! In new relise doesn't some queries. The simplest non-working query is like to: sqlite> select 1 from file_text where rowid=1 and file_text match 'document'; Error: SQL logic error or missing database sqlite> select 1 from file_text where docid=1 and file_text match 'document'; Error: SQL

Re: [sqlite] undefined reference to sqlite3_mutex_held

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel Mierswa wrote: > Though I wonder why the header does not hide the prototype when it gets > installed into the system. The header file has no idea what options you used when compiling the library. This applies to much other functionality you

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

Hello! On Thursday 10 December 2009 04:04:34 Roger Binns wrote: > Thanks! The great idea. Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] undefined reference to sqlite3_mutex_held

On 10.12.2009 05:42, Dan Kennedy wrote: > sqlite3_mutex_held() is only defined if SQLite is built with > SQLITE_DEBUG defined. Looks like this was not the case when > the library linked to by -lsqlite3 above was compiled. I wrote exactly that in my initial mail to the list. Though I wonder why the

Re: [sqlite] undefined reference to sqlite3_mutex_held

On Dec 10, 2009, at 11:19 AM, Daniel Mierswa wrote: > On 10.12.2009 01:22, Shawn Wilsher wrote: >> See https://bugzilla.mozilla.org/show_bug.cgi?id=533171 (this isn't >> really a >> SQLite issue). > I'm not sure what you mean. I can reproduce it without any Thunderbird > code involved at all.

Re: [sqlite] undefined reference to sqlite3_mutex_held

On 10.12.2009 01:22, Shawn Wilsher wrote: > See https://bugzilla.mozilla.org/show_bug.cgi?id=533171 (this isn't really a > SQLite issue). I'm not sure what you mean. I can reproduce it without any Thunderbird code involved at all. impu...@istari ~ $ echo -e "#include \n int main() {

Re: [sqlite] .importing file into a BLOB

Ted, >Is it the command-line program misinterpreting the CR/LFs? Unfortunately, any command-line tool will interpret control characters at their face value when they are fed directly. With no ad hoc program doing it for you, the solution, as I've discussed at length before and even if it is

Re: [sqlite] Using pivot table

Walter wrote: > I have the following tables > > CREATE TABLE data( > id INTEGER PRIMARY KEY NOT NULL, > name TEXT DEFAULT '', > titleTEXT DEFAULT '', > > ) > > > CREATE TABLE pivot( > id INTEGER PRIMARY KEY NOT NULL, > link1INTEGER DEFAULT

[sqlite] Using pivot table

I have the following tables CREATE TABLE data( id INTEGER PRIMARY KEY NOT NULL, name TEXT DEFAULT '', titleTEXT DEFAULT '', ) CREATE TABLE pivot( id INTEGER PRIMARY KEY NOT NULL, link1INTEGER DEFAULT 0, link2INTEGER DEFAULT 0, rank INTEGER DEFAULT 0,

Re: [sqlite] .importing file into a BLOB

.import imports data from a file in CSV format. In a CSV file a newline indicates a new record. If you want all your data to be in one record have all your data on one line. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] .importing file into a BLOB

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 09 Dec 2009 11:48:31 -0800 Roger Binns wrote: > http://catb.org/~esr/faqs/smart-questions.html What wasn't clear? I apologize for any murkiness. My understanding is that a BLOB takes any piece of data and stores it

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: > I want to build a universal extension for logging all user queries. I can > write > this with trace function but it's difficult or impossible to split system and > user queries. There are two ways that can be done. The

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

Hello! On Thursday 10 December 2009 02:36:25 Simon Slavin wrote: > Do not rely on the operation of 'trace' in production code. It's a debugging > feature only. But why? I think with additional query type argument the trace function will be useful in production for database logging and

Re: [sqlite] undefined reference to sqlite3_mutex_held

See https://bugzilla.mozilla.org/show_bug.cgi?id=533171 (this isn't really a SQLite issue). Cheers, Shawn On Wed, Dec 9, 2009 at 3:32 PM, Daniel Mierswa wrote: > Hi list, > when I try to build the current thunderbird 3.0 release against > sqlite-3.6.21 i get an undefined

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

On 9 Dec 2009, at 11:16pm, Alexey Pechnikov wrote: > I want to build a universal extension for logging all user queries. I can > write > this with trace function but it's difficult or impossible to split system and > user queries. Do not rely on the operation of 'trace' in production code.

Re: [sqlite] iPhone App close database

On 9 Dec 2009, at 11:13pm, Greg Walters wrote: > I am looking for some general information regarding closing the sqlite > database when used from an iPhone app. Since you never know when you app will > go away, when do you close the database. I have found one example application > that closes

[sqlite] undefined reference to sqlite3_mutex_held

Hi list, when I try to build the current thunderbird 3.0 release against sqlite-3.6.21 i get an undefined reference to sqlite3_mutex_held, with 3.6.19 that didn't occur. When i compile sqlite3 with -DSQLITE_DEBUG the symbol is exported, now I wonder if this symbol is not supposed to be exported in

Re: [sqlite] pthreadMutex

Thanks Thomas, My problem was when I compile the code with gcc I used like this: # gcc sqlite3.c code.c -o test -lpthread -ldl Work fine! Thanks again. Gustavo Tonello On Dec 9, 2009, at 8:52 PM, Thomas Mittelstaedt wrote: > Luiz, > > You may try to compile

Re: [sqlite] pthreadMutex

Gustavo Tonello On Dec 9, 2009, at 8:52 PM, Thomas Mittelstaedt wrote: > Luiz, > > You may try to compile with -pthread in the compile flags. > > Am Mittwoch, den 09.12.2009, 00:12 -0200 schrieb Luiz Gustavo P > Tonello: >> undefined reference to

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

Hello! On Thursday 10 December 2009 01:36:39 Roger Binns wrote: > My point was that if you only want to log queries your code makes then alter > your code. For example instead of calling sqlite3_prepare/bind directly you > can make wrapper functions that log the query and bindings. And because

[sqlite] iPhone App close database

Hi, I am looking for some general information regarding closing the sqlite database when used from an iPhone app. Since you never know when you app will go away, when do you close the database. I have found one example application that closes the database after getting data and doing updates.

Re: [sqlite] pthreadMutex

Luiz, You may try to compile with -pthread in the compile flags. Am Mittwoch, den 09.12.2009, 00:12 -0200 schrieb Luiz Gustavo P Tonello: > undefined reference to `pthread_mutexattr_init' -- thomas ___ sqlite-users mailing list

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > The second argument with query type [user|system] for trace function > will be very helpful. And third argument for profile function. But may be > exists another way for logging only user queries?.. I'm sorry but I can not understand what you are

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

Hello! On Wednesday 09 December 2009 22:49:53 Roger Binns wrote: > Since you are the "user" you can do your own logging to the SQLite API > recording whatever information you want. The second argument with query type [user|system] for trace function will be very helpful. And third argument for

Re: [sqlite] The trace command show system queriel like analyze, vacuum...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alexey Pechnikov wrote: > As you can see internal system queries are visualized too. It's may be useful > for developers but very bad for users becouse it's impossible to log only > user-applied queries. Since you are the "user" you can do your own

Re: [sqlite] USING bug

> > On Dec 9, 2009, at 3:42 AM, Wiktor Adamski wrote: > > > > SQLite version 3.6.21 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> create table t1(a int); > > sqlite> create table t2(a int); > > sqlite> create table t3(a int, b int); > > sqlite>

Re: [sqlite] [sqlite-dev] query on sqlite3_open16

> According to documentation on CreateFile() function: "In the ANSI > version of this function, the name is limited to MAX_PATH characters. > To extend this limit to 32,767 wide characters, call the Unicode > version of the function and prepend "\\?\" to the path." > > SQLite is already calling

Re: [sqlite] how to show blob data while select in sqlite3 shell?

Thanks!!! SimonDavies wrote: > > 2009/12/9 liubin liu <7101...@sina.com>: >> >> sqlite> INSERT OR REPLACE INTO periods_value VALUES (0, 1, >> x'000102030400a0afaabbaa'); >> sqlite> >> sqlite> SELECT * FROM periods_value; >> 0|1| >> sqlite> >> >> how to show the blob data? > > Select id,

Re: [sqlite] Commit failing due to DB locked.

Hi Thanks for responding, I've added my comments in below. On Dec 9, 2009, at 11:30 AM, Kees Nuyt wrote: > On Tue, 08 Dec 2009 22:07:34 +0100, John Clayton > wrote: > >> Hi >> >> I've got two processes opening up two sqlite databases. Assuming the >> databases are called A

Re: [sqlite] how to show blob data while select in sqlite3 shell?

2009/12/9 liubin liu <7101...@sina.com>: > > sqlite> INSERT OR REPLACE INTO periods_value VALUES (0, 1, > x'000102030400a0afaabbaa'); > sqlite> > sqlite> SELECT * FROM periods_value; > 0|1| > sqlite> > > how to show the blob data? Select id, valid, hex( value ) from periods_value; Regards, Simon

Re: [sqlite] BUG: the rowid column in view is automatically named as id

Hello! On Wednesday 09 December 2009 15:07:16 Pavel Ivanov wrote: > It's been said in this list not once already: unless you're using "as > ..." to name the column it's not guaranteed to have any particular > name you expect it to. So it's not a bug. This is bug becouse the column with alias

[sqlite] how to show blob data while select in sqlite3 shell?

[...@** createdb]$ [...@** createdb]$ sqlite3 ./db_ctrl_0.1.db SQLite version 3.6.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE periods_value (id INTEGER PRIMARY KEY, valid CHAR(1), value BLOB ); sqlite> sqlite> INSERT OR REPLACE INTO

Re: [sqlite] [sqlite-dev] query on sqlite3_open16

According to documentation on CreateFile() function: "In the ANSI version of this function, the name is limited to MAX_PATH characters. To extend this limit to 32,767 wide characters, call the Unicode version of the function and prepend "\\?\" to the path." SQLite is already calling CreateFileW()

Re: [sqlite] BUG: the rowid column in view is automatically named as id

It's been said in this list not once already: unless you're using "as ..." to name the column it's not guaranteed to have any particular name you expect it to. So it's not a bug. Also: sqlite> create table test (id INTEGER PRIMARY KEY, a text); sqlite> insert into test (a) values (1); sqlite> .h

[sqlite] BUG: the rowid column in view is automatically named as id

Hello! $ sqlite3 SQLite version 3.6.20 sqlite> create table test (id INTEGER PRIMARY KEY, a text); sqlite> insert into test (a) values (1); sqlite> create view view_test as select rowid,* from test; sqlite> .header on sqlite> select * from view_test; id|id:1|a 1|1|1 Best regards, Alexey

Re: [sqlite] USING bug

On Dec 9, 2009, at 3:42 AM, Wiktor Adamski wrote: > SQLite version 3.6.21 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t1(a int); > sqlite> create table t2(a int); > sqlite> create table t3(a int, b int); > sqlite> insert into t1 values(1);

Re: [sqlite] Commit failing due to DB locked.

On Tue, 08 Dec 2009 22:07:34 +0100, John Clayton wrote: >Hi > > I've got two processes opening up two sqlite databases. Assuming the > databases are called A and B respectively, then both processes do this: > using A, BEGIN IMMEDIATE > using B, BEGIN IMMEDIATE

Re: [sqlite] SQLite version 3.6.21

>> And what compiler are you using that is sensitive to these violations >> yet generates no warnings? > > It's the very nature of undefined behaviour that it does not require a > warning. Welcome to the world of C. Is the compiler you use a secret? Do you have to kill us if you tell the