!coding@lemmygrad.ml
A community to discuss programming and or related topics
!coding
@lemmygrad.mlHi!
Let's say I have a questions system and the writers of questions always add at least one but maybe more clues for the question.
Would it be better design to have each question have its own table for clues, even though the vast majority of the time the questions only have 1 clue? (ie is it inefficient to create like a zillion tables for a database?) Or would it be better to have a "clues" table, where each clue stores which question ID the clue applies to? (ie are later queries linear in time based on the amount of clues in the table which would be bad?)
Thanks for your help! And I'd appreciate motivations for the answers too so I will understand better.
I’ve tried using ChatGPT for some basic coding syntax/logic, and I’ve had mixed results. Usually not so great.
Wondering if it had access to the whole code base and could better understand the context of the code if it would be better.
What’s your experience been like?
I just can't find the words to describe how happy I was to receive so much feedback and understanding on your part, this community is truly wonderful <3
I'll work on some of your (legal) ideas in my spare time, which is not much but I work fast! So far I've designed a generalized edit distance function with some pretty cool properties that would make it useful for running an organization under non-friendly conditions:
$ cat message1.txt
Liberal anti-fascism is a reactionary idea. Anti-fascism is not practical without being anti-capitalist.
$ cat message2.txt
The anti-fascism of liberals is not a progressive idea. It is impractical with no anti-capitalism.
$ cat leak.txt
Liberals' anti-fascism is not useful without anti-capitalism, not a progressive idea.
$ ./trace.py leak.txt message*.txt
Delta | File name
----------------------
19 | message1.txt
8 | message2.txt
Predicted origin of 'leak.txt' is 'message2.txt'.
So far it works with any sufficiently long text I've thrown at it. Make two versions of any text, rewrite any of the two into a third file, and the algorithm will trace its origin. Also the math is pretty elegant!
For obvious reasons I won't be publishing any of it any time soon :) Maybe the RTC will advise me on what to do. Or maybe I'll just hoard a bunch of software like this. Anyway, thanks, I'll keep at it.
Imagine a forum where each post is piece of theory. Users can create and rate connections between posts. There are three types of connection: introductory, elaborative and contra.
How could one easily implement such a forum (as someone who knows nothing about web-dev)? Would lemmy work? All you'd need is three bot-generated pinned top-level comments under each post, one for each type of connection, then users submit connections in the form of links as replies to those top-level comments. Though it would be nice to be able to sort those replies by rating. Does Lemmy fulfill any/all of those requirements? Any other software that could fit the bill?
I have absolutely zero background or knowledge on coding/programming/IT/software/computing etc, but I've recently taken an interest in it. How much time, effort and resources would I need to sink into it in order to become at least borderline competent?
I'm a membership organiser with a community union and spend an inordinate amount of my time prepping excel spreadsheets with membership data. Is there anything out there I could use to split the entire data set into sheets with tables of, say, 20 members each, their contact details, plus boxes for whether or not they can attend this or that event?
I've been thinking about acquiring one of these for a while, because RISC-V sounds quite interesting, but I think I should ask about it here before I spend money on this stuff and the shipping...
First of all, how well does it run Linux? It appears that MangoPi uses their own distro, so I could imagine that a standard one wouldn't run... I don't know about the Sipeed chips. Did anyone here try?
Secondly, which specific model do you have? It's a little hard to get an overview of what's currently available (MangoPi and Sipeed are the only two that I know), I would appreciate a list or just the name of the one you have.
And, in general, what's it like? Does the shipping take long? What are you using it for?
Aside from the proverbial legal use of "linux ISOs", file sharing software is best known for the facilitation of digital piracy. I'm not gonna lie, as a third world person who grew up in the days of dial-up internet, before YouTube and legal music streaming were even concepts, my cultural horizons would have been much more narrow without P2P software growing up. Radio stations only played (and still play) whatever was popular at that moment, in that place; CDs were expensive, and stores didn't allow you to preview music before purchase other than a few high-charting albums; my family was poor and we were unable to afford video games, and so on.
Piracy via P2P software allowed me to get my hands on a vast amount of music, games, software and movies that I wouldn't have even known about without it. It shaped my life beyond belief, and that's just my personal experience with it. Legal streaming services wouldn't have appeared if the traditional business models of the entertainment industries hadn't collapsed due to P2P piracy. My cultural enrichment experience was certainly not the only one in the world, and there are quite a few popular musicians out there who credit music piracy for introducing them to tons of music they wouldn't have found otherwise.
That said, from a workers-centric Marxist perspective, the collapse of the music industry in particular only worsened material conditions for every musician and band that wasn't a superstar already, as they were no longer able to make a living off selling albums, since sales plummeted directly as a result of P2P file sharing becoming so popular. While the immediate adaptation of the music industry in the early 2000s (iTunes) did try to get on with the times and offer the purchase of individual songs for 99 cents and albums for $9.99 from the comfort of your computer, it did not end piracy, and only the arrival of the streaming model managed to do that.
The streaming model, however, has devalued music more than ever before in history:
On the other hand, listeners love the fact that for only $10 a month they can instantly enjoy all the music they can listen to, legally. But aside from the streaming services themselves, only huge artists benefit from this deal. All in all, this represents an absolute worsening of material conditions for the vast majority of artists.
There's this essay here that explains the reasons way better than I can (tl;dr it's the capitalists' fault, both the streaming services and big record labels): https://medium.com/@michaelcbrook/this-is-why-spotify-pays-so-little-how-to-fix-it-1e0c0e1ef860
Now, my questions are: did this devaluing of music really begin with P2P file sharing, and did it directly lead to today's terrible conditions for artists, or is it only capitalism's fault for "locking in" that devaluation by offering unlimited music to customers for the price of a single album a month with a model that benefits the biggest labels over the actual artists? (my personal opinion is that this could be overcome with a different royalty model, as the one proposed with services such as resonate.coop)
But most importantly:
Has the revolutionary potential for P2P file sharing been exhausted as of 2022?
Is piracy still revolutionary? Was it ever?
What is revolutionary software now?
I know I'm focusing on music in this post, since as a musician, that's the field I have the most first-hand experience on, but I'd like to know if the P2P file sharing phenomenon had a similar effect on other industries. Let me know guys if you have any experience on that.
For anyone that doesn't know, rustlings is a "project [which] contains small exercises to get you used to reading and writing Rust code. This includes reading and responding to compiler messages!"
I'm going to help someone with learning Python. After we go through Automate The Boring Stuff With Python, I was hoping we could work through something similar to rustlings, as it's really an incredible set of exercises that helped me immensely.
If there isn't, I might look into creating something similar that follows along with Python 3 tutorial, as that covers a good chunk of the language and would also expect a basic grasp of Python and programming concepts.
https://drewdevault.com/2022/05/25/Google-has-been-DDoSing-sourcehut.html