Re: [sqlite] sqlite-users Digest, Vol 126, Issue 13

[José María Mateos]

On Wed, Jun 13, 2018 at 09:01:22PM +0200, Simone Mosciatti wrote:
> Hi folks,
> 
> I already posted this message but I believe there was some error or
> issue with nabble and I am not sure it was received, if you already
> got it, please sorry a lot for the noise.

I'm finding some mailing list posts made from nabble.com to be flagged 
as spam on my system in the last days. I don't know if there is some 
problem there.

Cheers,

-- 
José María (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mailing list shutting down...

[José María Mateos]

On Wed, Jun 13, 2018 at 12:14:46PM -0400, Richard Hipp wrote:
> (1) Nobody seems to want to own the GNU MailMan software.  It is not
> well maintained as far as I can see.

I'm not an expert, but how does Sympa handle this? I remember a few 
years ago a lot of people were moving their Mailman systems to Sympa. It 
seems to be properly maintained too (latest release was April 19th).

Cheers,

-- 
José María (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Only see unused when there are unused records

[José María Mateos]

Sorry, re-reading your question I realized my solution doesn't work: it would 
return 0 when there are unused, but you don't want to see them.

Cheers,

-- 
José María (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Only see unused when there are unused records

[José María Mateos]

On Wed, May 9, 2018, at 16:19, Cecil Westerhof wrote:
> I have a table where I use 'unused' to signify that a record is not yet
> used. I want to know the number of unused records (but only if there are
> unused records) and the total number of records.
> 
> At the moment I implemented it like:
> SELECT   *
> FROM (
> SELECT   'Not used'  AS Type
> ,COUNT(*)AS NoUsed
> FROM quotes
> WHEREtotalUsed == 'unused'
> UNION ALL
> SELECT   'Total'  AS Type
> ,COUNT(*) AS NoUsed
> FROM quotes
> )
> WHERENoUsed > 0
> 
> Is this correct, or is there a better way?

Would this work?

SELECT COUNT(*) AS Total,
  SUM(CASE WHEN totalUsed = 'unused' THEN 1 END) AS NotUsed
FROM quotes;

Cheers,

-- 
José María (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Always call a value-quoting routine

[José María Mateos]

On Sat, May 05, 2018 at 11:57:22PM +0100, Simon Slavin wrote:
> This is a genuine company registered under the UK Companies Act:
> 
> 
> 
> The name of company is
> 
> ; DROP TABLE "COMPANIES";-- LTD

Obligatory: https://xkcd.com/327/

Cheers, 

-- 
José María (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

[José María Mateos]

On Tue, Apr 17, 2018, at 17:39, Simon Slavin wrote:
> Dear list-posters,
> 
> Are you getting a new dating-spam each time you post to this list ?  If 
> you are, please post a brief follow-up to this message.  Please do /not/ 
> include any details about the spam, its headers, or the person it's 
> apparently from.  Just a "me too" until I say I have seen enough 
> responses.

For what I understand, this exact behavior is happening right now on the r-help 
mailing list too. People were wondering if addresses were being scrapped from 
nabble.com or something similar.

Cheers,

-- 
José María (Chema) Mateos
https://rinzewind.org/blog-es || https://rinzewind.org/blog-en
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users