Re: [sqlite] SQLite port to RTOS

Thank you very much Donald Griggs On 9/3/2013 6:18 PM, Donald Griggs wrote: Hello, Prakash, In addition to John McKown's fine advice, you might possibly want to attempt to contact Kritesh Tripathi, who posted in 2012 that he was using sqlite with iTron RTOS, which seems it may be a cousin of

Re: [sqlite] SQLite port to RTOS

Hi Kees Nuyt, That was really helpful. Also I have another doubt. Eventually I will be running sqlite integrated with other modules in a board. As far as I have read I suppose that sqlite treat a database as a file. Adding data to the database and retrieving data from

Re: [sqlite] count from 2 tables

On 9/3/2013 6:52 PM, ChingChang Hsiao wrote: What is the count of services have more than 2 service_port(sp) and type is e-lan? The answer is 1. Could it be described as one sql statement? select count(*) from service_table s where service_type = 'e-lan' and (select count(*) from

Re: [sqlite] BETWEEN and explicit collation assignment

On Thu, Aug 29, 2013 at 6:35 PM, James K. Lowden wrote: > On Tue, 27 Aug 2013 21:00:50 -0500 > Nico Williams wrote: > >> Of course, lacking a syntax for associating collations with string >> literals there will be times when some, or even all of

[sqlite] count from 2 tables

CREATE TABLE service_table ( service_nameTEXT, /* name of the service (unique) */ service_no INTEGER, /* internal service number, assigned by the system. */ service_typeTEXT, /* Type of Service. Should be one of

Re: [sqlite] Query problems

On Mon, 2 Sep 2013 13:48:02 +0100 Simon Slavin wrote: > > On 2 Sep 2013, at 8:25am, Eduardo Morras wrote: > > > Or create the index with collate > > > > CREATE INDEX idx_collated_column ON myTable ( column COLLATE NOCASE ) > > The problem with doing

[sqlite] count from 2 tables

CREATE TABLE service_table ( service_nameTEXT, /* name of the service (unique) */ service_no INTEGER, /* internal service number, assigned by the system. */ service_typeTEXT, /* Type of Service. Should be one of

Re: [sqlite] What am I missing when recovering a hot journal?

On Mon, 2 Sep 2013 21:45:04 -0700 Michael Foss wrote: > You are right that new data is usually more than a single INSERT. I will > try out your suggestion of opening and closing the database file outside of > each transaction. > > I am also going to look into WAL

Re: [sqlite] SQLite port to RTOS

On Mon, 26 Aug 2013 18:33:02 +0530, Pratheek Prakash wrote: >Hi all, > I had downloaded the SQLite ver 3.8 code base from the >SQLite website. In the documentation they say that it supports Unix >(Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE,

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Marc L. Allen > Sent: dinsdag 3 september 2013 15:55 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Inefficient covering index used for Subversion

Re: [sqlite] [CRASH] Segmentation fault since 3.8.0

On Tue, Sep 3, 2013 at 9:09 AM, Richard Hipp wrote: > > > We should have a proper fix before too long. > > That fix can now be seen at http://www.sqlite.org/src/info/0303d6bc71 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

Am I understanding that, in this example, the I_NODES_PARENT is being chosen as the search index because... it's smaller and therefore faster to find initial qualifying rows that you can then use in some sort of ordered lookup in another index/table? I'm always in awe of some of the plans a

Re: [sqlite] [CRASH] Segmentation fault since 3.8.0

On Mon, Sep 2, 2013 at 11:07 PM, Alexandre Courbot wrote: > Hi everyone, (not subscribed to the ML, please CC) > > The following happens since 3.8.0 (tested on both 3.8.0 and 3.8.0.1): > > Could this be related to the new query planner? > No. This seems to be due to the new

Re: [sqlite] SQLite port to RTOS

Hello, Prakash, In addition to John McKown's fine advice, you might possibly want to attempt to contact Kritesh Tripathi, who posted in 2012 that he was using sqlite with iTron RTOS, which seems it may be a cousin of ulTron RTOS (correct?). http://search.gmane.org/?author=kritesh+tripathi=date

Re: [sqlite] SQLite port to RTOS

Thank you very much Mr.McKown On 9/3/2013 5:36 PM, John McKown wrote: I think you're on the wrong list. This is more a "how to use" type forum. You might want to subscribe to sqlite-dev ( http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev) where the developers hang out. You may not have

Re: [sqlite] [CRASH] Segmentation fault since 3.8.0

On Mon, Sep 2, 2013 at 11:07 PM, Alexandre Courbot wrote: > Hi everyone, (not subscribed to the ML, please CC) > > The following happens since 3.8.0 (tested on both 3.8.0 and 3.8.0.1): > > $ cat |sqlite3 > create table t1(id INTEGER); > create table t2(id INTEGER, v INTEGER); >

[sqlite] [CRASH] Segmentation fault since 3.8.0

Hi everyone, (not subscribed to the ML, please CC) The following happens since 3.8.0 (tested on both 3.8.0 and 3.8.0.1): $ cat |sqlite3 create table t1(id INTEGER); create table t2(id INTEGER, v INTEGER); insert into t1 values(1); select distinct t1.id from t1 left join t2 on t2.id = t1.id order

Re: [sqlite] SQLite port to RTOS

I think you're on the wrong list. This is more a "how to use" type forum. You might want to subscribe to sqlite-dev ( http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev) where the developers hang out. You may not have gotten any response because nobody here has tried and so has no

Re: [sqlite] SQLite port to RTOS

Hi, Somebody please shed some light on my doubt... Regards Pratheek On 8/26/2013 6:33 PM, Pratheek Prakash wrote: Hi all, I had downloaded the SQLite ver 3.8 code base from the SQLite website. In the documentation they say that it supports Unix (Linux, Mac OS-X, Android,

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: dinsdag 3 september 2013 02:12 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Inefficient covering index used for Subversion

Re: [sqlite] Is SQLite a DBMS?

Surely this is all about context - SQLite is a DBMS and a RDBMS for "computer" systems, not for card index or DNA, but so are Microsoft Access, and Foxpro, and many others, each with their own strengths, weaknesses, and varying ways of achieving management of the data. -- Stephen Hughes