RE: [sqlite] Receiving notification of table updates

2004-09-27 Thread Hihn, Jason
What is updating the table? Another [apache module] thread or another process? If they are from the same module, I'd think you could use a static int or semaphore. There's also shared memory. > -Original Message- > From: Kazuho Oku [mailto:[EMAIL PROTECTED] > Sent: Monday, September 27,

RE: [sqlite] Encrypting data stored in database

2004-09-10 Thread Hihn, Jason
In theory, ( have not tried this with SQLite) you caould make 2 add-in functions, encrypt(str) and decript(str) then use it as such: Select decrypt(sensitive_column) from table where id=3; Insert into table (sensitive_column) values (encrypt('3434 3434 3434 3434')) To provide field-level

RE: Spam: Re: [sqlite] Version 3.0.0 ALPHA now available

2004-06-18 Thread Hihn, Jason
I am not the one to answer this, but I do know the mains that KJSEmbed is going through at the moment. The whole delay is trying to get it to compile in MSVC, but they moved to mingw32, where it's much more standard. They've since been chugging along. "Weeks" of work was reduced to days. I

RE: [sqlite] sqlite with Visual Basic

2004-06-18 Thread Hihn, Jason
Again, I'm coming to this late... While not VisualBasic, you could theoretically do it in JavaScript (just as easy) using KJSEmbed. KJSEmbed is a project that binds JavaScript to KDE. Now not Everyone is KDE users, and since you're asking for VB, I'll assume you're on windows. Well good news.

RE: [sqlite] Is there a demand for Client / Server Modules ? (It seems to be..)

2004-06-17 Thread Hihn, Jason
I'm joining this late, but I just updated the wiki. Appearently SQLRelay already has this worked out? http://sqlrelay.sourceforge.net -Original Message- From: Nicolas Girard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 2:44 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Is

[sqlite] Upping sizeof integer

2004-06-17 Thread Hihn, Jason
I searched the archives, and only found info relating to the proposal for v3. I'd like to know how hard it would be to make "integer primary key" be 64 bits wide. I have and application that will burn through 2^32 in about 3 months in the main index table. I know I'll be well under the size