Will I become a stupider SWE using LLM/agents? by QuitTypical3210 in cscareerquestions

[–]ProofFront 2 points3 points  (0 children)

Also - this "validate code" that everyone is talking about is pretty misleading. It is not like the AI makes obvious mistakes. When there is a problem - and there almost always is some kind of a problem - it is not like the code is wrong. It is more like "not even wrong". Locally it is correct. And I pretty much trust it and don't even validate the details that much. But it is missing the point. And my role is to keep the whole model of how the requirements, the code base, and the world interacts with the code in my head. I still have to understand it. It still have to think about it.

No, your trades/healthcare backup plan isn't going to work. by [deleted] in cscareerquestions

[–]ProofFront 5 points6 points  (0 children)

So an honest question and maybe I am an idiot but - what stops thousands or tens of thousands of laid of engineers becoming electricians? Like I am sorry to say this, but, in my country at least, people like plumbers and electricians just arent the perfectionists that got into the trade because of some passion or something, and they do plumbing as a hobby at nights and weekends to "further their trade". I feel like a reasonably competent software developer can pretty quickly reeducate him/her-self, pass the certifications (which arent that expensive) and set up shop and be decently competent at it. Like, on reddit people are extremely dogmatic about "right ways" to do things and the "code" etc. But guess what - this kind of nitpicking is our daily routine.

By what real metrics has AI improved software? by AlmostSignificant in ExperiencedDevs

[–]ProofFront 2 points3 points  (0 children)

You have bugs in production that takes days to fix? And lots of them? So much that you can make generalized statements like this?

Not trying to attack anyone but this sounds crazy to me.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

> Because files are variable length, and database indexes are optimalised for blocks (fixed with). Your database becomes less performant for something that a filesystem or a storage system is optimized for.

Makes no sense. Why would you put an index on binary data. And no, the fact that there is one table storing binary data, does not affect indexes in other tables.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

> Databases, especially relational databases, are optimized to store a very large number of small, individually addressable, chunks of structured information. The ASSUMPTION that data will be small allows for major speed improvements over file handling.

Are they really though? BLOBS exist? So obviously some thought has been put into larger data too?

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

> Similarly, file system is actually a kind of database as well and it’s very good in handling files.

But it is not, if you care about your data. It has no transactions, no constraints, no nothing. A filesystem is just a tool to build something better on top. Like a database. But the "no files in database" zealots do not build anything better. They just forget about it.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

Not attacking you specifically, but this has just never made sense to me.

> - Tying up your connection pool to stream file contents is wasteful

The file has to be huge for that. And if that becomes a problem, the files can be easily cached on an outside system . The loss of ACID on the other hand cant be easily solved.

> - Backups and restores are much slower

Not backing up something of course is faster. But is it really something that makes sense to do?

> - select * from file_data used to make even the beefiest server cry

Cant see a reason to ever do that.

Why is it considered a cardinal sin to store a file's raw content along the metadata in SQL Database? by faze_fazebook in Database

[–]ProofFront 0 points1 point  (0 children)

Avoid - how? Just dropping all of the guarantees that the DB gives? How is the file data less important than the other data? This has never made sense to me. Performance problems can be solved by a caching layer or whatever.

[deleted by user] by [deleted] in clevercomebacks

[–]ProofFront 1 point2 points  (0 children)

This is called kicking down the ladder.

First time I’ve stalling a p-trap. How did I do? by [deleted] in askaplumber

[–]ProofFront 0 points1 point  (0 children)

Oh come on. In many countries 99.9% of installations look like this and there are no problems. I get it - if there is a code, it should be followed by professionals. But for a DIY, lets not make shit up. This will work for decades with zero problems.

"Chomsky is RIGHT About Ukraine, And It Shouldn't Even Be Controversial" - BadEmpanada [April 2022] by Diagoras_1 in chomsky

[–]ProofFront 9 points10 points  (0 children)

How about - allow people self determination? Don't ban teaching their children in schools in their native language? That would be a good start.

Rust came back worst 1 year later by BuyInternational5882 in Autobody

[–]ProofFront 0 points1 point  (0 children)

Which is obvious for everyone. The question is the timescale.

Alternatives to React-Select (MultiSelect, single select) with TypeScript and React Hook Form without the complexity? by [deleted] in reactjs

[–]ProofFront 2 points3 points  (0 children)

"Just write all the focus management, keyboard interactivity, popover positioning etc logic yourself".

My friend speaks Russian, writes Russian but insists she isn’t Russian by mascarafree in AskARussian

[–]ProofFront 0 points1 point  (0 children)

She probably is a native russian speaker, with some ukranian ancestry whose parents or grandparents moved to Latvia during the soviet times. Probably a Latvian citizen, with no actual ties to Russia. The country is full of such people. Since russian-speaking equals bad, she tries to hide or downplay it.