skysight-inc/HackerNews huggingface dataset:
If you've got tens of files on an old machine that's probably to be expected. It's efficient with large files, written in C, and on a modern computer could open that many easily. My six year old laptop opens ten files from an encrypted drive in 2ish seconds.

I suppose it could load the interface first, then load the files, then parse and highlight them after the window is up, but don't feel like it would make a lot of difference until its done.

You may find projects useful. Can open the dozen files for one project, then close it, then open the next group from another project. Instead of every file you potentially might want to work on.
where exists (select 1...) is completely standard and normal.

We should write our code to be readable, but it is reasonable to expect that the reader knows the language.
ASCII Art Farts
Yep, they could just fire up an EC2 instance after creating an AWS account on Isengard and go ham. /s
Strange hill to die on - the SELECT 1 query is not particularly hard to understand, and it's demonstrably better.
Query optimizers are already black boxes of magic I guess one has to stop somewhere.

A top level distinct to a query like this is a huge red flag. Even in a sub select or a join clause id rather have a group by than a distinct.
The optimizer doesn't know your semantic intent.
Yeah just change it to `SELECT OrderID`.
Fwiw, I believe the romanticization of advanced mathematics needs to end. I'm 15-20 years out of university, and I had thought I might delve into some specific area of math after graduating. I studied EECS and only took courses in abstract algebra and real analysis. But pursuing further math never materialized for me. Moreover, all of my friends who majored in math transitioned away from it within five years of college. Most became developers, a few became product managers, but I haven't seen anyone maintain or even express an interest in advanced math outside of academia, especially in their 20s and 30s.
Though not quite as short, the Watson and Crick paper is another famously short paper:

https://dosequis.colorado.edu/Courses/MethodsLogic/papers/Wa...
Linear Algebra courses in pure math degrees are typically used as a gentle introduction to theoretical math, different from the applied linear algebra courses that engineers and the likes would take.

Just based on my experience with UCLA's pure math undergraduate program (which I assume is similar to other top tier math departments), the listed subjects in the video cover the "core/required" courses of a solid pure math degree. PDE's and differential equations in general are optional electives (edit: usually taken by the applied variants of math degrees).

It should also be noted that calculus is a pre-req for even declaring the major, and hope the video should list that as a pre-req for self-study as pure math.
No problem. I have Adblock on always. I still pay for YouTube Premium.

I know Adblock is “wrong”. I fully admit it. I’m not going to justify my Adblock usage by saying ads are morally wrong.

I should disable Adblock so services can make money. But I don’t because it’s too easy to enable Adblock.
whenever I see [select distinct ... group by] , i know i'm in for some bs. the original code creator had some duplication/cartesians but never properly addressed it
Month after pig heart transplant, Maryland man pushing through "tough" PT
Just don't drink.

Not an easy 'just' if kicking a physiological and peer-pressure habit and especially worth it for these groups.
Businesses bundle services all the time and they have done it throughout human history. Has nothing to do with tech or being in a dominant position.

If Google can duplicate Spotify’s business and give it away cheaper, why not?

Add more value if you’re Spotify.
The quantum engine and the fact that it's not April 1st means that it's a scam .....
Threads + locks style heisenbug prone low-level programming is one possible avenue towards exploiting this, but its' notoriously difficult and a bad fit for Python's user base. Also, most parallelism is found on the GPU platforms.

The alternative road is to figure out how Python could automatically exploit parallelism in the underlying hardware, possibly in a way that would let it work on GPUs as well. The SIMT data-parallel way (seen in eg in ISPC, OpenCL, shader languages) is also more programmer friendly as it doesn't require the constant use of error probe synchronisation primitives. Or other HLL approaches in Jax, Futhark, etc.
Deckard provides context for how replicants are seen by police and the police themselves. He also has a rationale for why he has to take a job that he doesn’t want. He even has background for the weird language being spoken. A lot of knowledge would have been lost, and I wouldn’t have gotten into the universe otherwise. I’m sure if you’ve seen it several times over the years, sure you won’t need it but what about the people watching for the 1st time.

The ending is also on a lighter side which matches the sequel. (Yes, I know they just reused The Shining’s intro. Again I don’t care.)

Watching the White Dragon edit and they surprisingly kept it!

Edit: The narration adds a lot of flavor and world building

https://archive.org/details/white-dragon
How about if the patient tripped, knocked their head on the sidewalk, and has started believing some very strange and scary and stupid stuff?
I think atlas allows tls/ssl probes, so that could still be used to track unexpected changes in certificates?
You don't need to be logged in for them to know who you are and/or what accounts are yours.
Are you asking if that's what they are doing?
I can't really phantom that. When I was six grade or something, I had old PC with Debian in my room as "server" to play around and serve some random stuff from. And I had real time monitoring on that.
MMO Architecture: clients, sockets, threads and connection-oriented servers
Apparently it is incredibly expensive to convert office to living and meet most housing standards (windows, bathrooms, HVAC, etc.)

I recall a story about a month ago that a firm said they would be willing to have undertaken that cost for a tower in downtown San Francisco but the city, and it's wisdom, had passed an ordinance that required a certain percentage of new housing to go for low income people and thus for low rent and when that was baked in it made absolutely no sense (or cents).

So not only do you have the trouble of the cost of conversion, you also have the trouble of meddling do-gooders messing things up (because one of the easiest ways to reduce rent for everybody is to slam a lot of supply into the market)
What makes neostore better than droidify? I used to use the former but switched to the latter a year ago.
That's subinterpreters in a single process, and the Python runtime already has that (though the only API is from C, not Python, currently); Python API is planned for 3.13.
From my experience going through a lot of offices in SF, they are really good at flexibly up and downsizing workspaces. This space will open to smaller companies or will be sliced and diced into sizes appropriate for anyone willing to buy for commercial purposes. Granted my experience comes from before work from home, so maybe things have changed, but I doubt it will change to residential unless the location was already mixed use.
I grew up in a country without a written constitution (but have lived under the US one for 34 years). I can say with much feeling that it is wonderful to have a written constitution.

But this particular one? Not so much. Vastly better ones elsewhere, if only because they have less veto points and a better amendment process.
Eh, anytime I need to read SQL that includes that I have to sit down and think about it. It's not glance-and-understand and you have to maintain that state in your head. Not the sort of SQL I want to rely on as a practice.

Mind you, most of what I write are ad hoc SQL queries where I might write 100-200 queries in a single day. So that sort of thing really adds up. And it's in a strange place where performance isn't dire, since I can work on other stuff while queries chug.
On the bright side they're huge and terrifying, so they probably won't stay under the radar anywhere around people. Almost anybody who notices these will try to track them down and kill them.
I think what's happening is a lot of people who studied very little or no math are realizing a few 100 level courses in things like linear algebra, probability, stats, calculus etc would be very helpful. They might not realize that the cost/benefit beyond that is minimal. It's similar for many subject areas. A couple 100 level courses in accounting is super helpful, same for finance, law, mechanical engineering, electrical engineering, computer science, biochemistry and on and on.
The previous comment sounds and reads like an AI written mess unfornately, since contextual history is one of the harder things to throw out with AI and have it get right.
And the government probably subsidizes oil too.

It’s easier to build more nuclear power plants than to import more oil in the long term.
EPA tightens reporting requirements for releases of 'forever chemicals'
Wikipedia doesn't accept primary sources. You could be the inventor of a thing, but you'd be unqualified to write a wikipedia entry about it. You'd have to get someone else to write about it, get that published, and then cite that in wikipedia.
I like the selection of topics and the resources recommended, but I'd love to see some recommendations of "front the ground up" resources, like start with ELI5 stuff like variables, math operations, expressions, equations, functions, notation conventions, etc. In my experience as a tutor, many people have gaps in their "basic math" knowledge, so it makes learning pure math topics more difficult to access (like if you don't know what the symbols are, you can't see the beauty of the thing).

I've been working on addressing this problem through my books (links in profile), because I think it's important to consider the general audience, which means including all the "high school math prerequisites in each book.

For anyone who is wondering how to fill in these basics skills, the khan academy videos + interactive exercises are probably the best way to go: https://www.khanacademy.org/ If you prefer a book on the topic, check mine: https://nobsmath.com Here is the concept map from the book that lists the various topics normally covered in high school math that I think everyone should know: https://minireference.com/static/conceptmaps/math_concepts.p...

See also similar concept maps from the other books: https://minireference.com/static/conceptmaps/math_and_physic... and https://minireference.com/static/conceptmaps/linear_algebra_...
It wasn’t a secret that I was in pre-pip. But here is how it escalated

1. A project that I was peripherally involved in under a new project manager went bad and even after escalating I was made the scapegoat

2. My manager that I actually respected left shortly thereafter and the new manager put me on focus as their first act two days after I started reporting to them

3. I met all of the requirements to get off with flying colors and got perfect customer sat scores from two customers (Professional Services). I led both engagements. First goal accomplished. I lasted through a six month vesting event

4. The manager added on more requirements for me to get out of focus and told me a date to meet them. I met the requirements and the manager kept declining my meeting invites and I thought I was off.

5. Finally when they did have a meeting with me three weeks later after the deadline, the manager cooked up more things that I hadn’t done that wasn’t related to any of my projects and mostly geared toward my refusing not to take on a new project that I knew was going to fail on top of my current project that was going well and that would have had me working 60 hours + a week.

By the time #4 came up, I saw the writing on the wall and started putting feelers out. I was just waiting to be offered a severance. I had something basically already lined up.
100% true and concerning. My main problem is that people treat this as a simple black and white "killer robot is evil" situation. It's not. It's far more nuanced.
That makes me think of the near loss of the classified STS-27 mission.

https://www.americaspace.com/2018/12/09/dying-all-tensed-up-...
I'm not sure what you mean by that. We certainly didn't fight a war over racism, but instead over chattel slavery and a states right to have that. I do not believe the north was less racist simply because they did not have slaves by the time the civil war broke out.

I also don't understand your "doesn't exist" comment. Racism exists (and we're also seeing the trial of "combat racism by more racism")
I don't know about NV specifically, but in both PA and NM nothing requires you to buy insurance through the state marketplace, and some insurance companies operate inside, outside or both. You can get back the subsidies that might have been prepaid for you via your tax return. The prices may or may not be as good, but hey, that's the free market for you!
BR was widely panned by critics at the time as well. "Blade Crawler" I think was the catchy headline. I find it a tad boring myself, but it is kind of fascinating on a "Los Angeles in a 1980s dystopian parallel universe" kind of way.

And gorgeous... from the peak of optical effects. But effects are not enough to fill a movie unfortunately.

We looked around at night in Downtown in November 2019 and it did rain a bit more than usual that month. ;-)
Counter argument, prove that Okta does any of those things to any meaningful degree. They are responsible for guarding the authentication to literally billions of dollars of assets. They are a prime target for organized crime who can field teams of tens to hundreds of hackers and state actors who can field teams of thousands for years. The recent Ceasar's attack had a 15 M$ payout, which means it would have been profitable to spend 5-10 M$ of hacking resources to pull off that attack. Okta is a much juicier target. They need to have security adequate to defeat a attack with 10 M$ of funding at a bare minimum.

So yeah, show me a red team exercise with 10 M$ of funding, they get a 30 person hacking team and 1 year fulltime, that failed to find any vulnerabilities and failed to gain access to any sensitive data, then we can talk about if they provided evidence of adequate security. I bet all they have is what everybody else has which is red team exercises that had 3 people for a month that reported 27 serious vulnerabilities, then another red team exercise that found a different 23 vulnerabilities, then another, then another, then another, always finding new ones because their systems are actually at the 100 K$ quality level. Those exercises do provide evidence and confidence in their security, you can be extremely confident their systems are grossly inadequate for their threat landscape. I have not looked, but the same can almost certainly be said about their certifications, audits, etc. since the gold standard that everyone aspires to is, when looked at objectively, grossly inadequate.
Indeed, I would be surprised if there exists any RDBMS where the content of the select list in an EXISTS subquery matters. Postgres's SQL dialect even lets you use an empty select list (`... WHERE EXISTS (SELECT FROM related_table WHERE related_id = id_from_outer_query)`). In T-SQL, however, a non-empty select list is required, and in my experience, developers writing T-SQL tend to prefer a constant value like `1` or `NULL` over `*` -- I suspect there's some superstition there related to both the common wisdom that `SELECT *` queries are to be avoided (which is true -- you really should only ever select the columns of interest) and a lack of truly understanding that EXISTS only reads enough of the table to ascertain whether rows exist that satisfy the subquery's predicate, and returns a boolean value, not a result set.
Have to break a few eggs to make an omelette, right?
I know it's just an example, but why aren't these tables normalized better anyway? None of them should have columns for the PK of another table.

The relationships between them should be represented by bridge tables. Really there's only one relationship here which is product orders.

Why have the expense of a join in your select queries when you can just associate them properly during the insert in the first place?

Then you can simply select limit 1 from the bridge table and only have one scan on the customer table for the whole query.
It’s not a secret. They tell you your on “focus”.

Let me take that back. I knew I was on focus. But thought I was off since I had met all of the criteria and my manager went on radio silence for a month.

I mostly worked with project managers and customers (consulting division) day to day. That’s when my manager was finding things to use against me.
Motor racing perhaps. As in, the wheels are on fire.

I believe I've heard it in relation to the internet since broadband rollout. But who knows, perhaps that's just past experience fallacy.

To see whether or not, try the Wayback Machine. Here's a search for this phrase: https://web.archive.org/web/*/blazingly%20fast
If they figure out how to reanimate historical figures with AI, I’m voting for Henry George.
> most Python code in prod is what, 3.8?

3.8 is the oldest supported version, so I would hope not, but probably.
It was a support ticket opened on Okta's systems which got breached and leaked the info which was used to attack Cloudflare systems.
With X, Musk is playing the bottom-up game
Copper Is Critical for America's New Energy Economy
i am happy with vim, i dont need geany

CHANGE MY MIND
Yep.

Though he's not really rentier, either--he's more like meta-rentier, and probably closer to aristocracy (though I don't know marks isn't well enough to know if he had that as a separate group)
My studded winter tires are 700x40 with rim brakes.
It’s internet slang. Looks like the earliest urban dictionary entry is 2012.

https://www.urbandictionary.com/define.php?term=tiddy
> Python needs to have an urgent answer to the use of multiple cores

https://docs.python.org/3/library/multiprocessing.html
Adding cost into thy mix too. The arm devices, like the surface X are all noticeably more expensive than the Intel version.

It's just not really worth risking that much money on a unknown, when a known good product is cheaper.
How to Run FreeBSD on Power – Toshaan Bharvani – EuroBSDcon2023
Did Europeans not already have those advantages in 2008 though? If the figures quoted are correct then the Eurozone has had negligible growth over 15 years while the US has almost doubled the size of its economy over the same period. That surely can't be explained merely by Europeans continuing to enjoy the same advantages they already had but paying for the privilege.
Pretty sure Warframe uses it, too.
People in the Numpy/ML user camp are like this, but in general usage the computationally expensive parts of Python code are heterogenous application code written with Python dicts, lists, etc that could be run much faster (as evidenced by JS).
Which makes sense. Cool, wise managers would mention the pre-PIP possibility to otherwise good employees informally because surprises are Generally Bad™ for indicating a lack of transparency and mutual understanding between manager-employee. Performance reviews EOY or EOHalf should never be arbitrary or magical surprises, but a stack of accomplishments and positive "thanks" notes for specific assistance.
> In my opinion, Python needs to have an urgent answer to the use of multiple cores.

Subinterpreters are an answer (heck, so is multiprocessing).

Whether between them they are enough for Python's domains is another question. Probably not for the long term, but possibly for the neart term. But anything more is going to be a big lift, no-GIL is the obvious broader answer, so its good its being worked on, because by the time its betond question that its needed, it’ll be too late to start working in earnest.
The previous one was a Boox.

This time, I got myself a BigMe. You can get one on https://store.bigme.vip/ the URL looks suspicious but don't fall for the official looking bigmestore.com: it's run by a dropshipper called good reader, who apparently impersonates several Chinese companies by squatting the .com domain name and pretending to be them, just to raise the prices and in return generally give you a negative service (slower shipping, not saying the truth about unit in stocks or shipping dates...)

If you need to know more about this dropshipper shady methods, use your favorite search engine with "goodeareader scam" and learn from the various user reports, the BBB ratings or trustpilot.

The difficulty was getting a legit Bigme from the official store, but the hardware is great: I think the quality is higher than the Boox (which I already liked a lot), but unfortunately it seems to have a lot more google software than your usual Chinese device.

OTOH, there's also a 5G module in the BigMe, so I could get data anywhere... it's complicated: I might return to Boox when they have a better lineup, but getting either a Boox or a BigMe is a good decision if you like the slower refresh rate of eink and the "more visceral" feel of eink compared to emissive technologies (TFT, OLED...)

I'll try to write some guide like my previous one for the Lenovo X1 Fold: https://csdvrx.github.io/
What's the difference between Legion and Regent, by the way?

I noticed the Regent code is inside the Legion repo. Is Legion the system, and Regent the language?

Can Legion be used without Regent, or vice versa?
Git is popular because it's linear, and the linear paradigm usually translates well to serial things such as programs, instructions, document sets, etc.

It's actually bad at non-linear stuff, which you will have noticed if you have ever been working with hierarchical formats, especially e.g. xml or nested JSON.

Word is bad for a whole litany of reasons, but the reason it can't be easily versioned (atop the format being a literal Goldberg machine requiring inane transforms to properly) is that it encodes a bunch of non-linear formatting instructions. Sure, we can sort-of reason about this stuff e.g. with a hierarchical css+html+js structure, but without a way to render that I challenge you to be able to simply diff that information. Seeing "bold" or "blue" seems simple enough, as long as you also know to which elements it applies and in what layout. So, suddenly you can't reasonably diff the css file without also difficulty the html.

For programmers, we are used to reducing things by their dimensions into fairly linear spaces, this then helps us reason fairly linearly about changes, but doing this from any other context is challenging. Lawyers e.g. perhaps focus on the relations between various clauses, so linearizing their document flow is not very important to them, at least when there exists methods to diff the general textual content without investing much in how they are doing that.

As programmers we see the similarities to editing a code base and that excites us, however we do have a tendency to go off and write frameworks to parse and simplify these things, without ever actually bothering to learn to apply these things. This is not invaluable, but it's a different focus, which maybe explains why lawyers are not in the habit of using git.
Which was wonderful. Some (many, a few, who knows?) lawyers have stuck with WordPerfect for this reason.
> All these years and multiprocessing is still abysmal.

Shrug. Is it really that much worse than JavaScript or PHP?

I mean, maybe they are or have been abysmal, but at least Python is in popular company.
> We spend 21 times more on defence than Russia does

Russia can’t even reach Kyiv 150 miles away - maybe they should have spent more
I guess we won't be getting "Winnie the Pooh: Blood & Honey" on Apple TV, either.