skysight-inc/HackerNews huggingface dataset:
I have a theory that pretty much every developer saying "X is best for Y" is simply believing what a developer relations engineer or evangelist has said to them at a conference (or they read on a blog post, or heard 5th hand from a dev they know). What they fail to realise is that people who work in dev rel jobs are paid to promote a product. Next.js is wildly popular because the dev rel team are excellent devs who produce fantastic content, but they're paid to promote Vercel and Next, and they do it well, but they don't mention where it isn't a good fit. Consequently every frontend dev claims Next is the answer to everything, and then builds a site that doesn't work very well because it doesn't fit Next's model.

I'm singling out Next but it's not limited to that framework. I like Next. I use it. I spent weeks working out if it could do what I need before I started. The problem isn't Next, it's applying Next where it doesn't fit. This is true for everything that has paid promoters. You have to do your homework. You can't blindly trust what the internet says.

When the dev industry stops conflating the opinion of someone paid to promote a product with stop cold facts that apply to everything then things will improve.
> You are understating the limitations of B+trees for real workloads.

I never said anything about workloads. All I said was that your statements about B+Trees having dwindling usage are clearly false.

If you make a claim that is self-evidently bogus, then you shouldn't expect anything else that you may have said at the same time to be taken seriously.
>People in coma do have brain activity. People who don't aren't "less human", they are clinically dead.

And fetuses have some level of brain activity as well.

A fetus has some level of brain waves at 7 weeks. Does that mean you think a fetus is alive after that time period, but not alive before?

Since you didn't reply to everything, I will ask again: Are people with severe mental disabilities less human than a regular person?

>xD

I don't know what this means. Like I said I don't know about that specific condition.

>Because in the biological context this is true. However, your whole reasoning is based on reusing this in a completely different context

To quote you: "Why would you want to use a completely different criteria for this one case?"

>wrongly assuming that every bit of homo sapiens, regardless of its state, is a person. That's why its absurdity would be obvious to a nurse: it's obvious to anyone who knows about both contexts and thus can tell the difference between them.

I don't think every part is human. Skin cells are not human. I agree that would be a ridiculous point to make. Good thing I am not making it
Sorry, your negative emotions.
>Doing regex date validation in a json derived from a string in an sql dialect without function-definitions is horrendous.

Doing regex is horrendous, but doing it on SQL in a modern database is no more difficult than in a full-fledged programming language. Most modern DBs have strong JSON support and built-in regex functions

1. JSON_CAST/JSON_PARSE your data

2. REGEXP_EXTRACT() on the result, here's several date validator regex from a SO post (https://stackoverflow.com/questions/15491894/regex-to-valida...)

And that's it. In fact in many cases it's probably faster to do it natively in SQL than to export it to python or R and parse there.
You can also do this in PRQL:

from a
join b [a_id]

is the equivalent query.
If you never use the recording except for yourself you'll never run into an issue.

If you are a group that may someday be subpoena'd for something, you may want to consider the laws around it.

Note that if one side says the conversation may be recorded or monitored, I believe both can now record.
I work on a TUI logfile viewer that uses SQLite as a backend for doing analysis on the log messages (https://lnav.org). However, writing SQL interactively is painful since you can't really provide good auto-complete or preview, which is something I try to provide for most other operations.

The PRQL pipeline syntax would make for a much better experience for lnav since you're able to progressively refine a query without having to jump around. (You've probably noticed that many log services, like Sumologic, already provide a pipeline-style syntax instead of something SQL-like.) The nice thing is that you can simply keep typing to get the results you want and get a preview at each stage. For example, entering "from" and then pressing <TAB> would make it clear to the program that table-names should be suggested. The program could then show the first few lines of the table. Typing "from syslog_log | filter " and then pressing <TAB> would make it clear that columns from the syslog_log table should be suggested (along with some other expression stuff). And, then, the preview of the filtered output could be shown.

In the current implementation, pressing <TAB> just suggests every possible thing in the universe, whether it's appropriate or not. This leaves the poor with not much help after they've typed "SELECT". I find myself having to lookup docs/source to figure out column names or whatever and I wrote the darn thing. Ultimately, I think the analysis functionality just doesn't get used because interactively writing SQL is so user-hostile.
So, I'm looking forward to seeing this succeed so that I can integrate it and still be able to use SQLite in the backend.
Also quite remarkable that the flu vaccine seems to have a larger impact on the prevalence of Alzheimer's disease than it does on, well, influenza.
I hear on you social connections, which is why this must be a coordinated effort. Moving slowly in will not be that appealing, but having everything set up ahead of time and then moving en masse would work.

RE: politics, the governorship isn't elected by land. Take out the governor and you can fix political gerrymandering (or wield it to your benefit).

End of the day, the vision as I see it isn't to build a new city or to make a small town feel like a city. It's to enjoy the benefits of large plots of land and large houses, but to do so with a modern, youthful population and great restaurants and entertainment.

I'm envisioning Bend, OR but all across the country. Or Los Alamos, etc, the examples above. These towns didn't happen by accident. Someone had a plan, and then a tipping point was reached that cemented the place as a modern small town.

That can be reverse engineered and purposefully carried out. Not saying it's easy, but it's 100% doable. And I want to know who's trying, because I want to help.
The main reasons (IMHO) to have SSR are:

* SEO capabilities
* Faster response for first page load

And for both of those, a CDN is useful, if not essential - you're missing out on a lot of performance boost if you don't.

Other reasons to have SSR include things such as unfurling, where a CDN isn't essential, but still nice to have.
Many type-2 diabetics can even put the condition into remission by following a strict diet.

https://www.virtahealth.com/research
Well that didn’t take long to go astray
I'm surprised how few people know all the ISO-3166-alpha-2 codes. LK is obviously Sri Lanka :-)

(Although this has been headline news for a few days in the mainstream press[1], which helps.)

[1] https://www.theguardian.com/world/srilanka
purify-ts is my favourite currently.
In your next employer, if your recruiter is game, just do what I suggest upthread, don't bother asking permission.
And even those teardowns are subject to people trying to get the balloon framed single family home designated as a historical entity and preserved for all of time
Rather silly title, but that's true of many papers reusing this meme.

The abstract presents an alternative to wear leveling that they refer to as "capacity variance", also known as breaking compatibility with all previous filesystems, drivers, and bootloaders. Wear leveling has been a necessary evil, because without it flash storage simply would not be usable at all as hard drive replacements/successors. Nowadays some of the pieces are in place to allow software to interact with SSDs in a more natural fashion, but it still isn't possible to completely forego the FTL that emulates hard drive behavior.
I could easily quibble with some of the assumptions, but a basic analysis [1] shows that...

> A USGS report from 2011 reports 80 million tons (Mt) of lead in known reserves worldwide, with 7 Mt in the U.S. [...] That’s still not enough to build the battery for the U.S. alone.

https://dothemath.ucsd.edu/2011/08/nation-sized-battery/
The person committing the crime does not always have to worry about being charged with a crime. The burden of proof is pretty high, and anyone with a half a brain will not explicitly state they are committing a crime.
Apple prepares to release over 20 products and updates this year
Great article. Have been brushing up on bit manipulation for interview prep lately and I love finding easy to digest, real-world use cases like this.
If the inverted pyramid is in an "old-fashioned" economy and society, where the great majority of adults generally work hard until the last few years of their lives, and families mostly do their own service work, then the inverted pyramid might not be a serious problem.

But if you're hoping for something closer to the modern, Western ideal - education until age ~25, work until age ~60, retirement until age ~90 - then the inverted pyramid is going to need at least one of:

(1) Armies of imported service workers - to staff all the nursing homes, retirement homes, cruise ships, restaurants, etc. that the huge "top" of that pyramid need / want.

(2) Armies of robots so advanced that they can fill the great majority of those jobs. WithOUT requiring an extra army of humans to build, pay for, maintain, run, etc. those service worker robots.

(3) Huge changes in medical technology and social expectations, so that most of those service workers are never needed.
What's up with partial refresh that developers want it so much?

Usually the only gain is that you don't have to reload and re-parse all the javascript that is there for doing partial refreshes.
What is striking in this development is the destruction of our social fabric.

From African village model to the nuclear family is a massive step, made possible by the nation state. Arguably this impoverishes community/extended family life. The most extreme form can regularly be read in the news: somebody found dead in their home, undetected for weeks or months.

But not even that is enough. Even within the scope of the nuclear family are we further individualizing. Each partner in the couple is to be fully economically independent from the other. Note that I'm not suggesting any traditional angle here, I'm purely talking about individualism in general. Even within our very own family, we no longer dare to rely on each other, to be dependent on each other.

If I were to pick a cliche busy urban family, they have very few shared moments. They may not even eat together. They relax on their own individual device, often in separate rooms. And we outsource care for both our young and the old.

We drifted far from our roots.
I have to agree about the Great Courses. The ones I've watched have been very high quality, as good as the university courses that the universities will charge several thousand dollars to sit in. (Some fancy schools are hitting $8000 per course these days, at least at the list price before financial "aid" kicks in.)

Enjoy them. There's no reason to get poor to get an education.
>If you aren't going to offer the recordings to the public in any way I can't see how you would even be caught.

I'd appreciate it if you'd clarify this point. Are you implying (not saying you are, but it is a parsimonious reading of your assertion) that not getting caught doing something makes that activity legal/ethical?

Personally, I'm more concerned with the ethical implications rather than the legal ones, as many things that are legal are highly unethical.
As I recall they had the teachers themselves graded those tests, so naturally they cheated.
How much are they paying for this service?
And people who want a contest of how willing to die your driver is can already just watch motorcycle racing.
Did you miss the hundreds of clients bit? So we're talking several thousand responses per second per core. I think that's fairly impressive, and VERY different from an FTP server connection that isn't really doing much most of the time.
If you scratch a NIMBY you'll find a fan of Ehrlich underneath. You have no idea how quickly a Berkeley zoning board meeting devolves from ordinary discourse into Malthusian debates about whether young people are entitled to exist. Of course Ehrlich was a gigantic racist, as are his followers, which was recently covered very well at https://www.theatlantic.com/ideas/archive/2022/05/population...
Not always welcome - I certainly decline or recycle all the branded clothing I get. Better if it was never made.
While I personally agree with you, this sort of thing is closer to a political position than a fact. There’s plenty of people who will push a low fat, plant and carb-based diet as evidence-based even today.
Can you provide an explicitly named "modern" database that doesn't use B+tree indexes, and what specifically does it use instead?
The problem is that drivers consider practically any changes to the status quo to be “punishment”. Replace several street parking spaces (in a neighborhood with hundreds of spots) to put in a bike lane? Punishment. Cut ten minutes off bus travel time by installing a dedicated bus lane, at the expense of a minute or two extra for car traffic? Punishment. Make drivers pay money to store their cars on public streets? Punishment
That doesn't seem to line up with your previous post?
It's super simple: America is rich, and people want the opportunity to participate in our wealthy economy.
There's nothing really inherently racist about it, or bullshit. Mass immigration is a serious subject matter, one that deserves scrutiny and ruthless questioning. Avoiding the questions by calling it racist doesn't make it go away.

It's been around for a lot longer than 2010. It has been a popular subject matter in Europe for decades [1]. I guess someone just decided to finally put a more official, catchy title to it and publish books. Does this particular author have a racist tone? Perhaps they do. But ask an average European citizen back in late 80s, 90s and they'd tell you what's up without skipping a beat. It's something you can see from a mile away. Pleading ignorance won't help.

[1] Your media won't tell you this, so don't be surprised. Talk to a handful of locals to get a sample for how people really feel about things. It's a much better barometer than getting your news from something like Voice of America.
Pictures are blurry, NSFW tag is questionable due to poor image quality.

For anyone interested they were inspired by DDM but trained on 2 1080Tis over the weekend. So if you're familiar with these models you'll probably realize that the images aren't anywhere near realistic.

To the OP, maybe just keep with low image resolution (32 or maybe 64) and don't bother with 128 given your limited compute. There's no reason upscaling if you aren't training far into the 32 case.
This reminds me of the intentionally-ambiguous "officer-involved shooting" turn of phrase.

https://www.mcsweeneys.net/articles/an-interactive-guide-to-...

https://www.cjr.org/analysis/officer-involved-shooting.php
No, it means that researchers now can have access to Facebook's large language model. No one is forcing the researchers to do research using it.
For a professional journalist I would recommend a model with dual card slots, especially if you do important interviews. Maybe even use two recorders with a split as the devices are quite compact. SD cards do fail, and Murphy's law always holds true.
It's been spotty all day with sporatic ow! and gateway errors. But it does seem totally down now.
Isn't this an incredibly dangerous game Amazon is playing with Alexa devices, then? IIRC everything gets recorded.
Hanes Beefy T for me. AA stuff is too trendy. I need something that can handle some wear and tear.
> How does this work?

I don't know myself, but it's possible that they are simply reading unencrypted SNI fields from TLS connections. SNI exposes the website hostnames that you connect to.
The threat is always systemic risk. That's why we need such a massive and seemingly unfair bailout of financial firms in 2007-8. Or the S&L crisis in the 80s. At some point, other's peoples bad decisions affect everyone else. I don't think the crypto market is big enough to have the same affect yet but it could. And it really shouldn't be allowed to get to that point until the market submits to regulation.
I'm not sure if this is a joke, be we actually had a serious an idea to replace side:left/right with nulls_left:true and nulls_right:true

This part of the join operation should be an after thought - just a flag after the central argument of the transform which should be the condition you join over.
The article says "a road-legal version of the Goodwood fan car is in the works"
If you wanted a pithy explanation this comment points to it. It's the speed of the justice system (of which city council is ultimately a part). People want to complain about the participants, but the system itself is so goddamn slow, and more and more decisions are plugged into it, that it's slowness is really the central cause. A working system should be able to handle baseless allegations and NIMBY whining; you can't expect people to show self-restraint.

(The justice system's slowness is also at the heart of another critical problem, the failure of the criminal justice system. Again, people want to complain about the agents, but it's the system itself, particularly it's glacial slowness, that creates perverse incentives and terrible outcomes.)

The justice system is, at its heart, a collaborative information system, and as such is ripe for disruption by software. And I think it's more important to fix even than the healthcare system! At least in part because a large fraction of the complexity of every other system is caused by problems in that most foundational system, justice.
Yes those times are called "Winter" and they aren't fun to camp during. Summer is the best time always, and summer in any of the popular national parks is miserable.
If you really want to know what the locals want, make it easy for everyone to voice their opinions.

An admittedly straightforward example: in my city, each street gets to decide for themselves if they want paid parking or not. (Residents and businesses can get a permit for a reasonable yearly fee.) A vote can be requested by any resident at most once every two years, in which case every house in the street receives a letter with information, a voting form, and a return envelope.

I think this is a lot better than basing decisions on the opinions of what's likely to be a vocal minority that shows up on consultation meeting.
I have a very nice yeti cup company from a certain company. Use it daily. The company had a super serious data breach so we didn't use them and it makes me think about it from time to time.
With this sort of thing, lots of social factors weigh in too. Access the flu shots implies regular access to healthcare and perhaps other interventions.
> How much longer is "longer" supposed to be?

For as long as nobody else is capable of doing so. Don't forget the part where I said "or open-source everything so that the community can". If they did that from day 1, I wouldn't care if they never provided any official updates.
The national security issue is more with chronic lifestyle conditions such as obesity.

https://www.militarytimes.com/opinion/commentary/2018/07/18/...
> Secondly, an Indian version of chipotle.

What does this mean, exactly? Like, I know what Chipotle is. And I know what Indian food is, hah.
Most of the alcohol these days has pull tabs or twist tops. There was a time when the companies tried to pretend that old bottles with old caps were somehow better but I think that urge has faded.
I agree - for me the idea of shared pipelines is what kills a lot of the motivation - I don't who what the person will be working with, what on, I might have a passing familiarity with another interviewer (but most likely not) - it's difficult to treat people as anything else than a calendar appointment.
SFMTA likes to point out that in the course of the project it was necessary for them to excavate and replace all the underground utilities along the route. Basically 100 years of the municipal equivalent of "tech debt" showed up on the SFMTA balance sheet.
Of course it is! That's the premise of every open-source initiative, too. It's not too cynical, it's plain economics. Pretty sure it's the explicit purpose, too.

No one really thinks open-source sponsorships are charity, do they?
You get sold on Global Warming, Healthcare for All, and Social Justice and end up with a Byzantine System 57 bureaucratic layers deep, mountains of paperwork, legal problems, and grift whose total government size is 44% of the GDP - with big plans to grow. Good luck building anything.
Ah yes, that's most likely it!
This is such a misleading headline. It compares the speed of a basket of sites that happen to use Angular in some capacity with a separate list of sites that happen to use Next.js and makes a broad sweeping conclusion about framework speed?

I wonder how reliable this is for SSR as well (and sites that opt into SSR might actually have more complicated sites, so skewing the numbers): https://gist.github.com/Alex3917/fec45e5c2114c2c13b41b30e198...
The problem is not just that a vocal minority us opposed. Our political ruthlessness and acumen is so high, that project that is longer than a politician's term will leave them open to sound bites they can't recover from. It puts them in a position at reelection time of having all the cost, and none of the payoff. And more than likely, the project is harder and more costly than planned. And by the way, the party can't afford to not control that seat going into the national election.

Neither side can tackle anything that can't be roi positive by election time. Most of those projects are "deck chairs on the titanic" value propositions.
IMO the problem is that "politician" is a career. Now the municipal government is just one rung on the ladder, and the worst thing is not getting elected (getting fired). There is no incentive for career politicians to do anything other than what will help in the next election cycle.

Politics used to be a hobby for the already successful who wanted to give back. These people were bound by a sense of what was right. Elitist as hell, yes, but at least they weren't trying to climb the corporate ladder.
Nier Automata is an interesting example! It touched on a lot of interesting topics and did so in a very creative way. At the same time I also feel that the game wasn't mindful of my time at all. The stretches between the interesting story elements were frequently separated by long, often-repeating stretches of fairly simple hack'n slack gameplay. I'd hold up something like Outer Wilds or Disco Elysium though. But Disco Elysium is pretty close to an amazing book and doesn't do as creative work with the game medium as Nier does.
ARM has the same. Apple's CPUs are interesting as they lose most register state on WFI, though there is a chicken bit to disable that behaviour - it's mentioned in one of the Asahi Linux blog posts [0]

[0] - https://asahilinux.org/2021/03/progress-report-january-febru...
This seems like a dubious recommendation. In Japan there is a large acceptance of yearly flu shots yet Alzheimer s prevalence remains high.
You keep talking about how B-Trees are rarely used but I’ve seen relatively new systems deployed that use them (or some minor variation). FoundationDB, FASTER, and a few others.

Other than in-memory hash indexing as used by SAP HANA, I’m not aware of any other data structures anywhere near as popular for database engines.

Can you name the data structure(s) that have superseded these?