Re: [sqlite] [ANN] SQLcrypt 1.0
On Mon, Nov 22, 2004 at 09:24:36AM +1100, Dennis Volodomanov wrote: > Is anyone using the mentioned library? Is it stable and fast? (First one didn't get thru. Trying again...) Hi, I suggest you download and test the trial version, which works just like the retail version, apart from (a) being limited to a passphrase of exactly 8 bytes, and (b) have the passphrase stored in the clear in the first 8 bytes of the database file. Check out this script that does timing tests for SQLcrypt, SQLite v3, MySQL and PostgreSQL. The numbers posted on the SQLcrypt website are based on my puny test machine. I'd be interested to see your numbers. http://www.sqlcrypt.com/speedtest-sqlcrypt.tcl Just comment out the MySQL or PostgreSQL tests if you don't have them. Also see this page for discussions about the timing tests and the use of crypto. http://www.sqlcrypt.com/versus.html > Are there any other similar products for SQLite v3? drh has a source-code add-in. His uses RC4; SQLcrypt uses AES. His is available for both SQLite v2 and v3; SQLcrypt is SQLite v3 only. HTH. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog http://www.sqlcrypt.com -+- Database Engine with Transparent AES Encryption
[sqlite] Schema has changed Error
In a previous thread about sqlite_schema, I commented that there *is* a case where SQLITE_SCHEMA does get raised as an error, although DRH said that this is not possible in version 3.x. It turns out that I was wrong. The scenario I described does raise an error, but it is not SQLITE_SCHEMA, it is SQLITE_ERROR, and thus it is more difficult to handle. in short: if two processes are accessing the same database, and one modifies the schema, the other gets this error on first access. stranegely, this behavior can not be verified using the command line program, as it does not happen there. however, this probably has to do with how this particular program is using the API. I am using the library via the windows dll, and in this case the sqlite3_step function will return a value of SQLITE_ERROR when another process has modified the schema. when I try to retrieve an error description via sqlite3_errmsg(fdb), I get a message similar to "database schema has changed", however the error code returned was NOT SQLITE_SCHEMA,but SQLITE_ERROR. Clearly, this creates havoc in a multi-user environment, and my code does not have a neat way of handling it. Since the error is sqlite_error, the only indication that a retry would succeed is in the text description, and I would hate to have to issue retries based on the text content.. DRH, is this fixable ? shall I open a ticket ?
Re: [sqlite] SQLite Tutorial - [Request For Comments]
[EMAIL PROTECTED] wrote: >On Wed, Nov 24, 2004 at 04:41:37PM +0100, jacob navia wrote: > > >>Clay Dowling wrote: >> >> >> >>>Re: SQLite Tutorial >>> >>> >>> >>> http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download >>Hi! >>I have compiled the documentation of sqlite (3) in a CHM format, the >>standard help file >>format for windows. Would it be possible to add the tutorial to it? >> >> > >I have not used that tool, so I would not know how to add it. Are you >asking if you have the legal right to add it? Yes, this falls under the Open >Publication License. > >Regards, > >Mike Chirico > > Yes, OK I downloaded the license, and added it together with your tutorial to the documentation of sqlite. Thanks for making your work available for others. jacob
[sqlite] Re:[sqlite] sqlite-GUI - under linux
> hello freind's , > i am using sqlite on terminal .. > any download version under linux which is availabale in GUI .. Try this : http://sourceforge.net/projects/sqlitebrowser/ The homepage is : sqlitebrowser.sourceforge.net/ Ciao Max Libero ADSL: navighi gratis a 1.2 Mega, senza canone e costi di attivazione. Abbonati subito su http://www.libero.it
Re: [sqlite] SQLite Tutorial - [Request For Comments]
On Wed, Nov 24, 2004 at 04:41:37PM +0100, jacob navia wrote: > Clay Dowling wrote: > > >Re: SQLite Tutorial > > > > > >>http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?download > >> > >> > Hi! > I have compiled the documentation of sqlite (3) in a CHM format, the > standard help file > format for windows. Would it be possible to add the tutorial to it? I have not used that tool, so I would not know how to add it. Are you asking if you have the legal right to add it? Yes, this falls under the Open Publication License. Regards, Mike Chirico > > Thanks in advance. > > jacob > > P.S. > The chm file is distributed with the lcc-win32 compiler system, that can be > downloaded at no charge from: > > http://www.cs.virginia.edu/~lcc-win32. >
[sqlite] sqlite-GUI - under linux
hello freind's , i am using sqlite on terminal .. any download version under linux which is availabale in GUI .. THNKING U.
Re: [sqlite] SQLite (sql query) vs TSQL or MS Access
this kind of functions :-), sorry (not king :P ) - Original Message - From: "Cosmin Vlasiu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 25, 2004 11:39 AM Subject: [sqlite] SQLite (sql query) vs TSQL or MS Access > hello, > > i'm a newbie in sqlite and i want to ask > what kind of functions are available; i mean Mid, DateDiff, InStr... > Are available this king of functions? can be used in a sql query? > > Thanks a lot > > a+ > > Cosmin
[sqlite] SQLite (sql query) vs TSQL or MS Access
hello, i'm a newbie in sqlite and i want to ask what kind of functions are available; i mean Mid, DateDiff, InStr... Are available this king of functions? can be used in a sql query? Thanks a lot a+ Cosmin
