[sqlite] Max Value In Group By Scenario

I realize this is more of a general SQL question, but I figured while I was digging for the answer one of you would probably already know it. I have a table where the three import fields for my situation are MfgProductID, ProductID and Weight. For any given MfgProductID there can be multiple

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

On May 4, 2009, at 10:14 PM, Ken wrote: > > You could just pass the sqlite3_int64 value. It is portable between > systems. Search through the sqlite3 code and there are routines that > do the conversions from the sqlite3_int64 to a native int64 type. > They basically perform bit shifting

Re: [sqlite] which is faster SQLite or STL Map?

I figure out a better solution than the two I initially proposed: Create a temp table to put the image names into and then use a left outer join to get the answer. Sam On Mon, May 4, 2009 at 7:49 PM, Sam Carleton wrote: > Here is my situation: > > I have a SQLite

Re: [sqlite] [newbie] How to upgrade sqlite3 in Ubuntu?

Well, it seems that things become weirder and weirder. I have to install sqlite3 on 2 computers, one at my office and one at home. Today when I launched sqlite3 at my office it showed that the version was 3.6.13 although just yesterday it was still sqlite3 3.4.2 and I swear that I have done

Re: [sqlite] Building SQLite ... configure/make deprecated?

On Mon, May 4, 2009 at 2:59 PM, Rob Sciuk wrote: > > I note with interest the source download now (recently?) deprecates the > configure/make build of SQLite 3.6.x sources.  What gives??  I've been > configure/make(ing) SQLite since, forever, and the only problems I ever >

Re: [sqlite] Building SQLite ... configure/make deprecated?

On Tue, May 5, 2009 at 3:59 AM, Rob Sciuk wrote: > How does one actually obtain the "amalgamation", if not by using the > configure/make scripts, complete with lemon and friends?? One way is by direct download of say, sqlite-amalgamation-3.6.13.tar.gz, from

Re: [sqlite] SQL error: database disk image is malformed

Thanks for respond my email. Yes, There is  index defined on peerid. Second query used the index which is defined by peerid. How to fix this corruped database. Thanks, JP From: "Griggs, Donald" To: General Discussion of SQLite

[sqlite] which is faster SQLite or STL Map?

Here is my situation: I have a SQLite table that has a customer id, the folder id, and the image id (filename). This is a favorites table, so for a given customer and folder, there is going to be a small set of images in the table. The operation is to scan the folder/directory on the HD for all

Re: [sqlite] SQLite and GHS Integrity Issues

On May 4, 2009, at 2:38 PM, Christopher Taylor wrote: >> I am told that SQLite compiles and runs out-of-the-box on Integrity >> OS. No porting necessary. But not having a license for Integrity OS >> nor hardware to run it on, I've never actually tried this myself. > > Thanks for a quick

Re: [sqlite] SQL error: database disk image is malformed

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joanne Pham Sent: Monday, May 04, 2009 2:51 PM To: General Discussion of SQLite Database Subject: [sqlite] SQL error: database disk image is malformed Hi All, I ran the

Re: [sqlite] sqlite3_prepare returns SQLITE_MISUSE

Beau Wilkinson wrote: > Nevertheless, I am getting some very puzzling errors. In particular, > there are cases where sqlite3_prepare() is the first call to cause an > error, typically SQLITE_MISUSE. You are passing a bad (never opened, already closed) connection handle to

[sqlite] sqlite3_prepare returns SQLITE_MISUSE

I have inherited a large Sqlite project recently. The project is multi-threaded, but has thus far kept Sqlite calls in a single thread. Recently, I have complicated this somewhat by adding a second thread that deals with other, essentially independent databases. No connections, statements, etc.

[sqlite] What encoding format is used in the FTS3 tokenizer? and other tokenizer questions.

I am writing a FTS3 tokenizer that works with iPhoneOS using Apple's CoreFoundation library. What encoding is used on inbound insert statements into a FTS3 virtual table? For example I have Japanese text encoded as UTF-8 and passed in as UTF-8 insert statement is encoded as UTF-8. I am

Re: [sqlite] How to exit from sqlite shell?

On Mon, 4 May 2009 15:01:26 -0400, Pavel Ivanov wrote: >In windows shell Control-Z should be equivalent of Control-D on Unix >(it sends EOF to stdin). Yes, you're right. Control-Z, Return does it. The Return key is required to terminate the line editor. On Unix the

[sqlite] Building SQLite ... configure/make deprecated?

I note with interest the source download now (recently?) deprecates the configure/make build of SQLite 3.6.x sources. What gives?? I've been configure/make(ing) SQLite since, forever, and the only problems I ever encountered were omitting options that I needed, and quickly sorted out! How

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

Why would you want to convert something to a string that is already cross platform compatible? If you need to store the value in a different DB, then converting it locally to a native int64 and then into whatever DB construct would be way more efficient than hauling around string conversions.

Re: [sqlite] How to exit from sqlite shell?

I find it easy to confuse myself if I have either an unclosed quote, an unclosed "/*" comment, or an unterminated command (semicolon).Below is an example of two simultaneously. SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select

Re: [sqlite] How to exit from sqlite shell?

Yes, and Control-Z exits sqlite3, in Windows, as expected. g -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Monday, May 04, 2009 2:01 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to exit from

Re: [sqlite] How to exit from sqlite shell?

In windows shell Control-Z should be equivalent of Control-D on Unix (it sends EOF to stdin). Pavel On Mon, May 4, 2009 at 2:58 PM, Kees Nuyt wrote: > On Mon, 4 May 2009 14:00:45 -0400, "D. Richard Hipp" > wrote: > >> >>On May 4, 2009, at 1:44 PM, Sam Carleton

Re: [sqlite] How to exit from sqlite shell?

On Mon, 4 May 2009 14:00:45 -0400, "D. Richard Hipp" wrote: > >On May 4, 2009, at 1:44 PM, Sam Carleton wrote: > >> prefix with a period: >> >> .exit > >Yes. Also ".quit" or ".q" or Control-D (on most Unix systems > - I don't know if Control-D works on windows) Control-D

[sqlite] SQL error: database disk image is malformed

Hi All, I ran the following sql statement:     select blobid, fbid from sig group by peerid; return about 10 rows         22    ...    33 return about 10 rows and I got the error message:  SQL error: database disk image is malformed but when I ran the following

Re: [sqlite] SQLite and GHS Integrity Issues

>I am told that SQLite compiles and runs out-of-the-box on Integrity >OS. No porting necessary. But not having a license for Integrity OS >nor hardware to run it on, I've never actually tried this myself. Thanks for a quick response. I will try and be more precise. I get a number of

Re: [sqlite] How to exit from sqlite shell?

On May 4, 2009, at 1:44 PM, Sam Carleton wrote: > prefix with a period: > > .exit Yes. Also ".quit" or ".q" or Control-D (on most Unix systems - I don't know if Control-D works on windows) > > > Lucius Fox wrote: >> Hi, >> >> Can you please tell me how to exit from sqlite shell? >> >> I try

Re: [sqlite] SQLite and GHS Integrity Issues

On May 4, 2009, at 1:29 PM, Christopher Taylor wrote: > Has anyone done a successful port of SQLite to the Integrity OS. I am told that SQLite compiles and runs out-of-the-box on Integrity OS. No porting necessary. But not having a license for Integrity OS nor hardware to run it on, I've

Re: [sqlite] How to exit from sqlite shell?

prefix with a period: .exit Lucius Fox wrote: Hi, Can you please tell me how to exit from sqlite shell? I try typing 'exit', 'quit', '.quit' or press cTRL X CTRL c, but they don't work. sqlite> exit ...> quit ...> ^X^C ...> ^C ...> ^X^C ...> .quit Thank you.

[sqlite] How to exit from sqlite shell?

Hi, Can you please tell me how to exit from sqlite shell? I try typing 'exit', 'quit', '.quit' or press cTRL X CTRL c, but they don't work. sqlite> exit ...> quit ...> ^X^C ...> ^C ...> ^X^C ...> .quit Thank you. ___ sqlite-users mailing

[sqlite] SQLite and GHS Integrity Issues

Has anyone done a successful port of SQLite to the Integrity OS. Using their WLFS file system and nand flash, I can run ok for about 5 hours inserting 1 record every 3-5 seconds. My db gets to be about 1.8 MB and holds steady. Then I get an error message that the file system has panicked and I

Re: [sqlite] Searching for sqlite version 0.1

On 4/05/2009 9:10 PM, lakshmi pathi wrote: > Hi, > Where can i find the sqlite version 0.1 (Assume that's first sqlite > version) source code. I'm an open source programmer,looking to learn > about database. So learn from the LATEST code. It's gone through MAJOR revisions, all for the better.

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

Ken, this is true, except that I might migrate the system to some other database someday that wants to use something else as PK other than an int or int64 (MS SQL is optimized for guid's not int), so passing around the id's as strings keeps all the middle and front end code neutral :) Sam

Re: [sqlite] Minus sign in table name

D. Richard Hipp wrote: > > > On May 4, 2009, at 10:18 AM, bitzzz wrote: > >> >> I am converting an existing database to sqlite format, but I got the >> following problem: >> >> When I create a table name with a minus sign inside then the following >> column definitions are ignored. >> So: >>

Re: [sqlite] OT: how best to convert sqlite3_int64 to and from string in a cross platform fashion?

You could just pass the sqlite3_int64 value. It is portable between systems. Search through the sqlite3 code and there are routines that do the conversions from the sqlite3_int64 to a native int64 type. They basically perform bit shifting and will be much faster than the string conversions.

[sqlite] Minus sign in table name

I am converting an existing database to sqlite format, but I got the following problem: When I create a table name with a minus sign inside then the following column definitions are ignored. So: CREATE TABLE 'TEST1-TEST' (TST TEXT); refuses to create the column TST in the table TEST1-TEST. The

Re: [sqlite] Minus sign in table name

On May 4, 2009, at 10:18 AM, bitzzz wrote: > > I am converting an existing database to sqlite format, but I got the > following problem: > > When I create a table name with a minus sign inside then the following > column definitions are ignored. > So: > > CREATE TABLE 'TEST1-TEST' (TST TEXT); >

Re: [sqlite] Minus sign in table name

bitzzz wrote: > I am converting an existing database to sqlite format, but I got the > following problem: > > When I create a table name with a minus sign inside then the following > column definitions are ignored. > So: > > CREATE TABLE 'TEST1-TEST' (TST TEXT); > > refuses to create the column

Re: [sqlite] sqlite undefined reference on making subversion 1.6

On May 4, 2009, at 9:22 AM, Adam Bruss wrote: > Hello all, > > > > I'm trying to upgrade SVN from 1.5 to 1.6. 1.6 requires a certain > sqlite > version so I installed the latest sqlite3. When I do a make on the > subversion 1.6 source it errors out with these messages. > > > >

[sqlite] sqlite undefined reference on making subversion 1.6

Hello all, I'm trying to upgrade SVN from 1.5 to 1.6. 1.6 requires a certain sqlite version so I installed the latest sqlite3. When I do a make on the subversion 1.6 source it errors out with these messages. /root/Desktop/subversion-1.6.1/subversion/libsvn_subr/.libs/libsvn_subr- 1.so:

Re: [sqlite] Updating Database from multiple threads

Hello Igor Tandetnik, Many thanks. It is working ! Regards, Souvik -Original Message- From: sqlite-users-boun...@sqlite.org on behalf of Igor Tandetnik Sent: Mon 5/4/2009 5:04 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Updating Database from multiple threads

Re: [sqlite] Updating Database from multiple threads

wrote in message news:61c4c33b211cd64ebf4b6eb0d03dd56e20d...@blr-m3-msg.wipro.com > I have an application that requires two threads to insert data into > the database simultaneously ( both the threads are updating > independent tables which are in the same database).

[sqlite] Searching for sqlite version 0.1

Hi, Where can i find the sqlite version 0.1 (Assume that's first sqlite version) source code. I'm an open source programmer,looking to learn about database. ps:I checked kernel source code via lxr. ..and googled for it...but no success. Cheers, Lakshmipathi.G www.giis.co.in

[sqlite] Updating Database from multiple threads

Hi, I have an application that requires two threads to insert data into the database simultaneously ( both the threads are updating independent tables which are in the same database).I am using sqlite-amalgamation-3.6.10 on Ubuntu 8.10. My database is on ext3 partition.I found

Re: [sqlite] Retrieve database modification stamp

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ben Harper wrote: > Is there any official way of obtaining the database modification counter? No. The closest is the schema version which only changes when the schema changes. There is also a user version you can use in your own code. See

[sqlite] Retrieve database modification stamp

Hi, Is there any official way of obtaining the database modification counter? I'm talking about the counter that is mentioned in the Atomic Commit docs: " In order to determine whether or not the database file has changed, SQLite uses a counter in the database header (in bytes 24 through 27)

Re: [sqlite] How to create a table from a text file via c/c++interface?

It works. I changed " for (int i=0;i<1e5;i++) { rc = sqlite3_exec(db, "insert into wigfile values(1,2000,3000,0.4)", callback, 0, ); }" into "sqlite3_exec(db, "begin", callback, 0, ); for (int i=0;i<1e5;i++){ rc = sqlite3_exec(db, "insert into wigfile values(1,2000,3000,0.4)", callback,