On 6/8/18 2:39 AM, Simon Slavin wrote:
On 8 Jun 2018, at 7:19am, Ron Yorston wrote:
Meh. *All* programmers of a certain age wrote their own web server.
Zawinski's Law:
"Every program attempts to expand until it can read mail."
updated for an age where everything is web-based, not email-ba
On 8 Jun 2018, at 7:19am, Ron Yorston wrote:
> Meh. *All* programmers of a certain age wrote their own web server.
Zawinski's Law:
"Every program attempts to expand until it can read mail."
updated for an age where everything is web-based, not email-based.
Simon.
On 8 Jun 2018, at 6:55am, Hick Gunter wrote:
>> Why can't we have both? I mean the software is in the public domain there is
>> nothing to hide so what's the point of encrypting the site?
>
> I believe it is because of the EU GDPR, which is designed to placea
> disproportionate burden on small
On 6/8/18 2:33 AM, Scott Robison wrote:
On Fri, Jun 8, 2018, 12:19 AM Ron Yorston wrote:
Dennis Clarke wrote:
On 6/7/18 9:59 PM, Richard Hipp wrote:
On 6/7/18, Scott Doctor wrote:
Just out of curiosity, is the sqlite website using nginx or
apache as the server?
None of the above.
The we
On Fri, Jun 8, 2018, 12:19 AM Ron Yorston wrote:
> Dennis Clarke wrote:
> >On 6/7/18 9:59 PM, Richard Hipp wrote:
> >> On 6/7/18, Scott Doctor wrote:
> >>> Just out of curiosity, is the sqlite website using nginx or
> >>> apache as the server?
> >>
> >> None of the above.
> >>
> >> The web serve
On Fri, Jun 8, 2018, 12:11 AM Hick Gunter wrote:
> >
> >
> >I've encountered a feature that I think would be awesome:
> >https://www.postgresql.org/docs/9.3/static/dml-returning.html
> >
> >Example: INSERT INTO blah (this, that, another) VALUES (x, y, z)
> RETURNING id;
> >
>
> What does this do
Hick Gunter wrote:
>> I've encountered a feature that I think would be awesome:
>> https://www.postgresql.org/docs/9.3/static/dml-returning.html
>>
>> Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) RETURNING
>> id;
>
> What does this do if the INSERT creates multiple rows?
It re
Dennis Clarke wrote:
>On 6/7/18 9:59 PM, Richard Hipp wrote:
>> On 6/7/18, Scott Doctor wrote:
>>> Just out of curiosity, is the sqlite website using nginx or
>>> apache as the server?
>>
>> None of the above.
>>
>> The web server is one that I wrote myself
>
>You're level of cool just jumped to
>
>
>I've encountered a feature that I think would be awesome:
>https://www.postgresql.org/docs/9.3/static/dml-returning.html
>
>Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) RETURNING id;
>
What does this do if the INSERT creates multiple rows? What about inserts
generated fro
Adding the attribute "hidden" to a column prevents it from showing up in the
expansion of '*' in the select list, while still allowing it to be queried by
name. There is no RE matching in the select list; you are expected to know
exactly what you want.
Having multiple instances of a field or fi
>
>
>Why can't we have both? I mean the software is in the public domain there is
>nothing to hide so what's the point of encrypting the site?
>
>Cheers and thank for you generosity and work.
>Best regards,
>George
I believe it is because of the EU GDPR, which is designed to placea
disproportion
On Thu, Jun 7, 2018, 9:25 PM Rowan Worth wrote:
> On 3 June 2018 at 07:28, Scott Robison wrote:
>
> > I've encountered a feature that I think would be awesome:
> > https://www.postgresql.org/docs/9.3/static/dml-returning.html
> >
> > Example: INSERT INTO blah (this, that, another) VALUES (x, y,
On 7 Jun 2018, at 5:11pm, mukeshkb4u wrote:
> I have a table with multiple similar column names, like
> abc_1,abc_2,abc_3...
>
> Is there a way i can do a select on only these columns in a table, without
> specifiying the full column list?
> Can i use a regular expression in selecting colum
On Jun 7, 2018, at 8:24 PM, George wrote:
>
> On Thu, 7 Jun 2018 14:31:22 -0400
> Richard Hipp wrote:
>
>> As an experiment, I have reconfigured the sqlite.org website to
>> redirect all HTTP requests over to HTTPS.
>>
>> Let me know if this causes anybody any unnecessary grief. It is easy
>>
Keith,
Thank you. After upgrading everything works as expected. It was just
an old library version.
And I won't even bother trying to track down the fixing commit. ;-)
And thanks to Olivier for a suggestion about the "SELECT.. " statement
instead of mprintf().
The issue is closed.
On Thu, Jun
On 7:24PM, Thu, Jun 7, 2018 George wrote:
>
> On Thu, 7 Jun 2018 14:31:22 -0400
> Richard Hipp wrote:
>
> > As an experiment, I have reconfigured the sqlite.org website to
> > redirect all HTTP requests over to HTTPS.
> >
> > Let me know if this causes anybody any unnecessary grief. It is easy
>
George wrote:
Why can't we have both? I mean the software is in the public domain
there is nothing to hide so what's the point of encrypting the site?
ISPs and other intermediaries alter website traffic between the server and
the client. The purpose of their alterations is irrelevant, you shou
Hello,
I have a question regarding checking for errors that occur when calling
sqlite3_column_*.
From this manual page:
https://sqlite.org/c3ref/column_blob.html
it seems that the only error that could occur (other than programmer
error, like out-of-bounds column index or calling it after someth
Thanks to all who replied. Richard, you specifically said that “on
posix, filenames are expected to be UTF8”; sorry, I’m not very familiar
with the POSIX standard, but I wasn’t aware that was the case? This
page:
http://pubs.opengroup.org/onlinepubs/9699919799/basedefs/V1_chap03.html#tag_03_271
s
Hi All,
I have a table with multiple similar column names, like
abc_1,abc_2,abc_3...
Is there a way i can do a select on only these columns in a table, without
specifiying the full column list?
Can i use a regular expression in selecting column names ?
Regards
Mukesh
--
Sent from: http://
On 6 June 2018 at 07:14, Richard Hipp wrote:
> On 6/5/18, Stéphane Aulery wrote:
> > Hello,
> >
> > The changelog of the last release [1] say at the point 13 :
> >
> > UPDATE avoids writing database pages that do not actually change. For
> > example, "UPDATE t1 SET x=25 WHERE y=?" becomes a no-o
Agreed. Would be good.
On Fri, Jun 8, 2018 at 1:25 PM, Rowan Worth wrote:
> On 3 June 2018 at 07:28, Scott Robison wrote:
>
> > I've encountered a feature that I think would be awesome:
> > https://www.postgresql.org/docs/9.3/static/dml-returning.html
> >
> > Example: INSERT INTO blah (this, th
On 3 June 2018 at 07:28, Scott Robison wrote:
> I've encountered a feature that I think would be awesome:
> https://www.postgresql.org/docs/9.3/static/dml-returning.html
>
> Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) RETURNING
> id;
>
> my thoughts are just that this could
On 6/7/18 10:29 PM, Simon Slavin wrote:
On 8 Jun 2018, at 2:59am, Richard Hipp wrote:
The web server is one that I wrote myself
Yeah. And it doesn't return a "Server:" header.
How do you NOT love that? :-)
dc
___
sqlite-users mailing list
sql
Yes, 3.24.0 is officially released and the official release page on the
sqlite.org website has been updated. I don't think I saw a release
announcement either though.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>
On 8 Jun 2018, at 2:59am, Richard Hipp wrote:
> The web server is one that I wrote myself
Yeah. And it doesn't return a "Server:" header.
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin
On Thu, 7 Jun 2018 14:31:22 -0400
Richard Hipp wrote:
> As an experiment, I have reconfigured the sqlite.org website to
> redirect all HTTP requests over to HTTPS.
>
> Let me know if this causes anybody any unnecessary grief. It is easy
> enough to undo the setting.
>
Why can't we have both?
Hi, Keith,
On Tue, Jun 5, 2018 at 5:09 PM, Keith Medcalf wrote:
>
> Most of them. In particular those that return (as in SELECT) data work
> either way. Those that set things can only be used as a pragma.
>
> Note that the table name is passed differently (in the case of pragma's
> expecting
On 6/7/18 9:59 PM, Richard Hipp wrote:
On 6/7/18, Scott Doctor wrote:
Just out of curiosity, is the sqlite website using nginx or
apache as the server?
None of the above.
The web server is one that I wrote myself
You're level of cool just jumped to UNIX silverback level :-)
Dennis
__
On 6/7/18, Scott Doctor wrote:
> Just out of curiosity, is the sqlite website using nginx or
> apache as the server?
None of the above.
The web server is one that I wrote myself, long again, before SQLite,
called althttpd.c. You can find the source code here:
https://www.sqlite.org/docsrc/f
On 6/7/18 5:34 PM, Bob Friesenhahn wrote:
On Thu, 7 Jun 2018, Warren Young wrote:
Yes, I know that, but it does solve the other likely problem when
using a too-old system with HTTPS, being an inability for the client
and server to agree on a mutually-supported encryption suite. With
all of
On Jun 7, 2018, at 2:32 PM, Stephen Chrzanowski wrote:
>
> On Thu, Jun 7, 2018 at 4:07 PM, Warren Young wrote:
>
>> Do you really need something in the daily scrape that you wouldn’t get
>> from a Fossil clone?
>
> To that, I can honestly say, I don't know. The thing I like about the
> daily
Just out of curiosity, is the sqlite website using nginx or
apache as the server?
-
Scott Doctor
sc...@scottdoctor.com
-
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailin
On Thu, 7 Jun 2018, Warren Young wrote:
Yes, I know that, but it does solve the other likely problem when
using a too-old system with HTTPS, being an inability for the client
and server to agree on a mutually-supported encryption suite. With
all of the security vulnerabilities found in encry
On 1:38PM, Thu, Jun 7, 2018 Keith Medcalf wrote:
>
>
> Just tell wget --no-check-certificate in the command line. wget does not
use a certificate repository and you need to obtain and specify the
expected root manually. It will be no less secure than it was before (when
using HTTP) except that n
On Jun 7, 2018, at 3:08 PM, Bob Friesenhahn
wrote:
>
> On Thu, 7 Jun 2018, Warren Young wrote:
>>
>> I ask because if you build a Fossil binary by hand, you can link it to an
>> up-to-date version of OpenSSL, which may solve the certificate problem.
>
> OpenSSL does not provide certificates.
http://sqlite.org and https://sqlite.org seem to redirect OK to
https://sqlite.org/index.html
http://www.sqlite.org and https://www.sqlite.org seem to redirect OK
to https://www.sqlite.org/index.html
fossil clone https://www.sqlite.org/src sqlite.fossil works for me on
my mac (recent version inst
On Thu, 7 Jun 2018, Warren Young wrote:
I ask because if you build a Fossil binary by hand, you can link it
to an up-to-date version of OpenSSL, which may solve the certificate
problem.
OpenSSL does not provide certificates.
The missing certificate could be copied from a newer Let's
Encryp
On June 7, 2018 3:52:04 PM EDT, Stephen Chrzanowski wrote:
>Probably, yes. Its running Debian Lenny. I'm trying to locate a
>resource
>right now to see if I can get the appropriate files, and how to keep
>them
>updated.
>
>On Thu, Jun 7, 2018 at 3:43 PM, Simon Slavin
>wrote:
>
>> On 7 Jun 2018,
Just tell wget --no-check-certificate in the command line. wget does not use a
certificate repository and you need to obtain and specify the expected root
manually. It will be no less secure than it was before (when using HTTP)
except that now it will use Transport encryption. Certificate ch
On Thu, Jun 7, 2018 at 4:07 PM, Warren Young wrote:
>
> That OS is over 9 years old now.
>
Trust me, its showing its age, and I'd really like to get rid of it, but
there's a bunch of things I really don't want to migrate as some of what is
doing relies on functionality in the underlying language
On Jun 7, 2018, at 1:52 PM, Stephen Chrzanowski wrote:
>
> Its running Debian Lenny.
That OS is over 9 years old now.
I’ve been known to run Linux boxes longer than that, but one of the several
tradeoffs for that stability is that you must accept incompatibilities like
this.
Besides the CA d
Probably, yes. Its running Debian Lenny. I'm trying to locate a resource
right now to see if I can get the appropriate files, and how to keep them
updated.
On Thu, Jun 7, 2018 at 3:43 PM, Simon Slavin wrote:
> On 7 Jun 2018, at 8:35pm, Stephen Chrzanowski wrote:
>
> > stephen@vmLamp:~$ wget -
On Thu, 7 Jun 2018, Simon Slavin wrote:
Your copy of wget is using a different set of Certification
Authority certificates to those used by your browser. Since your
browser was updated more recently than your OS (purely a guess on my
part) I'm guessing that the certificates used by "wget" ar
On 7 Jun 2018, at 8:35pm, Stephen Chrzanowski wrote:
> stephen@vmLamp:~$ wget -O - https://sqlite.org/download.html
> --15:30:59-- https://sqlite.org/download.html
> => `-'
> Resolving sqlite.org... 45.33.6.223
> Connecting to sqlite.org|45.33.6.223|:443... connected.
> ERROR: Certific
I've got a script that runs daily and scrapes the download page and grabs
everything new. The last run was this morning at midnight eastern (-4UTC)
and it successfully grabbed the list of files that could be downloaded,
however, when I run it now, it doesn't seem to want to see anything. After
ma
As an experiment, I have reconfigured the sqlite.org website to
redirect all HTTP requests over to HTTPS.
Let me know if this causes anybody any unnecessary grief. It is easy
enough to undo the setting.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-us
The download page (https://sqlite.org/download.html) provides
precompiled binaries for Mac OS X (x86):
https://sqlite.org/2018/sqlite-tools-osx-x86-324.zip
This zip file contains a single binary you can put onto your path.
Lutz
___
sqlite-users
On 6 Jun 2018, at 17:06, Sabrina Abdul Jalil wrote:
> I am on MAC OS Sierra VER 10.12.06. How to download SQLite?
As a couple of people have already pointed out, you actually have it already.
Depending on your needs, it may be significant that the version of SQLite
which is bundled with macOS (S
On 6 Jun 2018, at 5:06pm, Sabrina Abdul Jalil wrote:
> I am on MAC OS Sierra VER 10.12.06. How to download SQLite?
The shell tool is already on your computer. In Terminal type
which sqlite3
and it will tell you where it is. You should be able to type just
sqlite3 datafile.sq
On 06 Jun 2018, at 17:06, Sabrina Abdul Jalil wrote:
> I am on MAC OS Sierra VER 10.12.06. How to download SQLite?
It's already installed on your computer.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http:/
Hello,
I am on MAC OS Sierra VER 10.12.06. How to download SQLite?
Please help.
Thanks,
Sabrina
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 7 Jun 2018, at 5:25am, Dianne Dunn wrote:
> Hey there do you know how I can get off this list.??
Click the link that appears at the bottom of every post.
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.
53 matches
Mail list logo