[sqlite] [OT] "encrypted" e-mail address (was Re: [sqlite] sqlite3Explorer)

2007-11-24 Thread John Machin
Cariotoglou Mike wrote: you can't ?! I overdid it, then :) [snip] From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sat 11/24/2007 7:00 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3Explorer the address follows, obfuscated for the usual

RE: [sqlite] sqlite3Explorer

2007-11-24 Thread Cariotoglou Mike
you can't ?! I overdid it, then :) I wish I could "make it for Unix", but it uses a lot of windows-specific things, plus it is done in Delphi, and since Kylix is practically dead, wlll... From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sat 11/24/2007 7:00

Re: [sqlite] Re: building a custom DBD::SQLite

2007-11-24 Thread Scott Hess
On Nov 18, 2007 3:28 PM, P Kishor <[EMAIL PROTECTED]> wrote: > Following those pretty much to the t, I almost got everything working. > Except, I got the following during make > > ../sqlite-3.5.2/ext/fts1/fts1.c:7:2: error: #error fts1 has a design > flaw and has been deprecated. > make: ***

RE: [sqlite] Re: How to reset errcode

2007-11-24 Thread Igor Sereda
> If you use sqlite3_prepare_v2 function to prepare your statement, > you opt out of this legacy behavior and then sqlite3_step returns > the actual error code directly, and sqlite3_reset and _finalize > behave in a sane way. Thanks for the clarification! -- Igor -Original

Re: [sqlite] Optimizing Application - SQLite Connection Creation/Sharing

2007-11-24 Thread John Stanton
Cache your open connections. Keep your list in most recently used order and use the most recently used to maximize cache availability. Sabyasachi Ruj wrote: I have an application that uses SQLite extensively. In a part of that application, I need to do the following steps:- 1. I need

Re: [sqlite] sqlite3Explorer

2007-11-24 Thread Joe Wilson
> the address follows, obfuscated for the usual reasons. to e-mail me, remove > any > numeric digits and punctuation from the address that follows, and do the > obvious substitutions. > hopefully spammers will not... > > m6_i_ke$car(ampersand)(dot)s#i#n#g#u#l#a#r(dot)gr Nevermind the spammers

[sqlite] SQLite with PHP

2007-11-24 Thread Cesar D. Rodas
Hello, This message is only for let know users that I've wrote a class for manage SQL database using the same interface. It supports: - Connect to a database given a connection string - Prepared queries - Caching query results in files - Binding variables to query result columns - Fetch whole

[sqlite] sqlite3Explorer

2007-11-24 Thread Cariotoglou Mike
Hi. I am the author of the Sqlite3Explorer GUI front end. I have been inactive on this tool for some time now, frankly because I initially created it to cover my own needs, and I havent had any new needs lately :) In any case, since I see that people still use it, and some even like it, I am