Re: [sqlite] Do source updates effect DB file compatiblity?

On Fri, Mar 18, 2005 at 02:13:39PM -0800, Kiel W. wrote: > As SQLite progresses and I update my source with new releases, > recompile and deploy If your application works fine with the version that you've embedded, why change? -- Ng Pheng Siong <[EMAIL PROTECTED

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

On Fri, Mar 11, 2005 at 02:16:35PM -, Steve O'Hara wrote: > I'd like England to win the World Cup... I thought England did win the rugby World Cup the last time out? Oh, you mean _football_! ;-) -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+-

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

ing http://www.python.org/moin/WebStack HTH. -- 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

Re: [sqlite] authenticating user before allosw to use sql_lite?

ypical mod_php situation. My company (ahem, the company I work for) sells an encrypting version of SQLite where the encryption key is derived from a passphrase. But there is still no notion of 'user'. HTH. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto

Re: [sqlite] Accesing database remotely

Google search results where "optimistic" or "opportunistic" caching on Windows clients may cause data corruption, in the context of other file-based database libraries. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerS

Re: [sqlite] Detecting if the db has changed

SQL statement in place instead of calling a Python function that wraps said SQL statement, then you still have to touch every code path. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog http://www.sqlcrypt.com -+-

Re: [sqlite] Detecting if the db has changed

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

Re: [sqlite] example for TCP connection to sqlite database.

the wiki http://www.sqlite.org/cvstrac/wiki?p=ClientServer points to here: http://www.it77.de/sqlite/sqlite.htm On the same wiki page there is discussion about the TDS protocol. Recently, I've also come across something called DRDA - "distributed relational database architecture". HTH.

Re: [sqlite] PySQLcrypt

On Fri, Dec 03, 2004 at 09:56:42PM +0800, Ng Pheng Siong wrote: > PySQLcrypt is an enhanced version of PySQLite that uses SQLcrypt, which > itself enhances SQLite version 3 with transparent AES encryption. I'm apologise for following up to myself, but I forgot to mention that I've posted

Re: [sqlite] [ANN] SQLcrypt 1.0

tml > 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

[sqlite] [ANN] SQLcrypt 1.0

Hi all, I'm pleased to announce the release of SQLcrypt. http://www.sqlcrypt.com SQLcrypt is SQLite 3 + transparent AES encryption. Try before you buy. Please take a look. Thanks. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZSer

Re: [sqlite] Saving database

values (1,1); sqlite> ^D $ ls -l test.db -rw-r--r-- 1 ngps ngps 2048 Nov 4 16:22 test.db If you're using the C API, the first parameter to sqlite3_open() is the filename. HTH. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZS

Re: [sqlite] Crypt the database file

. Signups are still available. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog http://www.sqlcrypt.com -+- AES Encryption for SQLite

Re: [sqlite] Warnings during compilation

compiler happy then people won't be nervous? ;-) -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog

Re: [sqlite] Wich compiler to use in Windows

lso built it using msys, although strangely the generated sqlite3.exe works on plain cmd.exe but not on msys's bash shell. I only wanted the Lemon parser-generator anyway so I didn't investigate further. HTH. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker

Re: [sqlite] first DBD::SQLite for SQLite 3.x released

d I won't go into it now. -- Darren Duncan I'd imagine keeping DBD::SQLite for v2 and creating DBD::SQLite3 for v3 is the most straightforward approach. Ditto for Python, Ruby, etc. etc. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://firewall.rulemaker.net -+- Cisco PIX & Ne

Re: [sqlite] Simultaneosly using sqlite on windows

ing.html It talks about disabling 'read caching' on clients and 'opportunistic locking' on servers in the context of another shared-file database product. If you do try the suggestions, please share your findings with the list. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http:

Re: [sqlite] Saving BLOBs in Sqlite

%, base64 encoding of the blobs raises no compatibility issues. Whether +30% is acceptable depends on the specific application, of course. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://firewall.rulemaker.net -+- Firewall Change Management & Version Control http://sandbox.rulemaker.net/

Re: [sqlite] Quick import

ata is screwed up. Cheers, just-another-astronomy-buff-in-my-younger-days -- Ng Pheng Siong <[EMAIL PROTECTED]> http://firewall.rulemaker.net -+- Firewall Change Management & Version Control http://sandbox.rulemaker.net/ngps

[sqlite] Magically turning a memory blob into an SQLite memory db?

of it. An idiomatic usage in OpenSSL's context is to keep a trusted CA cert or RSA public key within the application binary, instead of in a disk file which can be edited. TIA. Cheers. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://firewall.rulemaker.net -+- Firewall Change Management &am