• 1 Post
  • 7 Comments
Joined 1 year ago
cake
Cake day: June 6th, 2023

help-circle
  • For #3, as far as the instance lists and the Lemmy Community Browser are concerned, I believe a 301 redirect should work as long as it redirects with the URI. e.g. old.lemmy.tld/c/Hangout -> new.lemmy.tld/c/Hangout . Eventually my new instance will be picked up by those, but I’m still not sure if/when my old instance would drop off (see question #1)

    That would allow anyone clicking into my old instance from any of the currently published instance lists to land on the new domain. But I’m not sure how currently federated instances would handle that.





  • PTZ@lemmy.ptznetwork.orgtoLemmy Support@lemmy.mlUser list?
    link
    fedilink
    English
    arrow-up
    2
    ·
    edit-2
    1 year ago

    To expand on that, I do a join between the local_user and person tables so I can grab the name and display names for the local users:

    select 
      p.name, 
      p.display_name, 
      a.person_id, 
      a.email, 
      a.email_verified, 
      a.accepted_application 
    from 
      local_user a, 
      person p 
    where 
      a.person_id = p.id;