[sqlite] Database Open takes most of the time??

Hi, I want to replace file based storage system with SQLite. Flat file storage is much faster (20-100 milli seconds) if the storage data is less. As the data increases the transaction(create/update/delete) time increases and reaches to 1. 1 seconds. Any Transaction(create/update/delete) in

[sqlite] Password-function in SQLite?

Is there any function in SQLite to mask input values like 'password('anything')' in MySQL? I would need this, because of the sqlite-db-files can be opened and read by any text-editor and sometimes I must store connection-data(ip's, passwords etc.) in the db. Thanks, hermann

Re: [sqlite] CVS branch

aducom wrote: Will there be a version 14 with blob support? (The escape routines are needed in the dll, but are only available in cvs?) Will the experimental version 3.0 and follow-up also be available as a dll binary? (Windows). I would like to investigate differences in an early stage for

Re: [sqlite] Use of alloca() in SQLite sources

On Mon, 26 Apr 2004, D. Richard Hipp wrote: ~ If I make use of alloca() in SQLite version 3, will this ~ cause any extreme hardships? Who is using a C compiler to ~ build SQLite that does not support alloca()? I have been avoiding using it for my programs heeding the following warnings from the

RE: [sqlite] FW: Help with Porting Problem

Christian, Thanks for your reply. I have been side-tracked for a few days. But thanks for your suggestions. You are correct. My changes are confined to os.c: 1.- Use file descriptors instead of inodes in file lock hash keys (We're using DOS). 2.- access() function changed to either a nop or

Re: [sqlite] Use of alloca() in SQLite sources

D. Richard Hipp wrote: If I make use of alloca() in SQLite version 3, will this cause any extreme hardships? Who is using a C compiler to build SQLite that does not support alloca()? I could be wrong, but I think alloca() may not be available to CodeWarrior. It probably wouldn't be hard to

[sqlite] archive?

Hi, is there an archive of this list somewhere? -Michal - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Use of alloca() in SQLite sources

Will Leshner [EMAIL PROTECTED] wrote: I could be wrong, but I think alloca() may not be available to CodeWarrior. No, looks like it's defined in CodeWarrior for Mac and Windows, at least in the latest version (CodeWarrior Dev. Studio 9). -- James W. Walker, ScriptPerfection Enterprises, Inc.

Re: [sqlite] Use of alloca() in SQLite sources

If I make use of alloca() in SQLite version 3, will this cause any extreme hardships? Who is using a C compiler to build SQLite that does not support alloca()? Warning: there are gcc bugs in the x86 optimizer related to alloca(). E.g.,

Re: [sqlite] MINUS keyword

Does SQLite support the subtraction of queries ... Yes, but 'minus' is not a keyword in std SQL. See http://www.sqlite.org/lang.html#select for the correct syntax. Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [sqlite] Password-function in SQLite?

You can create a new function to do this quite painlessly. Poke around the wiki for information on creating a new function, or read the source. But beware: consider creating one that uses SHA1 or MD5 as a hashing function instead of your local systems' crypt() as not all crypt() are created

Re: [sqlite] MINUS keyword

Drew, Stephen wrote: Does SQLite support the subtraction of queries, e.g. SELECT * FROM TABLE_A MINUS SELECT * FROM TABLE_B Use EXCEPT instead of MINUS. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To