HNHacker News
TopNewBestAskShowJobs

stoperaticless

290 karma · joined April 14, 2024

submissionscomments
stoperaticless··on PostgreSQL and UUID as Primary Key
- Plenty of use-cases want to generate it on application side, so they can just “insert”, instead of “insert+select the id”

- not everybody uses Postgre (either way, somebody will be left out)

stoperaticless··on PostgreSQL and UUID as Primary Key
Related pondering:

- UUIDv4 causes page fragmentation (ideally, on disk pages of data would be stored in sorted fashion; HDDs still exist)

- if in your app fresh records have more reads, having them close will help with read speed (being cpu cache friendly)

stoperaticless··on PostgreSQL and UUID as Primary Key
to illustrate point above:

Sequence that easy to guess, but will never collide until it wraps back to 1.

n1=1,n2=2,…

(Caveat: if generated only by single node/thread)

stoperaticless··on PostgreSQL and UUID as Primary Key
> The key leaking doesn’t seem like a realistic security issue.

But it is.

If you have a password in a system, you want to rotate it regularly or at least have that ability (for example, when angry colleague leaves).

stoperaticless··on PostgreSQL and UUID as Primary Key
Amen (or similar)
stoperaticless··on The Life Of Lithium
> Calling out long duration storage is another red flag. How much of that is needed? In giga watt hours please. Nobody ever bothers to qualify that.

That includes you. (No numbers just assumptions that all will be fine)

Worth noting that there is no “required” amount of kWh of storage, people can get used to blackouts and/or real time prices spikes and/or adjust habits (reduce usage).

Just to have some numbers:

1kWh of battery costs 139$

US uses 11,267 kWh/year/capita of electricity alone. Thats 30 kWh per day. So 1 day electricity storage costs 4000$/capita of investment.

Total energy consumption in US is 295 million BTU/capita/year, which is 236 kWh/capita/day.

To cover for one day of all energy, US needs 32000$/capita/person investment.

In current setting, Oil/Uranium/wood act as a kind of battery, and we are very used to having large “batteries”. (Some people prepare wood for couple of winters ahead)

https://en.m.wikipedia.org/wiki/Energy_in_the_United_States)

https://www.statista.com/statistics/883118/global-lithium-io...

https://en.m.wikipedia.org/wiki/Energy_in_the_United_States

stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
Have you cooked anything? Have you never ever had a hair fall into a pot your mixing? (Even if you always wear a hat, and always clean it before hand, there is non zero chance)

Spirit of that previous parent message was that “never ever contaminated” is not a realistic option.

Yes op stretched that to molecules, but exactly same argument applies to seeds.

I guess you forbid any kind of hyperbole in 50m radius.

stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
I foresee a business that produces “all allergen mix”, to be used as default ingredient in all baked products.
stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
Did I understand it correctly?

- Single meal will not kill you.

- Continuous use will shorten your life significantly.

(Something like smoking then?)

stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
What world do you foresee?

A world where sesame is banned from food industry?

If no (which I assume), then what is the proposal?

“No contaminants” does not seem realistic even in a cleanroom.

stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
That I feel is on the consumer as business just does a full disclosure.

The business discloses, what was added as ingredients, and what contamination is possible. (Because production line is shard or similar)

What more do you want?

I guess results of regular random testing could be put online.

Forbid using same knife to slice different things is another thing to be done.

stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
Not a straw man if you look at the spirit of the argument.
stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
I like sesame. Should sesame be banned world wide because 0-5% are allergic to it? (I assume: no)

Can company choose to produce sesame products? (I assume: yes)

Can company choose solely sesame products, without doing sesame-free stuff? (I assume: yes)

If new regulation comes along, and business deems new requirement is unacceptably high, can it pivot to a different market where it can reuse same investments? (I assume: yes)

Law can be flawed. (Because people definitely are)

Maybe it can be improved? E.g. require random testing, and then say there are 7 seeds in every 100000 of pies.

stoperaticless··on FDA warns top U.S. bakery not to claim foods contain allergens when they don't
How? Forbid sesame seeds for everybody?
stoperaticless··on Maker of RStudio launches new R and Python IDE
s/serious/hyped
stoperaticless··on Apple found in breach of EU competition rules
Not arguing with general point.

But I strongly doubt that your business model would even approach #1 spot on S&P index.

If you are looking for advice on your business model..

> Whipping homeless people

On avg. homeless people are less competent part of the bell curve. Don’t limit yourself, toss the “homeless” restriction.

You could reduce cost by mostly just threatening to whip, and to actually demonstrate the whipping only on Mondays, just to prove that it happens.

Also, micro-management has serious downsides. It does not build trust, it eats away at initiative and motivation.

stoperaticless··on Apple found in breach of EU competition rules
EU is not about “open for all”, but “open among members”.
stoperaticless··on Microsoft breached antitrust rules by bundling Teams and Office, EU says
Tradition is more serious than you think.

Being around for a long time is a quality of its own. It strongly implies familiarity and good enough fit for everybody. (Traditions compete in a sense, some do not survive)

stoperaticless··on Apple found in breach of EU competition rules
I don’t see the future, but argument for Apple could go like this:

- it is Apple vs EU

- US gov has guns and influence and various levers

- US gov will definitely protect Apple from guns of EU (so regulator with guns is a bit mute point)

- Apple is important to americans (I think they feel it’s their symbol or something), so officials in US gov might think it’s good opportunity to grab some political points.

- US gov might act to help out Apple in this dispute (Nothing like a war, but some slight nod or handshake; maybe via diplomatic backwater; maybe in exchange for something)

Though most probably apple will give “something” even if minor change in the rules, at least just so EU would not loose face, to keep relationship friendly. (But it will be move in the right direction)

stoperaticless··on Apple found in breach of EU competition rules
Fair or not, but it is very good business model. Smart people realised, that in open market profits will go to zero as competition increases.

Solution: create your own alternative to open market - be the market (and write rules for it)

Apple will do a lot to keep this cash cow at peak performance.

stoperaticless··on US prosecutors recommend Justice Department criminally charge Boeing
While my sense of justice would be tickled by executives in prison, it is probably not a required condition to improve Boring situation.
stoperaticless··on Rotation curves: still flat after a million light-years
I do. Just please don’t mention that to my wife.

Worth noting that recently (when couple of months is considered recent), she mentioned that she had falling out with MOND (due to some new study coming to ger attention).

stoperaticless··on Open Source Python ETL
Etl as text is good, because you can save it in version control. (Is it “code” or “json” is irrelevant for the vcs)

Edit: save in vcs stringly implies usability of ‘diff’ and ‘grep’

stoperaticless··on Open Source Python ETL
Gui Etl makes a promise that you dont need a programmer to wield it. But it is a false promise.

> They need scale, observability, modularity, and maintainability.

Seems orthogonal to code-vs-gui dimension.

stoperaticless··on Electricity prices in France turn negative as renewable energy floods the grid
I argue that the number of such industries is and will be low.

Usually clients want consistency in the output. (they depend on the product/service)

Business owner usually wants consistency in employee/machinery output. (They cost money)

To me it seems that only low priority computation (incl. con-coins) is such industry. (Investment kind of reused, and relatively few employees)

There will be some shift to adjust to intermitency (e.g. Worker hours might be shifted to the time when solar generates the most energy to take advantage of the price)

stoperaticless··on Electricity prices in France turn negative as renewable energy floods the grid
Name for it: https://en.m.wikipedia.org/wiki/Jevons_paradox
stoperaticless··on Are animals conscious? New research
But sadly they dont have theory of rope.
stoperaticless··on Are animals conscious? New research
I gather that there is no simple definition of concious, and it mostly is “same as humans”.
stoperaticless··on European Alternatives
Well, I don’t want anybody to get access to my emails.

I understand that if they would spend any effort they could easily get access (via breaking my phone or bones), but I don’t want to voluntarily send over my emails.

(Happy proton subbcriber; that would change if those allegations would appear true)

stoperaticless··on Start presentations on the second slide
So true.

Some people are just allergic to accepting advise from others.

(On the other hand best way to learn not to play with fire is to get burned)

← PreviousPage 5 of 7Next →