[sqlite] Sqlite Control Center

Q. on this this application (Sqlite Control Center ) does it included sqlite 3.x or is it the front end for it? Notice a few font end apps included sqlite, well, we already compiled and installed sqlite 3.2.5 usr/local/bin , where just looking for the font end only. Big Thanks - Richard

RE: [sqlite] Version 3.2.6

CVS HEAD now compiles clean on Solaris, but the link line for the CLI tool (or any application linking against the SQLite library) needs to include -lposix4 in order to link correctly. -Tom > -Original Message- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Thursday,

Re: [sqlite] Lib and H files

Bradley Small wrote: Thanks for the answers. I will for now assume that I can just take SQLITE.H.IN and rename it to sqlite3.h since, I don't see a sqlite3.h to extract from the sources. I guess at some point it would be nice to have all the nice un*x flavored text and building tools to work

RE: [sqlite] Function to find the size returned data size from a SELECT??

OK Thanks for your reply. Yeah, I know that sqlite3_get_table() allocates the memory for me, but thanks for the heads up any way! I think the possibility of checking the number of rows will be sufficient for my purposes... If I don't check is there not a possibility of there not being enough

Re: [sqlite] Lib and H files

Hi, Well, as Dennis Cote pointed out, you can get sqlite3.h by downloading sqlite-source-3_2_6.zip Still, it looks like renaming sqlite.h.in to sqlite3.h in the complete source tarball is okay, but you should edit 2 preprocessor directives manually: #define SQLITE_VERSION "--VERS--" to

RE: [sqlite] Version 3.2.6

Please try the patch at http://www.sqlite.org/cvstrac/chngview?cn=2732 and let me know if this fixes the fdatasync problem on Solaris and OpenBSD. On Thu, 2005-09-22 at 10:33 -0400, Thomas Briggs wrote: >Solaris also does not support fdatasync, and as such doesn't compile > without this

Re: [sqlite] Including sqlite3 in a GNU project

I have found the following link that inspired Gnome-DB to use SQLite. http://aaronbock.net/articles/sqlite/ But this method only uses the sqlite-source.zip which are just the pure C files. I want to use the sqlite3.tar.gz distribution that uses GNU tools. On 9/22/05, Mark Drago <[EMAIL

RE: [sqlite] Lib and H files

Thanks for the answers. I will for now assume that I can just take SQLITE.H.IN and rename it to sqlite3.h since, I don't see a sqlite3.h to extract from the sources. I guess at some point it would be nice to have all the nice un*x flavored text and building tools to work with. Regards ...

Re: [sqlite] Lib and H files

Bradley Small wrote: I have d/l the binary distribution for windows. I am wanting to try the c sample, but apparently need a lib and h file. Does anyone have these compiled/built that I can d/l? Or perhaps someone can send them to me? Regards ... Bradley M. Small Senior Developer MCC (Mobile

Re: [sqlite] Including sqlite3 in a GNU project

On Thu, 2005-09-22 at 07:23 -0700, Doug Hanks wrote: > Has anyone went through (what I feel is a painful process) of adding > sqlite in a GNU project? > > I'm not referring to sqlite specifically, but just with the GNU tools > in general. > > I would like to copy the sqlite distribution into my

RE: [sqlite] Version 3.2.6

Solaris also does not support fdatasync, and as such doesn't compile without this workaround. > -Original Message- > From: Jolan Luff [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 17, 2005 4:14 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Version 3.2.6 > > On

[sqlite] Two questions about #PRAGMA SYNCRONOUS

Question 1 Is #PRAGMA SYNCRONOUS a global database setting or is it possible to open two handles on the same database and set two different values for #PRAGMA SYNCRONOUS on the two handles ? Question 2 Is it possible to change the value of #PRAGMA SYNCRONOUS on the same handle during the

[sqlite] Including sqlite3 in a GNU project

Has anyone went through (what I feel is a painful process) of adding sqlite in a GNU project? I'm not referring to sqlite specifically, but just with the GNU tools in general. I would like to copy the sqlite distribution into my project directory and just extract it. Then modify my configure.in

Re: [sqlite] Lib and H files

see http://www.sqlite.org/cvstrac/wiki?p=HowToCompile - Original Message - From: "Bradley Small" <[EMAIL PROTECTED]> To: Sent: Thursday, September 22, 2005 2:03 PM Subject: [sqlite] Lib and H files I have d/l the binary distribution for windows. I am wanting

RE: [sqlite] Multiple Threads and Transactions

On Mon, 19 Sep 2005, Iulian Popescu wrote: >Thank you very much for the answer and I apologize for my misconception. My >confusion came from the fact the database handle was used by two different >threads and one of them was executing operations inside a transaction. >Is that possible to obtain

[sqlite] Lib and H files

I have d/l the binary distribution for windows. I am wanting to try the c sample, but apparently need a lib and h file. Does anyone have these compiled/built that I can d/l? Or perhaps someone can send them to me? Regards ... Bradley M. Small Senior Developer MCC (Mobile Computing Corporation)

Re: [sqlite] Share an sqlite3 struct between multiple threads

On Wed, 21 Sep 2005, Guillaume Fougnies wrote: >So SQLite is not "portable" on some Unix (more precisely on >recent linux NPTL where file locks seems broken). SQLite is indeed portable. It works round lock problems as best it can with the current model. It is the POSIX locking implementations