HNHacker News
TopNewBestAskShowJobs

prosqlinjector

27 karma · joined September 27, 2023

submissionscomments
prosqlinjector··on Ask HN: Any felons successfully found IT work post-release?
The elephant in the room is legal liability. If something happens with a criminal employee then the question is raised "what precautions did you take from letting this dangerous person into your workplace".
prosqlinjector··on Writing books remains a tough way to make a living
> This is where institutions like universities, governments, etc. come in.

Science was doing pretty well before it became institutionalized in the early 20th century. It's not without tradeoffs, but these aren't essential components.

prosqlinjector··on Writing books remains a tough way to make a living
Of course rare books are valuable. The point is that if you want to buy a physical book you probably will pay $10-15 more for the nice version. The market for the cheap entry is smaller.
prosqlinjector··on Writing books remains a tough way to make a living
Your value to your company is also not a linear function of your time there. There are high fixed costs to training, liability, insurance, etc. They are paying you to always be available, etc.

With that said, I think it's very possible to find a much more easier development job with a lower salary. You should be able to meet performance expectations in very little time.

prosqlinjector··on 50 Algorithms Every Programmer Should Know (Second Edition)
You actually don't need any of that stuff, you can just write .js files and run them in node. The node.js standard library is quite extensive.
prosqlinjector··on Ousted propaganda scholar accuses Harvard of bowing to Meta
Would you be persuaded by more examples of headlines using this technique?
prosqlinjector··on Ousted propaganda scholar accuses Harvard of bowing to Meta
The individual is using the same reasoning as the headline. They weren't getting the fund they wanted and noticed there was a donation recently. They are speculating that that's the cause of their lack of organization support.

"whistleblower" is a journalism word meant to imply who the good guy is and endow them with credibility. Rewriting the story with "employee files complaint" doesn't hit the same.

prosqlinjector··on Ousted propaganda scholar accuses Harvard of bowing to Meta
Either make it clear you are speculating about two events being connected, or get evidence that links them.
prosqlinjector··on Wikidata, with 12B facts, can ground LLMs to improve their factuality
We can do polynomial regression of data sets that looks equally plausible, but it's not real data.
prosqlinjector··on Wikidata, with 12B facts, can ground LLMs to improve their factuality
Curating and presenting facts is a form of narrative and is not at all objective.
prosqlinjector··on Wikidata, with 12B facts, can ground LLMs to improve their factuality
The sky is not one color and changes color depending on weather, sun, and global location.
prosqlinjector··on Home schooling's rise from fringe to fastest-growing form of education
> but if you watch how they act, how they vote, and how they discriminate it could not be farther from the truth.

This is a low quality and bigoted comment.

prosqlinjector··on Google Brain founder says big tech is lying about AI danger
"wow our software is so powerful, it's going to take over the world!"
prosqlinjector··on LA County's guaranteed income program to give some foster youth $1k per month
It was your idea. He suggested it was a universal temptation, you suggested it was a personal problem. If it's personal, there is a community of people with that same problem.
prosqlinjector··on LA County's guaranteed income program to give some foster youth $1k per month
> because you personally couldn't handle a tiny bit of welfare.

If there was a segment of the population who "couldn't handle" welfare, where do you think we would find them?

prosqlinjector··on The real engine behind "AI" is the bad tech economy
> What would a "good" tech economy look like?

Producing goods and services that real people buy and benefit from.

prosqlinjector··on The real engine behind "AI" is the bad tech economy
> women are less likely to die in childbirth

This one has been debunked many times. US healthcare attempts riskier births that would otherwise be aborted.

prosqlinjector··on Advice for Prospective PhD Students
I chose mine because he was a reasonably guy to work with and talk to. What I did not know at the time was that he was very junior in the department and needed to please other professors. So even though I liked working with him, I was quite helpless at certain difficult parts of the process.
prosqlinjector··on Safety vs. Performance. A case study of C, C++ and Rust sort implementations
Yep, so now your sort function isn't just a sort. It's a sort with a unit test at the beginning. This burden is placed on EVERY use.
prosqlinjector··on Safety vs. Performance. A case study of C, C++ and Rust sort implementations
> If I'm reading the article correctly, the user can be informed at runtime with little to no performance impact.

It's not possible to verify a function is a strict weak ordering without enumerating the entire domain.

prosqlinjector··on Safety vs. Performance. A case study of C, C++ and Rust sort implementations
Agreed. And I think that's a good idea to do. It's still possible to do wrong.
prosqlinjector··on Safety vs. Performance. A case study of C, C++ and Rust sort implementations
> that argues it's the users responsibility to be careful,

If you try to sort with a function that's not a valid comparison operator, I don't know what to tell you. What should it do?

Semantics cannot be validated at compile time. The best that can be done is to annotate the function as "yes this should have the right semantics" as is done in Rust and C++ concepts, but that's still not a guarantee.

prosqlinjector··on Safety vs. Performance. A case study of C, C++ and Rust sort implementations
Currently employed writing new C++ btw.
prosqlinjector··on Return to Office Is Bullshit and Everyone Knows It
Nope, I'm saying that people advertised that the lockdown allowed them to work less.
prosqlinjector··on Return to Office Is Bullshit and Everyone Knows It
Everyone was posting on twitter about all the "projects" and video games they were working on during the lock down, despite supposedly still having full-time remote jobs.

They also had time to move all across the country.

prosqlinjector··on The most copied StackOverflow snippet of all time is flawed (2019)
This is nonsensical. When you use a function, how do you know what it will do? You guess from its name?

> auditing it is awful.

If a function specifies a requirement, you look at the callers and see if that requirement is met. If it's easy to verify in code, you can assert. Is there an easier way to audit correctness?

prosqlinjector··on The most copied StackOverflow snippet of all time is flawed (2019)
> That kind of reasoning only works if the language or ecosystem has some kind of compile time error or linter or comprehensive testing that will catch the error if the preconditions ever change.

Most requirements can't be verified at compile time, or even at runtime in a feasible amount of time.

If you expect functions to do things that they don't say they do, I don't know what to tell you. Conventions and specs are the best we have.

prosqlinjector··on The most copied StackOverflow snippet of all time is flawed (2019)
The only principle I want to defend is that a function is correct relative to its preconditions. If the caller doesn't meet them, that's on them.
prosqlinjector··on The most copied StackOverflow snippet of all time is flawed (2019)
I think I agree with your coworkers. If the data is predefined constants, then you don't need to worry about injection. All functions have preconditions which must be met for them to work. As long as that's specified, that's acceptable.

Imagine the internals of a database. An outer layer verifies some data is safe, and then all other functions assume it's safe.

The example you're sharing is a bit of straw man. It's just as easy to use the parameter, so of course that's the right thing. But interpolating a table name into the string from a constant isn't wrong.