You can write selects with many joins, as long they are regular and either add a column or reduce the result set. You have to write the joins explicitly though. Just shoving all of the restrictions into the where clause will definitely confuse everybody.
- 0 Posts
- 14 Comments
luckystarr@feddit.deto
Linux@lemmy.ml•Linux 6.6 To Better Protect Against The Illicit Behavior Of NVIDIA's Proprietary Driver
1·3 years agoThey don’t want you to see the “if benchmark_xyz { do less work }” blocks of code.
luckystarr@feddit.deto
Technology@beehaw.org•PRQL — a simple, powerful, pipelined SQL replacement
2·3 years agoThe 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.
luckystarr@feddit.deto
Linux@lemmy.ml•Jeff Geerling stops development for RedhatEnglish
01·3 years agoScenario:
- Sign up for RedHat account
- Acquire source code
- distribute source code
- RedHat cancels your account
- you still have the binaries (and are allowed to, they’re GPL)
- you want the source code again… but can’t. Account is closed.
Now you’re in a situation where you’re entitled to receive the source code, but can’t because they won’t let you.
If this will ever go to court, I suspect RedHat will pursue a “corner case” solution. A canceled account will probably have access to the source code from RedHat *up to that very cancel-date" and you’ll not get a new binary (from them). So it should be mostly legal for them to do so.
However, as long as no trademark of RedHat is violated, distributing individual RHEL binaries (not the full images, they contain trademarked assets) should be fine. So you could receive a binary through that route and be entitled to the source code for it, starting the whole process over again.
One could always fork it, though I like the name. I’m a LeGuin fan.
luckystarr@feddit.deto
Technology@beehaw.org•The music industry is waging war upon an AI server on DiscordEnglish
2·3 years agoFirst 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?
luckystarr@feddit.deto
Technology@beehaw.org•FediPact is an Organized Effort to Block Meta's ActivityPub PlatformEnglish
6·3 years agoAre you one? Over the years I’ve gotten quite paranoid on Reddit. Now, with LLMs, it’s even harder to spot them.
I’m not even sure if including a hashcash scheme into the software would actually help, because they are so targeted.
I feel like I’m back in the early 2000s, where it was so bad that “the brightest minds of the generation were spending their time writing spam filters”.
luckystarr@feddit.deto
Technology@beehaw.org•FediPact is an Organized Effort to Block Meta's ActivityPub PlatformEnglish
29·3 years agoOnce federated with Meta, not only “valid Meta users” would join the network, but also bots which would nudge the users, influencing the narrative.
luckystarr@feddit.deto
Technology@beehaw.org•Kev Quirk, one of the admins of Fosstodon (a Mastodon instance), destroys Meta in an email exchange.
7·3 years agoDo you have a link? I’d like to know that
sorrystory too.
luckystarr@feddit.deto
Technology@beehaw.org•Kev Quirk, one of the admins of Fosstodon (a Mastodon instance), destroys Meta in an email exchange.
1·3 years agoIt’s not cynicism if the other party has a track record of behaving in an anti-competitive manner. The Fediverse became a competitor once it showed non-negligible growth.
It’s not cynicism, it’s weariness.
luckystarr@feddit.deto
Technology@beehaw.org•Kev Quirk, one of the admins of Fosstodon (a Mastodon instance), destroys Meta in an email exchange.
4·3 years agoI like to think they see the rapid growth as an opportunity to grab some Reddit refugees. I’m not sure they see the Fediverse as a viable threat YET. They could hedge it though and try to snuff it out while they still can.
luckystarr@feddit.deto
Technology@beehaw.org•Kev Quirk, one of the admins of Fosstodon (a Mastodon instance), destroys Meta in an email exchange.
5·3 years agoTheir idea is likely to eventually present themselves as the “better part of the network” and make migrating to their servers very easy.
This must be prevented at all costs.
luckystarr@feddit.deto
Technology@beehaw.org•Kev Quirk, one of the admins of Fosstodon (a Mastodon instance), destroys Meta in an email exchange.English
6·3 years agoWe should bake it into the software (Lemmy, Kbin, Mastodon, etc.) as a first line of defense. If you want to federate, you’d have to fork the server first.

It does that for some decades already. The trick for dual booting was always to install Linux second. :/