skysight-inc/HackerNews huggingface dataset:
I spent time researching this a while back.

The duplicate row issue is part of why I don't use MINUS for table value comparisons, nor RECURSIVE like the original article suggests (which is not supported in all databases and scarier for junior developers)... You can accomplish the same thing and handle that dupes scenario too, with just GROUP BY/UNION ALL/HAVING, using the following technique:

https://github.com/gregw2hn/handy_sql_queries/blob/main/sql_...

It will catch both if you have 1 row for a set of values in one table and 0 in another... or vice-versa... or 1 row for a set of values in one table and 2+ (dupes) in another.

I have compared every row + every column value of billion-row tables in under a minute on a columnar database with this technique.

Pseudocode summary explanation: Create (via group by) a rowcount for every single set of column values you give it from table A, create that same rowcount for every single set of column values from table B, then compare if those rowcounts match for all rows, and lets you know if they don't (sorted to make it easier to read when you do have differences). A nice fast set-based operation.
Hi Peter, just wanted to say thank you for navigating my complicated I-485 case and helping me get my green card!
>Its become clear that it was a bit of a liberal pipe dream saying [...] that conveniently meant you didn't need to address systemic issues and stone wall any attempts at grander change.

Really? I thought liberals were all about addressing systemic issues (eg. systemic racism), and all about "grander change" (eg. defund the police/ICE, eat the rich, etc.).
They had been doing this before that point. Altera had been on Intel's foundry service since 2013.

5k wafers after ten years of foundry service is pretty abysmal.
What's the usual cost for a company to change someone's status from a TN visa to an EB3/EB2 greencard? How long does it usually take?
The number of H1B visas in relationship to the entire market is just a drop in the bucket.
Software/app testing (manual or automated) is always a killer app for stuff like this. And my anecdotal observation of HN over the years is that most of HN doesn't get the point when it comes to anything that could be a killer testing tool. Running browsers on desktop OSes in the cloud? I don't get it! (My first startup) Robots to automate tapping on phones? I don't get it! (My second startup)

I'm not surprised people don't understand the value of something like Cophone. It doesn't mean the value isn't there. It just means they probably don't spend enough time dealing with software testing issues to see the potential.
yes of course. this is about negative feedback (https://en.wikipedia.org/wiki/Negative_feedback) in terms of statistical infection. People who infect each other and who will despite remain loyal to each other will not spread the infection. The child might and as well might not get infected (https://www.who.int/teams/global-hiv-hepatitis-and-stis-prog...) but this is transmission to the next generation. Also HIV positive parents could consider refraining from further procreation, once they noticed it (the infection), while maintaining their closeness and loyalty. This could break the infection positive feedback loop.
I'm actually just talking about the expansion joints! Like one or two places that are metallic, the rest can be concrete. I havent biked over one but I expect that they are one of the least hazardous of the hazardous terrains - I'm comparing them mentally to pot holes and rail lines (not sure the right for them, street car lines that as it turns out are perfectly shaped to get a bicycle tire stuck in while at speed).

Just between you and me, fuuuuuck those metal grates on bridges. I'm grateful that I have almost always had the opportunity to get onto a good sidewalk/path instead of navigating a bridge with an 'interesting' surface.
Redis transactions [1] also apply pipelining, but AFAICT there is no practical way to use them for implementing generic RPC.

[1] https://redis.com/ebook/part-2-core-concepts/chapter-4-keepi...
Why is DNS still hard to learn?
COMMAND.COM is a far more closer “relative” to SystemD than AUTOEXEC.BAT.
Look inside the world’s largest 3D-printed neighborhood in Texas
> Think the end of this line of reasoning is that small towns have no reason to exist, so let them go?

Correct.
> One way to look at it, how much art did they produce? Lots of art? Food was probably pretty easy to come by. Scratch a line on a log? Those folks worked _hard_ to survive.

That's really only applicable to desert civilizations and those in colder environments where decomposition is arrested, which were unfortunately the harsher environments. Humans in the tropics are more likely to use wood and other organic materials to produce art, which don't survive for very long.

The oldest wooden art is only 9,500 years old [1] whereas the oldest stone tools are over 3 million years old [2]. The oldest wooden tools, on the other hand, are hundreds of thousands of years old for spears and tens of thousands of years old for axe handles.

[1] https://en.wikipedia.org/wiki/Shigir_Idol

[2] https://en.wikipedia.org/wiki/Lomekwi
Yep. There are very few true villains in reality. Just a lot of people with different values and priorities. Even Vlad Putin probably thinks he’s on the side of the angels.
He's technically saying "I am going to berate you if you criticize X"
I have used Sorbet in my web framework. The method signatures can be tedious to type out sometimes, but it helps a lot when refactoring code. I feel more confident that my changes will work. It's not as flexible as TypeScript, but it's pretty good and has saved me from mistakes many times. The language server helps a lot with autocompletion so I don't have to keep every little detail in my head all the time. Sometimes I have to structure the code a little bit different just to make Sorbet happy which is annoying, but I've also been able to replace huge parts of the codebase quite easily.
There is not currently any specific "pathway to citizenship" designed for people who are currently in the country illegally. They would have to qualify for a green card on the same basis as anyone else, then apply for citizenship after that.

However, they often are not eligible to do so because of their illegal prescence. If one has been in the US illegally, as an adult, for more than 180 days, they have a three-year ban. After one year it becomes a 10-year ban. This applies to both visiting and immigration. They have to return home (or another country) to serve the ban before getting a visa to return.

One notable exception to this rule is marrying a US citizen, but only if the initial entry was legal (i.e. visa overstay, not border jumping). Being a parent of a US citizen also works, but the child has to be 21 first. Being a parent of a US citizen under 21 has no immigration benefits.
I'm having trouble imagining what you think could cause that. Katrina itself was about as devastating as flooding can get without being permanent, and we didn't lose New Orleans (nor has it ever even had half a million people in population). A nuclear bomb didn't even cause us to lose Hiroshima.

Seemingly, the only thing that could do this is permanent sea-level rise (not a storm surge) on the level of Katrina or Sandy, but if this was possible, it wouldn't be local and we wouldn't lose one coastal city. We'd lose many.

Have we ever lost an entire city other than Pompeii? Krakatoa killed everyone on Sebesi, but I don't believe had any permanent settlements of its own.
Where is the Flash porn?
Pretty neat, but I wish they would have emphasized safety a bit more and put up a full sheet of plywood behind the target.
Is the idea here for SQLite to move from DB level locks to page locks and finally to row level locks?
Thanks for the clear answer! is proving the years of experience usually difficult? e.g. references from 12 years ago can be hard to get (although I have those 11 years ago myself).
I think it’s being able to have stuff in /etc/init.d that show up as services in SystemD.
Your code seems to be relying on logical events to reach you in order from the postgres server. That doesn't always happen, and if to that a client restart follows you effectivelly loose data. How do you deal with this?
Views of China ‘broadly negative’ in India and Brazil
I take it you don't use Apple products, because there are a bunch of 3rd-party apps out there that use the Face-ID or Touch-ID all the time. For instance the password manager 1Password uses biometrics to get into the app, if you choose.
What restrictions/things to know or consider are there for Canadian founders who are on a mix of TN/H1-B visas?
or chicago, in general (where i'm originally from)
"reflexively engage their skepticism/critical thinking muscles upon hearing Save-The-Children-and-Stop-The-Terrorists rhetoric"

Not part of human nature. Save the children/Rethoric is embedded. Reflexive thinking has variying energy requirements and for most requires external kickstart, when possible at all

Forcing tor in all new network adapters is more feasible, which is saying much.
That's completely understandable, thank you for the answer! I'd love to try and help with at least one implementation for those languages, but there's a good chance that it would end up like the existing implementations due to lack of time.

Anyway, thank you for making it open source and for working on it all this time!
you don't have to be a perfect bastion of morale without any hint of hipocrisy to oppose something that is so blatantly wrong.

if we don't allow people who are contributing to the problem in any way or are benefitted by it, to oppose it, we are doomed to fail.
I believe it would be slightly more optimal if the knife only rotated 1/2 of a rotation. That's what I always aimed for when I was practicing throwing knives, based on the logic that less angular velocity would provide a longer "sweet spot" time during which the knife would be at the optimum angle for deeper penetration, so if the rotation speed was off by a little bit it would still be closer than it would be if the rotation speed was "off" by the same absolute amount but with a 3x-6x faster rotation speed.
As a fun data point, the capital of Sierra Leone gets more rainfall in a single month than the PNW gets in an entire year.

I was there in the rainy season, it rained harder than I ever imagined possible for ten hours a day, every day.
> Some of the best people I’ve worked with are getting passed over because they’re quiet and undersell themselves.

I think this was my biggest issue in the beginning after the layoff. There were a few interviews I had that went well until they asked me about my expertise with X, at which point I would get a bit cautious. In some cases, I found out they the company and I had very different definitions of “expertise”.
Thanks for the book recommendations. I've been looking for something interesting to read.
I will try this out later, I find spotify recomendations a pure torture. The best I got was old last.fm recomendations, while they still had streaming, then soundcloud and pandora. The best ones had dislikes, not just likes.
Unfortunately, that's outside my area unless you are asking whether a foreign national can raise money for his or her startup.
Damn those numbers are wildly interesting.
"That's a self-fulfilling issue, though."

It's not self-fulfulling. The state of the Gecko codebase and its performance is not _because_ Brave didn't end up using it.

"If no one is using Gecko why does Gecko have reason to improve performance."

This question is a valid question, but is unrelated to Brave which does not use Gecko.

"If they had good performance engineers it wouldn't matter if they picked the "worst performing", because they could work to improve it and prove they had good performance engineers."

It would matter, because they would have chosen the most difficult task which is a sidetrack from the reason they were making a fork of a browser in the first place. The focus of Brave is not to improve the performance of a browser engine.
Adoption is gonna be difficult. Many users don't care that much about privacy in general. So getting them to change their habits is a tall order. Furthermore, a lot of sites see TOR as suspicious and make the effort to block it/put them through captcha hell. I don't see a critical mass of users dropping convenience for the sake of something they don't really care about anytime soon.
There are ways to track which orb originated identities and it would be easy to mass remove a known compromised orb. It would result in some people needing to be rescanned but it would ultimately make this extremely high effort attack vector not very fruitful. Additionally any stolen orb would be immediately remotely blocked so this would take coordination with an orb operator who would also be banned for life
I'm currently on a H1B visa with a company. Due to family reasons I intend on going back to my home country and spend some time with family, which means I'll have to quit work. Is it possible to come back to the US, assuming I'm able to secure a job with a company? And will this have to be done before the expiration date of the H1B document?
> There is no motive for truth

This also ignores the larger question that has been a known issue for at least 2,000 years: "Quid est veritas?"
>expert witness against someone

The state is not a "someone". The state is in an extremely privileged position legally, and as such is bound by the First Amendment which you and I are not.
This will also probably follow a power series too. So it isn't unlikely that you could deanonymize someone given just 2 courses. Not much information is needed to encode a lot of things.
Recycling isn't really a pickup problem but a commodities pricing and market forces one. Most of that stuff is worthless because it costs more to recycle than it does to make them new. So we end up subsidizing them for the feels while ultimately accomplishing nothing.

Some materials are worth it (aluminum) but a lot of it just gets dumped in poorer countries after sorting. It's just a way for first world nations to export their waste streams while lessening consumer guilt over single use items. Because environmental protections differ so much between countries, it's often cheaper (but environmentally worse) to export those materials than to just bury them here in modern landfills. Problem is, once they're exported, our environmental regulations no longer apply, and they're free to be dumped in the waterways or in poor villages.

I'd say overall recycling is a scam, and making pickups easier would actually worsen climate change by encouraging individual pickups (Doordash style) instead of a shared route on fewer recycling trucks (UPS style).

That said, the waste management industry as a whole (bigger than recycling) is interesting, like landfills and incinerators and mob contracts and zero waste diversion quotas etc.

Climate tech is booming though, everything from batteries (especially) to solar PV "balance of system" components like inverters. There are also niche companies working on algae and hydrogen and of course wind, etc., but by and large solar PV seems to have won out in terms of dollars.

There are a few software companies working on streamlining the design and permitting processes, using a combination of aerial imagery and photogrammetry plus human design to automate rooftop solar module (panel) layouts for optimal production, and making applying for permits easier. Google's Project Sunroof is a good example of the former tech, and Aurora and Opensolar are examples of more integrated design project management solutions.

Beyond low hanging fruit like that, there are of course the much harder problems of battery chemistry (and storage in general) , EV charging networks, nuclear acceptance, megahydro removal, micro hydro for communities, etc.

Check out Appropedia.org sometimes for a wiki of DIY sustainability stuff that people around the world are tackling. Might give you some ideas?
There aren't even 900 hours in a month. That's 765k for 900 billed hours, and you have to imagine that a good chunk of unbilled hours also occurred. So maybe that's for the equivalent of 8 months of boring work. Not continuous 8 months either, you have to schedule other things between prepping. A lot of money. But not for a billion dollar lawsuit.

As for "who can afford this" is a company worth tens of billions suing over a major product line vs a trillion dollar company.
I am honestly not bothered by having an account, it's just that sometimes it would be much faster to fill in entries on the computer and my current app only has mobile variants and slow animation transitions. It can get infuriating.
So they're working to make users aware of misleading ads, but they've dismantled efforts to make users aware of misleading tweets?

I don't know how this got to production. Advertisers won't like it and they absolutely need advertisers right now to keep the lights on (even shitty misleading advertisers). I wonder how long it will last before Musk kills it.
Great achievement. To be honest I wouldn't recommend Capnp. The C++ API is very awkward.

The zero copy parsing is less of a benefit than you'd expect - pretty unlikely you're going to want to keep your data as a Capnp data structure because of how awkward it is to use. 99% of the time you'll just copy it into your own data structures anyway.

There's also more friction with the rest of the world which has more or less settled on Protobuf as the most popular binary implementation of this sort of idea.

I only used it for serialisation. Maybe the RPC stuff is more compelling.

I really wish Thrift had taken off instead of Protobuf/gRPC. It was so much better designed and more flexible than anything I've seen before or since. I think it died mainly due to terrible documentation. I guess it also didn't have a big name behind it.
USCIS applies a 3 to 1 rule.
I don't see 8 => 2. I see 3 => 1 from Peter and 4 => 1 in this answer.
Interesting, do you have any sources for this?
This doesn't seem to be true. A quick search on their home page shows a bunch of articles from 2021 and 2022. I caught a few 404s and messaged Alexandra, she says this is some bug and she'll look into this.

Btw, using this opportunity to remind everybody about her donation page:
https://sci-hub.ru/donate
By the 90s everyone in the Northerhn hemisphere got a decent TV with instant
tuning. Once you tuned the channel and set it up to a button on the remote or the TV front panel, things went as fast as Linux switching TTY's todays. No joke.
Elon Musk’s X Corp. sues Israeli company over data scraping
It's not even a secret, look at the Tor Project's funding sources (public tax record). State Dept & DoD were their primary funders last time I checked.

Hypothetically, if the USG wanted to produce "official" backdoored TOR clients (e.g. only served as prebuilt downloads to IPs geolocated in Iran, etc to make detection difficult), they are in an excellent position to influence that work. And as the story of Julian Assange makes clear, that should concern anyone who purports to care about privacy, human rights, etc.
Happy to see this futzing around on a JH7110 based board! :-)

Because this SoC is used on 3 boards that I'm aware of:

StarFive VisionFive 2
Star64
Milk-V Mars

(please add if I missed any)

All friendly priced, similar specced, and possibly more to follow? Turning many issues affecting these boards into a kind of 'smart cow' problem: fix some issue, and chances are it will trivially translate to other JH7110 based boards.

Not that I'm advocating to see this SoC everywhere! But having more affordable, Linux capable RISC-V boards in the hands of developers, should provide a nice boost for the ecosystem.

(and bringing up a RTOS like NuttX shouldn't hurt attempts to bring up other OSes - whatever flavour)
Many older commercials, even some from as recenlty as the 90s, would be considered offensive (or worse) by today's standards.
There are pinball distributors that will do short to medium term rentals, a few hundred dollars for a couple months. Medieval Madness is probably in short supply for that, but there are quite a few other options for newer games, often ones a few years old that just came off a public location. Renting could be a way to go if you really want it but can't swing ownership.
Just use Erlang or Go. Even Java... Python doesn't hold a candle to any of those languages when it comes to multitasking.

The most important advise anyone could give on using Python's anything, especially stuff that has to do with concurrency is to stock up on mood enhancing drugs, else they'll probably cry themselves to death out of despair.

I don't understand why a company like RHEL would publish such a low-effort article. But, if you genuinely needed and advice on how to use Python's multiprocessing, and for some screwed-up reason you cannot use a decent language... well, never use plain multiprocessing.Process. Use multirpocessing.pool.Pool: https://docs.python.org/3/library/multiprocessing.html#multi...

And if you wonder why would you do that... well, obviously the later builds on the former. And, trust me, it doesn't improve the former in any way. But, it saves you some work. Virtually any task you will end up doing will be done with process pool in less code. Most importantly though, it's a "recognizable pattern" -- it's something that someone who ate from the garbage pile known as Python has learned to recognize in code and to treat accordingly. Code randomly peppered with mention of Process or, worse yet, extending that class is a sign of lack of experience, and produces an urge to delete that nonsense code and write it afresh because nobody's got the time to deal with novice's nonsense.
> True but we're talking about juries who are essentially random members of the public and are far from guaranteed to spot a fallacy or buy that it is a fallacy even when pointed out.

In the US, at least, juries are generally less sophisticated than a random sample of the general public; anyone who displays significant world knowledge or critical thinking during jury selection will be removed.
real world boston was the only reality tv show i watched more or less all the way through. it was fun while it lasted but once it was over, reality tv felt "done" and i didn't really want to watch much more of it. i still don't understand the lasting appeal tbh.
An AI prompt pack that covers different types of tasks in marketing, content, SEO, email copy, ad campaigns, and lots of other tasks that an ecom expert has to do daily. Save money by replacing these ChatGPT prompts with freelancers or consuming staff time.
Here's a blog post about Cloudflare's use of Cap'n Proto in 2014, three years before I joined: https://blog.cloudflare.com/introducing-lua-capnproto-better...

To this day, Cloudflare's data pipeline (which produces logs and analytics from the edge) is largely based on Cap'n Proto serialization. I haven't personally been much involved with that project.

As for Cloudflare Workers, of course, I started the project, so I used my stuff. Probably not the justification you're looking for. :)

That said, I would argue the extreme expressiveness of Cap'n Proto's RPC protocol compared to alternatives has been a big help in implementing sandboxing in the Workers Runtime, as well as distributed systems features like Durable Objects. https://blog.cloudflare.com/introducing-workers-durable-obje...
We stopped chasing clock speeds because of the physical timing limitations of gate and signal propagation. Not because of heat. Suppose you are using a 5GHz clock. Every cycle is 0.2ns. Light can only travel 6cm in that time. Electricity propagates a little slower through a conductor (and even slower through silicon). So if you are using some insanely fast clock, you are just wasting cycles waiting for signals to move across the chip.