skysight-inc/HackerNews huggingface dataset:
> although it would seem to be so by design, however design is only as robust as

It only seems so if you assume auto-increment is used to populate the order_id and that it always increases with time. That latter assumption is quite unsafe:

* Systems could have been merged with a bulk import of old orders into this one from elsewhere (assuming order_id is a surrogate key and there is a separate order code or such that is used to identify the orders externally).

* In fact, a simple insert of several records in the same statement will not necessarily get auto-increment values in the order you expect (in practise they usually do - but the DB engines do not guarantee this, it is an accident of other factors in their design rather than a defined behaviour).

* Because of optimisations for concurrency in the way auto-increment is handled, it is possible that long-running transactions could cause ordering discrepancies. In theory at least, in practise unless you've explicitly opted out of ACID-preserving locking semantics for those transactions I suspect these protections will stop this un-ordering happening by blocking the concurrency. This sort of issue is why you occasionally see unexpected gaps in auto-increment values.

* I have seen an example where an incrementing signed-int ID was getting too close to MAXINT for comfort, and as a temporary measure ahead of changing that ID to be a longer type the increment was reset to restart at MININT and head back towards 0 from there! This was with a 16-bit integer (I'm old enough to have been around when it was common to use them to save space, where we generally default to 32-bit these days) but the same could happen to larger types.
I kind of thought Python would enable the GIL if any no-nogil libraries were installed, but even that is hard to define when you can modify sys.path with environment variables and code.

Will look it up.
"How AI reduces the world to stereotypes"

I find this interesting, in that there are any number of A.I. systems other than deep learning and large language models. Contemporary usage in the nontechnical press, though, uses "A.I." to refer specifically to DL and LLM, especially when they are generative. From this perspective, the above title uses a stereotype which ignores other A.I. technologies.
Unless they're working in that space they won't know it. And that's fine. There's enough to keep in our memory and tools and resources for us to look up information if we need it.
Why is this post flagged? In which way is it against the guidelines?
A little taste of Htmx (part 1)
Dollar going up isn't the same as more dollars being created, it is the same dollars being worth more.
> Also these annoying “proof left as an exercise” is now “ask chatgpt for the answer”.

ChatGPT is horrendously bad at mathematical proofs (I've written about this before), so I fear that this is a rather dangerous approach: you could be learning things that are wrong without realising it.
> The us banking system is unraveling before us and I’m getting the pop corn out.

People said the exact same thing in 2009, and two years later everything was back to the way it had been before.
Not it can't.

It's way too big and the subs are way to siloed to exist without search.
I'd look at it in the opposite direction. Good abstractions are powerful when you understand what they build on. That recurses all the way down. Learning bottom up is a natural path, but there is still plenty of opportunity to explore top down. The difference is that top down discovery needs to be an intentional journey.
Honest question. If inflation was caused by debt, why is inflation going down while the debt increases faster?
I guess in IT it's the other way around, where you can start with advanced abstractions and frameworks without bothering what kind of rabbit hole is underneath (at least while it's going smooth), it gets deeper as you go closer to the hardware. While in maths you need to understand the basics to even know what's going on with more advanced areas. And this already applies to the fundamentals too, where in school it's expected you understand the stuff from previous years. At least that's my impression as a non-mathematician.

And then there's the mix between the two in languages that rely heavily on powerful type systems.
What I don’t understand is the totally arbitrary cargo cult nvarchar limits. Why 255?
From at outside perspective it's interesting how little the US taxes people in the top 5% income bracket. Here in Denmark the progressive tax on this segment makes up the biggest source of tax collection.
How they detected it can be found at the bottom of the blogpost:

> *Indicators of Compromise*

> ...

> Okta activity for a user without any clear indication that the user authenticated (e.g. a user.session.start event for that user from a similar geographic area)
Government debt is, in general, not expected to be repaid. Ever. Only the interest, and often not even that.
I don't know where you are going, but I did fix several articles already and never had a single issue with it because my sources were correct.

Yes, there might be bad actors, but it doesn't mean that everything is bad and impossible. You should try first, at least.
I agree that is a large problem with industry.

Folks that have really strong opinions on issues of taste, but then they output apps that send a couple of thousand requests ( with several second latency ) are extremely difficult to reason with.
What's Next for Clearpath Robotics?
Wow - 1/3 seems a lot, for payroll taxes. Do you not get tax-free allowances?

I spend nearly all of my income; VAT (sales tax) takes more than 20% of that. Other non-payroll taxes:

* Council tax (land-value tax)

* My pension is taxed as income, even though I already paid for it through National Insurance (a payroll tax)

* If I drove a car, I'd be taxed again.

* If I dispose of assets, I get charged CGT.

If I was still working, I reckon I'd be paying over 50% of my earnings in taxes. I wish politicians would come clean, and simply levy taxes on income. It's fair, and it's transparent.
First and foremost, the editor/systems were not open source. Second, the companies are known for requiring certain kinds of logins and locking things down (Google/Microsoft/AWS account, etc).
Top Israel/Hamas misinformation spreaders use Elon Musk's paid "verification"
A good book on the subject

"Fix IT: See and solve the problems of digital healthcare"

https://www.waterstones.com/book/fix-it/harold-thimbleby/978...
So what?

What's the problem with that?

In several countries, they even put up billboards next to projects they paid for.
You're probably going to run Linux on these which means you're going to use the ppc64le port.
python already has asyncio
I take the first to mean that you can't purposefully degrade the quality from what would otherwise be possible, not that you can't use higher bitrate elsewhere.

The second bit simply says "third party service" - nothing stops you from doing the combined chat overlay locally and streaming the result.

Also, twitch is still very much the top dog, but you're right - they're actually having to compete against youtube now.
It's not for lack of trying. The FAA is the only thing holding them back from testing more often and their speed is atrocious and concerns are totally baseless. It's clear the current government, who Elon is at odds with, is weaponizing that over him along with the justice departments bullshit lawsuit about SpaceX not hiring enough foreigners (ITAR regulations specifically ban hiring of foreign nationals).

Whatever you think of Elon, or even people like Trump for that matter, you'd have to be an idiot to cheer this kinda stuff on.
> It's not a choice if the consequences of making the 'wrong' choice is being invaded, bombed into the stone age and have your country pillaged and its assets handed off to reserve currency alligned corporations.

Is there a reason everybody here seems to believe in that threat? I don't think the US is keen to repeat the 200X invasions. Plus Saudi Arabia, a US ally is threatening to switch to China's currency despite that?
> A big percentage of so-called experts today only know how to configure some kind of hype-tool, but they understand nothing about how things work at the deeper level.

This resonates with me strongly. Everyone seems to know how to do things by rote memorization ("to do X, add this line to your config file") but nobody knows how to go off-script if you need to do something slightly different (not-quite-X or a variation on X). Worse, people will waste your time trying to steer the conversation away from not-quite-X back to X. (Insert the parable of the man searching for his lost wallet under a streetlight because that's where the lighting is best.)
An average citizens quality of life has dramatically decreased nonetheless, default or not.

> The currency has been devalued by 90% – still not enough to reflect its slide in full. Inflation is in triple digits. Public services have collapsed; without hiring a private generator, households can expect only an hour or so of power a day. Shortages of drinking water have contributed to disease outbreaks, including the first cholera cases for decades. Parents are sending their children to orphanages because they cannot feed them. A growing number of citizens have resorted to armed robbery as the only way to extract their own deposits (now vastly reduced in real terms) from banks when they desperately need to pay for basic services such as healthcare. The collapse of Lebanon, formerly known as the "Switzerland of the Middle East", has been described by Western media as one of the most devastating and worst financial recessions since at least the 19th century.

https://en.wikipedia.org/wiki/Lebanese_liquidity_crisis
At least you get to estimate.
The author's "Advice to people studying technology" goes against the dominant practices for individuals making money in software right now.

This is sometimes a misalignment with organizations, though other times a company is playing games (e.g., priority is to appear externally as having growth or progress).
The Gems Hiding in Plain Sight in the Treasury Market
Question with regards to the FIFO queue and processing it:

Say a user does two actions in quick succession - action A that is something that inherently takes a bit longer to process on the game server (ie a complicated transaction of some kind) and then right after does action B, one that requires little to no processing.

How is it best handled to make sure that the order of actions by the player is maintained with processing? With this scenario, it is possible action B will be processed before action A, leading to the game server considering them in the wrong order. I'm assuming the solution is to have some additional logic to make sure you are only processing one action per player at any given time, but I was wondering if anyone knows any better ways?
but pretty much nobody mentioned or cared for something like O3DE

Because it's a project started by Amazon.
Just want to say thank you. I could have typed that out and didn't. ( See my reply below )

My faith on HN discussions continues to fall. There are many topics I keep thinking may be I shouldn't even click on. But it is good to know there are people, who continue to contribute in a positive manner. ( at least more positive than I am )
https://archive.ph/z0a8d
Before you do a technical interview, you send them a website and ask them to write that FizzBuzz equivalent for you, or if you want to be seen to be nice, schedule a 30 minute interview with them and ask the FizzBuzz thing.

It doesn't have to be asked during the full technical interview stage.
I am not so sure debt has to be repaid.

Debt is supposed to be repaid, or should be repaid, or comes with great declarations of an intention or obligation of being repaid, but debt can be kept indefinitely.

Cases from the top of my head:

- IMF lends money to country. Later the country is insolvent, and the credit is renegotiated to a lower amount (same for mortgages) as opposed to getting nothing.

- Parents "lend" money to children for house downpayment. Parents died without debt having been paid.

- World ends tomorrow by $reason_of_your_choice. All the existing debt gets cancelled.

- Friend lends some money to another friend. They fall out and never repay the debt, and everybody lets it go.
Sure they did, the AsRock P4 Combo for example ( didn't find any in laptop form-factor though ).
Software Architecture for Humans
interesting maybe this could be done with an extension using the omnibox api...
> Maxon and the township signed an agreement in 2008 that Maxon would not face any zoning action if he did not increase the number of cars he had on his property. In 2010, 2016, 2017, and 2018, the township hired a company called Zero Gravity Aerial to do aerial drone surveys of Maxon’s property to ensure he was complying with the settlement.

Is there a reason why they couldn’t just use Satellite data from Google Maps? Or pay for existing commercial satellite images? Can’t believe it’s cheaper to pay for a drone for multiple years to validate the number of cars in his yard.
"How often does a front-end developer need to know about /proc/pid/mem?"

It's not about any particular detail, obviously.

He himself does not ever have had to previously see /proc/pid/mem before in his life in order to solve a problem involving it.

However many times a day he gets a question of any kind, that's how often.
Xbox does. I think it was there at the beginning of the Xbox One Gen?
I mean it is literally the issue that planning poker addresses - identify differing expectations without influencing the initial estimate. People can then totally ignore that, and ignoring something makes it pointless, but that's true of literally anything.

It identifies a lack of a shared understanding of the task. Or framed differently, it identifies when you probably all have the same expectation and you can move on.
Downside here, is that following this advice will usually mean they make less money.
I don't know, I've seen some 10x women do it in seven months, though the deliverable did suffer.
We have a deadline and estimates, now all we need are the requirements...
You can't use both CPUs at the same time with that one. If you install both either something will explode, nothing will happen, or it'll just use one of them (probably configured using a jumper)
Ask HN: How to avoid engineer stamp as a founder fundraising?
As an engineer talking to investors while i am running my uphill solo business i often have the impression they think i am stuck in engineering lala land and not a “business guy” like they are even though i have launched products and acquired customers. has anyone else experienced this and how do you deal with it?
This could be applied to society as a whole. Currencies are an abstraction on bartering which is an abstraction on doing every task required to support your life and family yourself. Each layer of abstraction creates a specialization and efficiency. Those who consume the abstractions may lack the details, but they have levers long enough to move mountains! Those who provide them have a valuable role. Don't be afraid, we must keep making more.
Lebanon and Pakistan aren't exactly politically stable, Greece was incompetently managed for a long time. Don't know about Turkey. Compared to the national deficits of basically everyone in the EU, US, and big Asian economies, it does look like GP is right that big national deficits can be managed?
I love these types of posts. Most of my career as a developer felt like being in a bazaar, where the buyer (manager) would constantly be trying to get the price of a carpet down (my work) without ever knowing exactly what type of carpet they wanted, but having a vague idea of a "quality" carpet in their head.
Thanks for elaborating, that makes sense.

Historically WebSQL would drop a real live SQLite database onto the disk (in some application support directory for the browser) which was very convenient for exactly this use case.

It's unfortunate that's no longer the case.
Are there good historical examples of this happening, where foundational knowledge is completely lost?

I know I have read about it in books as a fiction, but I assume it must have already happened here before.

Maybe its an oxymoronic question to ask, seeing as if its lost we might not even know its lost, but more in the vein of "We put the lime in the mortar because this is what we have always done", unaware of the actual properties of lime when interacting with concrete.
Spitballing here . . . The unreliability of such a network for live video would make routing quite a challenge. Assuming that could be solved Twitch could offset this by reducing the number of ads shown to people acting as redistribution nodes.
A lot of people append "reddit" when they search for stuff on Google to try and find better results (rightly or wrongly). Killing that and forcing people to login to access any content would be a crazy move for them.

I wonder if this is just bluster, or if they're still desperately trying to look more valuable for an the IPO (if that ever actually happens).
But you know those things exist and how things relate to each other and affect each other, or could affect each other, and you don't need to already have a mental text book in ram to solve a problem. I don't know you and yet I know this.
Python implementation of Blizzard Authenticator (TOTP)
What is the most disgusting element of this beyond the law proposal, is to me the fact that companies wants to earn money fighting csam.

What if they become big enough (and own multiple companies in many industries) to lobby hard for draconian laws forcing seemingly innocuous competitors to buy their services or who knows get fined/arrested because arent "thinking of the children".

I'm all for fighting csam, but do it right and proper in a liberal democracy, not with authoritarian means.
Never reduced an estimate (without change of scope) in my whole career. Didn't do me any harm.
Because interest rates are increasing? Both the cost of debt and the cost of the dollar increase.
You can find there investigation here.

https://www.bellingcat.com/news/2023/10/18/identifying-possi...
Sure, curing the disease is more important than curing the symptoms, though the two aren't entirely unlinked.

What the systems describe isn't reality though. Mexicans invariably wearing sombreros doesn't reflect Mexican fashion, it reflects whether people have bothered to tag the image with "Mexican" or not.

If you can tag reality in ways in which US frat boys' fancy dress preferences are somewhat representative of the label "Mexican" and famous Mexicans in Mexico City usually aren't, then it certainly isn't necessary for job title tags to be highly correlated with ethnicity (Posed stock photos have tended to push back against this for years). And whilst it's true that certain occupations are dominated by white males in the West, they're certainly not the world's "default" people; that's more a reflection of the sort of English speaking internet power users whose content gets hoovered up by the dataset. And that is definitely a bias, even if it's a completely unintentional one.

In general it's "reality as seen through the narrow lens of people uploading and tagging photos, often not even with the intention of conveying useful information to an image generation algorithm". That reality includes a lot of biases, some of them more accurate than others and some of them more benign than others.
I can't help but share the MMO we're working on that fits that mold! https://www.seed-online.com

EVE is by the way also working on an FPS, Vanguard. Which is supposed to interact with the game world of EVE.
That's what SpaceX gets for their recklessness. It's not a software product where move fast and break things can be fine. It's damn rockets where even following the regulations it can cost a significant amount of human lives.

Their last launch attempt, they couldn't even get a tank of fuel to explode reliably for crying out loud.
Actually, I’d think using “ANY” would be the clearest translation of the semantic intent.

If your query processor is even marginally competent, ANY & EXISTS are indeed optimized exactly the same way.

A slightly smarter QP will perform as well for the equivalent IN condition, too.
Except this isn’t a balanced perspective. That Ticketmaster can help cover the increased costs of touring is not really relevant to the discussion of “why isn’t there a replacement for Ticketmaster?”.

Why?

Livenation and Ticketmaster controls like 70+% of the market for shows (https://insights.som.yale.edu/insights/did-ticketmasters-mar...). They own fuck tons of venues and literally can’t be competed with in a lot of instances. Theres not a competitor because it turns out that acquiring vast numbers of venues is expensive and is only something that a market leader like Livenation could do.
They were told to renew the original certificate, but weren't told to also renew the renewed one.
Ugh, why do they want me to register to access a free course.
Having worked for many years in IT in Denmark I would say that the author is right, but many of these are luxury beliefs, since in Denmark people are given alot more time to do their job right than in many places. In many parts of the world developers are not given the time to understand anything, and end up working 8 hours after the job to understand the tools in their own time
The great post Covid inflation ended that fantasy world of low inflation despite deficit spending.

There is a lot of uncertainty in the future. Will human population shrink ? Will robots get cheaper than humans for general tasks ?

The federal budget doesn’t move as fast as bond traders. but in the end the fed can pump and dump short or long term bonds at will. But it generally is data driven as is the federal budget.
Google as an IdP is honestly terrible, and probably the one of the primary reasons why Okta is popular, especially amongst Google Workspace orgs.
Not all work for workstations require a 16-lane GPU or four NVMe SSDs. Sometimes all you need is a lot of CPU cores and lots of memory at a reasonable, albeit not ludicrous, bandwidth.

Although I work with 2-3 monitors all the time, I'm happy with low-end GPUs - I don't do much data visualization or 3D rendering. I mostly develop software, so I stand-up relatively thin ephemeral VMs and containers all the time. For me the core count and amount of memory is the limiting factor. To completely avoid any swapping, 64GB of RAM is needed, and more would allow me to keep a CI pipeline running all the time. If I need more space, I can spare one or two SSDs as bcache for a larger SATA array.

As much as I'd love the biggest Xeon X, EPYC, AmpereOne, MI-300, or Grace Hopper under my desk, I have no need for that much power.
If developers did not approach projects with the goal of adding
acronyms to their resumes and infuse every project with the
latest cargo cult du jour it would improve the ability to
predict timelines.

Pick boring technology, that the team is already comfortable with, when possible.
Keep the teams as similar as possible,
Keep running projects the same way, when possible

I am not saying it will get things perfect, but it will be an
improvement.
It is all about how much risk do we tolerate in the western world.

People are getting nervous because if a war with China would happen with a rapid de-globalization something akin to the "1970s energy crisis" would happen in the semiconductor and digital world.

Well price of our beloved computers and devices would probably need to go more than 10x and around 100x for things to get really interesting.

If this would happen, your cloud native scalable & hyper convergent smart platform powered by AI would feel like a car that have been designed when oil was $15 a barrel. Not exactly what you need right now.

Company would seek the services and even surrender to the blog author like a life long addict seek help and realize he wants to live once he reached the bottom.

Until this happen, this is just an old man rant.