• 0 Posts
  • 22 Comments
Joined 1 year ago
cake
Cake day: June 24th, 2023

help-circle






  • You should read this. https://erinkissane.com/untangling-threads

    By federating your instance to Threads, you are providing more content to Meta for them to place ads next to, supporting a network that allows abuse orgs like Libs of TikTok with limited moderation.

    Consider this scenario: LoT sees a post you made on Lemmy. They select you as a random target of hate, as they did hundreds of people at the beginning of this year.

    Their followers start going after you, but you don’t know it because you block them. It turns to real life harassment.

    This is a real issue, one of many.




  • Do that in Javascript. Or HTML. Or CSS. Or by that logic is a web developer not a programmer? What about microcontroller programmers?

    I could easily write a full logic program in SQL where the API just feeds it data, which is the inverse of how you treat SQL. Admittedly that’s not as common, but it happens pretty frequently in areas of big data, like medical.

    I’ve hired Senior Software Engineers that were DBAs, and others that weren’t. They were a development team, all programmers in their own right.



  • This doesn’t make sense to me. SPs and functions are in every major database. If I wrote a bash script that runs like a program, and sounds like a program, did I program it? Script it?

    And lots of systems have nested logic in the DB, optimization often leads to that to reduce overhead. Unless you’re being lazy with an ORM like prisma that can’t even join properly.

    Getting high performing queries is just as difficult as any other programming language, and should be treated as such. Even Lemmy’s huge performance increases to .18ish came from big PG optimizations.