ptah

joined 1 year ago
[–] ptah 4 points 4 months ago

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)

[–] ptah 11 points 8 months ago

https://lemmy.world/pictrs/image/71e493a4-b4cc-4300-b2f7-c287a0e5ac06.jpeg No clue where it came from. I’ve been using this for about four years now.

[–] ptah 4 points 8 months ago* (last edited 8 months ago)

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.

[–] ptah 2 points 1 year ago

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

[–] ptah 3 points 1 year ago (1 children)

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.

[–] ptah 2 points 1 year ago

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

[–] ptah 14 points 1 year ago (1 children)

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.

[–] ptah 4 points 1 year ago* (last edited 1 year ago)

Approx 23.5

Edit: This sent me down a rabbit hole and apparently it changes. Currently the tilt is approx 23.44 and it's decreasing by 46.8 arcseconds per century.

[–] ptah 7 points 1 year ago

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 "[email protected]" the URL becomes --> "https://lemmy.world/c/[email protected]"

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.