[sqlite] Manifest Typing question

Hello, When I add text to the database, it's getting truncated because SQLite is converting it to a number. For example, I enter "9.0", but SQLite stores it as "9". Is there a way to force the value to be inserted as string? Thanks, -- Tito

Re: Re: Re: [sqlite] Poor performance searching from multiple DBs

>It's not the first field in the index, so I don't think it >will use it >for searching on "WHERE field5 = 'xxx' ". >Try adding an index on field5 only > CREATE UNIQUE INDEX main_indexf5 ON main (field5); >I don't see any problem. Thanks Jay. You are right. The query

[sqlite] No video from OSCON

I just heard back from my contact, and they do not video the tutorials. Generally, the tutorial teachers don't want this anyway, as they sell the same tutorial to other companies (and a cheap DVD would undermine that). I suppose that, in theory, Dr. Hipp could arrange to have his own person there

Re: [sqlite] Write performance

On Fri, 17 Jun 2005, Sean Heber wrote: >>> SQLite write (insert) performance doesn't seem very good to me so I'm >>> trying to find ways to improve it in my application. I had this idea >>> so I figured I'd run it past you folks who likely better know how the >>> db works under the hood. >>> >>

Re: [sqlite] Write performance

Sean Heber wrote: I've been inserting data into a table with a non-integer primary key. The data does not come in in an ordered fashion. My thought is that perhaps performance suffers because it needs to rewrite huge chunks of the data file in order to slot the new data into its correct

Re: Re: [sqlite] Poor performance searching from multiple DBs

> >> I have to search for field5 in some DB files (30 or more >>for a total of > >> 50 GB of space and 150 M of records ). > > >> select * from main where field5= "AABBCCDD"; > > > > > Did you put an index on field5? > > Yes I use: > > CREATE UNIQUE INDEX main_index ON main

Re: Re: [sqlite] Poor performance searching from multiple DBs

>> I have to search for field5 in some DB files (30 or more >>for a total of 50 >> GB of space and 150 M of records ). >> select * from main where field5= "AABBCCDD"; > Did you put an index on field5? Yes I use: CREATE UNIQUE INDEX main_index ON main (field2,field5,field7); Is a

Re: Re[4]: [sqlite] Sqlite low level and Speed.

On Jun 20, 2005, at 11:24 AM, Yuriy wrote: CS> What are you actually trying to do? And can you quantify "very slow" and CS> tell us what you actually expect or what would be acceptable? 100,000 oll ok 7 seconds 1,000,000 software halt :( CS> Is this representitive of what you are trying to

Re[4]: [sqlite] Sqlite low level and Speed.

CS> What are you actually trying to do? And can you quantify "very slow" and CS> tell us what you actually expect or what would be acceptable? 100,000 oll ok 7 seconds 1,000,000 software halt :( CS> Is this representitive of what you are trying to do? Are you storing IP CS> addresses, and you

Re: Re[2]: [sqlite] Sqlite low level and Speed.

- Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: "Christian Smith" ; "Yuriy" <[EMAIL PROTECTED]> Sent: Monday, June 20, 2005 12:01 PM Subject: Re[2]: [sqlite] Sqlite low level and Speed. > On Mon, 20 Jun 2005, Yuriy wrote: > > >CS> When

Re[2]: [sqlite] Sqlite low level and Speed.

On Mon, 20 Jun 2005, Yuriy wrote: >CS> When creating testtable, specify val as unique, and specify what to do >CS> with conflicts: >CS> CREATE TABLE testtable(val TEXT UNIQUE ON CONFLICT REPLACE); >CS> The conflict clauses are documented here: >CS> http://www.sqlite.org/lang_conflict.html >Try it

Re: [sqlite] assert during exec of sql statment

On Mon, 2005-06-20 at 15:03 +0300, Amir Hadar wrote: > Hi > > I encountered an assert in function moveToRoot in file btree.c. > Not much to go on. Can you tell me what you were doing or how to reproduce the problem? -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] errors compiling with MS VC++ 6.0

Robert G. Ristroph wrote: I am building sqlite 3.2.2 on windows with MS VC++ 6.0. I am doing this because I believe I need the .lib file to use the .dll with my code. Hi Robert, You don't need to build SQLite in VC++ to generate the .lib file. VC++ includes a utility program called

Re: [sqlite] Sqlite low level and Speed.

Yes. Sorry, haven't had my morning caffeine yet. ;) On 6/20/05, Will Leshner <[EMAIL PROTECTED]> wrote: > > On Jun 20, 2005, at 7:42 AM, Jay Sprenkle wrote: > > > for i:=1 to 1000 do > > begin tran > > insert or on conflict fail into testtable(val) values(StringN); > > commit > > end for >

Re: [sqlite] Sqlite low level and Speed.

On Jun 20, 2005, at 7:42 AM, Jay Sprenkle wrote: for i:=1 to 1000 do begin tran insert or on conflict fail into testtable(val) values(StringN); commit end for Shouldn't the transaction wrap the loop?

Re: [sqlite] Query on multiple tables

Martin Gagnon wrote: Hi all, Using sqlite3 on QNX 6.3.0. I need to do a select query on 3 tables by binding them by their ID's. Something like: Select tbl1.ID, tbl1.fld1, tbl1.fld2 /*(15 fields total, all from tbl1)*/ from tbl1, tbl2, tbl3, where tbl1.ID=4 AND tbl1.ID=tbl2.ParentID AND

Re: [sqlite] Sqlite low level and Speed.

On 6/20/05, Yuriy <[EMAIL PROTECTED]> wrote: > 1. Example of the decision > > CREATE TABLE testtable (val text) > CREATE INDEX index_val ON [testtable]([val]); > PRAGMA synchronous = OFF; > > for i:=1 to 1000 do > begin > select * from testable where val=StringN > if val NOT Exist insert

[sqlite] assert during exec of sql statment

Hi I encountered an assert in function moveToRoot in file btree.c. The assert is in the following code: static int moveToRoot(BtCursor *pCur){ MemPage *pRoot; int rc; Btree *pBt = pCur->pBt; rc = getAndInitPage(pBt, pCur->pgnoRoot, , 0); if( rc ){ pCur->isValid = 0;

[sqlite] Quick news on the Perl-bindings front

I just sent a patch to the maintainer of the DBD::SQLite package, that lets it build against an installed version of the library. The current package carries a copy of the code with it, and builds it locally. With this patch, you can update your base sqlite installation and the Perl driver will

Re: [sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite

Dear Richard, I have forwarded your email to a friend in my university (Open University) who often arrange conferences and tutorials. I am sure due to the popularity and respect UK programmers have for SQLite, something may be possible. Regards, Ben Clewett. D. Richard Hipp wrote: On

Re: [sqlite] Sqlite low level and Speed.

On Mon, 20 Jun 2005, Yuriy wrote: >Hello sqlite-users, > >Sqlite low level and Speed. > >Sorry for my bad English. > >I try use Sqlite for Operation FAST grouping strings (delete duplicates) > >I have input array of strings > >String1 >String2 >String3 >String1 >String2 >??? >StringN > >

Re: [sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite

On Mon, 2005-06-20 at 08:23 +0100, Ben Clewett wrote: > May I ask if this tutorial will be held in the UK? If not I'll second > the requests for DVD or written transcripts. > The tutorial has not been proposed for any european conferences. Though, if you can suggest one and make a case that

Re[2]: [sqlite] Sqlite low level and Speed.

BV> use transactions, speeds up a lot Sorry transaction i also use speed low :( begin c:=0; for i:=1 to 1000 do begin select * from testable where val=StringN if val NOT Exist insert into testtable inc(c); if c=1 then begin Commit; Begin; c:=0; end;

Re: [sqlite] Sqlite low level and Speed.

use transactions, speeds up a lot Op maandag 20 juni 2005 11:35, schreef Yuriy: > Hello sqlite-users, > > Sqlite low level and Speed. > > Sorry for my bad English. > > I try use Sqlite for Operation FAST grouping strings (delete > duplicates) > > I have input array of strings > > String1 >

[sqlite] Sqlite low level and Speed.

Hello sqlite-users, Sqlite low level and Speed. Sorry for my bad English. I try use Sqlite for Operation FAST grouping strings (delete duplicates) I have input array of strings String1 String2 String3 String1 String2 ……… StringN Need delete dublicates. Output database String1 String2

Re: [sqlite] Reading German Umlauts correct

SQLite stores text as UTF-8 - this is the default and it can be changed to UTF16, but you would probably encounter similar problems. "ü" is the UTF-8 representation of "ü" - to retrieve and display the German Umlaut you must decode the UTF-8 encoded text to its Unicode representation. For

[sqlite] "database full" errors

what would cause this error? I have a few users reporting it, all with different database file sizes. is there a limit on row counts in 3.x ? -- Cory Nelson http://www.int64.org

Re: [sqlite] Re: - Re: [sqlite] Training opportunity: The Inner Workings Of SQLite

May I ask if this tutorial will be held in the UK? If not I'll second the requests for DVD or written transcripts. Kind regards, Ben Clewett. D. Richard Hipp wrote: On Mon, 2005-06-20 at 10:34 +1000, [EMAIL PROTECTED] wrote: I too would be happy to pay for DVDs if they were to be made