spark947
@spark947@lemm.ee
- Comment on New Junior Developers Can’t Actually Code. 2 weeks ago:
Yeah, I’m not even that down on using LLMs to search through and organize text that it was trained on. But in it’s current iteration? It’s fancy stack overflow, but stack overflow runs on like 6 servers. I’ll be setting up some LLM stuff self hosted to play around with it, but I’m not ditching my brain’s ability to write software any time soon.
- Comment on New Junior Developers Can’t Actually Code. 2 weeks ago:
What are you guys working on where chatgpt can figure it out? Honestly, I haven’t been able to get a scrap of working code beyond a trivial example out of that thing or any other LLM.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 weeks ago:
Another commentor pointed out a legitimate use case, but it’s not even worth thinking about that much. De-duplocated is usually a word you use in data science to talk aboutakong sure your dataset is “hygienic” and that you aren’t duplicating data points. A database is much different because it is less about representing data, and more about storing it in a way that allows you to perform transactions at scale - retrieval, storage, modification, etc. Relational databases are analyzed in terms of data cardinality which essentially describes tradeoffs in representation between speed of retrieval (duplications good) vs storage efficiency (duplications bad).
The issue is that Elon is so vague and so off the mark that it is very hard to believe that he even has the first clue about what he is a talking about. Even you are confused just by reading it. It is all a tactic to convince others that he is smarter than he is while doing extreme damage to the hardworking people that actually make this stuff possible. Have you noticed that the man has never come to a conclusion that wasn’t in his interests? This is not honest intellectualism, or discussion based on technical merit. It’s self serving propaganda.
- Comment on Open Source Software and Corporate Influence. 3 weeks ago:
No I agree, that’s what I’m trying to say. Open source is the only way to create better software, but the software we have is pretty good. Better software won’t cure what ails us.
- Comment on Open Source Software and Corporate Influence. 3 weeks ago:
It’s a useless discussion open source is as good as to is gonna get technology wise. Their will always be a problem as long as profitable anterprise is what people rely on to make a living and feed their families. Fixing that requires more than open source software.
- Comment on AI is Stifling Tech Adoption. 3 weeks ago:
Honestly, might be a good thing kinda. Adoption in the front end world is out of control.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 weeks ago:
As someone explained in another comment, you often duplicate information due to rules around cardinality to gain improvements in retrieval an. structure. I would be pretty worried if SSSNs were being used as a a widepread primary key in any set of tables - those should generally be UUIDs that can be optimized for gashing while avoiding collisions.
Even if we are being generous to Elon, we could assume that social security payments are processed on mainframes given how many have to go out and the legacy nature of the program. Most mainframe shops I know have adapted an SQL interface for records in some capacity, but who knows what he is looking at.
Government federal IT is done at a per agency basis. I would say oracle database is pretty much the most licensed piece of software the government does use outside of Redhat Linux and windows desktop.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 weeks ago:
It really is baffling trying to make sense of what he is saying. It’s like the only explanation that makes any sense at all is that he has no idea what he is talking about. Even if he knew just cursory knowledge about database cardinality you wouldn’t say stuff so stupid.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 weeks ago:
Excel is accounting workbook software, it is not suitable for data storage. Although people certainly use it that way.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 weeks ago:
It’s an insanely idiotic thing to say. Federal government IT is myriad, and done at a per agency level. Any relational database system, which the federal government uses plenty of, uses SQL in one way or another. Elon doesn’t know what he is talking about at all, and is being an ultimate idiot about this. Even in the context of mainframe projects thatif we are giving elong the benefit of doubt about referring to, most COBOL shoprbibknow have adapted to addressing internal data records using an SQL interface, although obviously in that legacy world it is insanely fractured and arcane.
- Comment on US can’t ban TikTok for security reasons while ignoring Temu, other apps, TikTok argues 5 months ago:
Ban them too.
- Comment on Amazon cloud boss echoes NVIDIA CEO on coding being dead in the water: "If you go forward 24 months from now, it's possible that most developers are not coding" 6 months ago:
The real work of software engineering isn’t the coding. That is like saying that being a doctor is all about reading health charts. Planning, designing, testing and maintaining software is the hard part, and it is often much more political than it is a technical challenge. I’m not worried about getting replaced by AI. In fact, LLMs ability to generate high volumes of code only makes the skills to understand it to be more in demand.
- Comment on Threads? 1 year ago:
What are you talking about? I can’t find anything to back this up, but I am curious. Their about page claims they are funded by patreon donations, and doesn’t mention cloudflare anywhere.
Is it just that they use cloudflare services for traffic control, or they host on cloudflare? Especially if it is the former, that is pretty inane.
- Comment on Google announces April 2024 shutdown date for Google Podcasts 1 year ago:
Antenna pod is great. I switched to it from google podcasts a couple months ago figuring this would happen.
- Comment on Access home server from anywhere 1 year ago:
My advice: only forward ports 8080 and 443, then make sure that you have fail2ban or crossed properly set up on your reverse proxy. After that, you are pretty much fine as long as you keep on top of updating your containers.
I would be careful about which apps you proxy. Idk why you need to access the admin portal for pi hole worldwide. If you really want to do that, you should set up a vpn.
- Comment on Programmer tries to explain binary search to the police 1 year ago:
Yeah, in general, but not necessarily in that circumstance. A lot of time talking to tech people (I’m a softwar engineer) they can can be smug about this while leaving out important context.
- Comment on Programmer tries to explain binary search to the police 1 year ago:
Yeah, seriously. What is even the context of this? We have no idea. The cops might have been like “We need a warrant to look at that footage you idiot.”
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
Yeah, it will be interesting to see how the case goes.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
They usually sign an exclusivity deal in exchange for funding the development of the game. David is alleging that steam pressured him in ways not covered by steam ToS. It’s not like valve funded development of receiver.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
So what? Who cares if it “looks bad”? They have to compete on service. They need to find out why devs want to sell on steam at a higher price.
If other platforms want to compete in ways that make prices lower for customers lower for customers, so be it.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
Yeah, it sucks when mommy and daddy fight.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
That us all fine. David is alleging that Valve is trying to restrict other platforms wolfire can sell their cases on. Valve needs to compete, not threaten to stop distributing a game if they don’t like how it is selling elsewhere.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
Steam runs weekly deals and daily sales all the time. I doubt they have to check with gog.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
What right does valve have to discriminate against devs and publishers who are selling their game on other platforms? They have to compete for their business, not punish them for having a game that is more successful on another store that gives a higher revenue cut to the dev and a lower price to the customer.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
David said in a blog post that the suit is specifically alleging price fixing tactics for other platforms that aren’t key sellers, but sell the whole game. Whether that holds up in court - we will see.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
That hasn’t been my experience, could be a regional pricing thing.
- Comment on Court rules Gabe Newell must appear in person to testify in Steam anti-trust lawsuit 1 year ago:
David Rosen of Wolfire Games (Receiver, Overgrowth, Lugaru) is alleging that steam reps have threatened to de-list his game if he lists it as less expensive on other platforms. Specifically not just steam keys but other distribution platforms.
- Comment on Google CEO Sundar Pichai Warns Android Users Not to Sideload Apps 1 year ago:
Yeah, this is what I’m talking about.
- Comment on Google CEO Sundar Pichai Warns Android Users Not to Sideload Apps 1 year ago:
So they argue that they want to protect users… from epic games? Like they are going to make a virus filled app? I kinda agree people need to be protected from fortnite, but its kind if a silly disingenuous argument.
- Comment on Industrial robot crushes man to death in South Korean distribution centre 1 year ago:
Various parts of the US too, especially in distribution centers. It got a bit bad out there.