No clue where it came from. I’ve been using this for about four years now.
No clue where it came from. I’ve been using this for about four years now.
It lasts forever with regular maintenance. I moved into a house with a slate roof that’s 96 years old. We just have a roofer come out and replace a few cracked tiles every year. Not necessarily any cheaper but the cost is spread out and it seems less wasteful.
The article warns of several pathogens but I wonder if anyone has tried cooking it.
Also this…
In 2010, a religious group leader was investigated for smuggling the snails into Florida and encouraging his followers eat their mucus, the Miami New Times reported, possibly contributing to the spread of the snails.
I’m speechless.
Looking through the code on GitHub it looks like active is the number of new posts plus the number of new comments in a certain time period (in this case 6 months).
Caveat: I’m just a hobbyist so my reading of the code may not be exactly correct.
create or replace function site_aggregates_activity(i text)
returns int
language plpgsql
as
$$
declare
count_ integer;
begin
select count(*)
into count_
from (
select c.creator_id from comment c
inner join user_ u on c.creator_id = u.id
where c.published > ('now'::timestamp - i::interval)
and u.local = true
union
select p.creator_id from post p
inner join user_ u on p.creator_id = u.id
where p.published > ('now'::timestamp - i::interval)
and u.local = true
) a;
return count_;
end;
$$;
update site_aggregates
set users_active_day = (select * from site_aggregates_activity('1 day'));
update site_aggregates
set users_active_week = (select * from site_aggregates_activity('1 week'));
update site_aggregates
set users_active_month = (select * from site_aggregates_activity('1 month'));
update site_aggregates
set users_active_half_year = (select * from site_aggregates_activity('6 months'));
I’ve checked Reddit a few times the past few days and I’ve started to notice how many comments are the same inside jokes over and over again. The hive mind really looks different when you’re on the outside.
You can actually type the math into DDG and it will do it for you. Just search for “1.2+5.6+10” (I’m not sure how DDG handles the comma versus period but I would expect that it would adapt to your location)