ptah

u/ptah@lemmy.world
0 posts · 9 comments

Recent posts

No posts.

Recent comments

on Good job man 👍 · c/memes · 4 pts · 2y

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.

I had this problem with my last car and I’m certainly going to explain it poorly but here goes.

There’s a vent or pipe of sorts in or around where the fuel goes into your car and if it gets clogged vapors build up and cause the shutoff mechanism in the handle to trigger prematurely. Cleaning it out can help.

But I also just came across this saying it’s probably the pumps fault. So it’s probably best to disregard everything I’ve said. https://jalopnik.com/you-may-want-to-avoid-yosemite-national-park-right-now-1850592362

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.

on Lemmy growth curve · c/general · 2 pts · 3y

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'));

on Lemmy growth curve · c/general · 14 pts · 3y

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.

Adding to this for clarity as I just tried this out: When you use the community search you do in fact need the whole URL --> "https://kbin.social/m/tech"

Additionally you can manually edit the URL by adding the magazine name to "https://lemmy.world/c/" So for "tech@kbin.social" the URL becomes --> "https://lemmy.world/c/tech@kbin.social"

From there you can subscribe. I've found that you need to hit the subscribe button twice and it will say "subscribe pending" but it will still show up in your subscribed feed.