• 0 Posts
  • 19 Comments
Joined 1 year 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.


  • First I thought you were writing incoherently, but now I understand your point.

    I agree with what you said, that our “art” is most likely just something akin to bird song. Maybe even less or something else entirely.

    My point of view: Birds also have a “rebellious phase” where their songs differ from the songs of the general population. They are experimenting with new and unorthodox songs. These go away after they come of age and have to find a mate. My hypothesis (well, I’m no bird) is that there is a lot of emotional impact in these bird songs, whereas in some songs humans produce, much which previously required emotional awareness or emotional connection is now being replaced by templates, methods and formulas to make music. It’s some sort of depersonalization or objectification of the process of making music. This is probably what you meant by “it isn’t art anymore”.

    Did I get right, what you were trying to convey?










  • Each instance is free to field their own donation drives for their running cost. They even can display advertisements if they feel like it. There is no “one size fits all” here, and there shouldn’t.

    Each instance is potentially in a different jurisdiction, making it hard to transfer money, etc.

    Not only that, but I think having funds centrally collected and then distributed is a particularly bad idea. It comes with too much opportunities for bad blood. Money and friendship don’t mix.

    The only unifying constant of the network is the software that runs it. This though needs to be improved in various areas, for which centrally collected funds would be ideal, as every instance will benefit from it. No operator of any instance would have a disadvantage from advertising the central donation drive. They would benefit from it by having better software in the end.