Re: [sqlite] Making blob as a sqlite database.

ned this to > developers around me and they are intrigued. You are storing a database > file as blob in a database? We are curious as to the application. I am > assuming the database being stored is a collection of sensor or event data? > > On Fri, Apr 26, 2019 at 5:48 PM Mohd Radz

[sqlite] Making blob as a sqlite database.

Hi, is there a vfs that could be used to open a blob column as a database? thanks. Radzi. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problem with clause "where X in (...)"

Hi, I thought that I hit a bug with SQLite 3.28.0 and 3.27.1 when my in-list contains too many items the code breaks here: The sqlite3_step just exit without returning any error code. best regards, Radzi ___ sqlite-users mailing list

Re: [sqlite] de...@ukr.net

select from (select ... ) must have alias. It should be select from (select ... ) a On Tue, May 20, 2014 at 9:38 AM, YAN HONG YE wrote: > Hi, > Sorry, I use mysql, not in sqlite, in mysql ,I run this command, the > console show this error: do you know why? > Thank you

Re: [sqlite] Web application with SQLite

fossil is a webserver by itself with sqlite as the database engine. AFAIK, there's no scripting language used on the server. All written in C. On Mon, Dec 30, 2013 at 1:02 AM, Tim Johnson wrote: > * Stephan Beal [131229 07:48]: > > On Sun, Dec 29,

Re: [sqlite] Hints for the query planner

who have to deal with more than one database engine would prefer to use use such a pragma to adjust such implementation behaviour. pragma set_text_match_probability %value% pragma set_pattern_match_probability %value% Ibrahim ___ sqlite-users

Re: [sqlite] UPDATE question

Further comment : If you want to implement a sequence of records in a table you can do it much faster with only on record to update when you insert a value in the middle of this sequence. For this purpose you shouldn't use a pseudo array but a single or double ended queue with only one

Re: [sqlite] UPDATE question

workaround for your problem : create table t1 (pk integer primary key, name text, seq integer) ; create unique index idxt1 on t1 (name,seq) ; insert into t1 values (1, 'blue', 1) ; insert into t1 values (2, 'blue', 2) ; insert into t1 values (3, 'blue', 3) ; insert into t1 values (4, 'blue', 4)

Re: [sqlite] UPDATE question

On 06.09.2013 20:52, Igor Tandetnik wrote: On 9/6/2013 1:05 PM, ibrahim wrote: Perhaps you should really try it out cause my suggestion is totally different from yours it uses a temporary table it works. create table t1 (pk integer primary key, name text, seq integer) ; You missed the whole

Re: [sqlite] UPDATE question

On 06.09.2013 18:30, Dominique Devienne wrote: On Fri, Sep 6, 2013 at 5:41 PM, ibrahim <ibrahim.a...@googlemail.com> wrote: You can let sqlite handle the creation of a temporary table by : update t1 set seq=seq+1 where pk in (select pk from t1 where seq >= 3 order by seq desc) ; a

Re: [sqlite] UPDATE question

On 06.09.2013 18:30, Dominique Devienne wrote: On Fri, Sep 6, 2013 at 5:41 PM, ibrahim <ibrahim.a...@googlemail.com> wrote: You can let sqlite handle the creation of a temporary table by : update t1 set seq=seq+1 where pk in (select pk from t1 where seq >= 3 order by seq desc) ; a

Re: [sqlite] UPDATE question

On 05.09.2013 20:20, Peter Haworth wrote: I have a table with the following (simplified) structure PKeyINTEGER PRIMARY KEY NameTEXT Sequence INTEGER The Name/Sequence pair of columns is defined as UNIQUE I need to insert a new row into a point between two sequence numbers. For example, if

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

On 16.08.2013 18:03, Gary Weaver wrote: Thanks to you and Richard for the links and info. Concurrency is not outlandish to expect, especially when it works in OS X and just not in the Ubuntu vm in Travis, but I now understand that these are expected problems.

Re: [sqlite] Concurrent inserts -> DB corruption in travisci vm with sqlite 3.7.9

On 15.08.2013 21:39, Gary Weaver wrote: SQLite varies between file is encrypted/not a DB errors and database disk image is malformed. It would seem consistent with SQLite not handling concurrent processing in this particular environment or with the version of SQLite since 3.7.7 is fine in OS

Re: [sqlite] select prepared statement always returning SQLITE_DONE

after sqlite3_reset () all bound parameters keep their values they are not unbound or nullified by default so for that purpose you would have to call sqlite3_call_bindings () see link http://www.sqlite.org/c3ref/clear_bindings.html this is not necessary if you want to keep all bound values

Re: [sqlite] Where Clause

On 02.08.2013 10:14, techi eth wrote: Come across one issue with conditional query execution. Query: UPDATE COMPANY SET Name= 'test' WHERE ID = 2; According to my understanding if no ID = 2 is present in table then error should return but it return with SQLITE_OK however Name value is not

Re: [sqlite] Comparing two tables column by column

On 30.07.2013 14:49, fnoyan...@yahoo.com wrote: Yes, it is slow actually. But I could not do it with SQL. I wish I could do more with SQL than code, which would give a good performance improvement. From overall application point of view, I may be considering using threads to read from

Re: [sqlite] System.Data.SQLite: Leading zeros being stripped off

On 16.07.2013 13:26, Bernd Lehmkuhl wrote: On 16 Jul 2013, at 4:39am, Bernd Lehmkuhl wrote: Am 15.07.2013 22:26, schrieb Simon Slavin: The following two statements do different things. INSERT INTO myTable VALUES (01) INSERT INTO myTable VALUES ('01') Can you tell what's being

Re: [sqlite] sqlite abnormal IO writing

On 21.04.2013 05:15, 刘运杰 wrote: Ok,I do not make my means clearly. I mean 60 seconds after my program started,not token 60 seconds to load database file. Now, I got the reason of sqlite abnormal IO writing,it about batch insert. Here is my usecase: One table about 4 column and 500 row,the

Re: [sqlite] SQL Logic error or missing database

On 05.04.2013 17:01, Dan Kennedy wrote: On 04/05/2013 09:08 PM, Rob Collie wrote: Yeap, I'm on Visual Studio 2012. I've created a console app: sqlite3 *oDatabase; int returnValue; returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db", , SQLITE_OPEN_CREATE, NULL); if

Re: [sqlite] SQL Logic error or missing database

On 05.04.2013 16:47, Rob Collie wrote: sqlite3_open_v2("file://C:/Newfolder/testing.db", > > > >& oDatabase, SQLITE_OPEN_CREATE, NULL); Can you try : returnValue = sqlite3_open_v2 ("C:\\Newfolder\\testing.db", , SQLITE_OPEN_CREATE, NULL) ; Use double backslash also after "file://"

Re: [sqlite] SQL Logic error or missing database

On 05.04.2013 14:54, Rob Collie wrote: Hello there, For my sins, I'm trying to create a library allowing our legacy fortran code to work with SQL. Calling this from fortran... CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue) ...runs the following code, and yet the error returned is

Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

Those measurements asume that you store each blob in a seperate file. So the raw file access seems slower for smaller blob sizes. If you use external blob storage do it in raw clusters like i suggested in a previous post (size limit 32/64 MB) and store your blobs on page boundaries (page size

Re: [sqlite] Performance with journal_mode = off

In reference to your needs one more suggestion : >> If you put the blobs outside of a sqlite database and store your householding, indexing data inside your sqlite data i would suggest to use journal mode = on because your journal file and database file without the blobs has a small amount

Re: [sqlite] Performance with journal_mode = off

From : http://www.sqlite.org/pragma.html#pragma_journal_mode The OFF journaling mode disables the rollback journal completely. No rollback journal is ever created and hence there is never a rollback journal to delete. The OFF journaling mode disables the atomic commit and rollback

Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

On 29.03.2013 20:17, Jeff Archer wrote: I have previously made an apparently bad assumption about this so now I would like to go back to the beginning of the problem and ask the most basic question first without any preconceived ideas. This use case is from an image processing application. I

Re: [sqlite] Performance with journal_mode = off

On 29.03.2013 19:42, Jeff Archer wrote: From: "James K. Lowden" To: sqlite-users@sqlite.org Your experiment is telling you different: transaction control costs more than I/O. But shouldn't transactions be disabled when journal_mode = off? Maybe that is a faulty

Re: [sqlite] Performance with journal_mode = off

On 28.03.2013 14:03, Jeff Archer wrote: On Thu, Mar 28, 2013 at 8:24 AM, ibrahim <ibrahim.a...@googlemail.com> wrote: On 28.03.2013 13:09, Jeff Archer wrote: On Wed, Mar 27, 2013 at 6:35 PM, Simon Slavin <slav...@bigfraud.org> wrote: Reasonable figures. With 5764 writes

Re: [sqlite] Performance with journal_mode = off

On 28.03.2013 13:09, Jeff Archer wrote: On Wed, Mar 27, 2013 at 6:35 PM, Simon Slavin wrote: Reasonable figures. With 5764 writes to the disk in separates transactions you have quite a lot of reading of data plus 5764 attempts to update the database file. The updates

Re: [sqlite] Performance with journal_mode = off

On 27.03.2013 22:55, Jeff Archer wrote: On Wed, Mar 27, 2013 at 5:46 PM, David King wrote: I am populating a database with 5764 records using the exact same data set each time into a newly created file. When I use no explicit transactions (default atomic commit) it takes

Re: [sqlite] SQL:2003 -- Window Functions

On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik wrote: > On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote: > >> Too bad SQLite doesn't yet support SQL Window Functions. >> >> Are there any SQLite Extension Libraries that support "SQL:2003 type >> Window Functions"? >>

Re: [sqlite] SQLITE in a Win7 Service Application

On Wed, Aug 15, 2012 at 11:19 PM, markus ruettimann < markus.ruettim...@trapezegroup.com> wrote: > Hi, > We are facing problems when the sqlite database () is used within an > application that runs as a Win7 service under the local system account. > The application is written in Java and we use

Re: [sqlite] An interesting (strange) issue with selects

Could it be that the .ext is used by the OS or other apps with some caching scheme? Try different extension... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I consider this a bug. Anyone else?

On Tuesday, June 26, 2012, Andrew Rondeau wrote: > Because my time is valuable; and my peers' time is valuable as well. > > For example, if I make a Mac application, I can target the SQLites shipped > with Mac. Problem solved, my valuable time can go to something else. > > Since I don't want any

Re: [sqlite] insert if record not exists without primary key

Hi, I guess, if you could sort your input data by col1 and col2; going thru the list and insert only when col1 and col2 are different from previous row, should speed up the loading too. Regards, Radzi. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Problem with FTS4 - Floating point error.

On 25-Oct-2011, at 2:53 PM, Dan Kennedy wrote: > This was fixed and then I forgot to follow up here. I should have. > Sorry about that. It's fixed here: > > http://www.sqlite.org/src/ci/3126754c72?sbs=0 > > Either updating to the latest trunk or just applying the linked > patch to fts3.c

Re: [sqlite] Problem with FTS4 - Floating point error.

On 18-Oct-2011, at 6:52 PM, Dan Kennedy wrote: > > > On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote: >> Hi, >> >> This is my table schema: >> >> CREATE VIRTUAL TABLE LocationFTS using FTS4 >> ( >> name text, >> address tex

[sqlite] Problem with FTS4 - Floating point error.

Hi, This is my table schema: CREATE VIRTUAL TABLE LocationFTS using FTS4 ( name text, address text, email text, remark text, telno text, contact text, isDeleted text ); This select statement gives floating point error in both

Re: [sqlite] No error on selecting non-grouped column

On 15-Sep-2011, at 2:55 AM, Magnus Thor Torfason wrote: > > I then ran a query grouping employees by job: > > > select ename, job from emp group by job; > "ENAME", "JOB" > == > "FORD", "ANALYST" > "MILLER", "CLERK" > "CLARK", "MANAGER" > "KING", "PRESIDENT" > "TURNER",

[sqlite] FTS4 reserved characters

Hi, I was searching for any reference to reserved characters used in FTS4, but failed to find any. I have problem with query with - ftstable match 'width 5" ' But it's ok with - ftstable match 'width 5' to fix this, I replaces every double-qoute in query with empty space. My question, is

Re: [sqlite] Import data in SQLite from excel using C# code

Hi, Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel files. The rest are just normal sqlite commands. On 28-Mar-2011, at 9:17 AM, Deepti Marathe wrote: > > Hi, > > I am new to SQLite and am using it for the first time. I need to create an > application using C# that

Re: [sqlite] Creation and modification timestamps with "insert or replace" possible?

On 10-Mar-2011, at 6:52 AM, Jay A. Kreibich wrote: > On Wed, Mar 09, 2011 at 11:37:46PM +0100, Armin Kunaschik scratched on the > wall: >> On Wed, Mar 9, 2011 at 11:28 PM, Igor Tandetnik wrote: > >>> INSERT OR REPLACE is indistinguishable from a DELETE followed by INSERT.

Re: [sqlite] Fwd: Re: Bug: Umlaut in database filename

On 21-Dec-2010, at 5:02 AM, Richard Hipp wrote: > (2) Create your own custom mini-SQL-server using SQLite and your own > protocol for your applications to talk to that min-server over the network. The key here is to define your own app-specific protocol for communication between client and

Re: [sqlite] Bundling sqlite database together with exe file.

my client don't want anybody to copy the database, except together with the exe. > Monday, October 25, 2010, 1:17:13 AM, you wrote: > > KN> On Sun, 24 Oct 2010 20:57:15 +0800, Mohd Radzi Ibrahim > KN> <mra...@pc.jaring.my> wrote: > >>> Hi, >>&g

[sqlite] Bundling sqlite database together with exe file.

Hi, I am planning to deploy my sqlite database together with the exe file. Is there a way to open the sqlite database with a file handle and starting offset of the file, as read-only? Thank you for any suggestion. regards, Radzi. ___ sqlite-users

Re: [sqlite] Substring (LIKE "%key%") searches, would FTS3 with suffix-tree tokenizer be the fast way?

Have you not consider loading the whole rows into memory array and use simple string search or regexp? I'm sure 10,000 records could be search a blink. best regards, Radzi. On 6-Aug-2010, at 3:42 AM, Sam Roberts wrote: > I'd appreciate any suggestions on good ways to do this, I'm neither an SQL

Re: [sqlite] EXTERNAL: setup sqlite in vc++

Hi, You could also use another open source layer for SQLite3, wxSQLite3 project on sourceforge. It's uses wxWidgets cross-platform C++ toolkit. best regards, Radzi. On 7-Jul-2010, at 6:09 AM, smengl90 wrote: > > I found out that including the header file alone is not enough. I need to >

Re: [sqlite] Prohibitive indexing time with large tables

Am 14.02.2010 18:53, schrieb Max Vlasov: >> This is appx. 500MB cache, why not trying with 2,000,000 cache size ? :-) >> >> >> > Hmm, managed to increase it to only 1,000,000 (x1024) size, larger values > bring to "Out of memory" finally, and this values (1G) allows up to > 6,000,000 fast

Re: [sqlite] String Vs Integer Index

cess your data but that's not what the op asked for as far as i understood his question. Ibrahim. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] String Vs Integer Index

Am 10.02.2010 18:19, schrieb Alberto Simões: > Supose a table with a key that is a string (say, words from 1 to 10 > characters) or a table with a key of integers. > > How different is the efficiency on fetching one record on these tables? > > If you look into the documentation for "create

Re: [sqlite] any command to find last rowid in a table

Am 05.02.2010 22:33, schrieb Vasanta: > Kittayya: > > My issue is, I already have imported table in the Database, there alreay > around 1000 records in that table where ROWID is from 1 to 1000, now system > generates new events, where ROWID again starts from beginning from 1, now > these new

Re: [sqlite] Local data structures vs sqlite

I think "worth" should be more accurate. - Original Message - From: "Jean-Christophe Deschamps" To: "General Discussion of SQLite Database" Sent: Friday, November 06, 2009 9:47 AM Subject: Re: [sqlite] Local data structures vs sqlite > You

Re: [sqlite] Question on index efficiency

ue integer as a primary key you will have one index table less and the B+Tree will use your integer. Less space, faster access without losing anything. Hope this simple description will help. Ibrahim ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] trying to optimize left outer join for large data set (multiple indices needed?)

Hi, at the first sight i'd suggest that you reorder the rows of your index : it is most likely that chr and strand will have many equal values in your example - especially chr. When chr is the first field of your Index than the path to find first differences in the btree to find the matching

Re: [sqlite] Db design question (so. like a tree)

Jan schrieb: > thx Ibrahim. Give me some time to digest yours and other suggestions. > > But it seems I will end up with a adjunct list PLUS something. Of course > you are right: I need to store many other information for each animal. I > definitely need to use a database (s

Re: [sqlite] Db design question (so. like a tree)

One further advice : The fastest solution for your Problem would be to create a Array with fixed size Entries to describe the relationship between animals. in C you would simply end up with a struct like : struct ancestors { integer id_father ; integer id_mother ; } ; If you have a

Re: [sqlite] Db design question (so. like a tree)

store a few thousand values. You would get a bit faster results with hashing. But before you invent your proprietary engine i'd advice to use a relational database with sql. I think you'll store more than only parent information for the animals and

Re: [sqlite] how to compose the sql sentence?

Assumptions : Your database scheme contains this declarations CREATE TABLE data ( num INTEGER, di CHAR(4), data CHAR(12), time1 INTEGER, time2 INTEGER, format CHAR(1) ); CREATE UNIQUE INDEX i_data ON data ( num, di, time1 ); You want to do : A)

Re: [sqlite] sqlite programmed in C++

and the generation of the amalgamation with only C this would make the whole thing simpler to port and more independent from any external tools or plattforms and it would also make it possible to use all of the creation makros while you create the sourcecode. Ibrahim

Re: [sqlite] SQLite command line interpreter vs DLL

Fam. Sera schrieb: > Is there a reason why the command line interpreter supports more functions > while the dll does not? > > I would like to create an application using SQLite with and in memory > database. I have some big text files (csv), which can be imported nicely by > the command line

Re: [sqlite] Is this legal SQL?

You should use sprintf(buf, "CREATE TABLE %s(x double, y double)", tableName); then use prepare and execute using from that string. - Original Message - From: "Mike McGonagle" To: "General Discussion of SQLite Database" Sent: Tuesday,

Re: [sqlite] Adding data with periods

It seems to works either way. I'm just wondering is there any hidden reason that single quote is preferred? Portability? Or is double-qoute has some kind of special meaning that we should use it for that special purpose? -radzi- - Original Message - From: "P Kishor"

Re: [sqlite] Adding data with periods

The syntax is wrong. INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!"); is the correct one. -radzi- - Original Message - From: "aditya siram" To: Sent: Monday, December 15, 2008 1:04 PM Subject: [sqlite] Adding data with

Re: [sqlite] please help with NULL and NOTHING?

You should handle this in your client program. Even in MS SQL or Oracle, it will not return any resultset. If you were to use left join, you may get it as NULL for any missing links. rgd, Radzi. - Original Message - From: "aivars" <[EMAIL PROTECTED]> To: Sent:

Re: [sqlite] Help for sqlite syntax

Could you just use ORDER BY 1 ? best regards -- radzi -- - Original Message - From: "li yuqian" <[EMAIL PROTECTED]> To: Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2008 1:56 PM Subject: [sqlite] Help for sqlite

Re: [sqlite] Innovative examples / user stories

Hi, I used SQLite to move "data-cube" from server to client. The server hosts data in MS SQL databases. There is a server-app that run query based on some input send by client program. The server then run MSSQL query and generate a SQLite db consisting of some tables (fact, dimensions, etc),

Re: [sqlite] Version 3.5.5 Released

Hi, The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip still contain the 3.5.4 version regards, Radzi. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, February 01, 2008 1:33 AM Subject: [sqlite] Version 3.5.5

Re: [sqlite] How do I add primary key on existing table?

On 21-Jan-2008, at 3:12 PM, Dan wrote: On Jan 21, 2008, at 1:24 PM, Mohd Radzi Ibrahim wrote: Hi, I was trying to add a primary key to existing table but could not. "alter table custsales add constraint pk_custsales primary key (id, type)" Is this supported? Is there a differ

[sqlite] How do I add primary key on existing table?

Hi, I was trying to add a primary key to existing table but could not. "alter table custsales add constraint pk_custsales primary key (id, type)" Is this supported? Is there a different syntax to do this? best regards, Radzi.

Re: [sqlite] Re: Re: How do I do this

This is my 2 cents. Maybe there's better way to do this: select id, amount, (select amount from tablename where id=t.id and sno < t.sno limit 1) as oldAmount from tablename t br Radzi. On 14-Jan-2008, at 8:14 PM, Vishal Mailinglist wrote: Hi sno | id | amount 1

Re: [sqlite] disable transaction support

on support sqlite has to write into the journal files as well. i want to avoid this too. Thanks, Rasanth On Dec 26, 2007 11:34 AM, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: On the contrary, sqlite work much-much faster when insert/update is done within BEGIN and COMMIT; regards, Radzi

Re: [sqlite] disable transaction support

On the contrary, sqlite work much-much faster when insert/update is done within BEGIN and COMMIT; regards, Radzi. On 26-Dec-2007, at 12:14 PM, Rasanth Akali Kandoth wrote: Hi All, I have an application which inserts large number of rows into a table, where transaction support is not

[sqlite] Compile error sqlite 3.4.2

I'm using Visual Studio 2005 with wxSQLite3 wrapper. I have this error at this line : SQLITE_PRIVATE const unsigned char sqlite3UpperToLower[]; the error says: .\..\wxsqlite3\sqlite3\src\sqlite3.c(6187) : error C2133: 'sqlite3UpperToLower' : unknown size any suggestion on how to

Re: [sqlite] Saving an in-memory database to file

How about dumping and import into new db? - Original Message - From: "Colin Manning" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 25, 2007 7:05 AM Subject: [sqlite] Saving an in-memory database to file Hi If I create an in-memory database (by opening

Re: [sqlite] storing floating point values in field

I've run SQLite3 inWindows, it's store up it surely did not truncate the decimal point - up to 15 significant digits... regards, Radzi. - Original Message - From: "folabi" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 10, 2007 3:20 AM Subject: [sqlite] storing

Re: [sqlite] Multiple connections to the same database and CREATE TABLE command

Is C1 in transaction? If it is, commit will enable C2 'see' the new table. regards, Radzi. - Original Message - From: "Vivien Malerba" <[EMAIL PROTECTED]> To: Sent: Friday, May 11, 2007 4:19 PM Subject: [sqlite] Multiple connections to the same database and

Re: [sqlite] create table error

Could it be that the data where *sql is pointing to is being re-used somewhere? --radzi. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, May 10, 2007 3:54 PM Subject: [sqlite] create table error the following is my test code. just

Re: [sqlite] how to add a new column quickly

How about this? update tablename set newcolname=(case rowid when 1 then 1 else 2 end); best regards, Radzi - Original Message - From: "Tomash Brechko" <[EMAIL PROTECTED]> To: Sent: Saturday, May 05, 2007 8:09 PM Subject: Re: [sqlite] how to add a new

Re: [sqlite] DB design questions

My 2 cents: create table Objects(id integer primary key, name text); create table Attributes(id integer primary key, name text); create table ObjectAttributes(objectID integer, attributeID integer, order integer, type integer, value text, version text); - Original Message - From:

Re: [sqlite] trim available ??

Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... best regards, Radzi. - Original Message - From: "Stef Mientki" <[EMAIL PROTECTED]> To: Sent: Monday, April 16, 2007 10:14 PM Subject: [sqlite] trim available

Re: [sqlite] Data structure

Hi, If you are using C++, then try hash_map. I've used this on strings with more that 50,000 records - in memory. Very fast. Much easier to program than BerkeleyDB. - Original Message - From: "Lloyd" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 11, 2007

Re: [sqlite] RE: Maintaining Master-Child relationships

Use sqlite3_last_insert_rowid - Original Message - From: "Arora, Ajay" <[EMAIL PROTECTED]> To: Sent: Thursday, March 29, 2007 12:19 AM Subject: [sqlite] RE: Maintaining Master-Child relationships Can anyone please look into my query, I've tables Master (

Re: [sqlite] CREATE INDEX performance

- Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 28, 2007 7:42 AM Subject: Re: [sqlite] CREATE INDEX performance I retract the overflow page theory on your compelling evidence and now understand better what it is

[sqlite] Linking error with sqlite3SrcListAddAlias...

Hi, I'm using MS VS 2005 (SQLite 3.3.9) and having problem re-building the component. I've just included all the source code inside my project and compile. With version 3.3.8 it works fine, but with current (3.3.9) it's giving me missing sqlite3SrcListAddAlias. Any files should be included

Re: [sqlite] How do I speed up CREATE INDEX ?

TED]> To: <sqlite-users@sqlite.org> Sent: Sunday, December 03, 2006 8:21 PM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? "Mohd Radzi Ibrahim" <[EMAIL PROTECTED]> wrote: Hi, I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million rows (with no

Re: [sqlite] How do I speed up CREATE INDEX ?

- Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, December 03, 2006 10:42 AM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: - Origi

Re: [sqlite] How do I speed up CREATE INDEX ?

- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, December 03, 2006 9:12 AM Subject: Re: [sqlite] How do I speed up CREATE INDEX ? On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote: Hi, I

[sqlite] How do I speed up CREATE INDEX ?

Hi, I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million rows (with no index). But then when I run CREATE INDEX it took me 40 mins to do that. What could I do to speed up the indexing process ? Thanks. Radzi.

Re: [sqlite] How do i do this UPDATE in SQLite?

Thanks, that works. The syntax i used is allowed in MS SQL. best regards, Radzi. - Original Message - From: "Kees Nuyt" <[EMAIL PROTECTED]> To: Sent: Monday, October 16, 2006 1:54 PM Subject: Re: [sqlite] How do i do this UPDATE in SQLite? On Mon, 16 Oct

[sqlite] How do i do this UPDATE in SQLite?

update i set val=qty*q.price from salesrecord i inner join historicalprice q on i.itemid=q.itemid thanks. Radzi.

Re: [sqlite] Re: Terminating long query in C ?

Thank you guys for the suggestion. That's what I really need. Which one is better, the sqlite3_interrupt() or sqlite3_progress_handler()? My gut feeling is that sqlite3_interrupt() should be better since it does not interfere with the running of the query until it is signaled. Besides, the

[sqlite] Terminating long query in C ?

Hi, How do I cancel a long running query? In OLEDB I can call pICommand->Cancel() from a different thread to kill the running query. How can I do the same in SQLite? thanks. Radzi.

Re: [sqlite] Sql lite new user

Thanks you It works fine now

[sqlite] Sql lite new user

Hello, I m new to this mailing list , I currently try to add sql lite to a program I m working on It is a quizz program , And I want the question to be incorporated into a sql lite database to enable search ...etc.. I m download the source code of version 2_8_15 And compiled it under