skysight-inc/HackerNews huggingface dataset:
> FK constraints obviously dont work across system boundaries.

Not to their full extent, but they can still be used. At the simplest level, it is of course entirely possible to give different services their own schema in a given database, and FK constraints are supported across schemata in both MySQL and Postgres. Vertical scaling can take you enormously far with properly architected schemata and queries.

A more flexible, but still easy to reason about way to accomplish this is to have local versions of certain tables in each DB. This can be manually implemented (though this is not an easy problem to solve, for a variety of reasons), or by using something like Citus [0], which accomplishes this using 2PC. This is of course slower, but if your data model is carefully designed, it can be managed.

> soft deletes.

Sure, but now you have a new problem - needing to add a `is_deleted` or `deleted_at` column to a bunch of tables, and indexing that column on every table. In Postgres you might get away with this by using `DEFAULT [FALSE, NULL]` (respectively), and then creating a partial index with `...WHERE <column> IS NOT [FALSE, NULL]`; that way the index size stays reasonable, and the cardinality isn't as horrible (well, it is for bools, but since you're only using it as a filter, it can work OK). Also, of course, you have to include this predicate in most queries.

> Its theoretical protection, not practically needed IMHO.

Different subjective experiences, of course, but IME it very much saves you time and headaches.

[0]: https://www.citusdata.com
The problem is that many people view home ownership as a cultural / political statement beyond all else. They desperately need to stop being a rentoid and become a landchad. The reality is that renting is often a better financial decision than buying, especially short term. Plus, in this economy there is no guarantee that you're going to be employed in one city your whole life.
I don't have references, just bits of notion from reading various accounts of things online over the years. Most of the software that was distributed as an image would also run as an image and stop by saving that image down to the disk. This could lead to persistent difficult to debug errors (imagine a random RAM bit flip getting persisted into the image) that couldn't be recreated because they only existed on that one clients machine. Each customer was effectively modifying their versions as they ran and saved and reloaded the software, and the as seller was contracted to make local modifications for them, so the install base would diverge over time. There was no central or single source to rebuild the program from. Turning it off and on again just reloaded the saved bugs.
The type of people that want to start companies rarely invest. Once you adopt an investor mindset you start to see startups as one of the riskiest investments you could ever make.

I've seen quite a few one hit entrepreneurs lose it all chasing the next idea and never investing anything.
How has the Electoral College failed twice?
Sorry, I meant that I don't have it in my possession as I've moved out of the country and stopped paying for it, but I still know the number, the issue is that I can't get a message to it for 2FA.
I'm writing a ticketing manager for the terminal entirely in bash. Reasonably non-trivial project, and it's been pretty enjoyable working "exclusively" with bash. ("exclusively" here used in quotes, because the whole point of a shell scripting language is to act as a glue between smaller programs or core utilities in the first place, which obviously may well have been written in other languages. but you get the point).

Having said that, if I were to start experimenting with an altogether different shell, I would be very tempted to try jshell!

Incidentally, I hate when projects say stuff like "Oils is our upgrade path from bash to a better language and runtime". Whether a change of this kind is an "upgrade" is completely subjective, and the wording is unnecessarily haughty / dismissive. And very often you realise that projects who say that kind of thing are basically just using the underlying tech wrongly, and trying to reinvent the wheel.

Honestly, I've almost developed a knee reflex to seeing the words "upgrade" and "better" in this kind of context by now. Oils may be a cool project but that description is not making me want to find out more about it.
"Almost certainly", I'd say from my experience as a patient, as someone who worked in healthcare, and someone who worked for a company that wrote claims benefit management software for the industry.
And while I sympathize with your frustration, workers are caught between companies who can't even be bothered to send a rejection form letter anymore, companies posting "ghost jobs", and companies who post such broad salary ranges (if any at all) that they're unusable. Then you roll in the "resume farms" abroad (shady recruiters submitting candidates without approval and who don't match the requirements, so they can net a payday), and it's a nightmare for both sides (workers and employers).

Where my sympathy dissipates, though, is the knowledge that workers are merely responding to the ever-increasing demands of employers. It's ultimately up to the employers to fix this mess, because they're the ones who created it in the first place. It might mean an in-person career event to weed out remote candidates, if you're adamant about a local hire, with humans reviewing resumes in-hand, in real time, absent ATS and AI systems getting in the way. It might mean forgoing practical interviews entirely, in favor of better verbal interviews that assess skills and competencies, with hypothetical questions AI can't quickly or reliably answer.

And it also might mean rebuilding company loyalty and incentivizing people to stay instead of leave. It might mean reducing the amount of jobs you're posting externally by resuming promoting internally again. It might mean dangling carrots that keep workers from jumping ship every two years to grow wages in a meaningful way.

Point is, there's a lot of ways to address this, but the current attitude is "MOAR TECHNOLOGY", which doesn't seem to address either side's core grievances around the hiring and employment processes.
Many Americans' cellphone data being hacked by China, official says
I once read an article that speculated about this.

The conclusion was that perhaps there could be a ring around the planet, at the border of the side facing the sun from the side facing away from the sun. That ring could be a habitable zone.
why did you write all that non-sense when you could call them a tankie?
Protecting undersea internet cables is a tech nightmare
OP, were you inspired by this LLM comparison tool?

https://whatllm.vercel.app

The tables are very similar - though you've added a custom calculator which is a nice touch.

Also for the Versus Comparison, it might be nice to have a checkbox that when clicked highlights the superlative fields of each LLM at a glance.
I haven't lolled in a while like this. Thinking if I should try it on a branch of our project.
> it is a boom-bust industry,

It's surprising this is not more widely recognized. The majority of corporations need help configuring existing software, not developing and marketing novel software. Those new opportunities come and go. If you want stability, get a job in IT.
Can you ollama haters stop with this bullshit?

Does llama.cpp do dynamic model loading and unloading? Will it fetch a model you request but isn't downloaded? Does it provide SDKs? Does it have startup services it provides? There's space for things that wrap llama.cpp and solve many of its pain points. You can find piles of reports of people struggling to build and compile llama.cpp for some reason or another who then clicked an Ollama installer and it worked right away.

It's also a free OSS project giving all this away, why are you being an ass and discouraging them?
All the chargers I use regularly (Chargepoint, EVgo) support tap to pay with cards. No app or account needed.
> The US did not indiscriminately shell cities with cluster munitions [1]

Like I said, I heard first hand from a US veteran who served there in Iraq and was with me in Ukraine. He said Iraq was "much worse" in terms of civilian casualties in his estimation. Almost all statistical estimates you can find online also seem to confirm this, the civilian death toll was much worse in Iraq.
>I'm of the opinion that there should exist mechanisms for non-profits to reclaim ill gotten remuneration from ex CEOs

Absolutely on your side, also the foggy connection between Mozilla Corporation and Mozilla.org leaves a sour taste.
Ha, maybe there should be a tool that calculates your "bill" based on the OS stuff you are using and help you make a single payment that distributes it to the rightful owners. That bill thingy can be calculated as how much you actually used this stuff and how much donation they currently receive and then you pick how much you feel like paying thing month.

Distribution can favor projects that need funding to be sustained. Maybe you are using niche library than only 20 other people are using it but you are getting great value out of it, then maybe it can be reasonable to be billed $100(or not a strict sum but high coefficient to make your donation go mostly to this particular library).
Not intending to shame OP, but in 2024 with stories like this occurring regularly, I am totally baffled why anyone still trusts Google with anything important. Make the switch! Run, don’t walk. Do it today.

Google is the Scorpion in the parable of the frog and the scorpion - it cannot help its nature.

https://en.m.wikipedia.org/wiki/The_Scorpion_and_the_Frog
I think your idea of what represents "center-left" is miscalibrated. The China hysteria in the US is primarily a right-wing phenomenon, encompassing both the Republicans and much of the Democratic establishment.

It's clear (both from the timeline and from numerous statements by the politicians involved) that the reason this latest attempt to ban TikTok succeeded, where previous attempts had failed, was because TikTok did not suppress anti-Israeli / pro-Palestinian views in the way that Facebook did.

There's no need to get personal about a dispute over something like this. I've been following politics for a few decades in a few different languages. I'm old enough to know that the exponential growth in American hysteria over China is a new phenomenon (though I'm not old enough to compare it to the earlier Red Scare of the 1950s). There definitely would be enough psychopathy over China in American politics to have banned TikTok earlier, were it not for the fact that it's the most popular social network in the US and politicians were afraid of backlash. Gaza - and specifically TikTok's "failure" to suppress pro-Palestinian views - is what pushed the issue over the line, and convinced Congress - which is extremely pro-Israeli, on the whole - to ban TikTok.
Something can be both conceptually simple yet difficult to execute. (The key to losing weight is "just" to eat less and exercise, piano is "just a bunch of keys," etc)

Personally I have a mortgage and a family, so I'm not eager to burn through savings to build a company 0-1, but if I had to, I described exactly what I would do.
Wouldn't gravity tidal forces rip those planets eventually apart? Like we expect ie Phobos to end up, and Mars has much gentler gravity gradient than this would have.

Or would tidal locking somehow prevent it?
The fault that invalidates your variable is that children will independently pick up books, regardless of parents. What they tend to do with those books, pre-literacy, are the building blocks of later literacy. Additionally, this process can be helped if the child incidentally happens to see literacy modeled on TV for example.

This sounds interesting and I would like to know more about it.

If you do not believe me, then consult a textbook or google scholar. Assuming that you'd know what you'd need to read across the domain.

I'm not sure whether you're trying to be helpful by pointing me at academic papers, or mocking me by suggesting my lack of related academic credentials means I won't be able to find what I'm hoping to find.

In either case, it would be helpful if you could suggest one or two papers that illustrate your point about book exposure without reading. I can follow the citations in both directions to find others.
A year into Javier Milei's presidency, Argentina's poverty hits a new high
I bet paycheck to paycheck like most things has a range of meanings circling around the same essential thing, which is that if you do not get paid next month you cannot afford to live the same next month as you did this one.

You might be able to make ends meet by cutting the 401K and yoga classes, but if that's what you need to cut to eat the next month, what do you cut to eat the month after that?

This guy was obviously not living anywhere near paycheck to paycheck.
What ‘bout “C:\My Documents” though?
Sandpiles and Self-organized criticality [video]
Probably my largest one that was an order of magnitude smaller than these for the most part, but it checked that my VPN was up (or not) and started it if not. (And restarted various media based docker containers.)

If it was up, it would do a speedcheck and record that for the IP the VPN was using, then check to see how that speed was compared to the average, with a standard deviation and z-score. It would then calculate how long it should wait before it recycled the VPN client. Slow VPN endpoints would cycle quicker, faster ones would wait longer to cycle. Speeds outsize a standard deviation or so would check quicker than the last delta, within 1 Z would expand the delta before it checked again.

Another one about that size would, based on current time, scrape the local weather and sunup/sundown times for my lat/long, and determine how long to wait before turning on an outdoor hose, and for how long to run it via X10 with a switch on the laptop that was using a serial port to hook into the X10 devices. The hose was attached to a sprinkler on my roof which would spray down the roof to cool it off. Hotter (and sunnier) weather would run longer and wait shorter, and vice versa. I live in the US South where shedding those BTUs via evaporation did make a difference in my air conditioning power use.
Except that it is much better than anything that had existed before it.

The earlier handling of non-English alphabets or writing systems was horrible in MS-DOS and Windows.

While there have been made some serious mistakes in the development of Unicode, its main principles were fine and it does not have any competition.

Feel free to propose and implement a better standard.
About the poor memory stuff, just get it in writing. “In writing“ could mean in an email, or a chat, or more likely in an issue tracker that has an audit log. When there’s a discrepancy, just link to where it was written down.
There is a list of 6 disadvantages of WAL mode on the SQLite site:

https://www.sqlite.org/wal.html
Yep. In the US, I would of course pay for an unexpected car repair (or indeed most any expense) with a credit card. It doesn't mean it won't be paid off at the end of the month in essentially all cases. So one of those meaningless statistics.
I'm not aware of any real push to include Mathics in sagemath. I speculate it's because SageMath is mainly developed by research mathematicians and cryptographers, so performance is often a primary concern when evaluating components for inclusion. One of the reasons SageMath is the largest Cython project is because Cython makes it possible to utilize fast C/C++ libraries from Sage.

I have the impression that Mathics is currently not seriously concerned with performance. E.g., try this little microbenchmark in Mathics: "AbsoluteTiming[Sum[i, {i, 1, 100000}]]" or read their roadmap. This is fine -- there are many interesting applications of the Mathematica programming language where performance isn't important, e.g., carefully stepping through some symbolic operations with expressions. However, for Sage the motivation of most developers is cutting edge research math, and for that, performance is almost always very important. Performance is why Sage also implements a lot of similar functionality to Sympy rather than just using sympy for that functionality -- since sympy can be relatively slow due to their priority to be easy to install, which is definitely not a priority for SageMath.

The mission statement for SageMath is to be a viable alternative to Mathematica, Matlab, Magma, and Maple, but I never meant that to mean being a clone (e.g., directly running Mathematica code), but instead just an alternative in the sense that it can support research built on open source mathematical software that might otherwise be done with those closed source programs.
I wouldn't say that last bit though. So much code fails outside of the origin country, also from e.g. Dutch coders even though we're well aware how small our country is and how much we rely on trade and collaboration. People across the EU come into the country so you'd need to support other languages, payment methods, currencies, special characters in names, date notations, address formatting, timezones, phone numbers, etc. Part of Belgium even speaks the same language so the barrier really small, or even across the atlantic ocean where there are more people "in" The Netherlands except nobody ever realizes that a part of the country uses the US Dollar as its currency and is in a very different timezone.

Now living in Germany, they even translate timezone names. Not only do you have to look in a timezone database to figure out what a MESZ is, when the timezone database says "there is no such timezone" you have to realize you need to look in a German translation of it. Very approachable for the international people that need to know which timezone that German picked for the meeting invite

Which is all to say: sure, people know other countries exist and are more likely to need to learn to use localization, but by default it's not like everyone knows how to do that
I wouldn't be comfortable saying we'll never see AGI in our lifetimes. I've seen incredible progress since I was a kiddo and computers were these huge machines that took up an entire desk, not to mention that only a decade prior to that, they were machines that took up entire warehouses. And now, I carry around a computer who's primary function is organizing my life and helping me kill time, and it has hundreds of times more power stuffed into a little rectangle that runs the entire day in my pocket. I wouldn't say it's impossible by any stretch.

That said, I think it strains the hell out of credulity to say a fancy chatbot is getting anywhere close to that, especially since we apparently had to give it every word mankind has written up to this point just to get it to a stage of "mostly good at grammar, still makes tons of shit up." I just don't think this is the route there.
100%. Another reason to start by talking to customers. The product has to be more than useful—it has to fit into their current workflow. Most B2B startups underinvest in sales (which is not the same as sending 100,000 cold emails).
Denying claims generally doesn't improve health insurance company profits. It's not like auto or homeowner's insurance. Due to the minimum medical loss ratio rule, insurers can generally increase their profits by approving more claims. Their most important customers are self-funded employers.

https://www.cms.gov/marketplace/private-health-insurance/med...

When insurers tighten their claim approval policies it's usually due to pressure from those self-funded employers to control costs. If employers wanted it, insurers would be happy to sell custom health plans that would pay every claim with zero denials; this would be enormously profitable for insurers because they wouldn't have to do any work.

Claim approval or denial rates don't have much direct impact on consumers being able to afford insurance. Most of the cost is borne by employers, and low-income consumers who buy individual policies through the exchanges receive government subsidies. But of course that indirectly impacts all of us through lower wages and higher taxes.
> They are just allocating the very limited resources among more and more demand.

Are you saying that the same populations are getting more and more sick and ill? Citation needed for that. Or are they costing more and more money? And if so, why?

Wouldn't be health insurers setting up middlemen of their own (PBS, etc.) to get around legal caps on their own profit margins, would it?

> Legal is also up there. Those millions and tens of millions of dollar judgments don’t come from thin air.

Malpractice payouts are by and large a boogey man. Texas has had them capped for years and shockingly, malpractice insurance costs are effectively identical to what they were before. As an aside, malpractice insurance in itself isn't typically as onerous as people believe it to be. What is onerous, and what that industry does differently to most other insurance segments is "tail insurance".

Tail insurance is the concept that major malpractice suits may appear well after your claims-made liability policy has ended. In most cases it's actually DOUBLE the premium you're paying for malpractice insurance, implying the insurer believes that your coverage is less than one-third of the claims they expect to pay. What -should- happen is that you carry "claims-made and prior acts" coverage. The challenge there is that in many cases your employer will cover claims-made as part of your compensation or part of their insurance, but don't elect prior acts coverage (and because of the way they do it, I suspect it's not as simple as "let me pay the difference").

But in general capping malpractice payouts has done nothing to offset malpractice coverage costs, let alone flow-through to end consumer costs.
"Washington DC is suing Amazon for not delivering fast enough to low-income neighborhoods.

You can't make this stuff up. Amazon is an oppressor that destroys communities. It is also an oppressor of people of color if it doesn't provide them enough Amazon services. Why not let them be free of the horrors of two-day shipping?

The problem was that Amazon used its own drivers for wealthier areas, but relied on the post office for poorer areas. They oppressed local communities by forcing them to use government services!

Amazon notes that they stopped sending their own drivers to certain neighborhoods because they are too dangerous.

This is what parasitic government looks like. Let crime be out of control. Have terrible services. A corporation comes along that nonetheless through a miracle of logistics bring goods to the doorstops of a community that government has failed in every way, sue it for not being fast enough relative to some other community without the same problems.

What a disgrace."

source: https://x.com/RichardHanania/status/1864375901103988792
The French keyboard is the most notable example of anyone using something other than query or quertz. Even Japan and China use an extended querty. But even with the French keyboard the only issue is that everything is in the wrong place, not that the standard 26 "English" letters don't exist or are hard to reach.

Meanwhile using ä, é or ş in a username or password will make your life much harder once you are in a foreign country. Never mind any letter that isn't derived from the Latin alphabet.
Intel ruled tech. Now it's in deep trouble
First look at jet-powered VTOL X-plane for DARPA program
No idea. I wouldn't count on anything with a new administration/congress.
Starlink's first constellation of direct-to-phone satellites is now in orbit
Recent Noahpinion on this…

https://www.noahpinion.blog/p/paycheck-to-paycheck-and-five-...
That’s a self-defeating definition. Work that can be automated at no marginal cost is economically worthless.

Edit for clarity: “worthless” as in “no value add”, its worth is only capital investment and energy input.
India Could Be Apple and Samsung's Solution to the Future of Phones