skysight-inc/HackerNews huggingface dataset:
> ignore_row_on_dupkey_index

I was thinking of the hints you used to have to use with a merge statement in order to get an atomic upsert - holdlock in sql server and lock table in oracle. My recollection of the terribly old newsgroup thread where it was (presumably you) said merge doesn't perform atomic upserts without these hints and since people were primarily wanting merge to perform atomic upserts and postgres doesn't support hints it made more sense to just make something for upserts hence the on conflict update stuff. Do I have it wrong?
I’m currently trying Duckworth, I’ve been liking them. They’re a bit of a novelty in that the entire shirt is made sheep to shirt in the US. Only a couple of their lines are pure wool, though, so read carefully. The fabric seems a bit heavier/less soft than others, but they’ve been holding up better so far. Maybe related?

Icebreaker seems like the biggest brand in merino, and their shirts are pretty good, very light and breathable, but a bit fragile (my jeans buttons seem to be forming holes in them somehow, all in the same spot). Big fan of their long underwear, too, makes a huge difference in the winter.

Woolly shirts are super soft, probably the most comfortable, and not too expensive, but even more fragile than icebreaker IME.

Still looking for the perfect shirt, but I’ve liked the ones I’ve had from all of these.
And they have an infinite time horizon and attention span while we do not
HN, Financial Times, WSJ, the Australian, Ars Technica
I appreciate your obvious experience in this area, however synthesisers with more features, and more complicated user interfaces than the OP-1 have existed longer than I've been alive. I know this is not from a small company, but take for instance Yamaha's SY77 from 1989. It's built around a 16-bit Hitachi H8/500 processor, with 1MB of SRAM. It's CPU, synth engine, and peripherals are all glued together with 7400-series logic chips. Its AFM/AWM engine, sequencer, and the UI that controls them hold up well by today's standards. Compared to whatever ARM SoC the OP-1 is built around, the EE involved in designing the SY77 is much more complex. There is no comparison between the tooling available to Yamaha in the 80s, and the open-source tooling/libraries/resources available for embedded development in 2022. I understand economies of scale, however can't we expect more from a company like Teenage Engineering for the huge prices for their gear?

My TG77 is 33 years old. I replaced some aging capacitors because they were making the main output a bit noisy, however aside from that it's worked very well.
idk about the remaining risk, but there's definitely a kind of conservative investor who would be happy for a 6.5% return from a forever holding; also there's no reason to think you couldn't auction it for higher later. (Say, a decade from now when interest rates start falling again). It's a bad time to buy this thing, maybe... if you think you'll fetch higher returns next year. I'm a fan of tobacco, (don't shoot me, I'm a chain smoker, it's my future health plan), but it's just another thing people buy without thinking about what it costs. A lot of people are looking for stability versus maximizing growth. This always gets a bad rap - people think I'm insane for keeping almost all my portfolio in utilities and basic necessary goods. I'm 10% in tech and 10% in retail... the rest is utilities, commodities, real estate, and whatever kicks out at least 4% annual dividends. I'm in my early 40s, and have followed this strategy since my 20s. Could I be richer if I were more aggressive... probably. Although giving my track record in Vegas, maybe not. But I don't try to time the market, I basically never sell anything. I drip dividends and accumulate. I never got struck it rich on a hot ticket but I worked $100k saved in my 20s up to $1m or so now, rotating and seeking dividends.

What I'm trying to say is that for some people, the marginal cost of risk - even from real estate - is worth a few points on a "sure thing". A sure thing is hard to find.
their philosophy seemed to be "first seasons attract more new customers than n-th seasons", which I always perceived as based either an arrogant "you are not gonna leave anyway" or a fearful "of we do not grow quickly enough we are collapsing"
That's horrifying. What are we supposed to do? Can they be defeated? Do technology companies have enough lobbying power to put a stop to these never ending "anti-piracy measures"? Do they want to?
The “American Way” of finding a good enough monopoly that one can afford to pay legislators to allow it to continue so long as taxpayers can be convinced that it’s not bad enough to favor a different candidate. Or, just get every candidate to support it! Then taxpayers have no choice and you win.
You need to change teams to a project that interests you or find another job working on something that actually excites you imo
> "THE MAXIMUM AGGREGATE LIABILITY OF BANK AND ITS AFFILIATES, AND ITS AND THEIR LICENSORS AND SERVICE PROVIDERS, FOR ALL DAMAGES, LOSSES, AND CAUSES OF ACTION, WHETHER IN CONTRACT, TORT (INCLUDING NEGLIGENCE) OR OTHERWISE, WILL BE TEN U.S. DOLLARS ($10.00)."

Got to love agreeing to online contracts where it's not possible to make any changes! That said, isn't this a case where the FDIC steps in and restores a decent chunk of your account if the bank screws up?
After doing this for nearly 20 years I can say I’ve been pleasantly surprised at how rare it is to get spam unrelated to the company I gave my address to. What it’s been very useful for, in the other hand, is filtering email from companies that don’t honor their unsubscribe links or unchecking their “please send me marketing emails” boxes during signup. The common pattern is for them to invent a new kind of junk mail category and then act as though your opt-out obviously doesn’t apply to this totally new category.
Right; you don't just pay for egress. (It seems like your comments contradict each other but whatever.)
> The union is supposed to be akin to the EU but without international sovereignty for states.

Actually, not really. The EU is, in political science terms, a confederation (to the degree that it's a state and not a supranational organization in the first place). The constitution envisioned the US as a federal state (the first one ever), in explicit contradistinction to the confederation that preceded it, as well as other then-existing confederations. That the constitution was ratified meant that the people of the time agreed to disband a confederation and move to a federal state.

The primary difference between a federal state and a confederation is that in a federal state, both the federal government and constituent states have their own loci of authority and power, as opposed to a confederation (where the federal government exists at the behest of the states and derives all of its power from those states) or a unitary state (where the reverse is true). As the US was the first example of this kind of government, the US Constitution has several weird quirks that now seem anachronistic (e.g., the federal territory not having representation) that probably helped stabilize the government in its early years.

Arguments that center on what the Founding Fathers actually intended for the country fall flat for me because a) how do you know what they actually intended versus what you want to say that they intended, b) what makes you think that a government that made sense for the US 250 years ago would make equal sense today, and c) if you look up the history of treaty-making, you'll find that the first person to bin the original intended procedures of how the government would work was George Washington, barely a year into his first term in office.
They did write it in 2020(too): https://www.macworld.com/article/234134/fast-cheap-and-out-o...
Thinkpad X1 or Extreme runs Pop!_OS flawlessly
Yeah, completely counterintuitive if your mental association growing up is with super hot sweaters.
> It seems like a Herculean effort to attempt to get browser support for such a thing

https://caniuse.com/datauri
As a San Jose resident this all seems pretty accurate TBH.
Kickstarter regularly sells my address, even soon after changing it. I don't think any other entity did that, which is mildly surprising.
depends where you live. in River Oaks there are there instantly. corruption pays off.
We provide Macbooks for every developers that wants one at our company. For the past 8 years, with NO exeception, every single one of them had to go change something (screen, keyboard, the whole logic board and etc).

For me, without a shadow of doubt, macbooks has been the least reliable peace of technology that I've used for the past years. I can't deny that their support is awesome and they will change anything without questions if you have the money to pay for the repair or you are still under warranty. However, I would really appreciate if I didn't have to use the service.

I haven't used the new M1's, I really hope that they are more reliable.
You can use it for Vehicle Route Problems. I did so once as an interview project but never in production. If you start from some example problem, the learning curve isn't so steep.

https://en.wikipedia.org/wiki/Vehicle_routing_problem
Web browsers do not support pbm, last time I checked. On the other hand, the JPEG-XL rollout is well underway (e.g. Chrome supports it behind a feature flag).

The image is only 22 bytes as a jxl:

https://cdn.discordapp.com/attachments/286612533757083648/96...

base64 data uri version:

data:image/jxl;base64,/wp/QCQIBgEALABLOEmIDIPCakgSBg==
https://thehill.com/policy/technology/537874-biden-administr...
Not wildly unpopular with me. I’ve canceled multiple Netflix accounts using my $firstInitial$lastName@gmail account. My excuse if they ever challenged me would be to say I thought it was fraudulent because I didn’t set it up and I didn’t want my email to be the only contact method.

Edit: there is one boost mobile customer who has done this to me and I can’t figure out the exact address they used (the thing where you can add periods gives a lot of possibilities), and I really wish I could password reset and close this account because approximately every other month for years I get late payment notices, then impending cutoff notices, then cutoff notices, then “thank you for your payment your service has been restored” notices. It’s both sad and annoying and I finally just black-holed everything from boost mobile and hope I never decide to be their customer in the future because troubleshooting mail delivery problems when I’ve forgotten about this will drive me insane.
Prima Weight Loss Pills UK

Along these lines, during that time it will involve fats as an energy source and assuming your exorbitant fats will be utilized as a fuel over the course of the day for working and working of the body, then it will never again be there and all your fat will be dissolved.Therefore, you will actually want to get thin.

READ MORE >>> https://www.jpost.com/promocontent/prima-weight-loss-pills-u...

https://www.jpost.com/promocontent/prima-weight-loss-pills-u...

https://www.mynewsdesk.com/health-news-corp/pressreleases/pr...
I think this can cause legal issues: ianal, but generally work done during company time with company equipment belongs to the company, and I’d guess a litigious company could cause problems for open source projects contributed to in this fashion.
to be fair to sun and Self at least a lot of the research was rolled into the hotspot stuff!
Thank you! The website is up an running now
I'm not one to drum up drama, but I kinda got sick of Andrew after he faked his own kidnapping and then tried playing it off with the "it's just a prank bro" shtick. He represents a lot of aspects about influencer culture that I find grating.

Cuckoo, Loopop and Patchwerks also did some more in-depth videos today. Not here to take the wind out of anyone's sails, but there's probably more intellectually stimulating/gratifying content out there on this device.
Your understanding would be wrong for at least temperate climate zones (North America, Europe, much of Asia, forest and steppes alike). Not much grows there for half a year. Meat is around all the time.
It keeps upper management busy and out of your hair micromanaging you.
He wouldn't. Are you saying that 30% of shareholders saying they wouldn't vote for the take over implies that 70% are for it?
The Salar de Uyuni is, however, terrific.
Data URIs have much more widespread utility than what is being discussed, I think.
No. It goes only because there are very few browser engines, who mostly can align their behaviour with each other.

Protocols with miltiple implementations are way more strict, because you can't feasibly test your quirky approach on every implementation, and the chance they will all be as forgiving is slim.
In every Marvel movie I watched the Helicarrier was shot down before it could do anything useful. I imagine a real life version would suffer the same fate.
Umph. I really don't want to see Israel go this direction. I don't want to see them tied to a tanking US economy either, or soft-pedaling Russia... but no deal with China is good news. This gives way too much ammunition to forces in the West, left and right, who want to shut Israel's economy down; and the payback if any would be vassalization to China.

This reminds me of the time I tried to play CK3 starting as a Jewish vassal, took over most of the Middle East and then got annihilated in a mutual jihad + crusade. You start out with not many alliances, and they get thinner every move you make, considering the whole world wants to annihilate you from the start. Perhaps (hopefully) I'm a lot less wily than the actual Israelis.
Open sourcing the algorithm would be such a huge boon to those wishing to game it. Those with the sufficient compute resources could run billions of variations of Twitter activity to perfect their messaging to get it trending. It'd be an arms race for those with enough money to keep up. Any chance of anything ever making it into trending in an organic way would be lost.

For transparency, it might be nice for Twitter to continually release their algorithm from a certain time period ago, say 6 months
Bi-weekly payments isn't much different from making one extra payment each year, either by double-paying one month or paying 1/12 extra each month.

I've had more than my share of mortgages and every one of them has had the equivalent of an "extra principal payment" line on both the on-line and off-line payment systems.
CDC issues health advisory about acute hepatitis in children
There is mypyc and Cython, which compile Python to high performance machine code.
> They can pay for better QoS, which will result in better QoS for their customers if they want.

Please, stop using QoS as a synonym for explicit prioritization. QoS strategies have advanced greatly since the 1990s, and the goal of providing better quality of service should not be used to defend obsolete non-neutral techniques. Net neutrality and QoS are not conflicting goals, and enforcing net neutrality is an excellent way to incentivize ISPs to transition to better QoS strategies.
Fastmail "app" is just a webpage.
California = PG&E = extreme corruption so no idea about any of this
Love it! I feel that this is one of those choices that might always haunt you if you go through configuration churn, but I'm about to clean up my dotfiles once and for all™, and it just feels so worthwhile to pair down those layers that I habitually fall into, (wm (tmux ($editor (files)))).
While yes, you could use SVG today, for performance reasons (not obviously for water, but more complicated stuff like an actual city) raster files are both more efficient in terms of computation time and more consistent in rendering with the only disadvantage of file size tradeoffs. Not quite a concern for computers and dedicated navi systems (in fact Google Earth and the Google Maps apps for iOS and Android* uses vectors, probably not SVG though), but other embedded systems don't really have the luxury of including a proper 3D or even 2D-accelerated drawing (there's a basic chip for raster rendering and relatively fast path drawing but city maps usually contains many geometric paths that overwhelm the graphics processor).

* If you know Android Go (not Android Auto), the Maps there are raster due to hardware constraints.
You can probably just go around a bit with a geiger counter while kicking up some dust, right? Seems like it'd give you a good idea.

*not medical advice
It can be 30+ minutes in traffic. I did the Emeryville<->SF commute once when offices opened back up, then decided I needed to move back into the city.
All of the sudden articles about the negatives of textile fabrics in the last 3 days feels like a Paul graham style submarine.
HEPA really isn’t good, the way hepa filters are manufactured and discarded is really bad for the environment. A better alternative is electro static and ionizing filters that are cleanable, like airdog provides. The tech isn’t new, but the industry isn’t interested in not making money on disposable hepa filters..
The Wordle hurdle: the pitfalls of setting puzzles
Is it not widely known anymore what a nasty operator Sandberg is? Once upon a time she was rather infamous.
I love K-9 Mail!
According to the README, it bisects. It doesn't matter much for me, though - the batches in our case were never big.

https://github.com/bors-ng/bors-ng/blob/master/README.md#how...
Also interesting: Japan vs. Nippon.
AppleScript was pretty heavily inspired by Hypertalk, and you can use that with Automator today.
Wow, the old guard of technology are going out hard.
I've done that too. Password resets.
Nah I meant opposite. Just incompetent and unaware, there should be a name for it ;-)
Just took a quick look through the spam folder and found spam (real spam, like fake fedex invoices or whatever) from:

pretty much anything vaguely related to crypto

edaboard.com

lastfm.com

pcbway.com

asus.com
JPEG-XL has a lossless mode, and supports custom bit depths and channel counts.
I really like Playdate as an art piece but I think that's the wrong way to approach open video games. Hackers are better off hijacking existing systems because they are just much more accessible and objectively _better_. For example, Steam Deck is mere double the price of Playdate and it's a full, powerful and open linux computer - I can't wait to see what people will come up with for that!
At first I read the headline and thought, huh, that's pretty sad, I guess too many people were being fooled by Onion stories.

Then I realized it was an Onion story.
You can't automate meetings. Nor can you make PHBs become logical nor reasonable. Dilbert comic strip is actually a documentary.
I started getting recruiter emails coming into my work inbox. I have never given out my work email to anyone. I don't use it other than for internal company communications. They likely took my first.lastname from Linkedin and just appended @companyname.com and there you have it. Is your work email something simple like that?
I really thought I was going to learn about tastie pastries in Europe. Boy was I disappointed
In fact, SQL (structured query language) was originally called SEQUEL (structured English query language).
That's not really a good definition of compiled. Interpreted vs compiled is very much more a continuum than it was however many years ago when these terms originated - you had compiled ALGOL and interpreted BASIC, and little in between.

Rather, you have to look at it like an attribute based categorization:

Compiled:

- types known at compile time

- limited runtime features like stack traces, introspection

- working closer to primitive data types

Interpreted:

- dynamic, with lots of indirection

- wrapped data types (eg PyObject) vs primitives

- rich runtime with stack traces, introspection, monkey patching
>> The messiness of it is ok.

I like this optimism. I like that it's expressed in a long form post that's well thought out. I like that HN exists. But HN is a conversation among passengers in first class on the Concorde. Most of the internet is traveling 4th class steerage with the water buffalo. As an elitist classist jerk, I have no problem arguing that they should never have gotten on this boat at all, and I can easily see that Mark Zuckerberg feels the same way - the difference being that he's happy to profit from their misery.
> People rightly so have distrust for results coming out in fields they don't have good knowledge in. Without becoming an expert yourself it's very difficult to know who or what to trust.

A problem here is that there are fields of science that are almost certainly bogus in themselves. One very likely candidate is nutrition, which seems to be fumbling in the dark and has a long history of producing worse recommendations than doing nothing (e.g. replace fat with sugar). More controversially, the entire field of economics is seen by some to be very suspect from a basic foundations view.
With SMS, you can reply with STOP and it should take you off that list. Repeat for a few campaigns and hopefully you are done for that election cycle and get less/none in the next cycle.
There are a bunch like AliExpress, eBay, Paypal and kickstarter where 3rd parties get your email address too (or used to), so you don't know which one leaked them. I tend to change the email address every few years when it gets too much and block the old ones after a while.

I suspect that most of the entries on the list got hacked. There are a few exceptions where companies do not honor unsubscribe requests and keep sending you emails or flat out sell your email address.

Here's a list that was collected over many years:

- Cory Doctorow's mailing list (twice)

- bitcard

- Achatzi, CSV direct, easynotebooks, foto-erhard, hivilux - (german online shops)

- dcemu, gbadev

- Dropbox

- funcom

- gawker

- Kimsufi and OVH

- GoodLuckBuy

- Mails listed in WHOIS

- Mails used in Yahoo groups (RIP)

- MiniInTheBox

- monster.com

- moneybookers

- pianostreet

- Usenet (duh)

- Typepad

- UnternHammer
You are right. The real quote would be:
studies suggest that Omicron-specific boosters offer no advantage over a third dose of current vaccines.
I didn’t really connect with any of these objections. Python type hints are very permissive and you need to turn them up in strictness to get enforcement. No big deal for me.

But moving between a TS and Python codebase, I just find TS much easier to work with. Maybe it’s that type bindings are more widely defined in libraries (though typeshed has quite a few now). Or maybe it’s something about TS being easier to define type vars / infer types in my IDE? I can’t really put my finger on it.
In typical Onion fashion, they have been tweeting all day about how they are banned from Twitter:

https://twitter.com/TheOnion/status/1517215456985235462
How else would it be done, is the question.
> mindlessly watching TV

Also childish.

> going to sports games

More teenagy than childish, but still just as bad.
Type systems are great for catching representation errors.

However, the important errors that I make are "kind" errors.

Type systems can verify that you're adding two ints, but won't tell you when you add the number of bananas to the number of oranges. Of course, both numbers contribute to the total number of snacks.
Second alien world detected in the planetary system HD 83443
Wasn’t the issue with the ionizing filters the production of ozone? I recall that being the reason the Ionic Breeze units fell out of favor.

How is Airdog any different?
I get most spam coming to my main personal email address. I've signed up for exactly nothing using it - but other people have sent me ecards (remember those?), shared things from random apps, and/or presumably had their contact lists stolen.

I had always intended to do some analysis of my catch-all address spam, but there's just so little of it that it isn't that interesting. A quick glance through my spam folder shows these have been hacked or sold emails:

Dropbox, Canada Computers, Last.fm

I've also seen a couple forum accounts in the past, but nothing else noteworthy.
Security Issues with ODoH