Re: [sqlite] This list is getting spammed again

[Cecil Westerhof]

2018-05-11 11:12 GMT+02:00 Cecil Westerhof :

> 2018-05-10 1:09 GMT+02:00 Simon Slavin :
>
>>
>>
>> On 9 May 2018, at 9:37pm, Cecil Westerhof  wrote:
>>
>> > ​I am bitten by it also now. I posted a question and within two minutes
>> I
>> > got a spam message​
>>
>> I got three or four of these, each one soon after I'd posted a message.
>> Then I got no more.  I didn't do anything to stop them and I have checked
>> my spam system to see if it stopped them, but the spam system didn't
>> receive any more.
>>
>
> ​I marked the sender as spammer. (It was from one sender.) And the
> messages are send to spam now. I got a few more. I'll watch if this
> triggers again, or that it is a 'smart' spammer that stops when you do not
> reply.
>

​I got no new spam message. So it is a 'smart' spammer.​

-- 
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web hosting and perl DBD::SQLite?

[Warren Young]

On May 11, 2018, at 4:07 PM, Jim Dodgen  wrote:
> 
> Any VPSes you suggest?

I’ve used A2 and Digital Ocean successfully:

   https://www.a2hosting.com/
   https://www.digitalocean.com/

But, I’m far from broadly experienced in this field.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web hosting and perl DBD::SQLite?

[Richard Hipp]

On 5/11/18, Jim Dodgen  wrote:
> Any VPSes you suggest?

Linode.com

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web hosting and perl DBD::SQLite?

[Jim Dodgen]

Any VPSes you suggest?


*Jim Dodgen*







On Fri, May 11, 2018 at 2:14 PM, Warren Young  wrote:

> On May 11, 2018, at 2:53 PM, Jim Dodgen  wrote:
> >
> > A little off topic,  but my hosting company went a way. And after two
> tries
> > I need to find a hosting company who is not scared of SQLite,
> specifically
> > have installed or will let me install DBD::Sqlite?
>
> Why bother using web hosts that specifically support your development
> platform of choice in 2018?
>
> That was necessary back in the days when “web hosting” meant you got an
> unprivileged user account on a shared server which was configured to use
> name-based virtual hosting to route HTTP requests to the appropriate
> customer files and scripts.
>
> That need disappeared first with VPSes and then with cloud hosting
> providers, both of which let you set up a whole development platform as you
> like it.
>
> They’re not even expensive any more.  You can get a root shell for
> $5/month from multiple providers now.  You just need to install cpanm and
> get to work.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Web hosting and perl DBD::SQLite?

[Warren Young]

On May 11, 2018, at 2:53 PM, Jim Dodgen  wrote:
> 
> A little off topic,  but my hosting company went a way. And after two tries
> I need to find a hosting company who is not scared of SQLite,  specifically
> have installed or will let me install DBD::Sqlite?

Why bother using web hosts that specifically support your development platform 
of choice in 2018?

That was necessary back in the days when “web hosting” meant you got an 
unprivileged user account on a shared server which was configured to use 
name-based virtual hosting to route HTTP requests to the appropriate customer 
files and scripts.

That need disappeared first with VPSes and then with cloud hosting providers, 
both of which let you set up a whole development platform as you like it.

They’re not even expensive any more.  You can get a root shell for $5/month 
from multiple providers now.  You just need to install cpanm and get to work.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there ever a perf advantage to LIMIT outside of a subquery?

[Richard Hipp]

On 5/11/18, Deon Brewis  wrote:
> e.g. If you do:
>
> SELECT c1 from t1 ORDER BY c2 LIMIT 5;
>
> vs. just running the query without the "LIMIT" clause and taking the top 5
> rows programmatically?

Yes, if there is an ORDER BY that cannot be satisfied by an index and
the total number of rows in the output is large relative to the LIMIT.
This is especially in 3.24.0 and later.

Without the LIMIT, all the terms of the original query must be
computed then sorted.  This can require a lot of storage.  With the
LIMIT, only the top N results must be stored.  And beginning with
3.24.0, if it is clear that a particular row will never make the LIMIT
cutoff, then columns that are not part of the ORDER BY clause are
never computed in the first place.  This latter optimization can be a
big win if the non-ORDER BY terms involve expensive functions and/or
correlated subqueries.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there ever a perf advantage to LIMIT outside of a subquery?

[Simon Slavin]

On 11 May 2018, at 9:50pm, Deon Brewis  wrote:

> e.g. If you do:
> 
> SELECT c1 from t1 ORDER BY c2 LIMIT 5;
> 
> vs. just running the query without the "LIMIT" clause and taking the top 5 
> rows programmatically?

The LIMIT clause just tells sqlite3_step() to return SQLITE_DONE after the 
fifth result.  The only difference is whether you want to count to 5 in your 
own code or have SQLite do it for you.

In practise, you may have a specific reason for wanting the limit to appear in 
the SQL command, or not wanting it there.  It may be part of your business 
practise or it may be a detail of how your software works. Do whatever the 
reader would find easiest to understand.

Remember in both cases to do sqlite3_finalize() or sqlite3_reset() once you 
have finished fetching results.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Web hosting and perl DBD::SQLite?

[Jim Dodgen]

A little off topic,  but my hosting company went a way. And after two tries
I need to find a hosting company who is not scared of SQLite,  specifically
have installed or will let me install DBD::Sqlite?


*Jim Dodgen*
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is there ever a perf advantage to LIMIT outside of a subquery?

[Deon Brewis]

e.g. If you do:

SELECT c1 from t1 ORDER BY c2 LIMIT 5;

vs. just running the query without the "LIMIT" clause and taking the top 5 rows 
programmatically?


Obviously in the case of a subquery this makes a difference:
select count(*) from (select * from t1 limit 5);


But would it ever in a straight query with joins etc.?

- Deon

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fail building snapshot 201805081303

[Richard Hipp]

On 5/11/18, Charles Leifer  wrote:
> Try specifying "-lm" flag to include math library.

The configure script does that automatically.
https://www.sqlite.org/src/artifact/5f6cf281ae675685?ln=121

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fail building snapshot 201805081303

[Charles Leifer]

Try specifying "-lm" flag to include math library.

On Fri, May 11, 2018 at 2:24 PM, Richard Hipp  wrote:

> I am unable to reproduce the problem.  What system are you doing this on?
>
> On 5/10/18, Michele Dionisio  wrote:
> > building snapshot 2018051303 I have the following issue
> >
> >
> > |
> > /Projects/development-1.8.6.999/T/forgetux_2.0/tmp/
> sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o):
> > In function `fts5Bm25Function':
> > | sqlite3.c:(.text+0x4b307): undefined reference to `log'
> > | collect2: ld returned 1 exit status
> > | make: *** [bin/pseudodb] Error 1
> > | make: *** Waiting for unfinished jobs
> > |
> > /Projects/development-1.8.6.999/T/forgetux_2.0/tmp/
> sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o):
> > In function `fts5Bm25Function':
> > | sqlite3.c:(.text+0x4b307): undefined reference to `log'
> > | collect2: ld returned 1 exit status
> > | make: *** [bin/pseudo] Error 1
> > |
> > /Projects/development-1.8.6.999/T/forgetux_2.0/tmp/
> sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o):
> > In function `fts5Bm25Function':
> > | sqlite3.c:(.text+0x4b307): undefined reference to `log'
> > | collect2: ld returned 1 exit status
> > | make: *** [bin/pseudolog] Error 1
> >
> >
> > --
> >
> > Powersoft logo 
> >
> > *Michele Dionisio |*Senior Embedded System Manager
> >
> > *skype:*  m.dionisio *| email:* michele.dioni...@powersoft.com
> > 
> >
> > *HQ Italy:* Via E. Conti, 5 *|* 50018 Scandicci (FI) Italy
> >
> > *direct phone:*  +39 055 735 0230 *| Fax:*   +39 055 735 6235
> >
> > *web site:* www.powersoft.it 
> >
> > Green Audio Power
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fail building snapshot 201805081303

[Richard Hipp]

I am unable to reproduce the problem.  What system are you doing this on?

On 5/10/18, Michele Dionisio  wrote:
> building snapshot 2018051303 I have the following issue
>
>
> |
> /Projects/development-1.8.6.999/T/forgetux_2.0/tmp/sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o):
> In function `fts5Bm25Function':
> | sqlite3.c:(.text+0x4b307): undefined reference to `log'
> | collect2: ld returned 1 exit status
> | make: *** [bin/pseudodb] Error 1
> | make: *** Waiting for unfinished jobs
> |
> /Projects/development-1.8.6.999/T/forgetux_2.0/tmp/sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o):
> In function `fts5Bm25Function':
> | sqlite3.c:(.text+0x4b307): undefined reference to `log'
> | collect2: ld returned 1 exit status
> | make: *** [bin/pseudo] Error 1
> |
> /Projects/development-1.8.6.999/T/forgetux_2.0/tmp/sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o):
> In function `fts5Bm25Function':
> | sqlite3.c:(.text+0x4b307): undefined reference to `log'
> | collect2: ld returned 1 exit status
> | make: *** [bin/pseudolog] Error 1
>
>
> --
>
> Powersoft logo 
>
> *Michele Dionisio |*Senior Embedded System Manager
>
> *skype:*  m.dionisio *| email:* michele.dioni...@powersoft.com
> 
>
> *HQ Italy:* Via E. Conti, 5 *|* 50018 Scandicci (FI) Italy
>
> *direct phone:*  +39 055 735 0230 *| Fax:*   +39 055 735 6235
>
> *web site:* www.powersoft.it 
>
> Green Audio Power
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] fail building snapshot 201805081303

[Michele Dionisio]

building snapshot 2018051303 I have the following issue


| 
/Projects/development-1.8.6.999/T/forgetux_2.0/tmp/sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o): 
In function `fts5Bm25Function':

| sqlite3.c:(.text+0x4b307): undefined reference to `log'
| collect2: ld returned 1 exit status
| make: *** [bin/pseudodb] Error 1
| make: *** Waiting for unfinished jobs
| 
/Projects/development-1.8.6.999/T/forgetux_2.0/tmp/sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o): 
In function `fts5Bm25Function':

| sqlite3.c:(.text+0x4b307): undefined reference to `log'
| collect2: ld returned 1 exit status
| make: *** [bin/pseudo] Error 1
| 
/Projects/development-1.8.6.999/T/forgetux_2.0/tmp/sysroots/x86_64-linux/usr/lib/libsqlite3.a(sqlite3.o): 
In function `fts5Bm25Function':

| sqlite3.c:(.text+0x4b307): undefined reference to `log'
| collect2: ld returned 1 exit status
| make: *** [bin/pseudolog] Error 1


--

Powersoft logo 

*Michele Dionisio |*Senior Embedded System Manager

*skype:*  m.dionisio *| email:* michele.dioni...@powersoft.com 



*HQ Italy:* Via E. Conti, 5 *|* 50018 Scandicci (FI) Italy

*direct phone:*  +39 055 735 0230 *| Fax:*   +39 055 735 6235

*web site:* www.powersoft.it 

Green Audio Power

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo in documentation for .sha3sum CLI command

[Richard Hipp]

Thank you for the bug report.  Should now be fixed on trunk.

On 5/10/18, Aaron Zeng  wrote:
> Hi folks,
>
> The documentation
>  for
> the .sha3sum CLI command indicates that the default variety of SHA-3 used
> is SHA-256, but (at least on 3.19.3) when the command is run without
> options, I get a 56-hex digit output, indicating SHA3-224.  SHA3-256 would
> produce a 64-hex digit output.  I suppose this could be a bug in the CLI
> rather than documentation.
>
> Also, there is a minor typo in the options help for .sha3sum that is shown
> when an unrecognized option is passed:
>
>> .sha3sum -h
> Unknown option "-h" on "sha3sum"
> Should be one of: --schema --sha3-224 --sha3-255 --sha3-384 --sha3-512
>
> "sha3-255" should be "sha3-256".  The command recognizes the latter but not
> the former.
>
> Best,
> Aaron
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] '.open' without args crashes shell

[Richard Hipp]

Thanks for the bug report.  This should be fixed on trunk.

On 5/10/18, Abroży Nieprzełoży  wrote:
> SQLite version 3.24.0 2018-05-09 16:32:00
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> Use ".open FILENAME" to reopen on a persistent database.
> sqlite> .version
> SQLite 3.24.0 2018-05-09 16:32:00
> 9f7a6ae878cd17ff4de7c55e654406773e0ea2b9fe1c4e2a9fc2b0da84d059a4
> zlib version 1.2.11
> msvc-1912
> sqlite> .open
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] This list is getting spammed again

[Paul Sanderson]

ahh disregard - it was there

Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence

On 11 May 2018 at 10:33, Simon Slavin  wrote:

> On 11 May 2018, at 10:26am, Paul Sanderson 
> wrote:
>
> > Would it be possible for an admin to run a script that sent an individual
> > email (e.g. different number in subject) to each user on the list and see
> > who is sending the spam based on the replies?
>
> My guess is that the spammer harvests our addresses from nabble, or from
> the Mailman archive.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] This list is getting spammed again

[Paul Sanderson]

Prob not nabble as my message does not seem to have made it there yet,
didn't check mailman - I suspect that they are subscribed as spam is sent
within seconds.

Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence

On 11 May 2018 at 10:33, Simon Slavin  wrote:

> On 11 May 2018, at 10:26am, Paul Sanderson 
> wrote:
>
> > Would it be possible for an admin to run a script that sent an individual
> > email (e.g. different number in subject) to each user on the list and see
> > who is sending the spam based on the replies?
>
> My guess is that the spammer harvests our addresses from nabble, or from
> the Mailman archive.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] This list is getting spammed again

[Simon Slavin]

On 11 May 2018, at 10:26am, Paul Sanderson  wrote:

> Would it be possible for an admin to run a script that sent an individual
> email (e.g. different number in subject) to each user on the list and see
> who is sending the spam based on the replies?

My guess is that the spammer harvests our addresses from nabble, or from the 
Mailman archive.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] This list is getting spammed again

[Paul Sanderson]

Would it be possible for an admin to run a script that sent an individual
email (e.g. different number in subject) to each user on the list and see
who is sending the spam based on the replies?

Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence

On 11 May 2018 at 10:12, Cecil Westerhof  wrote:

> 2018-05-10 1:09 GMT+02:00 Simon Slavin :
>
> >
> >
> > On 9 May 2018, at 9:37pm, Cecil Westerhof 
> wrote:
> >
> > > ​I am bitten by it also now. I posted a question and within two
> minutes I
> > > got a spam message​
> >
> > I got three or four of these, each one soon after I'd posted a message.
> > Then I got no more.  I didn't do anything to stop them and I have checked
> > my spam system to see if it stopped them, but the spam system didn't
> > receive any more.
> >
>
> ​I marked the sender as spammer. (It was from one sender.) And the messages
> are send to spam now. I got a few more. I'll watch if this triggers again,
> or that it is a 'smart' spammer that stops when you do not reply.
>
> --
> Cecil Westerhof
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] This list is getting spammed again

[Cecil Westerhof]

2018-05-10 1:09 GMT+02:00 Simon Slavin :

>
>
> On 9 May 2018, at 9:37pm, Cecil Westerhof  wrote:
>
> > ​I am bitten by it also now. I posted a question and within two minutes I
> > got a spam message​
>
> I got three or four of these, each one soon after I'd posted a message.
> Then I got no more.  I didn't do anything to stop them and I have checked
> my spam system to see if it stopped them, but the spam system didn't
> receive any more.
>

​I marked the sender as spammer. (It was from one sender.) And the messages
are send to spam now. I got a few more. I'll watch if this triggers again,
or that it is a 'smart' spammer that stops when you do not reply.

-- 
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users