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

[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 sqlite-users@maili

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 very much! > > mysql>

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, 2013 at 5:35 PM, Tim Johnson wrote: > > > >

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"? >> I specifically need LE

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 th

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 o

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 [mailto:sqlite-users-boun...@

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 shoul

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 sqlite3.e

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", "SALE

[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 ther

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 wil

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. > >> Is it really DE

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 serv

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

r reason, 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> wrote: > >>> Hi, >>> I am planning

[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 mai

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 > link

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 read 'worse' instead of 'worst', of course!

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, January 13, 2009 3:43 AM Subject: [sqlite] Is

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" To: "General Di

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 periods > Hi all, > I'm having trouble adding data wit

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: Monday, December 01, 2008

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 syntax > Hi guys, > > i

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), zi

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 Released 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

transaction 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; rega

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 necessa

[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 bypas

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 with ":memory:"), then add t

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 floating point values in

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 CREATE TABLE command Hi

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 create table. rc = sqlite3_o

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 column quickly On Sat, May

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: "Mic

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 ?? hello, As I read h

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 11:20 PM Subject: Re: [sq

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 ( id integer primary key,

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 doing after looking at the VDB

[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 whi

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

t;[EMAIL PROTECTED]> To: 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 index). But th

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

- Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: 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: - Original Message - Because

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

- Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: 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 was loading a file to sqlite (3.3.

[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] sqlite performance questions.

Hi, Could you tell me what breaks the transaction? Is create table/index within transaction breaks it? best regards, Radzi. - Original Message - From: "Isaac Raway" <[EMAIL PROTECTED]> To: Sent: Thursday, October 19, 2006 2:07 AM Subject: Re: [sqlite] sqlite performance questions.

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 2006 09:53:19 +0800, you w

[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 pro

[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.