HNHacker News
TopNewBestAskShowJobs

earnestinger

213 karma · joined December 15, 2024

submissionscomments
earnestinger··on Mayo Clinic's secret weapon against AI hallucinations: Reverse RAG in action
It can be both. (Ignorant not as “idiots”, but as not experts and proponents of this particular niche)
earnestinger··on JesseSort: A novel sorting algorithm that is faster than Python's default sort.
Pdf mentions split rainbows
earnestinger··on Okta Bcrypt incident lessons for designing better APIs
Could you give an example of real KDF?
earnestinger··on He went to jail for stealing someone's identity, but it was his all along
Is this legal? Everything is done by the book?
earnestinger··on Recent results show that LLMs struggle with compositional tasks
While humans seek “profit”.

It is important that “profit”, comes in various forms, which exchange rates are problematic to calculate (or maybe there can’t be any): not hungry, not thirsty, tastes good, not cold, feel safe, feel excited, feel righteous, feel powerful, listen to music, watch a movie, get curious, satisfy curiosity, laugh, love, sex, rock n roll.

earnestinger··on Composable SQL
Actually some do, but…

- non standard sql

- not concise

- has limitations

- installing a function is a db migration

I had dreams. A lot of them. I still do some times.

“Normal language” functions accept/return: primitives, objects(, functions, types).

Sql functions could accept/return: scalars/primitives, a row, set of rows, a table (maybe set of tables or related rows), for aggregating functions need to group by some columns, sliding window functions need to keep track of the window.

Let’s add some kind of interfaces/traits and generics.

If we are extending current sql, then I’m certain there will be corners cases for various clauses sql clauses (select, from, on, where)

And all of that on top of basic sqls (sel/ins, checks, access controls, query execution planning)

Quite quickly c++ starts to look like an exercise in language minimalism.

earnestinger··on Composable SQL
> you dont need unit test if you table design is clean, because SQL operators are deterministic and are tested by the RDBMS vendor

Imagine well structured tables in 3rd normal form.

And then a view which joins 20 tables and creates a report with myriad of case/then expressions.

Many things can go wrong. (Wrong join conditions, duplicate rows, omitted rows, wrong formulas)

You might say that there should be no such logic in database and I understand the sentiment, but circumstances (e.g. performance) might say it’s needed.

earnestinger··on The Alpha Myth: How captive wolves led us astray
I think it was this one https://m.imdb.com/title/tt0705911/
earnestinger··on The Alpha Myth: How captive wolves led us astray
> Like every time I've seen somebody unironically refer to themself as an "your leader," it's always had that underlying connotation of "Respect Me!" And every time I've seen someone mocking somebody else for being an "my leader," it's because, well, that respect was clearly undeserved.

I think same sentiment persists when alpha->”your leader” replacement is made.

earnestinger··on The Alpha Myth: How captive wolves led us astray
Dominance != aggression

(South park had interesting episode on that)

earnestinger··on The Alpha Myth: How captive wolves led us astray
> if you are defining alpha to mean "leader"

Could you elaborate what is the meaning of “alpha”? (I sense there is definition, that is being kept secret from me)

earnestinger··on Composable SQL
prior art:

https://research.google/pubs/sql-has-problems-we-can-fix-the...

https://www.scattered-thoughts.net/writing/against-sql/ - talks about compositionality

https://www.edgedb.com/blog/we-can-do-better-than-sql (2019)

(List taken from https://lobste.rs/s/vmyk7d/composable_sql#c_layb8n)

earnestinger··on Composable SQL
Attempt at sql composability.
earnestinger··on PhysicsForums and the Dead Internet Theory
I don’t understand the problem with AI generated images.

(I very much would like any AI generated text to be marked as such, so I can set my trust accordingly)

earnestinger··on Ruff: Python linter and code formatter written in Rust
> it's also how progress is made

Introducing n+1 solution/ standard may be the necessary cost of making progress, but it is possible to incur that cost without gaining anything

(at the extreme, trolling is fun activity with net negative on bigger scale)

earnestinger··on Ruff: Python linter and code formatter written in Rust
Does formatting match black? (Unlikely, but one can dream of standard being established)
earnestinger··on Is the world becoming uninsurable?
Makes sense.

I was fixating on the opposition of goals in the car (if car doesn’t bend/deform, then death risk increases).

earnestinger··on Is the world becoming uninsurable?
Nice point. Still, in wast majority of cases, house keeps standing -> habitant survival chance goes up.

Cars being on the move, makes that distinction much much more relevant

earnestinger··on Replit CEO on AI breakthroughs: We don't care about professional coders anymore
Definitely more work untangling, reverse engineering, optimising things that worked, but eventually reached its Schwarzschild radius.
earnestinger··on Replit CEO on AI breakthroughs: We don't care about professional coders anymore
Chagpt, generate quote about history cycles and/or rhyme
earnestinger··on Replit CEO on AI breakthroughs: We don't care about professional coders anymore
> Instead, he says it’s time for non-coders to begin learning how to use AI tools

Seems reasonable that more people will be able to utilise programability of computers.

People who already created elaborate spreadsheet’s with formulas, now might start also using python/java/go for their benefit. (Eg. Accountant, might start helping with the accounting system maintenance)

earnestinger··on No Calls
If client pays for a link that’s part of a chain, and doesn’t want the chain broken, and still has profit, it means client can pay more, that link is worth more.
earnestinger··on TSMC begins producing 4-nanometer chips in Arizona
Well they made the fiirst step. They have the fab, other parts of industry may emerge with time
earnestinger··on FFmpeg by Example
Many loosely compatible (so, not compatible if we are strict..) implementations are a problem, but awareness and testing helps.

All in all, my life would be miserable if I would not have regexp available in grep/sed/editor/ide/java/python, their usefulness trump any such inconveniences.

earnestinger··on Debugging: Indispensable rules for finding even the most elusive problems (2004)
700 page manual can be produced in several ways.

- Scope of the library is massive

- very peculiar way of writing, with lot of impressively unnecessary description of minute detail, that the reader starts counting not only sheep but also breaths until the ultimate end before finishing a sentence. (I.e. Unnecessarily verbose)

- very extensive docs describing things from various angles including references, topic based how tos and such.

(I agree that the last one is the least likely, but there is always hope)

earnestinger··on FFmpeg by Example
Not sure about ffmpeg, but you should definitely try memorising regexp. Casual Search&replace that becomes possible is worth it.
earnestinger··on Why Skyscrapers Became Glass Boxes
I feel your pain (but in Celsius)
earnestinger··on Hotel booking sites overcharge Bay Area customers
Also, it needs to be framed properly. I propose to name it: value based pricing.

How much value does this room provide you? If you can pay 2x, then it implies value you get is also 2x.

Third degree price discrimination is not as catchy. https://www.investopedia.com/ask/answers/042415/what-are-dif...

earnestinger··on The Origins of Wokeness
So -a is more polite than -er?

Really?

I mean rap songs and movies have both, as far as I can tell they are used interchangeably.

Any chance the distinction existed long time ago and now it does not anymore? (Im not from US)

earnestinger··on Debugging: Indispensable rules for finding even the most elusive problems (2004)
> if the manual of a library you're using is 700 pages, you're probably using the wrong library.

Statement bordering on papyrophobia. (Seems that is a real phobia)

← PreviousPage 3 of 4Next →