Skip Navigation
InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)PT
ptah @lemmy.world
Posts 0
Comments 9
Good job man 👍
  • 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.

  • Why does the gas pump sometimes pump super slow?
  • 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

  • Don’t touch the giant snails. Florida’s latest animal problem, explained.
  • 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.

  • Lemmy growth curve
  • 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'));
    
    
  • Lemmy growth curve
  • 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.

  • How do I add Kbin communities?
  • 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.