Re: [sqlite] "SQLite" Pronunciation

On 27 Feb 2013, at 11:39pm, Kevin Benson wrote: > http://www.youtube.com/watch?v=jN_YdMdjVpU Heh. I can't think of a more 'cannonical' source. I've been doing it wrong, but I can't remember the last time I spoke the word out loud so it doesn't matter. Simon.

Re: [sqlite] "SQLite" Pronunciation

http://www.youtube.com/watch?v=jN_YdMdjVpU -- -- -- --Ô¿Ô-- K e V i N On Wed, Feb 27, 2013 at 6:28 PM, wrote: > OK, how does one pronounce "SQLite"? "see-kwel-lite"? "ess-kyoo-lite"? > "ess-kyoo-ell-lite"? "see-kwel-ite"? "ess-kyoo-ell-ite"? Or...?

[sqlite] "SQLite" Pronunciation

OK, how does one pronounce "SQLite"? "see-kwel-lite"? "ess-kyoo-lite"? "ess-kyoo-ell-lite"? "see-kwel-ite"? "ess-kyoo-ell-ite"? Or...? I guess, to some extent, it may depend on whether one pronounces (or mispronounces) "SQL" as "see-kwel" or as "ess-kyoo-ell". I think I read someplace that the

Re: [sqlite] Sqlite on windows ce 5.0 Emulator

Anand Shah wrote: > > I am able to run application successfully developed with vs2005 .net CF 2.0 > on my local windows embedded ce 6.0 machine. I am trying to deploy this > application to windows emulator ce 5.0 as a device application and it also > gets deployed successfully but when any event

Re: [sqlite] SQLite equivalent to Oracle's MERGE INTO

On Feb 27, 2013, at 2:53 PM, James K. Lowden wrote: > On Mon, 25 Feb 2013 23:54:23 +0100 > anydacdev anydacdev wrote: > >> I was wondering what is SQLite's equivalent to: >> >> MERGE INTO x TGT >> USING (SELECT NAME, KEY FROM y) SRC >> ON

Re: [sqlite] SQLite equivalent to Oracle's MERGE INTO

On Wed, Feb 27, 2013 at 7:53 AM, James K. Lowden wrote: > begin transaction; > update tgt > set name = (select name from src where tgt.key = src.key) > where exists ( > select 1 from src > where src.key = tgt.key > ); > -- check for error Yes, this is

Re: [sqlite] Tool to import tables and its data from sqlserver to sqlite

On 27 Feb 2013, at 3:10pm, levi wrote: > More precisely, I want to create a sqlite database based on a few tables and > data from the Sqlserver database. Good solution: Have your SQLServer database software generate a set of SQL instructions for making the

Re: [sqlite] Memory DB - Query does not return all records after Update

On 2/26/2013 9:27 AM, mike.akers wrote: Yes I believe so. For my UPDATES, currently (things have moved around quite a bit for me trying to solve this) sqlite3_exec(this->hDBC_, "BEGIN EXCLUSIVE TRANSACTION;", NULL, NULL, 0); sqlite3_prepare_v2(this->hDBC_, updateStatement, -1, >hStmt_, 0);

Re: [sqlite] random, infrequent disk I/O errors

For the record, this problem was due to a locking problem between two processes trying to access the same SQLite database, in which a locked database was being mis-reported by SQLite as a disk I/O error. Furthermore, the problem went away when I upgraded to 3.7.15.2. On Feb 27, 2013, at

Re: [sqlite] locked database returning SQLITE_IOERR, not SQLITE_BUSY

For the record, this problem went away when I upgraded to the latest & greatest (3.7.15.2). On Feb 27, 2013, at 8:57 AM, Greg Janee wrote: From: sqlite-users-boun...@sqlite.org [sqlite-users- boun...@sqlite.org] on behalf of Dan Kennedy

Re: [sqlite] SQLite4 UPDATE performance

Richard, I commented out SQLITE4_DEBUG and SQLITE4_MEMDEBUG and added -DNDEBUG=1. That did the trick! More like 224,000 updates per second. Thanks for your help Rob On Wed, Feb 27, 2013 at 5:47 AM, Richard Hipp wrote: > On Wed, Feb 27, 2013 at 3:24 AM, Rob Turpin

[sqlite] Tool to import tables and its data from sqlserver to sqlite

Hello everyone, I have one Android App that will use the sqlite database, I would to do the following: I want to create the sqlite database, from sqlserver database, and download it sqlite database that I created from the SqlServer to my Android App Are there any tool to import the tables and

Re: [sqlite] Memory DB - Query does not return all records after Update

COT_EVENT_TABLE = "CREATE TABLE MAIN_TABLE( pk char(41) primary key,\ item1 real, \ item2 char(64), \

[sqlite] Sqlite on windows ce 5.0 Emulator

Hello, I am able to run application successfully developed with vs2005 .net CF 2.0 on my local windows embedded ce 6.0 machine. I am trying to deploy this application to windows emulator ce 5.0 as a device application and it also gets deployed successfully but when any event calls sqlite dll it is

Re: [sqlite] Memory DB - Query does not return all records after Update

Yes I believe so. For my UPDATES, currently (things have moved around quite a bit for me trying to solve this) sqlite3_exec(this->hDBC_, "BEGIN EXCLUSIVE TRANSACTION;", NULL, NULL, 0); sqlite3_prepare_v2(this->hDBC_, updateStatement, -1, >hStmt_, 0); sqlite3_bind_blob(this->hStmt_, 1, blob,

Re: [sqlite] like query

On Wed, Feb 27, 2013 at 3:16 PM, Igor Tandetnik wrote: > On 2/27/2013 4:35 AM, Dominique Devienne wrote: > >> PS: Something else that should also be part of SQLite built-in is the >> optimization that col LIKE 'prefix%' queries should implicitly try to use >> an index on col.

[sqlite] SQLite2010 Pro ODBC Driver

Good Morning, I am trying the SQLite2010 Pro ODBC Driver in a connection string in PowerBuilder 12.5. In the database painter and in a compiled app some selects from tables are returning more than what is in the table. The county table has 4280 records. Selecting specific columns or the whole

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

On Tue, 26 Feb 2013 19:45:27 -0500, Kevin Benson wrote: >> Right, but while the first DLL will be found since it's now part of >> the project (Project > Add Reference), the wiki doesn't say that this >> doesn't take care of the other DLL.

Re: [sqlite] like query

On 2/27/2013 4:35 AM, Dominique Devienne wrote: PS: Something else that should also be part of SQLite built-in is the optimization that col LIKE 'prefix%' queries should implicitly try to use an index on col. http://www.sqlite.org/optoverview.html#like_opt -- Igor Tandetnik

Re: [sqlite] SQLite equivalent to Oracle's MERGE INTO

On Mon, 25 Feb 2013 23:54:23 +0100 anydacdev anydacdev wrote: > I was wondering what is SQLite's equivalent to: > > MERGE INTO x TGT > USING (SELECT NAME, KEY FROM y) SRC > ON (TGT.key = SRC.key) > WHEN MATCHED THEN > UPDATE SET TGT.NAME = NAME > WHEN NOT MATCHED THEN >

Re: [sqlite] SQLite4 UPDATE performance

On Wed, Feb 27, 2013 at 3:24 AM, Rob Turpin wrote: > I wrote up a test case to do some performance tests for the update > statement, and I'd thought I'd ask before probing around the code first. > > For SQLite3: 280,000 updates per second > For SQLite4: 290 updates per second

Re: [sqlite] like query

On Wed, Feb 27, 2013 at 11:23 AM, Clemens Ladisch wrote: > Dominique Devienne wrote: > > My $0.02 is that such a chr() function could/should be built-in to > SQLite. > > Apparently, drh has a time machine: > http://www.sqlite.org/cgi/src/info/209b21085b > Indeed! Spooky :)

Re: [sqlite] like query

Dominique Devienne wrote: > My $0.02 is that such a chr() function could/should be built-in to SQLite. Apparently, drh has a time machine: http://www.sqlite.org/cgi/src/info/209b21085b Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] like query

On Tue, Feb 26, 2013 at 2:31 PM, Clemens Ladisch wrote: > ... 'somedata/' || CAST(x'F48FBFBF' AS TEXT) > Great trick! But it hardly qualifies as user friendly though, no? For our app, I added a chr() SQL function that take an arbitrary number of integers and UTF-8 encodes

[sqlite] SQLite4 UPDATE performance

I wrote up a test case to do some performance tests for the update statement, and I'd thought I'd ask before probing around the code first. I did some comparisons with SQLite3. The update statement is like this: update pk_sk set sk=? where pk=? pk being the primary key. Using the command line