Re: [sqlite] This list is getting spammed again

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, eac

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

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-user

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

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?

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 SQLit

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

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 specif

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

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

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

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

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

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-

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

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 straig

Re: [sqlite] fail building snapshot 201805081303

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 mailin

Re: [sqlite] fail building snapshot 201805081303

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 > > > > > > | >

Re: [sqlite] fail building snapshot 201805081303

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

[sqlite] fail building snapshot 201805081303

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 |

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

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 (

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

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> .versio

Re: [sqlite] This list is getting spammed again

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

Re: [sqlite] This list is getting spammed again

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/con

Re: [sqlite] This list is getting spammed again

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 addr

Re: [sqlite] This list is getting spammed again

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:/

Re: [sqlite] This list is getting spammed again

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.