Re: [sqlite] command line does not accept arrow keys

On Fri, Nov 20, 2009 at 10:29:20PM -0500, Qianqian Fang scratched on the wall: > Is this possibly caused by how sqlite binary was compiled? Yes. Readline support is not on by default. You need to compile it with -DHAVE_READLINE and add -lreadline to the linker: $ cc -DHAVE_READLINE -o

Re: [sqlite] Problem with database (SELECT hangs)

On November 20, 2009 08:11:26 pm Simon Slavin wrote: > On 21 Nov 2009, at 12:57am, Phil Longstaff wrote: > > I have an sqlite3 database where a SELECT hangs. The statement is: > > > > SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE > > s.tx_guid=t.guid AND ((s.account_guid IN > >

Re: [sqlite] command line does not accept arrow keys

I don't know, is there a way I can tell? the binary was downloaded from sqlite website, version is 3.6.2. The binary stores in a remote server, running Debian 3, I used ssh in a Terminator/gnome-terminal bash shell. I also installed sqlite on my local machine, running Ubuntu Karmic,

Re: [sqlite] command line does not accept arrow keys

On Fri, Nov 20, 2009 at 6:02 PM, Qianqian Fang wrote: > hi > > I can not type arrow keys in the sqlite3 command line, all the arrow > keys (as well as other keys in the small keyboard) will be shown as > escape sequence "^]]A". Could it be a problem with readline? See

[sqlite] command line does not accept arrow keys

hi I can not type arrow keys in the sqlite3 command line, all the arrow keys (as well as other keys in the small keyboard) will be shown as escape sequence "^]]A". I am using Terminator/gnome-terminal, is there a setting I need to twig in order to get this working? thanks Qianqian

Re: [sqlite] Problem with database (SELECT hangs)

On 21 Nov 2009, at 12:57am, Phil Longstaff wrote: > I have an sqlite3 database where a SELECT hangs. The statement is: > > SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE > s.tx_guid=t.guid > AND ((s.account_guid IN ('d076626fc5be59df7e592f8f0d66c7cd'))) > > Are there any

Re: [sqlite] New sqlite bug report: Problem with /* */ commentfollowed by Non-SQL (sqlite-specific) command

comment lines in sql begin with -- Regards, Simon === But both types are supported, right? http://www.sqlite.org/lang_comment.html C comments can span any number of lines. C-style comments begin with "/*" and extend up to and including

[sqlite] Problem with database (SELECT hangs)

I have an sqlite3 database where a SELECT hangs. The statement is: SELECT DISTINCT t.* FROM transactions AS t, splits AS s WHERE s.tx_guid=t.guid AND ((s.account_guid IN ('d076626fc5be59df7e592f8f0d66c7cd'))) Are there any tools to help me diagnose the problem? I could download the source

Re: [sqlite] CEROD enable error: sqlite3_cerod_enable()

On Nov 20, 2009, at 6:21 PM, Priyang Rathod wrote: > Hi, > > The CEROD (the compression and encryption extension) README instructs > that one needs to enable the extension by calling > sqlite3_cerod_enable() > in the main() function or before calling sqlite3_open(). I included > this > call

[sqlite] CEROD enable error: sqlite3_cerod_enable()

Hi, The CEROD (the compression and encryption extension) README instructs that one needs to enable the extension by calling sqlite3_cerod_enable() in the main() function or before calling sqlite3_open(). I included this call as the first line in my main(), but on compiling, it complains:

Re: [sqlite] substr in sqlite3 3.6.20

On Nov 20, 2009, at 2:30 PM, priimak wrote: > Hi. > > What happened to substr function. I upgraded from 3.6.7 to 3.6.20 and > found following difference. > > in 3.6.7 > > $ sqlite3 a.db > sqlite> create table X ( v text not null ); > sqlite> insert into X ( v ) values ( "123456789" ); > sqlite>

Re: [sqlite] CEROD Extension Linking Error

Thanks Pavel, It worked! That was easy (and in hindsight, obvious.) Thanks a lot, Priyang Pavel Ivanov wrote: >Try to add -ldl to g++ flags like this: > >g++ -o localVal Topic.o LinguisticDataStore.o StringUtil.o CppSQLite3.o >LocalValidator.o -L../Debug -lpthread -lsns -lcommon -ltagger -ldl

Re: [sqlite] substr in sqlite3 3.6.20

Shane Harrelson wrote: > On Fri, Nov 20, 2009 at 2:30 PM, priimak wrote: > > >> Hi. >> >> What happened to substr function. I upgraded from 3.6.7 to 3.6.20 and >> found following difference. >> >> in 3.6.7 >> >> $ sqlite3 a.db >> sqlite> create table X ( v text not null

Re: [sqlite] substr in sqlite3 3.6.20

On Fri, Nov 20, 2009 at 2:30 PM, priimak wrote: > Hi. > > What happened to substr function. I upgraded from 3.6.7 to 3.6.20 and > found following difference. > > in 3.6.7 > > $ sqlite3 a.db > sqlite> create table X ( v text not null ); > sqlite> insert into X ( v ) values (

Re: [sqlite] CEROD Extension Linking Error

Try to add -ldl to g++ flags like this: g++ -o localVal Topic.o LinguisticDataStore.o StringUtil.o CppSQLite3.o LocalValidator.o -L../Debug -lpthread -lsns -lcommon -ltagger -ldl -lboost_regex-mt -lZThread ../Debug/libsqlite3.cerod.fedo.a /usr/lib/libz.a Pavel On Fri, Nov 20, 2009 at 3:00 PM,

[sqlite] CEROD Extension Linking Error

Hi, I have a novice question. The question is more related the the CEROD extension but I'd really appreciate any help. I am using sqlite 3.6.14.2 and the evaluation version of the CEROD extension for compression and encryption on Fedora Core 5. I could build the extended sqlite library and

[sqlite] substr in sqlite3 3.6.20

Hi. What happened to substr function. I upgraded from 3.6.7 to 3.6.20 and found following difference. in 3.6.7 $ sqlite3 a.db sqlite> create table X ( v text not null ); sqlite> insert into X ( v ) values ( "123456789" ); sqlite> select substr( v, 0, 5 ) from X; 12345 in 3.6.20 sqlite>

[sqlite] begin transaction

i have several processes all trying to write to a given DB. i have set sqlite3_busy_timeout to 1 (10 sec). when proc A successfully beings a trasaction IMMEDIATE what appears to happen when proc B attempts to begin transaction IMMEDIATE is that it fails immediately w/ SQLITE_BUSY. i

Re: [sqlite] another Feature Request: char from codepoint?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tim Romano wrote: > The requirements for the flip() function I've requested are unambiguous: > simply reverse the string, raw codepoint by codepoint. My point was that your requirements are that, yet someone else wanting a "flip" function could

Re: [sqlite] [SOLVED] Force cache flush?

Figured out my problem - it actually had little to do with SQLite itself, but rather with my code, perhaps due to the way Qt interacted with SQLite. Be that as it may, it turns out I still had an active SELECT query on the database, which was keeping my changes from being committed to

Re: [sqlite] Unicode support

On Tue, Nov 17, 2009 at 09:31:46PM -0500, Tim Romano wrote: > but if ORDER BY is > relying on an index for ordering, then flip() can have negative > effects. > > > Substr() could have negative effects on ordering too. That is a red > herring. Flip() is merely a function that reverses the

Re: [sqlite] New sqlite bug report: Problem with /* */ comment followed by Non-SQL (sqlite-specific) command

Regarding: /* Here comes the comment. Source is reduced to show core of the problem. */ .mode column == FWIW, I reproduced error on 3.16.19 windows. Of course, I presume this is not a problem with sqlite itself, but with the sqlite3 utility program. Interesting in

Re: [sqlite] New sqlite bug report: Problem with /* */ comment followed by Non-SQL (sqlite-specific) command

2009/11/20 Norbert : > Hi, > > I use SQLite 3.6.16 on Ubuntu Linux Karmic Koala, installation via > normal Ubuntu repository. At home (Linux) and also in the office > (Windows XP), I encountered the following problem. > > Source of test.sql: > > *BEGIN OF

[sqlite] New sqlite bug report: Problem with /* */ comment followed by Non-SQL (sqlite-specific) command

Hi, I use SQLite 3.6.16 on Ubuntu Linux Karmic Koala, installation via normal Ubuntu repository. At home (Linux) and also in the office (Windows XP), I encountered the following problem. Source of test.sql: *BEGIN OF SOURCECODE (next line is line 1) .headers off /* Here comes the

Re: [sqlite] Difference between two dates fails

antastici premi! Gioca ora Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi? mid=9868d=20091120 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Difference between two dates fails

tici premi! Gioca ora Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=9868d=20091120 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Caselle da 1GB, trasmetti al

Re: [sqlite] Difference between two dates fails

rti i verbi > > non li so > > "se li avrei saputi mo' te l'imparavo" > > > > -- > Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e > SMTP > autenticato? GRATIS solo con Email.it: http://www.email.it/f &g

Re: [sqlite] Difference between two dates fails

ino a 3GB e in piu' IMAP, POP3 e SMTP > autenticato? GRATIS solo con Email.it: http://www.email.it/f > >  Sponsor: >  Gioca anche tu alla "faccia degli amici", crea la faccia che preferisci e > vinci fantastici premi! Gioca ora >  Clicca qui:

[sqlite] Difference between two dates fails

no a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it: http://www.email.it/f Sponsor: Gioca anche tu alla "faccia degli amici", crea la faccia che preferisci e vinci fantastici premi! Gioca ora Clicca qui: http://adv.email.it/cgi-bin/foclick.c

Re: [sqlite] another Feature Request: char from codepoint?

Roger, I have had a very brief time observing the SQLite community, the opposite of your own experience, but I have been working with a variety of databases since 1985: PICK, Revelation, FoxPro, Paradox, MS-Access, Oracle, and SQLServer, among others. I'm not a newbie to databases but am a

Re: [sqlite] temp directory?

You can try setting a temp or tmp or tempdir environment variable on the server, however, as I said in the previous post, I am not sure if it will work. Probably the safest and most robust way would be to have your code call the pragma temp_store_directory directly after opening the database.

Re: [sqlite] temp directory?

I collect some things now: My hoster: pdo_sqlitePDO Driver for SQLite 3.x enabled PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.4 2008/12/31 11:17:42 sebastian Exp $ SQLite Library 3.3.8 SQLiteSQLite supportenabled PECL Module version 2.0-dev $Id: sqlite.c,v

Re: [sqlite] temp directory?

You could also set the temp_store pragma such that *most* temp files are created in memory. I say most, because even though you set temp_store to memory, there is still one temporary file(statement journal) which will still need to use the temp_store_directory. I suppose another possibility

Re: [sqlite] temp directory?

I can, but doesn't there exists an another way? > I believe you can specify the directory in which temporary files will be > created. This is done with pragma temp_store_directory. I think you > can also set this in compilation. > > Artur Reilin wrote: >> >>> >>> On 19 Nov 2009, at 8:05am,

Re: [sqlite] does there some fts3 document i can read

ouwind wrote: > i cant find documents about fts3 in sqlite documents http://www.sqlite.org/cvstrac/wiki?p=FtsUsage Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users