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
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
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
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
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
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.
I am developing a hobby that is how to calculate something like the PageRank
with SQLite for HDD Storage.
Thanks to all.
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
./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"
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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
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
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"
-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
>
[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.
32 matches
Mail list logo
