Re: [sqlite] many-one relation

EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, October 8, 2007 9:10:22 PM Subject: Re: [sqlite] many-one relation On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote: > We got two tables, tableA & tableB. > > tableB is turning out to be a many-one relation where in w

[sqlite] many-one relation

Hi All, We are designing a data base landed in some problems would like to know what approach is the best. We got two tables, tableA & tableB. tableB is turning out to be a many-one relation where in we have many rows of tableA mapping to one row of tableB, would like to know what is the

Re: [sqlite] Re: Auto Increment of Integer Primary Key

I think if it would have been unsigned we could have got more range, as anyways negative numbers doesn't make sense as PK's, of course reaching the 2^63-1 is remote (or probably impossible) -x- Chetana - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite

Re: [sqlite] Re: multiple selects in a single prepare

ubject: [sqlite] Re: multiple selects in a single prepare * chetana bhargav <[EMAIL PROTECTED]> [2006-12-28 06:00]: > Just wanted to know can we have multiple quries in a single > prepare statement seperated by semicolons.Something like, > > Select count(*) from tbl where name=&q

[sqlite] multiple selects in a single prepare

Hi, Just wanted to know can we have multiple quries in a single prepare statement seperated by semicolons.Something like, Select count(*) from tbl where name="foo";select count(*) from tbl1 where name = "bar" ... Chetana. __ Do You Yahoo!?

[sqlite] conditional code in trigger

Hi , I have two seperate triggers like, CREATE TRIGGER cnt1 AFTER INSERT ON tbl1 WHEN (new.Id =1 and new.priority > 2 ) BEGIN update cnt set Critical = (SELECT Critical from msgs_cnt where Id=1) + 1 where Id=1; end; CREATE TRIGGER cnt2 AFTER INSERT ON tbl1 WHEN (new.Id =1 and

Re: [sqlite] problem with Triggers

em with Triggers chetana bhargav <[EMAIL PROTECTED]> wrote: > Hi, > > I was trying out to test some trigger stuff, basically > if I have 2 connections open, and one of the connection > registered a user defined function to be invoked. Now > when the other connectio

[sqlite] problem with Triggers

Hi, I was trying out to test some trigger stuff, basically if I have 2 connections open, and one of the connection registered a user defined function to be invoked. Now when the other connection inserts into table was trying to see if the first functions registered function is called or not.

[sqlite] indexes in memory

Hi, I have a question regrading indexes, When I open a connection, Will indexes be loaded into memory. If one of the tables in the DB, the connection for which I have opened, has an index. If, so is there any way to selectively load/unload that from memory. ... Chetana.

Re: [sqlite] Loading a table into memory

-users@sqlite.org Sent: Tuesday, November 7, 2006 10:56:07 AM Subject: Re: [sqlite] Loading a table into memory you can use a database named :memory: Is that what you were looking for? On 11/6/06, chetana bhargav <[EMAIL PROTECTED]> wrote: > Hi, > > I have a read only table, whic

Re: [sqlite] Sqlite DB file sizes

Try to see the reply, at http://www.mail-archive.com/sqlite-users@sqlite.org/msg19255.html ... Chetana - Original Message From: Dave Gierok <[EMAIL PROTECTED]> To: "sqlite-users@sqlite.org" Sent: Monday, November 6, 2006 10:10:39 PM Subject: RE: [sqlite]

Re: [sqlite] Sqlite DB file sizes

Pls see this message. http://www.mail-archive.com/sqlite-users@sqlite.org/msg19255.html ... Chetana. - Original Message From: Dave Gierok <[EMAIL PROTECTED]> To: "sqlite-users@sqlite.org" Sent: Monday, November 6, 2006 10:10:39 PM Subject: RE: [sqlite] Sqlite

[sqlite] Loading a table into memory

Hi, I have a read only table, which is very small(Bytes of storage consumed. 1024 from the analyzer). I am wondering is there any way to load this table in memory and unload it later. ... Chetana.

Re: [sqlite] Re: Re: Testing For Empty Table

Just wanted to know doesn't the use of "LIMIT 1 " optimise it. select count(*) from component where category='natural' limit 1 ... Chetana. - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite Sent: Sunday, November 5, 2006 5:28:23 AM

[sqlite] Indexes analysis

Hi, I am trying to analyze index usage for my queries for performance. Basically I found two methods, One of them EXPLAIN QUERY METHOD. And the other is idxChk tool. My DB is of latest version of 3.3.8. When I checked for idxChk tool page it says it was tested only till 3.2.7. Just wanted

[sqlite] unsigned shorts in bindInt on ARM

Hi, I saw a strnage problem using unsigned shorts, not sure if any one saw that, I was using an unsigned short for binding it to integer, the lint wasn't complaining and everything seem to go ahead fine, when I tested that on windows, all my querys were returning as expected. But when I moved

[sqlite] Journal file and EFS space

Hi, We are using embedded flash file system, now we have catch22 situation. When the EFS is full (we seeing this when we have <13k on EFS, ofcourse out of that 13k some will go for system) , the users aren't able to delete any content from the EFS. sqllite3_step() is returning error. We

[sqlite] PK and rowid

Hi, If I declare my column as, "uniqId integer primary key", now if I say something like, select * from tbl1 where uniqId=x; Will the uniqId be same as rowid, making my table look ups faster as I am using row id only. If not whats the way to assign my uniqId to the row id so that

[sqlite] transaction and tables

Hi, I have a query regarding transactions and tables. Say in a DB if you have 4 tables, now in my code I will say , "begin transaction" and start modifying a table, say tbl1, now a journal would be backed up for the tbl1 that I am going to modify, now if in the same transaction if

Re: [sqlite] Bind

<[EMAIL PROTECTED]> wrote: chetana bhargav wrote: > > I am just wondering what will happen, if I bind a column with null intially, > but later in my path if I bind some integer value, which value will be > considered while excuting step function. Note its on the same pre

[sqlite] Bind

Hi, I am just wondering what will happen, if I bind a column with null intially, but later in my path if I bind some integer value, which value will be considered while excuting step function. Note its on the same prepared statement and before doing a reset of the statement. .

[sqlite] trigger and schema error

Hi, Wanted to conform once, I am caching some of the prepared statements in memory, now if some one adds a trigger to another table in the same DB. Do we still get schema change error. -Chetan - Do you Yahoo!? Everyone is raving

[sqlite] Reg number of tables.

Hi, I wanted to know will there be any performance impact if the number of tables in a DB grow. I am planning to have around 8-9 tables in a single DB, so want to make sure does it have any affect. Is there any number for optimal usage. Apart from tables we may have indexes (of course not

Re: [sqlite] pre-compiling prepared statements

It does make a difference with embedded deivces, where both speed and memory constraints matter a lot. -Chetan. Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 9/1/06, John Stanton wrote: > I believe that Dr Hipp has available a special version of Sqlite which > stores prepared statements.

Re: [sqlite] pre-compiling prepared statements

. If any one can explain me correctly what sqlite3_prepare does apart from preparing the statement, and does prepare means generating the byte codes necessary. Thanks in advace, -Chetan. Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 9/1/06, chetana bhargav wrote: > Hi, > &g

[sqlite] pre-compiling prepared statements

Hi, Is there any way to pre compile some of the prepared statements during compile time. I am having 4 tables of which two tables doesn't create any triggers/joins. I am basically trying to speed up the queries on these tables (as they are most frequently used). I am looking for ways so

[sqlite] More on triggers

Hi, I just want to confirm one more thing, If two tasks create two seperate triggers each of its own, on the same condition each not caring whether already a trigger exists, and both of them had opened a session, now if the trigger is fired which one will be notified? 1)

Re: [sqlite] About Triggers

) Cheers, Chetan Roberto <[EMAIL PROTECTED]> wrote: - Last time I tried, the triggers are triggered only for the calling thread which registered the function. - When the trigger is fired, you can refer to any field in the table. HTH. On 07/08/06, chetana bhargav wrote: > Hi, >

[sqlite] About Triggers

Hi, I have few questions regarding triggers, * If we want to have trigger for some condition and if multiple applications create a trigger for the same condition providing different C callback functions (which I guess is possible through sqlite3_create_function), will the trigger be

Re: [sqlite] indexes

Thanks for the info. Cheers, Chetana. Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 4/17/06, chetana bhargav wrote: > Am I correct in saying that once we create an index on a table what ever the > new records added would be done according to the index mentioned. > > I

Re: [sqlite] indexes

TED]> wrote: On 4/17/06, chetana bhargav wrote: > I just want to know, if we create an index on any table, how the index is > stored, is it stored in a seperate file or as part of the current table only > in the same file. There's only one file no matter how many tables or ind

[sqlite] indexes

Hi, I just want to know, if we create an index on any table, how the index is stored, is it stored in a seperate file or as part of the current table only in the same file. Cheers, Chetana - New Yahoo! Messenger with Voice. Call

[sqlite] about deletion

Hi, I just want to know how rows are deleted, its same like insertion where we create journal? -x- - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

[sqlite] feild value pairs

Hi, My requirement is that, I want to store some common properties and some more optional properties depending on the need of each application. Where these optional properties need to be stored as feild value pairs. Most of the values(almost 99.5%) values are of integer type. And there

[sqlite] aynchronous loading

Hi, Does sqlite provides asynchronous loading of data. Basically if I have something around 3000 records and want to do some query, instead of returning the result in one single query is it possible for me to relinquish the control to other apps so that I wont get a time out error. and

[sqlite] Indexing

Hi, I am sure that this question would have been asked many times earlier also. I am new to this list, can any one point me about some info on indexing in SQLite. The time efficiency and space it requires. Some Do's and Dont's about indexing. Thanks for the help in advance.

[sqlite] Auto Increment?

Auto increment seems to return a unsigned long long is there any way for it to make it as 32 bit, as I am depending on this feilds to generate unique id, and i have a constraint fot the id to be 32 bit only. __ Do You Yahoo!? Tired of spam?