[sqlite] How can i install SQLite

2010-08-01 Thread MKiran
Please help me on SQLite install ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How can i install SQLite

2010-08-01 Thread Martin Engelschalk
Hi, sqlite needs not and cannot be installed. It is an emedded system which you link to your application. See http://www.sqlite.org/serverless.html Martin Am 01.08.2010 08:58, schrieb MKiran: > Please help me on SQLite install > > ___ >

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Alexey Pechnikov
2010/8/1 Nikolaus Rath : > My question is about the pros and cons of adding > a one-way hash function to SQLite (maybe calling it crypt() was > misleading for some). There are a lot of these. See http://sqlite.mobigroup.ru/dir?name=ext/md5

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Nikolaus Rath
Simon Slavin writes: >> Please don't suggest other ways of achieving this. There are plenty and >> I am able to use them. My question is about the pros and cons of adding >> a one-way hash function to SQLite (maybe calling it crypt() was >> misleading for some). > > That's

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Nikolaus Rath
"Jay A. Kreibich" writes: > On Sat, Jul 31, 2010 at 01:12:36PM -0400, Nikolaus Rath scratched on the wall: >> >> When tracing down bugs in an application that uses SQLite, I have >> repeatedly faced the problem that I wanted to send (or get) a copy of >> the sqlite database

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Nikolaus Rath
Roger Binns writes: > On 07/31/2010 07:28 PM, Nikolaus Rath wrote: >> Possible use case: I want to send someone an SQLite database with my >> data, so that he can debug an application that's using the database >> (since it's having problems with the particular set of data

[sqlite] Error in the documentation

2010-08-01 Thread Artur Reilin
Hello ^^ On the end of this site: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Is an error with the entities. http://www.areanda.com > http://www.areanda.com > This is written at the end. With best wishes Artur Artur Reilin sqlite.yuedream.de

[sqlite] How to manipulate Tcl lists/dicts by SQLite user-defined functions?

2010-08-01 Thread Alexey Pechnikov
I'm store Tcl lists/dicts in SQLite but there is no functions to manipulate by these. I want to find or write the extension. May be this exists? Or how to do it optimally? Of cource example will be very helpful. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/01/2010 08:47 AM, Nikolaus Rath wrote: > Since in this > case the file names are just opaque labels without any relations or > structure, hashing them all was a pretty good solution. I think it is rare that would work as a way of obfuscating

Re: [sqlite] Error in the documentation

2010-08-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/01/2010 10:14 AM, Artur Reilin wrote: > On the end of this site: > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools > > Is an error with the entities. It is a just a Russian spammer and I've removed the text. The wiki pages are not part

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Nikolaus Rath
Roger Binns writes: >> I was wondering why there isn't a hash function build into SQLite. > > Firstly note the last 4 letters of the name. It is indeed a fairly frequent > lament here that SQLite should include some functions the poster thinks is > generally applicable.

[sqlite] VACUUM and WAL

2010-08-01 Thread Nikolaus Rath
Hi, Could someone clarify to me how the VACUUM command works if WAL is enabled? I would like to compact my database, but I am note sure if I should: 1) Run PRAGMA wal_checkpoint to get all outstanding commits into the database file and then VACUUM to compact the database file, or should I

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Simon Slavin
On 2 Aug 2010, at 2:48am, Nikolaus Rath wrote: > Roger Binns writes: >>> I was wondering why there isn't a hash function build into SQLite. >> >> Firstly note the last 4 letters of the name. It is indeed a fairly frequent >> lament here that SQLite should include some

Re: [sqlite] crypt() as SQL core function

2010-08-01 Thread Jay A. Kreibich
On Sun, Aug 01, 2010 at 09:48:11PM -0400, Nikolaus Rath scratched on the wall: > SCNR, I get the point. But I do think that SQLite could get a few more > functions without immediately becoming SQHeavy. Perhaps, but considering how easy it is to add your own functions, the motivation for