Re: [sqlite] SQLite under linux

[Lloyd]

On Tue, 2006-09-26 at 19:18 +0100, Martin Jenkins wrote:
> If all you want to do is build an application using (some version of) 
> sqlite then just download the library and link against it - you don't 
> have to download the SQLite source and build it.
> 

Thanks Martin, I too wanted the same only. But I don't know how to
download and install the library on my Linux. I went to the download
section of the SQLite site and found  a file called sqlite-3.3.7.so.gz.
I think this is the library which I want.

Unfortunately, I don't know how to install this library in my system.
Please help me.. If I am dealing with the wrong file, please let me know
from where I can get the needed installable library.

Thanks for your clear and patient reply.

Thanks,
  Lloyd. 




__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Martin Jenkins]

Martin Jenkins wrote:

noticed a couple of minor nits

1. configure wants g++ but ISTM the build doesn't actually use it
2. "make clean" (or was it distclean?) doesn't delete sqlite3.pc


There was supposed to be a 3.

3. make distclean doesn't remove the installed files from usr/local

I'll have a look at fixing the autoconf stuff and maybe raise a bug 
report tomorrow but right now I'm going for a beer ;)


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Martin Jenkins]

Clay Dowling wrote:
> > ./configure, especially since I build on more platforms than are 
supported

> > by default.  OpenBSD and FreeBSD are in my mix.

Like you I always ./confgure and haven't had any problems. I just built
the libs on Cygwin and noticed a couple of minor nits but nothing worth 
mentioning. Certainly major like Lloyd is seeing.


1. configure wants g++ but ISTM the build doesn't actually use it
2. "make clean" (or was it distclean?) doesn't delete sqlite3.pc

I'm curious to know how/why he's getting these tcl errors though.

Martin





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: Anyone can help me?

[Cesar David Rodas Maldonado]

I know that man. I start to develop my own Rank system bases on PageRank
algorithm, and if any help me it will be GNU.

On 9/26/06, Clay Dowling <[EMAIL PROTECTED]> wrote:


I think first it would be helpful if you had a working pagerank algorithm.
Data storage is not really what makes Google's pagerank and search
engines so impressive, it's the searching and categorization capabilities.

Clay

Cesar David Rodas Maldonado said:
> Some one what to help?
>
> On 9/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>>
>> I am developing a hobby that is how to calculate something like the
>> PageRank with SQLite for HDD Storage.
>>
>> Thanks to all.
>>
>


--
Simple Content Management
http://www.ceamus.com



-
To unsubscribe, send email to [EMAIL PROTECTED]

-

Re: [sqlite] Re: Anyone can help me?

[Clay Dowling]

I think first it would be helpful if you had a working pagerank algorithm.
 Data storage is not really what makes Google's pagerank and search
engines so impressive, it's the searching and categorization capabilities.

Clay

Cesar David Rodas Maldonado said:
> Some one what to help?
>
> On 9/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
>>
>> I am developing a hobby that is how to calculate something like the
>> PageRank with SQLite for HDD Storage.
>>
>> Thanks to all.
>>
>


-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: Anyone can help me?

[Cesar David Rodas Maldonado]

Some one what to help?

On 9/26/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:


I am developing a hobby that is how to calculate something like the
PageRank with SQLite for HDD Storage.

Thanks to all.

[sqlite] Anyone can help me?

[Cesar David Rodas Maldonado]

I am developing a hobby that is how to calculate something like the PageRank
with SQLite for HDD Storage.

Thanks to all.

Re: [sqlite] The term "flat-file" as applied to sqlite

[Thomas . L]

On Tue, 26 Sep 2006 11:20:09 -0700, you wrote:

>Well, and English is a language used by humans to convey their
>understandings to other humans :-).  You can do technical
>hairsplitting all you want, but the fact is that the term "flat file"
>has a long history of being used to refer to text files with minimal
>internal structure, no indexing, accessed with no or minimal locking,
>no transactions, etc.

Thats OK to me... no hairsplitting  ;-)

I think, that is really no problem, what is worth strenuous
diskussion. Whether flat or not, this makes no important difference in
this case.

SQLite is a good engine... that is important to me :-)

Best Regards
Thomas

www.thlu.de

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Clay Dowling]

./configure, especially since I build on more platforms than are supported
by default.  OpenBSD and FreeBSD are in my mix.

Clay


Martin Jenkins said:
> Clay Dowling wrote:
>> I don't have tcl installed on my systems and I've never had a problem
>> doing the default build.  I do skip "make test" because I don't have tcl
>> installed, and because I don't modify my copies of SQLite.
>
> Do you use Makefile.linux or go the ./configure route?
>
> Martin
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Martin Jenkins]

Clay Dowling wrote:

I don't have tcl installed on my systems and I've never had a problem
doing the default build.  I do skip "make test" because I don't have tcl
installed, and because I don't modify my copies of SQLite.


Do you use Makefile.linux or go the ./configure route?

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Clay Dowling]

I don't have tcl installed on my systems and I've never had a problem
doing the default build.  I do skip "make test" because I don't have tcl
installed, and because I don't modify my copies of SQLite.

Clay

Martin Jenkins said:
> Clay Dowling wrote:
>> What I strongly recommend doing, rather than trying to cobble together
>> your own solution, is to download the source and go through the build
>> and
>> install -exactly- as decribed in the document.
>
> Good point, but I don't think he has (or wants) Tcl, so the build isn't
> going to work. Also, there seems to be a make install missing from those
> instructions so I'm not convinced it would work even if he did have Tcl.
>
> Martin
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Martin Jenkins]

Clay Dowling wrote:

What I strongly recommend doing, rather than trying to cobble together
your own solution, is to download the source and go through the build and
install -exactly- as decribed in the document.


Good point, but I don't think he has (or wants) Tcl, so the build isn't 
going to work. Also, there seems to be a make install missing from those 
instructions so I'm not convinced it would work even if he did have Tcl.


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] The term "flat-file" as applied to sqlite

[Nathaniel Smith]

On Tue, Sep 26, 2006 at 08:05:34PM +0200, [EMAIL PROTECTED] wrote:
> Maybe a structured Textfile is a flatfile, if 
> possibly readable as a tableview. But it is so 
> only in humans view and humans understanding. 

Well, and English is a language used by humans to convey their
understandings to other humans :-).  You can do technical
hairsplitting all you want, but the fact is that the term "flat file"
has a long history of being used to refer to text files with minimal
internal structure, no indexing, accessed with no or minimal locking,
no transactions, etc.

-- Nathaniel

-- 
"...these, like all words, have single, decontextualized meanings: everyone
knows what each of these words means, everyone knows what constitutes an
instance of each of their referents.  Language is fixed.  Meaning is
certain.  Santa Claus comes down the chimney at midnight on December 24."
  -- The Language War, Robin Lakoff

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Martin Jenkins]

Lloyd wrote:

After performing this section I got lots of errors. (I shall Add it
at the end of mail)


Either you're going to have to fix these errors BEFORE you proceed OR 
download the pre-built library from the site.



But when I browsed through the output directory, I found the
sqlite3.h file


sqlite3.h is built early on and is no indication that the library build 
was successful. Although you can copy it into your source directory, you 
shouldn't have to, it is supposed to be installed in a "standard place" 
with "make install" so that the compiler can find it automatically.



copied that file too to mu desktop directory
then given the command
gcc sqlite.c -o sqlite

it shown the following erorrs.

[EMAIL PROTECTED] gcc sqlite.c  -o sqlite /tmp/ccE2LJqr.o(.text+0xe1):
In function `main': : undefined reference to `sqlite3_open' 
/tmp/ccE2LJqr.o(.text+0xfb): In function `main': : undefined
reference to `sqlite3_errmsg' /tmp/ccE2LJqr.o(.text+0x11d): 


Your program includes calls to functions in the SQLite library, but you 
didn't successfully build that library so the references to the SQLite 
functions in your code cannot be resolved (i.e. linked to the code in 
the library).



So I tried this way...
gcc -c sqlite.c -c
thus got the sqlite.o file


All this command does is build a single object file. It doesn't produce 
an executable or link your program with the SQLite library.



then I executed the ldconfig command this way
ldconfig /root/Desktop/


ldconfig is nothing to do with this - it updates the system when new 
shared libraries are installed, but you haven't built or installed any.



ld /root/Desktop/sqlite-3.3.7.so  /root/Desktop/sqlite.o
This too shown eorros..


Dunno what you thought this would do, but it isn't what you wanted it to 
do. ;)



[EMAIL PROTECTED] ld /root/Desktop/sqlite-3.3.7.so
/root/Desktop/sqlite.o ld: warning: cannot find entry symbol _start;
defaulting to 080483d8


This is what I meant in my comment to your use of the -c flag. Imagine 
that the linker puts a framework (with _start) around your code. You've 
omitted that step completely.


Here I am adding the error output of the make command... (I am not 
installed TCL on my macine.. and it is not needed)
.../src/tclsqlite.c:20:17: tcl.h: No such file or directory 
.../src/tclsqlite.c:54: error: syntax error before "Tcl_Interp" 
.../src/tclsqlite.c:54: warning: no semicolon at end of struct or


After you've run configure, open the Makefile in an editor and change 
the line that starts HAVE_TCL to "HAVE_TCL =". That will tell make not 
to build the Tcl extensions for SQLite. *NB* I think the proper way 
round this should be to run configure with the without-tcl option, that 
is type "../configure --without-tcl" in step 3.3 but when I tried this 
configure failed with an error. I'm pretty sure I've seen a note saying 
that configure is unsupported so maybe the failure isn't too surprising.


> Can I use the library alone without recompiling the whole sqlite?
> (Thus it will be easier for me to distribute my application along
> with sqlite)

If all you want to do is build an application using (some version of) 
sqlite then just download the library and link against it - you don't 
have to download the SQLite source and build it.


Assuming a very simple program saved in a file called ts.c:

-- cut --
#include 
#include 

int main(void)
{
printf("SQLIte version: %s\n", sqlite3_libversion());
return 0;
}
-- cut --

The command line to compile ts.c and link with the SQLite library is simply:

gcc -o ts tc.c -lsqlite3

This produces an executable called "ts" in the current directory. When I 
run this program (with "./ts") I see:


SQLIte version: 3.3.7

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] The term "flat-file" as applied to sqlite

[Thomas . L]

On Mon, 25 Sep 2006 16:06:44 -0400, you wrote:

Hello

>I've noticed that more than one contributor to this list has referred to
>sqlite as a "flat file database."  I had always thought of a flat file as a
>file composed of single table of records, with records defined either by
>fixed-width allocations or by some sort of delimiter (e.g., comma-separated
>files).

What's about a flatfile? Is a SQLite-File 
really more than a Flatfile? Is a DBase-III-DB
more than a Flatfile? What's about a car? Is a 
Ferrari really more than a car? Maybe some 
people think so. I think, a Ferrari is only a 
car too. And every File created by me with any 
Application and lying on the Disk on my PC is a 
singlefile, or a flatfile.
Maybe some people can see the differences 
between a flatfile and a single-file. I cannot.

Maybe a structured Textfile is a flatfile, if 
possibly readable as a tableview. But it is so 
only in humans view and humans understanding. 
A SQLite-File is equally structured, but only in 
SQlite's view and understanding.

I distinguish this by way to access. A flatfile 
is accessible directly to me, a Client-Server-based 
DB only indirect. Only via a provider-connect to 
a server-instance, who handle my access to the DB,
completely processed by another machine. 
Maybe I'm wrong. Maybe it is even philosophical 
problem. I have no problem, is a SQLite-File a 
Flatfile or not ;-)

Best Regards
Thomas

www.thlu.de

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite_master table does not show all available tables....

[Nemanja Corlija]

On 9/26/06, Mark Pirogovsky <[EMAIL PROTECTED]> wrote:

One  can query  the sqlite_master table to find out all the available
tables and views.

However if you open (via ATTACH [DATABASE]  sql command) more then one
database files in the sessions, the sqlite_master only shows the tables
in the latest opened file.

Is there a way to see all the tables in all of the database files opened
for the session ?


Try this:

ATTACH "atch.db" AS atch;
SELECT * FROM atch.sqlite_master;

--
Nemanja Corlija <[EMAIL PROTECTED]>

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] sqlite_master table does not show all available tables....

[Mark Pirogovsky]

One  can query  the sqlite_master table to find out all the available 
tables and views.


However if you open (via ATTACH [DATABASE]  sql command) more then one 
database files in the sessions, the sqlite_master only shows the tables 
in the latest opened file.


Is there a way to see all the tables in all of the database files opened 
for the session ?



-- Mark Pirogovsky

"Computers made it possible to make millions mistakes a second"
"Ask no questions and hear no lies"

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Please test check-ins [3445] and [3446]

[Kervin L. Pierre]

Hello,

I just tried.  I am getting build errors
for CVS.  3.3.7 builds though.

Error   101 error C2065: 'SQLITE_FUNCTION' : undeclared
identifier  c:\src\sqlite\sqlite\src\expr.c 1185

Error   121 error C2065: 'sqlite3_overload_function' :
undeclared identifier
c:\src\sqlite\sqlite\src\loadext.c  217

Error   122 error C2099: initializer is not a constant
c:\src\sqlite\sqlite\src\loadext.c  217

--- [EMAIL PROTECTED] wrote:

> Windows users with the ability to build from source,
> please help me
> out by testing the changes in check-ins [3445] and
> [3446] at
> http://www.sqlite.org/cvstrac/chngview?cn=3445 and 
> http://www.sqlite.org/cvstrac/chngview?cn=3446
> verifying that
> they do not break anything.  Tnx.
> --
> D. Richard Hipp   <[EMAIL PROTECTED]>
> 
> 
>
-
> To unsubscribe, send email to
> [EMAIL PROTECTED]
>
-
> 
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: The term "flat-file" as applied to sqlite

[John Stanton]

A. Pagaltzis wrote:

* Griggs, Donald <[EMAIL PROTECTED]> [2006-09-25 22:10]:


2) If instead, I'm unaware of another popular use of the term
"flat file" -- then I'd be glad to learn this.



I think there's another explanation for how this term came about.
Dr. Hipp has asserted many timed that SQLite should be thought of
as a replacement not for Oracle, but for `fopen()`. That casts
the term "flatfile database" as a somewhat misleading way to say
that SQLite is a database that you can use just like you would a
flatfile.

Regards,


The term "flat file" came to be used many years ago to distinguish 
between a file of sequential records (a list) and a file organized for 
indexed access, like an ISAM file (a tree).  The CODASYL DBMS structure 
with its linked records was also regarded as not "flat".


Sqlite is definitely not a "flat file".


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] List all views in my sqlite-database - possible?

[Dennis Cote]

wqual wrote:
is there a way to list all views of my database? Something like 
the .tables-command for tables would be great.

I would be glad for some hints on this issue!

  


Wolfgang,

You can use the following query to get the view names from the 
sqlite_master table.


 select name from sqlite_master where type = 'view';

HTH
Dennis Cote

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Rich Shepard]

On Tue, 26 Sep 2006, Lloyd wrote:


 This too doesn't work. First of all I did not install the library,
instead I copied the sqlite-3.3.7.so file to the lib folder. Then ran the
ldconfig command. Then I compiled gcc sqlite.c -o sqlite - l
/usr/lib/sqlite-3.3.7


  I suspect that you are making your own problems. Building executables --
and libraries -- in linux is a five-step process after downloading the
tarball:

  1.) tar xzvf .tar.gz (or .tgz).
  2.) cd to the created directory.
  3.) ./configure (N.B., you can use './configure --help | less' to view
options).
  4.) make
  5.) make install (as root).

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] List all views in my sqlite-database - possible?

[wqual]

Hi list,
is there a way to list all views of my database? Something like 
the .tables-command for tables would be great.
I would be glad for some hints on this issue!

Best,
Wolfgang

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] List all views in my sqlite-database - possible?

[Martin Jenkins]

wqual wrote:

Hi list,
is there a way to list all views of my database? Something like 
the .tables-command for tables would be great.

I would be glad for some hints on this issue!


.schema

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Lloyd]

Hi,
  This too doesn't work. First of all I did not install the library,
instead I copied the sqlite-3.3.7.so file to the lib folder. Then ran
the ldconfig command. Then I compiled gcc sqlite.c -o sqlite -
l /usr/lib/sqlite-3.3.7

It is giving the error ld connot find the file
called /usr/lib/sqlite-3.3.7

How can I solve this? From where do I can get an installable copy if the
SQLite library for linux?

Thanks,
 Lloyd.

On Tue, 2006-09-26 at 13:17 +0100, Lloyd Thomas wrote:
> Hi Lloyd,
> I had exactly the same problem being new to C++. These are the 
> steps I took. You may find that the library files may be in a folder where 
> RH does not expect them to be. Try 'whereis libsqlite3.so' to locate. I 
> can't remember where the default lib folder is. you will need to 
> add -lsqlite3 in your Makefile or compile your code with -lsqlite3. You 
> don't mention what errors you get when the make files. Some may be able to 
> help you further if they have that information.
> 
> Lloyd T
> 
> - Original Message - 
> From: "Lloyd" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, September 26, 2006 12:45 PM
> Subject: [sqlite] SQLite under linux
> 
> 
> > Hi all,
> >  I have been trying to use SQLite with Redhat EL 4. I dont know how to
> > link the object file. I have downloaded the sqlite-3.3.7.so. but I don't
> > know how to link my source file with this file.
> >
> > As mentioned in the quick start guide I have copied the example source
> > code for C.
> >
> > though I could not find the sqlite3.h file, I downloaded the source code
> > file of the sqlite and executed the ../configure command. it worked file
> >
> > then I tried to "make"  the file, but it failed,  any how I got the
> > necessary sqlite3.h file.
> >
> > But still I don't know from where to download the sqlite library and how
> > to install it in my machine. Awaiting for your kind reply.
> >
> > Thanks and regards,
> >  Lloyd.
> >
> >
> > __
> > Scanned and protected by Email scanner
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> > 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite under linux

[Mark Richards]

To use the library, either in shared or static mode, you must first 
build it successfully and then install it,


Please tell us your build procedure and any errors you got.

/m

Lloyd wrote:


then I tried to "make"  the file, but it failed,  any how I got the
necessary sqlite3.h file.

But still I don't know from where to download the sqlite library and how
to install it in my machine. Awaiting for your kind reply.




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] SQLite under linux

[Lloyd]

1) I have downloaded the SQLite sqlite-3.3.7.so.gz and saved in the
desktop directory.

2) Then copied the sample C program from the quick start guide and saved
in a file. (given the name sqlite.c)
3) To get the sqlite3.h file, I downloaded the sqlite source.

 3.1) mkdir sqlite
 3.2) cd sqlite
 3.3) ../configure
 3.4) make
 
 After performing this section I got lots of errors. (I shall Add it at
the end of mail)

But when I browsed through the output directory, I found the sqlite3.h
file

copied that file too to mu desktop directory

then given the command


gcc sqlite.c -o sqlite 

it shown the following erorrs.

[EMAIL PROTECTED] gcc sqlite.c  -o sqlite
/tmp/ccE2LJqr.o(.text+0xe1): In function `main':
: undefined reference to `sqlite3_open'
/tmp/ccE2LJqr.o(.text+0xfb): In function `main':
: undefined reference to `sqlite3_errmsg'
/tmp/ccE2LJqr.o(.text+0x11d): In function `main':
: undefined reference to `sqlite3_close'
/tmp/ccE2LJqr.o(.text+0x148): In function `main':
: undefined reference to `sqlite3_exec'
/tmp/ccE2LJqr.o(.text+0x178): In function `main':
: undefined reference to `sqlite3_free'
/tmp/ccE2LJqr.o(.text+0x186): In function `main':
: undefined reference to `sqlite3_close'
collect2: ld returned 1 exit status


So I tried this way...


 gcc -c sqlite.c -c 



thus got the sqlite.o file

then I executed the ldconfig command this way

ldconfig /root/Desktop/

then tried 


ld /root/Desktop/sqlite-3.3.7.so  /root/Desktop/sqlite.o

This too shown eorros..

[EMAIL PROTECTED] ld /root/Desktop/sqlite-3.3.7.so /root/Desktop/sqlite.o
ld: warning: cannot find entry symbol _start; defaulting to 080483d8



(And it seems from your reply this way wont work)



Here I am adding the error output of the make command... (I am not
installed TCL on my macine.. and it is not needed)



.../src/tclsqlite.c:20:17: tcl.h: No such file or directory
.../src/tclsqlite.c:54: error: syntax error before "Tcl_Interp"
.../src/tclsqlite.c:54: warning: no semicolon at end of struct or union
.../src/tclsqlite.c:55: warning: data definition has no type or storage
class
.../src/tclsqlite.c:59: error: syntax error before '}' token
.../src/tclsqlite.c:67: error: syntax error before "Tcl_Interp"
.../src/tclsqlite.c:67: warning: no semicolon at end of struct or union
.../src/tclsqlite.c:69: error: conflicting types for 'pNext'
.../src/tclsqlite.c:58: error: previous declaration of 'pNext' was here
.../src/tclsqlite.c:70: error: syntax error before '}' token
.../src/tclsqlite.c:92: error: syntax error before "Tcl_Interp"
.../src/tclsqlite.c:92: warning: no semicolon at end of struct or union
.../src/tclsqlite.c:101: error: syntax error before '*' token
.../src/tclsqlite.c:101: warning: data definition has no type or storage
class
.../src/tclsqlite.c:102: error: syntax error before '*' token
.../src/tclsqlite.c:102: warning: data definition has no type or storage
class
.../src/tclsqlite.c:105: error: syntax error before '*' token
.../src/tclsqlite.c:105: warning: data definition has no type or storage
class
.../src/tclsqlite.c:110: error: syntax error before '}' token
.../src/tclsqlite.c:124: error: syntax error before '*' token
.../src/tclsqlite.c: In function `safeToUseEvalObjv':
.../src/tclsqlite.c:131: error: `pCmd' undeclared (first use in this
function)
.../src/tclsqlite.c:131: error: (Each undeclared identifier is reported
only once
.../src/tclsqlite.c:131: error: for each function it appears in.)
.../src/tclsqlite.c:131: warning: assignment makes pointer from integer
without a cast
.../src/tclsqlite.c: In function `findSqlFunc':
.../src/tclsqlite.c:147: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:148: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:148: error: invalid use of undefined type `struct
SqlFunc'
.../src/tclsqlite.c:148: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:149: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:150: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:151: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:151: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: error: dereferencing pointer to incomplete type
.../src/tclsqlite.c:152: 

Re: [sqlite] SQLite under linux

[Lloyd Thomas]

Hi Lloyd,
   I had exactly the same problem being new to C++. These are the 
steps I took. You may find that the library files may be in a folder where 
RH does not expect them to be. Try 'whereis libsqlite3.so' to locate. I 
can't remember where the default lib folder is. you will need to 
add -lsqlite3 in your Makefile or compile your code with -lsqlite3. You 
don't mention what errors you get when the make files. Some may be able to 
help you further if they have that information.


Lloyd T

- Original Message - 
From: "Lloyd" <[EMAIL PROTECTED]>

To: 
Sent: Tuesday, September 26, 2006 12:45 PM
Subject: [sqlite] SQLite under linux



Hi all,
 I have been trying to use SQLite with Redhat EL 4. I dont know how to
link the object file. I have downloaded the sqlite-3.3.7.so. but I don't
know how to link my source file with this file.

As mentioned in the quick start guide I have copied the example source
code for C.

though I could not find the sqlite3.h file, I downloaded the source code
file of the sqlite and executed the ../configure command. it worked file

then I tried to "make"  the file, but it failed,  any how I got the
necessary sqlite3.h file.

But still I don't know from where to download the sqlite library and how
to install it in my machine. Awaiting for your kind reply.

Thanks and regards,
 Lloyd.


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] SQLite under linux

[Lloyd]

Hi all,
  I have been trying to use SQLite with Redhat EL 4. I dont know how to
link the object file. I have downloaded the sqlite-3.3.7.so. but I don't
know how to link my source file with this file. 

As mentioned in the quick start guide I have copied the example source
code for C.

though I could not find the sqlite3.h file, I downloaded the source code
file of the sqlite and executed the ../configure command. it worked file

then I tried to "make"  the file, but it failed,  any how I got the
necessary sqlite3.h file.

But still I don't know from where to download the sqlite library and how
to install it in my machine. Awaiting for your kind reply.

Thanks and regards,
  Lloyd.


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Memory Usage

[Paul M]

Hi all,
I have a program that uses SQLite and it frequently updates and adds to the
database. However, despite my freeing the result when done memory usage
continues to increase over time. The database has currently has 940 rows and
uses sever selects and a select with limit and offset. Also only one insert,
so anyone have any suggestions on what could be the cause? Thanks in
advance.

Paul

AW: AW: [sqlite] Performance question

[Martin Pfeifle]

Hi Michael,
could you please (re)post the exact create inex statements +primary key you 
used.
For speeding up your query, you need an index on x only but not on id,x.
Best Martin

- Ursprüngliche Mail 
Von: Michael Wohlwend <[EMAIL PROTECTED]>
An: "sqlite-users@sqlite.org" 
Gesendet: Dienstag, den 26. September 2006, 09:34:00 Uhr
Betreff: AW: [sqlite] Performance question


-Ursprüngliche Nachricht-
Von: Dennis Cote [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 22. September 2006 17:07
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Performance question


Michael Wohlwend wrote:

> But If I do "select data from pictures where (x between high_x and 
> low_x) and (y between high_y and low_y) then this takes ca. 8 seconds 
> (!) on wince.
>
>   

>>If you are really writing your between clauses as above with the high 
>>limit first, then they are not doing what you think. The low limit 
>>should always be given first.

Ah, that was a typo, of course the query was "between (low and high)". I
changed this to
"x > low and x <= high ..." and i got the same result: 1 single query
(without bouds-check) takes 5ms, the query with the bounds-check takes ca.
7seconds (there are indices on x and y).
I changed the query to (select  ... where id in (v1,v2,...)) this was quite
fast again, even if the list of values got over 200 elements, but that's not
the way I wanted to do it. Maybe sqlite on arm cpus in the current
implementation isn't optimized enough. But I have no idea where this huge
slowdown comes from.

Cheers
Michael






___ 
Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: 
http://mail.yahoo.de

AW: [sqlite] Performance question

[Michael Wohlwend]

-Ursprüngliche Nachricht-
Von: Dennis Cote [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 22. September 2006 17:07
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Performance question


Michael Wohlwend wrote:

> But If I do "select data from pictures where (x between high_x and 
> low_x) and (y between high_y and low_y) then this takes ca. 8 seconds 
> (!) on wince.
>
>   

>>If you are really writing your between clauses as above with the high 
>>limit first, then they are not doing what you think. The low limit 
>>should always be given first.

Ah, that was a typo, of course the query was "between (low and high)". I
changed this to
"x > low and x <= high ..." and i got the same result: 1 single query
(without bouds-check) takes 5ms, the query with the bounds-check takes ca.
7seconds (there are indices on x and y).
I changed the query to (select  ... where id in (v1,v2,...)) this was quite
fast again, even if the list of values got over 200 elements, but that's not
the way I wanted to do it. Maybe sqlite on arm cpus in the current
implementation isn't optimized enough. But I have no idea where this huge
slowdown comes from.

Cheers
 Michael

Re: [sqlite] Please test check-ins [3445] and [3446]

[Dennis Cote]

[EMAIL PROTECTED] wrote:

Windows users with the ability to build from source, please help me
out by testing the changes in check-ins [3445] and [3446] at
http://www.sqlite.org/cvstrac/chngview?cn=3445 and 
http://www.sqlite.org/cvstrac/chngview?cn=3446 verifying that

they do not break anything.  Tnx.
  

Richard,

I built the latest CVS source and ran the test suite. I got 61 errors. 
Almost all these errors seem to be related to the new SQLITE_IOERR 
return codes.


  61 errors out of 25219 tests
  Failures on these tests: autovacuum-ioerr-1.1.3 autovacuum-ioerr-1.5.3
  autovacuum-ioerr-1.6.3 autovacuum-ioerr-1.7.3 autovacuum-ioerr-1.8.3
  autovacuum-ioerr-1.9.3 autovacuum-ioerr-1.11.3 autovacuum-ioerr-1.13.3
  autovacuum-ioerr-1.15.3 autovacuum-ioerr-1.17.3 autovacuum-ioerr-1.20.3
  autovacuum-ioerr-1.21.3 autovacuum-ioerr-1.22.3 autovacuum-ioerr-1.24.3
  autovacuum-ioerr-1.25.3 autovacuum-ioerr-1.27.3 autovacuum-ioerr-1.30.3
  autovacuum-ioerr-1.31.3 autovacuum-ioerr-1.32.3 autovacuum-ioerr-1.33.3
  autovacuum-ioerr-1.34.3 autovacuum-ioerr-1.35.3 autovacuum-ioerr-1.37.3
  autovacuum-ioerr-1.38.3 autovacuum-ioerr-1.40.3 autovacuum-ioerr-1.43.3
  autovacuum-ioerr-1.44.3 autovacuum-ioerr-1.45.3 autovacuum-ioerr-1.46.3
  autovacuum-ioerr-1.47.3 autovacuum-ioerr-1.48.3 ioerr-1.1.3 ioerr-1.4.3
  ioerr-1.5.3 ioerr-1.6.3 ioerr-1.8.3 ioerr-1.10.3 ioerr-1.12.3 
ioerr-1.14.3

  ioerr-1.17.3 ioerr-1.18.3 ioerr-1.19.3 ioerr-1.21.3 ioerr-1.22.3
  ioerr-1.24.3 ioerr-1.27.3 ioerr-1.28.3 ioerr-1.29.3 ioerr-1.30.3
  ioerr-1.31.3 ioerr-1.32.3 ioerr-1.34.3 ioerr-1.35.3 ioerr-1.37.3
  ioerr-1.40.3 ioerr-1.41.3 ioerr-1.42.3 ioerr-1.43.3 ioerr-1.44.3
  ioerr-1.45.3 ioerr-1.46.3
  make: *** [test] Error 1

I can send you the logs from these tests with the error details if you 
want. I will attach them to this message, but I don't think the mailing 
list passes attachments through.


While doing this build I was reminded (this has happened for quite a 
while, not just with these recent patches) that the test suite creates a 
large number of files that it does not delete when it is done. These are 
mostly sample database files and journal files, but there are so many of 
them, over 400 files, that it clutters the build directory. Also, these 
files are not removed by the makefile when doing a make clean or make 
distclean. I have attached a list of these files as well.


Dennis Cote

P.S. Attaching files to email is getting to be a real pain. On my first 
attempt I attached the raw text files. That message was rejected by the 
qmail-send program at sqlite.org because it was too big (> 30K). My 
second attempt packed all the text files into a single zip file. This 
was stripped as an unsafe file (using the rule *.zip) by "Antigen for 
Exchange" at relay2.mail.twtelecom.net.  Hopefully they don't know about 
the gzip compressed files attached to this email.






autovacuum_ioerr.log.gz
Description: application/gzip-compressed


ioerr.log.gz
Description: application/gzip-compressed


files.txt.gz
Description: application/gzip-compressed
-
To unsubscribe, send email to [EMAIL PROTECTED]
-