[sqlite] Queries on SQLite

2012-06-14 Thread vallur raghava reddy
Hi, I have few queries on SQLite. I have listed them below, please go through them and answer. 1. Is SQLite POSIX compliant? 2. Does SQLite create a any threads? If YES, how many will be created? Previously I have sent few questions and the response was really good. I really

[sqlite] Disk file size

2012-06-06 Thread vallur raghava reddy
Hi, I have created a database "MyDb.db" and created a table MyTable using the query *create table MyTable (id INTEGER PRIMARY KEY, value CHARACTER(10))* and inserted 3000 records in the table.I executed query *select * from MyTable* it returned 3000 rows and was able to print all values. Now

[sqlite] (no subject)

2012-06-05 Thread vallur raghava reddy
Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1. What will be the Stack Size? 2.