• 0 Posts
  • 36 Comments
Joined 2 years ago
cake
Cake day: May 2nd, 2023

help-circle







  • The way I perceive PRQL is somewhat like SQLAlchemy-Core (the SQL expression layer, not the ORM). Almost a 1:1 mapping to SQL but softening the rough edges in SQL when constructing more complex queries dynamically, in particular: no function calls, no real variables, only string concatenation. While SQLAlchemy-Core lets you even extract sub-queries into variables, I don’t know about how powerful PRQL is in this regard.

    From what I see from the docs I’m rather hopeful though.









  • In order to compete in user experience we need to up our game. We need to set up communities which collect, categorize and funnel user requests upstream. These features should be focused on:

    • reducing frictions like unclear UI, broken links, etc.
    • improving usability of the various web frontends (the one from Lemmy, kbin, etc.)
    • collecting bug reports and making sure they will be fixed

    This is meant to be a proxy between average users and tech enthusiasts who know how to do pull requests or open GitHub issues. Moderators of these communities would do it for them. This would enable us to gain visibility in the needs of the users.

    This is only a part of what needs to be done, but I think this can be done quickly.




  • The audience is not the problem. Meta’s mere presence on the network will be. We are now at a critical point in the struggle to survive as a network, and it’s not looking good.

    If we continue like today, the network effect (Google it) would eventually lead to ActivityPub being the de facto too-big-to-fail standard in all of the web. We aren’t there yet, though. Meta knows this too and doesn’t want it to happen, because extracting value from a diverse network is way harder than from a centralized user base. The fact that they even want to federate in the first place (shouldn’t be in their interest!) rings alarm bells.


  • Burn me once, shame on you. Burn me twice, shame on me. Big corporations want mainly one thing: gobble up as much value exclusively to themselves. They will take whatever means necessary to get there. The strategies to privatize public resources (XMPP, ActivityPub, etc.) are known. They look great for the public on the outside, but over the years will erode the value for everybody BUT them. In order to not let it get as far, many (including me) are of the conviction to not even give them a finger, let alone the whole hand.