HackerTrans
TopNewTrendsCommentsPastAskShowJobs

daxvena

no profile record

comments

daxvena
·2년 전·discuss
I doubt it's going to go the same way as search. You can't run Google on consumer hardware, but you can run LLMs locally.

At worse, newer models will get worse and you can just stick to older models.

You could also argue that proprietary models gated by an API are better than anything you can run locally, and yeah maybe those will get worse with time.

They're not going to get any worse than what you can run locally though. If they do, open models will overtake them, and then we'd be in a better position overall.
daxvena
·3년 전·discuss
I feel like I gamed this somehow. Instead of looking for serial killers, I looked for anyone who didn't look like a programming language inventor and got 10/10.
daxvena
·3년 전·discuss
I think you're missing what they're trying to say. You can still select what you actually need in a different order, but changing the order gives more immediate feedback from autocomplete. The order has pretty much zero impact on the performance of a query. A parser would still have to read out the whole query, and it's not expensive to unravel into a more efficient implementation if it would really help.

The problem is that SQL forces you to think about what to select before you even say where you're selecting from. There's nothing a client can do to recommend columns if it doesn't know where you're selecting from. It's pretty cumbersome to have to SELECT * FROM x and then go back and erase the * to actually get auto-completions.

It basically forces you to tell it what you want before you even know what the options are.
daxvena
·3년 전·discuss
Umm because medicine is supposed to be about helping other people? Why would people spend billions of dollars trying to help others work through a natural disaster?

To me that's one of the worst things about modern pharmaceutical companies, they care more about making money than actually helping people.