[sqlite] Suppress auto index

2008-01-09 Thread Yuvaraj Athur Raghuvir
Hello, When I upload data from a file into a table, I see that SQLite creates an auto index table. Is it possible to instruct SQLite not to create any auto indices for the tables I create? If so, how? Thanks and Regards, Yuva

[sqlite] How to persist MAX_PAGE_COUNT?

2008-01-08 Thread Yuvaraj Athur Raghuvir
Hello, I am not able to persist the MAX_PAGE_COUNT on the database I am using. OS : Windows Version: 3_5_4 dated 14.Dec.2007 1) Create a database - say store01.sqlite 2) Open store01.sqlite using sqlite.exe 3) Execute "pragma MAX_PAGE_COUNT = 20;" 4) Execute "pragma MAX_PAGE_COUNT;" -->

[sqlite] How to persist MAX_PAGE_COUNT?

2008-01-08 Thread Yuvaraj Athur Raghuvir
Hello, When I set the MAX_PAGE_COUNT and retrieve the value in the same connection, I get what I set. However, when I use a new connection to the database, I get the default value. Also if I close all connections and restart, I am getting the default value. Statements used: PRAGMA

[sqlite] Size of Meta data ?

2008-01-04 Thread Yuvaraj Athur Raghuvir
Hello, Is there any way to estimate the size of the metadata of a SQLite database? I am trying to do the following: 1) Set the DB size using MAX_PAGE_COUNT and PAGE_SIZE parameters 2) I want to do a bulk insert. 3) However, I want to insert only those many records such that the insert succeeds.

[sqlite] Re: SQLite and Columnar Databases

2007-12-17 Thread Yuvaraj Athur Raghuvir
are getting blurred. Thoughts? Regards, Yuva On Dec 13, 2007 4:42 AM, Yuvaraj Athur Raghuvir <[EMAIL PROTECTED]> wrote: > Hello, > > There seems to be a high interest in columnar databases recently. > > Is there any plan of supporting data organization as a columnar datab

[sqlite] SQLite and Columnar Databases

2007-12-12 Thread Yuvaraj Athur Raghuvir
Hello, There seems to be a high interest in columnar databases recently. Is there any plan of supporting data organization as a columnar database in SQLite? What are the challenges here? Regards, Yuva

Re: [sqlite] Regarding explicitly managing SQLite Databases....[Resend]

2007-12-11 Thread Yuvaraj Athur Raghuvir
. How do I ensure that there is nothing pending in the memory so that external file size APIs are accurate for my work? ~Yuva On Dec 11, 2007 2:18 PM, Dan <[EMAIL PROTECTED]> wrote: > > On Dec 11, 2007, at 3:00 PM, Yuvaraj Athur Raghuvir wrote: > > > 1) Can I assume that MAX_P

Re: [sqlite] Regarding explicitly managing SQLite Databases....[Resend]

2007-12-11 Thread Yuvaraj Athur Raghuvir
AIL PROTECTED]> wrote: > > On Dec 11, 2007, at 8:39 AM, Yuvaraj Athur Raghuvir wrote: > > > Hello, > > > > I am trying a simple experiment where I want to limit the size of > > the file > > that SQLite uses. Further, I want to manage the growth of the > > d

[sqlite] Regarding explicitly managing SQLite Databases....[Resend]

2007-12-10 Thread Yuvaraj Athur Raghuvir
Hello, I am trying a simple experiment where I want to limit the size of the file that SQLite uses. Further, I want to manage the growth of the database(s) explicitly. One of the first aspects I want to manage is the size of the file on the disk. I want to set hard limits on the size and during

[sqlite] Explicitly managing multiple SQLite databases.....

2007-12-10 Thread Yuvaraj Athur Raghuvir
Hello, I am trying a simple experiment where I want to limit the size of the file that SQLite uses. Further, I want to manage the growth of the database(s) explicitly. One of the first aspects I want to manage is the size of the file on the disk. I want to set hard limits on the size and during

[sqlite] How to create DLL for windows?

2006-10-02 Thread Yuvaraj Athur Raghuvir
Hello, I have sync'ed and created the exe using Cygwin on Windows. I also have the libtool available. Now, I donot see the dll that I can use in Windows environment. How to create a dll? Regards, Yuva