skysight-inc/HackerNews huggingface dataset:
Yes, but the runway is a good deal shorter if you’re doing things as most dev teams without RDBMS knowledge do. The biggest three issues unfortunately build on each other:

Using JSON when you really should be properly normalizing your schema (or using a DB better suited for JSON).

Using UUIDs – especially UUIDv4 – for any indexed columns, especially as PKs.

Using Postgres for no actual reason other than it’s popular.

MySQL / InnoDB is a clustering index RDBMS, which can have massive performance improvements over others IFF you build your schema around it. If you use anything non-k-sortable (e.g. UUIDv4) as your PK, it suffers massive performance degradation instead. So you use Postgres instead, and think you’re immune. Wrong – its MVCC implementation means you’ll have approximately 7x read amplification for Visibility Map lookups under the same circumstances, and huge amounts of WAL bloat, which can also lead to increased network latency.

JSON[B] in Postgres is frequently TOASTed due to its size. The overhead from TOAST/DETOAST isn’t small, and you also have to deal with difficulties indexing the column, and you can’t as of yet do a partial update to a JSON column. MySQL can do partial updates, doesn’t have TOAST, and has better (still annoying) strategies for extracting scalars from them to be indexed as a quasi-sidecar lookup, but it lacks GIN/GiST index types.

I’ve personally ran a single MySQL instance with over 100K QPS, and it had the plenty of runway, and a ton of vertical scaling left. This was with very careful tuning, and a suboptimal schema. I’m sure it could go far higher if everything was done correctly from the start.
Microsoft Olive: an easy-to-use hardware-aware model optimization tool
I think the optimistic interpretation in 2024 is that the developer is using some Byzantine frontend framework they don't fully understand.
it's not me -- which is why i'm not nervous about talking about it on HN. I work in the non-profit sector and don't currently use Cloudflare. Just stories I've heard from others.

I'd guess that the cost of switching/cost compared to other alternatives/cost compared to business value/revenue, remained sustainable for the customer, who didn't want to deal with a switch.

In truth, this is kind of how "enterprise sales" has always worked? The salesperson trying to figure out the biggest price that won't lose the customer? But additionally having unclear terms and unclear length of contract (or really no contract locking in your terms/payment) is definitely in the vendor's favor...
Folks who complain about Javascript don't realise how close we were to having vbscript as the dominant web language
The only price I ever compare and look at is €/gram €/liter. For my cheese that would be 6-8€/kg
Yep, from #1 to bottom of the first page in 5 minutes...
It is a good article, good to have practical details of how this goes down... but really an international casino cant afford more than $250 a month?
Because they're with us everywhere and conveniently at hand most of the time. A traditional computer, even in laptop form, is comparatively bulky, unwieldy and inconvenient. Laptops don't fit into your pocket, they don't pull out for one handed use while you're waiting in line and they don't slip easily back in once the line starts moving again. To type in text, you need both hands free, and a relatively stable surface to place your laptop on.

Phones trade ease of use for ease of access. They allow people to be online and participating in an online discussion when and where a traditional computer would be prohibitive or inconvenient. And as a trade off those people aren't always able to do (or conveniently do) something they would do on those traditional computers. Most people most of the time seem to find that an acceptable tradeoff. And to be fair to those most people, I write far more than I copy and paste links so it's not unreasonable to find that tradeoff to be acceptable.
> From personal experience I know that 10TB per month is like 30k/year

Is this true? We are at 3TB and growing so I'm slightly concerned
We already have DDoS protection from our colo provider and it wasn't clearly advantageous to switch to Cloudflare. We were mainly interested in zero trust but I don't know what we're looking at as of now; we still use various VPNs which, while not exactly fashionable, do work for us.
Almost 4000 files. That's quite a collection. Is there a better mousetrap inside?
Extremely shoddy story. People back in the day (working in agriculture) had to perform tons of complex tasks. Obviously they were able to reason.

It's clearly only someone quite far removed from any kind of practical work who could become convinced people who don't immediately answer the expected answer to test questions have no ability to reason.
Show HN: Launched with Just $137 After a 60% Loss in Web3, Discover AI Tools Now
I was rushing to judgment until I heard this... pretty plausible.

In support of your theory particular is I don't think enterprise sales "ragequits" a conversation when the customer is mid-evaluation based simply on the idea that they are considering multiple options.

Why would they walk away at this point, let alone ban the customer.

From the write-up I bet CloudFlare had it as a "60% to close" in their CRM at this moment. It doesn't make sense for them to drop the ban hammer in this moment.

PS: explanation or not, this is deeply shady behaviour from CloudFlare. Just perhaps a little less so.
Do you have a suggestion to make that not possible? It doesn't seem fair to punish them so aggressively because that might happen. The "may" there isn't a statement of intent.
People of color are the majority of the world population, and you are just a poor racist.
When anything changes by an order of magnitude, you have to reassess all your assumptions for application spaces. This can have big impacts on how you decide to invest.
"We've been on the Cloudflare Business plan ($250/month) for years. They suddenly contacted us and asked us to either pay them $120k up front for one year of Enterprise within 24 hours or they would take down all of our domains."

I'm sure INWX is not going to do this (#alleggsinonebasket)

https://robindev.substack.com/p/cloudflare-took-down-our-web...
Just out overhead wires over the interstate and the trucks can charge/draw juice from the grid that way. Bus routes in many countries still use that (Seattle and SF for the states, probably some others, and of course trains in Europe and Asia.

Trains in the USA mostly use diesel turbines to generate electricity that is then used to move the train. You could do the same with a truck, although I don’t think it would pay off the same as it does in trains.
yeah we should have a language that was built in a day instead of a week. move fast.
Show HN: I Built an Integrated Voice Chat for League of Legends
Recently at work, a colleague mentioned how frustrating it is to play League of Legends in SoloQ (when you compete alone against solo players) without voice chat. Despite not having much personal experience with the game, I decided to tackle this issue.

After seeing numerous Reddit posts where players passionately discussed the need for voice chat in a game that relies heavily on strategy and team coordination, I understood the necessity for a custom voice chat implementation. These discussions had thousands of likes and comments, which further convinced me of this need.

But there is Discord, right? Yes, Discord is currently used by most players who want to chat. However, it lacks integration with the game; you are chatting with Discord profiles, not knowing the other users' champions in the game or their League names at the start. Additionally, people hesitate to expose their Discord profiles everywhere. Finally, we've all experienced issues with Discord room configurations being handled poorly by inexperienced people. For all these reasons, I believe the community needs a more integrated and straightforward voice chat app.

After receiving validation from Riot (League of Legends' firm), including a production API key and authorization to use Riot Sign On, and setting up my server, I'm excited to announce that the app is now live!

How does it work?

1. You log in with your League account on our app (https://leaguespeak.net).
2. We place you in your team's voice chat room.
3. When your teammates log in on our app, they are automatically placed in your team's room. (You can share our app's URL in the game chat to help them connect)

You can now voice chat with them, seeing their names and champions! All for free, of course.

I'm very interested about any feedback you could have on this project, on the website or on the concept !
The NIO car company sells cars with swappable batteries and has built battery swap stations in Netherlands, Germany, Denmark, Norway and Sweden. The swap action looks slow and very particular still to be honest, but there's probably good reasons behind it (including not wanting actuators on the car itself): https://www.youtube.com/watch?v=aBdQQxgxDrY
Again, the same argument can be made for the other side. Two things can be true at the same time; both Hamas and Israel do/did terrible things and its tiring that people defend one side no matter what.

Their [the Palestinans] story is they didn't have a choice once others violated it and they had to defend themselves, and they make a very strong case.
Obviously you find Christian countries in general (and in number, they are the largest faction in the UN general assembly) ... extremely opposed to any enforcement, because they blatantly violated international law again and again and again.

*There are overwhelmingly more Christian-majority countries as compared to Muslim-majority countries. Also non of the Muslim counties have veto power. If you make an argument please base it on facts: https://en.m.wikipedia.org/wiki/Christianity, https://en.m.wikipedia.org/wiki/United_Nations_Security_Coun...
I find PowerShell, the language, verbose and not very ergonomic. This ship has sailed, but I wish Microsoft had done something to make Windows automation a little closer to other platforms, so that it could benefit from the good software that exists on other platforms.

It seems that VBA will continue to exist as the programming front end for MS Office, which is unfortunate. They had announced Python support for Excel a while back and I wish it was better promoted as a viable VBA replacement.
Vancouver council to consider supporting 'pod hotels' in vacant office space
Does it get sent every round trip?
the conflict did not start with invasion
to be fair, i don't know how much different the chinese management is from a european certification system.

we were told to use specific software. and for sure that software is created by some company that may or may not be government owned. i don't know if there was any choice since, as is typical with foreigners, someone will just tell me their recommendation and not try to explain the differences between choices, unless they matter. ie: just go with the default.

i did have the impression that different regions use different software at least.

i expect that potentially in european countries there are multiple competitors for the same software, but i don't know that either.

so for all i know the amount of choice and control in china could be the same as some countries in europe.
I did mention the multiple-domains issue in the post. It would not have been amazing for us to remove our secondary domains, but we would have been very happy to do it if it had resolved the issue. We asked them again and again but they would not give us any detail or options apart from their 120k/year package. Note that BYOIP (which I guess they could reasonably have required to isolate us even if we only use a single domain) is available for a fraction of the cost elswhere (e.g. fastly).

Since we already left Cloudflare the only reason I finished writing this article is to warn others. I think it's still relevant to many companies regardless of what you think of casinos, since very unprofessional sales tactics (unprofessional as in business threatening) seem common place with them. Do look at the linked other posts and comments here from other people affected that don't have anything to do with casinos.

I'm happy to answer questions as well.
are you ignoring years of conflict before the invasion on purpose, to help your argument?
All identity politics, a sickness that has incurred an incredible debt that is beginning to come due.
China is propelling its electric truck market by embracing battery swapping.

In 2022, China sold 36,000 electric trucks, 91% of the global total..support for battery swapping is playing a key role.

With plug-in charging, it usually takes 40 minutes with DC fast charging or several hours via regular charging to recharge an electric truck. In contrast, battery swapping only takes 3–6 minutes.

https://theicct.org/china-is-propelling-its-electric-truck-m...
They don’t even necessarily need to be cheaper than all existing methods. They only need to be cheaper than (IMO inevitable) carbon tax penalties plus the cost of these bricks compared to current methods, which is a rapidly falling curve.
Charging an EV is straightforward if you have a home parking spot. However, "According to the 2017 American Housing Survey, 66% of all occupied housing units in the United States had a garage or carport."

For those living in big cities and relying on street parking, EVs are still less practical. I envision a service where you leave your car parked on the street and schedule a mobile charger through an app to come and charge it while you're away.
Sounds like the famous Oracle licensing team.
'Dyson sphere' megastructures could surround at least 7 stars in our galaxy
It seems disingenuous to compare a complex war with multiple participants and over more than 10 years with something as clearly one sided as rape
It works just fine. Existing servers, proxies, and middleboxes just pass through the response if they don't understand status 209. The braid.org site itself is running on Braid-HTTP, through a reverse proxy, and everything is peachy keen.

SSE doesn't work because it (1) doesn't support binary data, (2) assumes that versioning is linear (which doesn't work in a distributed system), and doesn't provide any way to add new headers to each response.

SSE also has an awkward encoding format, but that's neither here nor there.
I'll do you one better, use magnetic levitation so there's no friction at all. And build it in a vacuum pipe, so there's no air resistance either.

I wonder why nobody else has thought of that yet? Such a mystery.
Worth a try at least. Though based on the fan speed while I'm in meetings I reckon it might be more to do with missing hardware video acceleration in Firefox or something.
Thanks to the HPT chat, I graduated from the university with honors
I think its safe to say that whatever RenTec is doing, they are not predicting the market...Since they sold 1M shares of NVDA at $699....

https://hedgefollow.com/funds/Renaissance+Technologies/Perfo...

https://hedgefollow.com/funds/Renaissance+Technologies

When I see prestidigitator performance I can't explain, I just don't go directly to assume it's real magic...

Here are 20 funds with a cumulative performance better than RenTec for the last three years...Did they also crack the market?

https://hedgefollow.com/top-hedge-funds.php
What went wrong with federal student loans?
It is actually more likely it is the opposite, that it got temporarily boosted to get exposure, and then fell back as interest vaned. If mods want it gone, then it will be gone.
It's a bit presumptuous to state that the world is or isn't anything.
PowerShell is terrible. The idea is good, the implementation bad
I don't really get that; did you try to understand my current before commenting, like the HN guidelines suggest?

You seem to assume the worst and seem to be disregarding my opinion because of that
Using hash-of-validation-WASM as a state key is a really cool idea and I'm excited to see how it goes operationally.

Using (blinded) proof of donation as an anti-abuse signal is a clever band-aid but seems fraught in the long term. Is there a plan to switch off of it to something less centralized, or is it staying this way until it causes problems?
You forget to mention that the DDoS traffic causing these issues are also behind cloudflare, but they don't give a damn about them, for obvious business reasons.

Cloudflare controls supply and demand, which, by definition of the law, should be classified as extortion.
What you are missing here is that ChatGPT has no internal mental state, nor a hidden place where it register it’s thinking. The text it outputs is its thinking. So, the more it think before answering the better.

When you ask it to don’t add extra commentary you are in essence nerfing it.

Ask it to be more verbose before answering, think step by step, careful consider the implication, rest for some time and promise it a 200 dollar tip.

Those are some prompt proven to improve the answer.
At the moment the account got banned, I would guess that the CloudFlare sales team had this down as a "60% likely to close, estimated close in 6 weeks".

There is just no reason they would suspect that they were going to lose the deal to Fastly at this moment. They were very much the default winner.

Extortion or not, I just can't fathom that they ragequit the deal at this moment, because they were about to win it.

It therefore seems likely that after looking into it they disqualified it as a business category which is against their TOS or whatever.

Or that the enforcement and sales teams have very similar, overlapping triggers for engagement, etc.

Cloudflare's behaviour here was shitty and this is not the only report. By all means their reputation is very generous free tier and a horrible experience in paying.

BUT seriously who ragequits a winning deal? Another comment summed this up - the attention caused them to take a look and realize they don't support shady-ish casinos, possibly (seeming to) evade US legislation, etc.
Yes, that's the point of the quote, but the point of the poster you're replying to is that wasting half your budget would be considered gross incompetence in any other department.

"Half the lines of code I write are useless, I just don't know which half." - an incompetent coder

"Half the time I spend on the phone is wasted, I just don't know which half" - an incompetent salesperson

"Half of my menu is inedible, I just don't know which half" - an incompetent restauranteur
Yeah, I've heard it's hard/impossible to put together a cable to transfer that much energy; in that context ofc. It's substation-tier equipment.

Battery-swapping may be the way.
antora also is a promising thermal pv company - heat up some carbon blocks resistively when clean power supply exceeds demand, then convert back to elec during peak demand or outages via pv panels operating on IR. Hopping container form factor. interesting partnerships w NREL and other gov partners.

https://antoraenergy.com/
For three years? Is that a serious comparison?

And yeah, it’s not remotely surprising they’ve made trades like selling NVDA at $700. Judging a fish by its ability to fly etc. RenTech doesn’t work by picking stocks based on industrial trends or anything — as far as we know that sort of stuff is literally not even an input.
Ask HN: What's your advice for the first management hire at a startup?
Imagine the company has around 10 engineers, getting ready for Series A, with great growth and revenue metrics. What would you look for on that first manager? What would you avoid?

Any anecdotes from past experiences would be great!
Would not want to be anywhere near the first highway accident involving one of these.
I'm not sure what you mean. They used daily weather reports to decrypt the enigma for that day, so I'm not sure how that is an operational failure. If you know part of the cleartext, it's possible to brute-force any encryption given enough time.

https://www.accuweather.com/en/weather-news/how-british-cryp... gives a pretty decent summary.
All the instructions I gave it were entirely ignored so I gave up trying
There are some cultures/languages in which their word for what most English speakers use "heart" for (as in, source of emotion) is instead the same as their word for "stomach". I want to say this was in Papua New Guinea but I can't remember for sure.
A deep chill ran down my spine as I remember all of those VBA tools I updated/generated during my first internship... some of those are still being used in some semi-industrial applications.....
what do you use for remote backups?
Some of 2000s Japanese imageboards worked a bit like that. Replying to a thread bumps it to top of a board, last thread in list of threads is deleted when total reply count exceeds a limit, bumps stop working for older threads. Thread MHT archives can be captured and uploaded to fileshares if needed. Remaining time is controllable by internal parameters, but also self regulating by traffic because of bump system, to somewhere between just few hours to over a week. Discussion worth continuing can be done so by starting a new thread.

Many from such communities later migrated to Twitter, despite the board still operating. Wrestling virtue signaling game while earning buzz is easier for those with that background, and I still come across accounts on timeline with clear influence from there.

Massive upgrade from there to Twitter was forced individual consistency with account requirement - absolute anonymity leads to people without working theory of mind going gung-ho with total release from normally enforced multi-agent world modeling, and that's just malicious, like rejecting concept of criticism, possession, even nominatives.
Good enough to prove they can't predict the market...
Tax Breaks for Data Centers Are Exactly Wrong
Yeah, I like the ideas behind PS, but Nushell implements them so much better (it's yet to be stabilized though)
You do realize that Microsoft, Apple and Google also have an "army of eyes and ears".
But, good luck believeing they will not be used against you.
I'm not philosophising, this was literally my job in the military and worked with a number of analysts who worked on this sort of thing.
Tbh iphone itself is less smart than android
I remember them criticising Google for not being faster at removing cached files. I don't remember them blaming Google for their screw up.

And let's be honest, if a big provider wants to offer cached versions of pages, they probably should have a way to purge those files in case there's a problem (eg: malware).
Thoughtful comments: I have no idea why you are being down-voted.
CF calls and says there is a problem with traffic. They want to push an enterprise plan. Customer says no.

CF calls and says there is a problem with domains. They want to push an enterprise plan. Customer wants to solve problem, dropping domains, making changes. CF says, only enterprise plan will remedy the situation.

There is obviously a sales script involved.

“get back to Trust & Safety"

Heard that story several times, it's always another team, e.g. "Licensing" that need to be satisfied, or that if you don't pay up, that team will be off the leash. Also heard the pay-for-a-year-upfront for several large vendors who pull this. The reason is, some sales reps need to make numbers, so they shake the tree and see who falls down:

"Cloudflare has absolutely no information on when they will force you into custom billing, but when they start "urgently" needing to talk to you you're probably not going to get out until you have a juicy custom contract with them."
Yeah, well, that's the kind of thing you say once you have so much money that effectively "giving most of it away" won't quite change your quality of life.
In a slightly different universe, CERN gave Tim Berners-Lee a windows workstation instead of a NeXT Cube and www was built on top of Microsoft Word and VBScript.
>They don’t even necessarily need to be cheaper than all existing methods.

That doesn't make sense. Why would anyone use them instead of the more efficient alternatives? For artistic reasons?