[sqlite] Suppress auto index

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?

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;" --> retu

[sqlite] How to persist MAX_PAGE_COUNT?

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 MAX_PAGE_COUNT

[sqlite] Size of Meta data ?

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

[sqlite] Re: SQLite and Columnar Databases

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 database

[sqlite] SQLite and Columnar Databases

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]

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

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]

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 q

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

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 q

Re: [sqlite] How to create DLL for windows?

Do I need to uninstall my cygwin for mingw + msys to work? I see that when I run configure or make, cygwin utilities figure On 10/3/06, Miha Vrhovnik <[EMAIL PROTECTED]> wrote: Why don't you use mingw + msys enviroment? Google for more. Regards, Miha "Yuvaraj Athur R

[sqlite] How to create DLL for windows?

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