Re: [sqlite] SQLite Web Site

2008-02-06 Thread L. S.
O-o-o-okay! That explains it.
I do vaguely remember that issue being discussed, some time ago.
Well... I'm in Cali', and I'm out of luck on this Palm/Blazer.

On 2/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "L. S." <[EMAIL PROTECTED]> wrote:
> > The page never loads. I get the message, "The page download could not
> > be completed. Please try again later."
> >
> > Here is the User-Agent header string:
> > Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; PalmSource/Palm-D052;
> > Blazer/4.5) 16;320x320
> >
>
> The webserver on www.sqlite.org specifically excludes clients
> claiming to be "Windows 98".  We were getting a lot of abuse
> coming out of China - people would download thousands of copies
> of tarballs and use up gigabytes of bandwidth.  Since excluding
> Windows98 clients, we have not had any of the abuse problems.
> We were not able to detect any change in the number of daily
> visitors when we implemented the no-win98 policy, from
> which we concluded that most people had upgraded to at least
> win2k by the we instituted the change.
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite Web Site

2008-02-06 Thread L. S.
The page never loads. I get the message, "The page download could not
be completed. Please try again later."

Here is the User-Agent header string:
Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; PalmSource/Palm-D052;
Blazer/4.5) 16;320x320


On 2/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "L. S." <[EMAIL PROTECTED]> wrote:
> > I've been ignoring this issue for a while; the world won't end over this
> but...
> > There is some issue with the newly-designed SQLite web site that
> > prevents access from my Palm Treo. It used to be accessible, with the
> > old design.
> > --
> > Often I surf, email, research, read, and download things using
> > wireless access on my Treo web browser (and even store a copy of the
> > SQLite source on my phone) because it's highly portable, has all day
> > battery life, and I can Bluetooth-transfer stored files to my laptop.
> >
> > The site is no longer found on this platform. Why is this?
>
> What do you mean "no longer found"?  Do you mean that that
> you cannot see anything at all, or that the new design is such
> that it is not displayed correctly?
>
> What does the User-Agent header string from your web browser
> say on the Palm Treo?
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] SQLite Web Site

2008-02-06 Thread L. S.
I've been ignoring this issue for a while; the world won't end over this but...
There is some issue with the newly-designed SQLite web site that
prevents access from my Palm Treo. It used to be accessible, with the
old design.
--
Often I surf, email, research, read, and download things using
wireless access on my Treo web browser (and even store a copy of the
SQLite source on my phone) because it's highly portable, has all day
battery life, and I can Bluetooth-transfer stored files to my laptop.

The site is no longer found on this platform. Why is this?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite Compilation Problems on FreeBSD

2008-01-31 Thread L. S.
I got "sqlite-3.5.4.tar.gz" to compile, cleanly, and installation went 
smooth.


After compiling and installing tcl and tk, the slqite "make" step still 
failed, saying "*** Error code 1", just like it did before tcl/tk; it 
complained about tclsh being installed under multiple names (tclsh, 
tclsh8.4, and tclsh.8.5).


It turned out to be "tclsh", itself, making all the noise. So I did the 
following:

# mv /usr/local/bin/tclsh /usr/local/bin/OFF_tclsh
# ln -s /usr/local/bin/tclsh8.5 /usr/local/bin/tclsh
$ make clean
$ make
# make install

It worked!


Rob Sciuk wrote:


On Sun, 27 Jan 2008, L. S. wrote:


Why doesn't SQLite 3.5.4 compile under FreeBSD 5.3? Can it be done in 
a sane manner?


AFAIK, it just works, but you may require the -lc_r  option to include 
the re-entrant (threadsafe) C library with your linked executeable ...




How can I link against SQLite under FreeBSD 5.3, using gcc?
Is there any way that I could just link the source files into my code?

* Using "./configure" and "make" with "sqlite-3.5.4.tar.gz", I got tcl 
and tcsh errors.
* Using "sqlite-source-3_5_4.zip", with "tclsqlite.c" removed, I got 
pthread errors. They went away with "gcc ... -lpthread", but 
compilation still failed.
* I think "sqlite-amalgamation-3_5_4.zip" produced the same errors as 
sqlite-source-.


I have compiled, installed, linked, and used it on other systems, but 
cannot do the same on my FreeBSD system. (I don't use the FreeBSD 
ports; I like to just download and build.)




Moi aussi, but I have *NEVER* had a problem with SQLite on FreeBSD, 
including 3.5.4 ... Of course I *ALWAYS* install Tcl/Tk first, and am 
happy to use the tclsqlite bindings which result ...


Again, when you link your C code to the libSqlite.so, just add the -lc_r
option, and you can delete the -lpthreads unless you are actually using 
pthreads, in which case you will likely need both -lpthreads *AND* -lc_r

or surprises may result.

Apparently, the -lc_r requirement is new with 3.5.4, and my query on 
this list has been met with silence thus far, so I cannot advise you 
further. Apparently the db engine has been re-worked somewhat 
(extensively) with this release, and I suspect that changes eminate from 
that code, but I haven't had time to investigate ...


HTH,

Rob Sciuk

- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






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



[sqlite] SQLite Compilation Problems on FreeBSD

2008-01-27 Thread L. S.
Why doesn't SQLite 3.5.4 compile under FreeBSD 5.3? Can it be done in a 
sane manner?


How can I link against SQLite under FreeBSD 5.3, using gcc?
Is there any way that I could just link the source files into my code?

* Using "./configure" and "make" with "sqlite-3.5.4.tar.gz", I got tcl 
and tcsh errors.
* Using "sqlite-source-3_5_4.zip", with "tclsqlite.c" removed, I got 
pthread errors. They went away with "gcc ... -lpthread", but compilation 
still failed.
* I think "sqlite-amalgamation-3_5_4.zip" produced the same errors as 
sqlite-source-.


I have compiled, installed, linked, and used it on other systems, but 
cannot do the same on my FreeBSD system. (I don't use the FreeBSD ports; 
I like to just download and build.)


**

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



Re: [sqlite] Compiled MacOS X version of 3.2.x

2005-09-07 Thread L. S.

Why don't you try compiling it with gcc, in a shell?

Richard Nagle wrote:

Does anyone have a 3.2.x with all the updates, for importing spreadsheets, tab 
delimited files..etc
already compiled for MacOS X (10.3.9 ) G4

Thanks -
Richard

PS: Yes, I did download the sorce code, and have xcode 1.5 installed with all 
the updates,
there is a major compiling error, going on, even after a complete wipe of HD, 
and re-install,
the same problem is still there.

PSS: So, enclosed, can't compile it, until C problem get fixs.
PSSS: if you want a peek at the config.log to see what I mean, email me off 
list.







Re: [sqlite] Documentation

2005-08-04 Thread L. S.

D. Richard Hipp wrote:

On Thu, 2005-08-04 at 12:59 -0700, L. S. wrote:

What is the prescribed way to create the complete documentation (without 
having to learn yet another scripting language--or whatever it is)?





make doc

Thanks!


Re: [sqlite] Documentation

2005-08-04 Thread L. S.

Ralf Junker wrote:

Hello L. S.,

you can create a HTML version by running the TCL scripts which are part of the 
tarball sources.


And how do I do that? I found enough info about TCL to do...
'tclsh foo.tcl > foo.html'
but that fails on some files.

What is the prescribed way to create the complete documentation (without 
having to learn yet another scripting language--or whatever it is)?


[sqlite] Documentation

2005-08-02 Thread L. S.
Where is the downloadable documentation? It was supposed to have been in 
cluded with the tarball sources, but I don't see it.