skysight-inc/HackerNews huggingface dataset:
I have a pretty robust, well-tested solution for advanced SQLite ALTER TABLE here: https://sqlite-utils.datasette.io/en/stable/cli.html#transfo...
As an american, it is unlikely (if understandable) that you know how your immigration system works neither in paper or in practice. As an american who has never lived abroad, you most definitely don't know how other immigration systems work. Your understanding of immigration has been molded by the media you consume, both news of whatever slant and movies.
I'm a massive Science Fiction buff and bought the game, played it for a few hours and decided it was not for me. I think it's because I couldn't relate to the factions, if that makes sense.
Listen to his podcast (Against the Rules) from today and you can hear his take on the trial.

I also recommend his interview of Matt Levine (5 episodes ago) to get a good TLDR of the book. Here's my TLDR on the book after finishing it, which mirrors Levine's closely: Michael Lewis sees that Sam thinks he's above the rules and acted with wild disregard for risk because he thought he was smarter than everyone else. It was all illegal and will land him in jail for a long time. But, he did it because he thinks he's the smartest man who ever lived and has the best intentions, not because he sees himself as a crook.

It's a minor nuance, but an important one. It speaks more to the ego of founders and children of privilege, than to a criminal conspiracy. The articles you've read don't like that nuance, and call Lewis soft.

>What happened there ??? The guy who calls out a lot of fraud, now can't see it?

He calls it Fraud many times in his book and in his podcast. He just doesn't call it theft.
Absolutely. Walmart used to have a policy of refunding gift cards in cash. You'd buy many at one location, and return them at another. Less trackable. Gift cards are also used quite regularly in human/sex trafficking to control the victims.
> The point is that Taiwan claims to be the legitimate government of the whole of China

Not since the early 90s.

Well actually it's a bit more complex since there are multiple parties and they disagree, and there's some nuance (e.g. "one China" but without actually defining what that means, exactly). But "Taiwan claims to be the legitimate government of the whole of China" is woefully outdated and incorrect.
It does just not very well. Maybe the pine sap is more interested in being stuck to pine sap than soap?

There are things that are much better at cleaning non polar molecules off of surfaces, alcohols, gasoline, lye, brake cleaner etc, but they’re not great at cleaning your hands because they strip the lipids that make up your skin off.
Well, it can brrr faster because the fuel is detonating only when the plugs fire so the timing can be better controlled.
I only have two data points (well, three now with OP): but I susped this is on purpose.

BR and CN both are painful for me for this reason. Try to use a credit card, they will try to SMS a phone number I haven't used in my bank for 3 or more years.

Now that OP tells us about IN i'm starting to see a pattern: for a fraud and insurance company, or being realistic, the payment processor middle man who offers those services at a loss, making their client lose a few sales while pushing their customers (you) to instant electronic payments (BR:pix, IN:UPI, CN:IBPS etc) is a much better deal (for the middle man)!
I have an instagram account, somehow... I almost never use it. Does this include me in that count if I use it to view some link that ends on Instagram?

Twitter, on the other hand, is one of my regular hang-outs.
I do not enjoy the default economic perspective that when it comes to artistic creation, capitalism will necessarily force all the worst possible negative incentives.

Least of all, if using Twitter as the example, for reasons I will return to.

The history of art and creation is filled to the brim with examples of creatives that refused to fold to the mold, to embrace the trends and incentives of the economy, and stuck to their convictions regardless of the monetary disincentives to do so.

YouTube and TikTok each have stereotypical extremes that gravitate for attention but each have brilliant, unique, relatively long-form (Hours+ on Youtube, 5-10 minutes on TikTok) content that is are basically the singular vision of one human sharing their perspective in a way that does not exist anywhere else. (I like many of you prefer to consume written word, but there is of course a lot to be said that seeing a person speak, and all their emotional intonation contributes something too).

It's hysterical to me that the stereotype for TikTok is still "teenagers dancing" or "gen z making funny faces", when for me it's Philosophers, Lawyers, Activists, Scientists, Technologists, Adventurers, all sharing their passions and perspectives in deep nuanced interesting looks into subjects I know nothing and everything about.

Twitter itself is interesting because this all used to be true about it too, and to a much more constrained way can still be found there. But by and large it was deliberately destroyed by Elon Musk, and the only "creators" that are left are ones that are absolutely there because they are salespeople selling themselves, or basically get rich schemes masquerading as tech content (NFTs -> Generative AI, but in general also a lot of "here's how i made money by selling a course on how to make money")
>> Didn't they just legalize unleaded avgas very recently?

More specifically, I believe they certified that a particular fuel as suitable for use in ALL engines that previously relied on leaded fuel. Until that happened there was a somewhat legit concern about banning leaded fuel. What people are afraid of now is a monopoly on the new fuel leading to higher prices. But there's already a near monopoly on leaded avgas.

It would be really cool if someone developed a new aircraft engine suitable for replacing all the old models and able to run on a wide range of fuels (this may actually exist). But even then its a slog to get that engine certified for all the planes you'd want to use it on.
Imagine being told you're very smart since a young age and internalizing it so heavily that you think you can talk your way out of everything. What you really end up internalizing is that other people are stupid. And this is why Sam is going to prison. Other people really aren't that stupid. Some of them are even very smart and competent, like the team prosecuting this.
>had to compete with spider-man

Yes, a much more popular IP-based movie.

I understand it's frustrating to accept that the viewing public prefers IP over original movies, but it's just true. Studio movies as audiences expect them (and increasingly TV) are just too big and expensive to be the medium in which we workshop new ideas. You'll often get new ideas from blank-check directors, animation, or indie films, but that's it.

Now, keep in mind, looking back at some of the greatest movies of all time, good movies were always IP-based, it was just less noticeable:

Godfather (book)

Gone With the Wind (book)

Lawrence of Arabia (book)

Wizard of OZ (book)

The Graduate (book)

West Side Story (Musical)

2001 (An expansion of an existing Arthur Clark Story)

I could go on, but you get the point.
> sending an OTP to my US number (and US number alone) for any transaction, making it impossible for me to move money when abroad

Strictly speaking it doesn't make it impossible. You have made a choice not to pay roaming fees while using your USA number while abroad.
Checkout https://insanelygood.tools/ideas for ideas
It's not the point of this article, but the top line graph captures the incredible shift from coal to gas in such a short time: https://www.washingtonpost.com/climate-environment/interacti...
I have and it works really well. This is less about SQLite not being able to handle it -- because it does -- and more about reliability and availability of the overall system. I don't want one server being down to affect the entire system.
I know someone who worked on MyQ a few years ago. Management was focused on money and then the company got bought by Blackstone. So despite all of the PO's and developers desperately wanting to build a good product that just opens up people's doors, they were forced to put in a ton of dark patterns and implement dumb strategies.
Thanks! Came to this thread hoping for something like these. They look useful!
This problem is not specific to cocoa.

The seeds of many plants concentrate lead and cadmium whenever they are found in their environment, so with most seeds and nuts there is always a risk of high lead or cadmium content.

In most countries there are legal limits for the lead and cadmium content of seeds and nuts, but the limits are much more lenient than for other products, because there are few sources of seeds and nuts that are not affected, so setting low limits would eliminate most products from the market.

So the only recommendation is like for fish, which should not constitute a too large part of the food due to the risk of high mercury content, also most seeds and nuts should not be a too large part of the food, due to the risk of high lead and cadmium content.

The pollution caused by human stupidity has converted some of the healthiest foods into health risks.
We wouldn't have to pretend if the Long Tail idea was working. It seems Long Tail doesn't work. If there are 10 books expressing 10 distinct valuable insignts, suddenly comes along a youtube video which combines all these 10 ideas into a nice story and it gets the views and money. Same behaviour as the Netflix Hackathon behaviour, where participating teams merged to combine their strong ideas to win the prize.
He’s also employed as part of the Remix team, that’s part of it too
FSD does have a merge right rule, but it can be turned off. The sort of person who'd do what you describe sounds like someone that would turn it off too. :facepalm

Of course, it could also have been one of the cases where the car just navigated poorly and thinks it needs to be in the left lane for some reason. The vehicle's lane selection is not great, IMO.
Note that this is about large tech service providers “taking this into their own hands.” The basic problem is that a lot of these companies deal with people who store their card information and then use an insecure password or so, or reuse the password at a different website... Someone else gets into the account and requests a transaction to a new address.

Also fun story about how your advice doesn't always work, I was locked out from my money multiple times on my honeymoon in Greece despite repeated calls to the bank, repeated unlockings of said account, “hi I am actually standing at an ATM in this bank branch, can we track this account lockup in real time?”... I think with all of the time on hold I actually might have spent something like 20+ hours in the trip trying to debug it over the several times it happened.

When we finally resolved it, I'm not 100% sure about the explanation, but it was something like “the person you called a week ago put in country code GE for Georgia rather than GR for Greece, and that is the first place everybody else who has serviced your request has probably looked, but they all probably thought GE was right because you have to memorize that DE is Germany and so people get confused real easily...”
I'm not against progress, I'm just against the breathless enthusiasm for the magic of science to solve all problems if only we put our blind faith in the Midgley's of the world who tell us that tetraethyl lead is safe, that chlorofluorocarbons are fine, that there's nothing to worry about!

Arguably those things were effectively "safe" in a laboratory setting and when testing at small scales.

It's not that I don't understand the technology, it's that these things get applied in ways we don't intend but could anticipate. Maybe today's RNAi solutions are provably safe, but what about some AI concocted future version which, at least according to the opaque AI model, is safe, too, yet, uh-oh, turns out maybe not?

Nothing is truly safe without safeguards, and if there's any industry that shows it's singularly uninterested in giving even the slightest of fucks it's the pesticide industry.
> With a handful of exceptions, single-engine prop planes are only certified to run on 100-octane leaded gasoline.

This was true up until last year, when G100UL was approved as a drop-in replacement for 100LL. It does require a STC and the associated paperwork, but this is apparently pro forma and quite cheap, and doesn't require any modification to the aircraft apart from some placards. The problem, of course, is that G100UL isn't really available anywhere yet, while 100LL is still ubiquitous.
Currently I'm at the 3rd attempt to unlock my account, let's see, hope you're right.
HACK (with the green-ish computer chip icon) is also amazing if you want something to "have"
> There is no nuanced discussion about this. Theft and stealing are legal terms

I think you missed OP's point; those calling copyright infingement "theft" (or "stealing") are being disingeneous to try and gain support for their argument - they're conflating legal terms about ownership with the idea of copyright infringement and they are not the same as theft/stealing include the concept of depriving the owner the use of whatever it is that was stolen.
Literally is literally a point. Figuratively is a point only figuratively, literally it is a continuum. If you're not using literally to literally mean literally, you are literally using it to mean figuratively.
yet most fat adults were not fat children, though in another 30 years that will no longer be true; childhood obesity was rare until this millennium
- At 400Kw, you're using DC, not AC anyway (whether three or single phase). Three phase is useful for faster (and more efficient) L2 charging (e.g. in the 10-50Kw range)

- CCS type 3 is compatible with existing Tesla vehicles (it's a software update)

- Tesla superchargers max out at 250Kw because they have all been 400V, whereas porche and etc are all 800V. The cybertruck is 800V so I expect faster chargers on newer Tesla vehicles
If I were the CIA, I would want to run a bunch of Tor nodes just to snoop on people.

Of course, if I were the KGB, or MI-6, or the Chinese State Security Ministry, or the DGSI, etc., then I would be doing the same thing.

Assuming that's true (and it may not be), I'm curious how much security would be compromised with many different adversaries instead of just one adversary.

Can anyone shed some light on this for me?
Being pedantic, but turbo-prop planes use a jet engine to turn the propeller, and so use jet fuel.

That's going to be bigger twins and prop planes like the Pilatus
Have you benchmarked your solution with the plain Write lock? Can share, if you have done so?
> unhinged her jaw and ate [him].

I think that must be a reference to Python.
Lately I've been using HeidiSql which supports postgres, MySQL, sqlite, and others
Counterpoint: greed has made Disney and others push copyright terms to damaging extremes that we all pay for. It's unethical to give them money.
Unleaded avgas started being approved in 2021, and is now generally approved for all piston aircraft [1].

[1] https://www.aopa.org/news-and-media/all-news/2022/september/...
It is a bad thing if you can be fired if someone digs up your 10 year old tweets.
That would be interesting, though this link requires an account.
Link doesn't seem to be working
Soap in very small amounts is nontoxic. In larger quantities soap will absolutely cause a great deal of discomfort, vomiting or even result in chemical burns in your digestive tract. Soap poisoning is absolutely something people get concerned with, especially those who have kids who are a little too curious.
Yeah. It's very unlikely to get something these days. The last person I can think of that got a hereditary title (not necessary the last person to get one, just one that I remember) is Dennis Thatcher getting a baronetcy.

And wikipedia tells me: "It is the only baronetcy to have been granted since 1964, and is one of only three extant hereditary titles awarded outside the British royal family since 1965."

Anyway, I'll keep up my gym going etc just in case I am inside an orphanage when it comes under attack.

I'm not sure though whether the fact that new hereditary titles not being created is more or less egalitarian? It now means unless your family did something 800 years ago you're out of luck.
This is very promising.

The benchmark results are great, with the exception of the single core speeds. We just need non-Apple ARM to catch up in the single core speeds across the board -- they seem particularly slow here compared to everyone else. Even Intel and AMD I think outdo Apple ARM now on single core.

I think it is a bit of a shame that Apple's top of the line M1/M2 go to 24 cores and the rumoured M3 CPUs only go up to 32 cores at most. I think the Ultra should have 64 cores personally. Rendering and video people want that.
> I'm literally dead right now

Is that figurative speech?
Safety regulations are written in blood. There should be a long and careful process before any so-called improvements from modern technology are forced upon us. In making new kinds of gasoline, chemical engineers should really consider safety and ethics. And every one of them should first be required to study the humanities.
> we have a very small cluster comprised of a main PostgreSQL instance and four replicas

As you said, it depends on what you want:

- If you are okay with losing data in the event of a failover, then a simple setup is fine.
- If you want lossless failovers (i.e. not a single transaction is lost), then that's hard.
- If you want entirely automatic failovers, that's also very hard.
- ...

My experience stems from MySQL, and not PostgreSQL, so this may or may not apply to pg. I wrote about my experience in this blog post: https://blog.heckel.io/2021/10/19/lossless-mysql-semi-sync-r... --- TLDR: Not losing data with MySQL is really really hard.
LLM Inference with VLLM and AMD: Achieving LLM Inference Parity with Nvidia
I mean this is kinda what I’m trying to get at. You need to build all this bespoke infra in order to fit SQLite into the round role where a database with native replication is a far more proven and battle tested solution.
They don't "need" lead any more than pre-70s cars "need" lead. They were designed to run on leaded fuel, but there are lead replacement additives which are able to fulfill the same technical requirements. TEL is just cheap, effective, and well understood for legacy applications. It isn't the only option to boost octane, by far.
> Culture has simply changed, and (bad) food has gotten to be incredibly cheap and easy to access.

It’s Gresham’s “law”: “bad money drives out good”, but applied to food.

https://en.m.wikipedia.org/wiki/Gresham's_law
There are 100 RON fuels without lead.
There's also distribution problems. Jet fuel aside, most airports only have one tank for servicing avgas. Once they switch over to non-leaded, now they have a customer base that may not be able to buy from them. Those revenues go to fund the airport operation.

There's going to have to be a concerted effort to fix type certificates and fuel distribution all at the same time. A slow effort is going to be more problematic.
Well, colors can be both pretty and informative.

Had to take Color Theory to get my BFA. We learned things like the "speed" of colors: yellow is the "fastest" and purple is the "slowest". Only a little yellow is needed to balance out a lot of purple. Same for balancing the other colors. You use these balances for guiding the eye (lots of yellow on a purple field).

When you keep this in mind, diagrams or not, then the output will be "pretty" (not jarring) and "informative" (guiding the eye to the most relevant info).
Actually, after googling the Thatcher Baronetcy above, I could be Prime Minister and then grant myself a hereditary honour when I leave office. Best of both worlds!
ah, i see. maybe so. agree to disagree about django being bad for a career.
I like the idea of generating recipes with AI. I dislike the idea of using text as a medium for it.

I want this AI to be considering whether what I ate this morning had enough protein, whether this ingredient is on sale and in stock nearby, or whether it's in my fridge and what's the expiration date on that. Is there a plan for the other half of the cauliflower? etc.

The last thing I need in a meal is appealing marketing copy for it.
Anything where you don’t want downtime. VM goes bad for some reason - what do you do?
Yeah, you should wash your hands for lots of reasons but I'm not sure COVID-19 is a particularly relevant one. Much more relevant is, say, fecal bacteria, which will make you sick.
It's worth reading Judge Kaplan's earlier rulings related to the "advice of counsel" defense. As the judge writes, you can only invoke this if you "made a complete disclosure to counsel," right at the beginning, of what you planned to do. Sounds like the kind of situation where, once on trial, you'd need to produce an original "Memo to Lawyers" spelling out all of the intended FTX/Alameda games.

Once that's on the the table, then you need to have asked the lawyers: can we do this? And then you need a clear response from the lawyers (i.e. a memo) saying: "Yep!"

SBF's testimony, peeling away some of the word haze, amounts to: "I think the lawyers were loosely aware of at least some of this stuff and I don't exactly remember them telling me we couldn't do it." That's miles short of the standard (Kaplan-summarized) test.

https://storage.courtlistener.com/recap/gov.uscourts.nysd.59...
> Maybe he was never really calling them out, but just liked the story.

Hasn't Lewis said as much?

I haven't read his books, but I think he writes about people that he basically admires. He doesn't set out to destroy his subjects.
> And FTX blowing up was a major event in the course of that debate, since it starkly illustrated the weaknesses of a moral philosophy that centers numbers and dollars over the kind of traditional ethical judgement practiced by other charitable movements.

Honestly, I think this just doesn't make sense (and I have no ties with EA whatsoever). You've written it nicely, but it just doesn't follow. It makes no sense to judge a movement by its worst possible member, and it doesn't make sense to say that the overall philosophy doesn't work when one guy obviously didn't follow the philosophy and then had it explode in his face.

The argument, to me, feels akin to "well, vegetarians think they're morally superior, because they don't kill animals, but just look at PETA! PETA does this horrible stuff where they kill animals in shelters[1]." And then perhaps follow it up with "this shows the weaknesses of a moral philosophy that centers around saving animals lives..." but it doesn't. PETA doing shady stuff doesn't illustrate any philosophical failures any more than SBF doing shady stuff. If you want to address the philosophical failures of EA, you may, but I don't see any of that in your comment.

> but it immediately and prominently shifts to arguing about how EAs are great people who will donate their kidneys to strangers

Is this so surprising? Look at the immediate and negative response that EA receives today. Of course any mention of EA would want to be brought with a caveat that "hey, EAs do some good things too, you know - we're not all SBF!"

But I question if your interpretation of the article is even correct. Simply Ctrl-F "effectiv" gives a bunch of hits in section IV, and then no more hits for the rest of the article, except for a stray one in section VII, which was essentially my impression when reading the first time. He talked about it enough to address the controversy, then moved on. Like a reasonable person, not an author of "promotional religious material".

[1]: Actually true, btw (not that it has any bearing on vegetarianism): https://www.theatlantic.com/health/archive/2012/03/petas-ter...