Re: [sqlite] GUI ?

2004-10-15 Thread John Dean
At 20:53 15/10/2004, Richard wrote: wondering if there are any Mac OS X GUI front-end apps, that will work with SQlite ? We now have a SQLite driver for our project Rekall. Unfortunately, it only supports SQLite V2.8.15, but we are working on a V3.0.x. BTW the Mac OS X build of Rekall will be

Re: [sqlite] SQLite for Windows CE

2004-10-15 Thread John Oliva
I am also interested in synchronizing SQLite databases. As far as I am aware, there is no support in the SQLite code for the tasks required to synchronize multiple databases. You would need meta-data indicating whether data has been added/deleted/modified along with either timestamps or update

[sqlite] SQLite for Windows CE

2004-10-15 Thread Stober, Mel
Does anyone know how to synchronize the data on the WinCE device with a database on a server computer? I'm just testing the feasibility of using SQLite for our projects that run under wireless WinCE 3.0 device. The primary database is a Sybase database server running on Sun workstations. The

[sqlite] GUI ?

2004-10-15 Thread Richard
wondering if there are any Mac OS X GUI front-end apps, that will work with SQlite ? Thanks - Richard

[sqlite] GUI ?

2004-10-15 Thread Richard
wondering if there are any Mac OS X GUI front-end apps, that will work with SQlite ? Thanks - Richard

Re: [sqlite] minor problems with 3.08 source package

2004-10-15 Thread Eli Burke
The configure script makes .libs/libsqlite3.a for me, without arguments or fiddling. I use ../sqlite/configure --enable-threadsafe to build the threadsafe, no tcl, and as a static lib version. Can you tell me what fiddling you did to "fix" it? Ok, color me embarassed. I rebuild again from

Re: [sqlite] BLOBs and sqlite_exec

2004-10-15 Thread Will Leshner
On Oct 15, 2004, at 9:43 AM, john mcnicholas wrote: Sorry, I couldn't be of more help but perhaps this will lead you in the right direction. Actually, this is extremely helpful. I should have realized that I could use the binding interface to bind blob data to a SQL statement. I'll play with

RE: [sqlite] BLOBs and sqlite_exec

2004-10-15 Thread john mcnicholas
Sorry, but I can't give you a definitive answer myself since I working on the same problem. I'll let you know when/if I solve it and I'm sure you'll do the same. But for what its worth below is what i'm trying in C++. first the disclaimer - i'm very new to sqlite and its been a while since i've

Re: [sqlite] minor problems with 3.08 source package

2004-10-15 Thread Doug Currie
Friday, October 15, 2004, 11:31:42 AM, Eli wrote: > I may be in a minority here, but I needed to build sqlite3: threadsafe, > no tcl, and as a static lib. > With both 3.06 and 3.08, this required fiddling as the configure script > does not create libsqlite3.a. The configure script makes

[sqlite] minor problems with 3.08 source package

2004-10-15 Thread Eli Burke
I may be in a minority here, but I needed to build sqlite3: threadsafe, no tcl, and as a static lib. With both 3.06 and 3.08, this required fiddling as the configure script does not create libsqlite3.a. configure --help does report: --enable-static[=PKGS] build

Re: [sqlite] BLOBs and sqlite_exec

2004-10-15 Thread Will Leshner
On Oct 15, 2004, at 7:50 AM, Will Leshner wrote: Sorry if this is terribly obvious, but I'm assuming that, in SQLite3, we can't use the sqlite_exec convenience API to store BLOBs, right? I see that if we go through the VM directly the API allows us to specify a data size, so that it doesn't

[sqlite] BLOBs and sqlite_exec

2004-10-15 Thread Will Leshner
Sorry if this is terribly obvious, but I'm assuming that, in SQLite3, we can't use the sqlite_exec convenience API to store BLOBs, right? I see that if we go through the VM directly the API allows us to specify a data size, so that it doesn't depend on NULL-terminated C strings. But

[sqlite] multiple indexes.

2004-10-15 Thread Guillaume Fougnies
Hello, I'd like to know if the management of multiple indexes on select statement is in the TODO list of SQLite? On joined request, this lack is a real performance killer. Example: select t1.id,t2.name from t1,t2 where t1.id IN(a00,b00, ,z99) and t1.t2id = t2.id; For now, SQLite use by

Re: [sqlite] Support for ODBC?

2004-10-15 Thread Eric Bohlman
R S wrote: Can an application access data from SQLite via ODBC? Didn't see documentation on the same. If you have an ODBC driver for SQLite, yes. The "SQLite Wrappers" page of the wiki mentions "ODBC driver for SQLite. http://www.ch-werner.de/sqliteodbc/;. I don't know anything about it,