skysight-inc/HackerNews huggingface dataset:
Postgres focuses more on this use case. It's probably still going to do a better job with concurrency, or at least have more features. It'll also cost more to pay for as a service, so you decide if it's worth. Whereas HC-tree is an obvious win if you're already using SQLite. It's fine for two things to approach similar use cases from different sides.

Personally I want the opposite direction, a sort of Postgres-lite that uses a single flat file and lives inside a lib, for things where the power of the full thing isn't needed yet but I want to design my backend code against a Postgres interface. I've seen Wasm Postgres examples, and maybe there are others, but nothing mainstream. And yes there was this SQL standard that everything was supposed to conform to, but that went out the window long ago.
A bun browser? Bun is like NodeJS. There is no ‘node browser’

Bun uses JavaScriptCore from WebKit/Safari, similar to how Node uses V8 from Chrome
By starting a program and saying "for the next x amount of time, this is what we're doing".
I 100% second the baffling nature of this. Maybe not baffling, but telling. If you can't relate your programming experience to new languages and paradigms, if you aren't curious and driven enough to learn the differences and likenesses between them, then you aren't a real developer. No shame in that, not everyone is cut out for it.
Damn I would have loved this for ripping "gamez" back in the day
This feels like it's assuming a certain causal direction. You say that I dislike the other person's character trait because it's a trait of mine I may dislike and suppress. What if it's the other way around? What if I suppress a trait of mine because I've been annoyed by other people exhibiting the trait and do not wish to exhibit it myself?

I know the latter is something I've taken conscience effort to do.
Regex search and replace is table stakes for a code editor. All the way back to ed ;-)

Tree-sitter queries is an interesting addition. That and bazel build system queries seem like a step up in editing and compiling code.
At this point, the One China policy is a political fig leaf that both sides of the strait cling to to pragmatically stave off renewed warfare, which is prudent. On the other hand, a lot of that de jure formality is constantly being played around with.

For instance, just recently the likely next DPP/pan-green presidential candidate is declaring that Taiwan is already de facto sovereign and independent, and so there is no need to formally declare independence:

https://twitter.com/brianhioe/status/1615638156367507456

Odds are, this entire discourse in this HN thread is just a lot of fulminating hot air by people who don't even live in Asia, grognarding hypothetical wargames and war toys, while the actual people in China and Taiwan will peaceably and gradually figure it out over time.
that's the thing i learned in my robotics class, with a from-scratch robot project. the mechanics are the hardest thing. the electronics the 2nd hardest.
It's sad that hacker culture was taken over and corrupted by capitalists who turned the web into a shopping mall and then started bitching about how it all lost its quirky small town charm a decade later. But what can you do?
The point is not claim but action. Many other countries have water disputes but no one outright builds new military airbases in international territory and bullies others whenever they come close. Some sort of peaceful, lawful process is followed in all cases but one.

Saying that ROC and PRC have same claims doesn't say they would be same in their disregard for general order
Documentation describing whats already their and why, or documentation describing what's suppose to be there and why? Or both?
They make and sell self-cleaning toilets at most big-box stores. They're just about 5x the price of a non-self-cleaning toilet, and I'm pretty certain they break down much, much more often, given that they have multiple valves and electronics in them.
The vast majority of those 1 million organizations received less than 100 dollars.
I never understood how Amazon decided which orders qualified for Smile -- but now (too late) I know. It turns out that I only contributed $1.29 -- but my charity (EFF) received over $1M. I guess that this indicates that they did some good outreach at one point.
> Lots of Wikipedia articles have become well-cited but that façade begins to break down as we dive into more niche topics.

A lot of the time they're just making the citation up. Wikipedia's page on French toast says this:

> The earliest known reference to French toast is in the Apicius, a collection of Latin recipes dating to the 1st century CE, where it is described as simply aliter dulcia 'another sweet dish.'[8] The recipe says to "Break [slice] fine white bread, crust removed, into rather large pieces which soak in milk [and beaten eggs] fry in oil, cover with honey and serve".[9]

The problem is that the reference to eggs doesn't exist in the Apicius. It comes from an "augmented translation" that was written in 1936; the eggs are original content from that "translation". The sidebar's claim that French toast originates in the Roman empire is a lie, and so is the claim that French toast appears in the Apicius.

This has been noted on the associated talk page forever, but (apparently) so what?

More on the obscure end of things, I'm also annoyed by the page on Chen Shimei ( https://en.wikipedia.org/wiki/Chen_Shimei_and_Qin_Xianglian ). It claims that Chen Shimei, a stock dramatic character which the page itself dates to 1594, is represents an attempt at character assassination against an official of the Qing dynasty, which began in the mid-17th century.

The claim (that the fictional character is based on a historical person) used to be cited to a newspaper article which did not itself cite anything. That citation has since been removed, but the claim lives on in the page without even a fig leaf citation.
I’m ignoring even “existing market destroying” and just looking for tech companies that are even consistently profitable that went public in the last decade.
They won’t get to see the easy victory up close in those positions
I can't speak for right now, as I last worked on this stuff 8 or so years ago, but I briefly contributed to a DARPA robotics challenge team and simply working in ROS as a whole is an immensely difficult process to really get anything to happen with atlas robots. It's not just something a small number of engineers can quickly ramp up on and be immensely productive immediately, you'd need a pretty big team working on stuff over a period of a couple of years to really take things to the next level.
Jackie Chan, the HK actor, filmmaker, martial artist, and stuntman, ended films with a blooper real. It showed stunts being practiced, and failing, with injuries. A reality check, a "what you've seen today was staged", a "don't think this was real, and then make poor life choices". I liked the integrity of that.

Lots of people only see BD's demo videos, and not their making-of videos. Or don't have the expertise to interpret those. So each time BD does another demo video, I think of Chan's films, and wonder if BD might do better.
Yeah, I think the last two recessions just happened to have coincided with a technological revolution (the internet, then mobile) - and were managing our way out of the recession by reducing interest rates, which spurs growth.

It's worth looking at the current macro climate through the lens of what is different, not what is the same. It remains to be seen if we land a meaningful revolution this time: lord knows it ain't the blockchain, but will it be AI? The other difference is as you point out, we're raising rates into this recession not lowering them. The intent right now is to slow growth and destroy demand making this an inherently more challenging time start.

As they say, don't fight the Fed.
Data is Rectangular and other Limiting Misconceptions
Amazon doesn’t have any employee match programs, but they had AmazonSmile. This matched their Customer Obsession leadership principle in a very smart way. Rather than making their charitable giving be directed by a foundation or employees, it let customers decide what mattered to them.

They highlight their charitable programs as a way of justifying the end of the Smile program. But those existed when Smile existed. It’s not a zero sum game as they imply. They took away an avenue customers got value out of, probably disproportionate to the value the charities received frankly, and that’s the end of the story. A sad day for customer obsession.
I chose a charity but then barely ever donated anything because I would always forget to type the smile in the URL. It was a blatant technique to discourage donations.
> text that is too wide causes people to read less comfortably and retain less information.

This seems like an excuse to force JS to enable ads & what should be the default that is toggled with the fullscreen button in the bottom right. It does not justify wasted width as the user can more easily set the text to the appropriate zoom than applying some custom CSS:

.mw-page-container {
max-width: none !important;
}
.mw-content-container {
max-width: none !important;
}

Zooming in now decreases the padding on the right, but has an offsetting increase in the wasted padding on the left contents until it completely disappears with huge text.
I found this whole thread really interesting. Maybe I have no idea but I’m wondering about interlab collaboration culture: is there like competition and maybe some lack of cooperation or grudging cooperation between labs? Sort of in the same sense that you get that stereotypical lack of information sharing between different government departments in other fields? Or it’s much more collaborative than the government bureau analogy (modulo classification/ project restrictions)?
I’d prefer an Old English font on parchment.
They seem pretty committed to pursuing profit forever. I would simply make it a part of my mission and have the integrity to stick to it.
It's often not a surprise when I read about something that's been around for a while which is closing down, and a) it's something I should be likely to run into, either because it's where I live, or it has something to do with things that I follow regularly, and b) I've never heard of it.

This happens with restaurants where I live, and it happens with tech companies or features or divisions of companies. If your thing isn't getting noticed in the mass media or the social media, then it's unlikely to be as successful as things that are getting noticed. You don't even have to spend money on advertising or PR - as Tesla has shown - you just have to make a name for yourself somehow (not that Tesla is how I would do anything).
I think it would bad PR if they just redirect to www, people that think they're still generating money for charity wouldn't be too happy once they figure it out. I've personally chosen Amazon Smile specifically because of the donations when there were plenty of other options I would rather use if I'm not getting anything out of buying from Amazon. I'm sure I wouldn't notice if it just redirected.
Seams to Sewingpattern addon for Blender, a quick walktrough (2020) [video]
The paper being discussed in this article rings true to me but as I was pointing out on an earlier thread about it, I'm not sure that disruptive always has the meaning the authors intend.

I can think of papers or work in my field that would be relatively high in a disruption index in the way they define it, but that are probably specious. They're papers that spurred new lines of research that are flashy and sound trendy but are ultimately theoretically and empirically empty and problematic.

It worries me a bit because these types of indices tend to get latched onto, and then get misinterpreted and abused, in conformance with Goodhart's Law. Taken in context, the paper makes an important point, and adds a bit of important empirical information, but I think the situation might be worse or better than the article implies, because what's disruptive isn't necessarily good from the perspective of scientific progress.
More like “try to start a business doing something you think is important, but accept that you won’t build it right the first time”.
Honest? Why should we believe all of the Amazon smile purchases will continue and contribute to charity? If the program is getting scrapped, are we to believe Amazon is going to send 0.5% of everyone’s purchases to charity?

This is an attempt to recover revenue, nothing more.
>I've never heard an American complain that Coca Cola is sold by the liter. There's no moral component to Americans not wanting to switch to metric.

There is, it's just that Americans are happy to overlook it here and there for completely arbitrary reasons.
you either restore from your snapshot/backup of the database, or replicate from the HA node that didn't fail.

it depends on the nature of your app as to whether either of those scenarios are acceptable. the former comes with downtime.
"That ancient billing run batch process is an optimal killing machine!" (It might even outlast us through climate change.)
is that not just describing the process of finding customers?

What happens if you don't find a customer, even after some several iterations/searchings? How do you know the tool has value in that case, other than personal conviction?
Child labour is illegal for a reason dude.

"Working with your parents" doesn't make child labour any less child labour.
I did not even know anything else than A4 existed, I just learned that now
I hope they're not laying off the accessibility team. Windows is rough as it is.
You could also just log in to an account and set your own theme. My account is still one the 2005 theme as it works best for me.
Guess I'll just have to start donating to The Satanic Temple directly :/ And start shopping elsewhere when possible. The only reason Amazon was ever my first stop was because of Smile.
big corporate donations require 0 engineers, that’s a huge savings
Pretty sure 1Password had "standalone" licenses.
https://piunikaweb.com/2021/06/22/1password-ceases-all-licen...

The article above talks about them being shutdown
For one, they can afford it. Two, it factors into my decision on the value of Prime to me as a consumer. Prime also offers me the ability to sub to a twitch steamer for free every week. That puts real money in creators pockets. YouTube Premium gives creators more cash when I visit than a free user. I enjoy using services that allow me to give back to creators.
Hadn't thought of those use cases, but it does seem like it could be pretty helpful in those scenarios, especially when doing extended narration for training and tutorial videos. It is kind of worrying that phone scammers, hackers and other bad actors could leverage this technology for much more nefarious purposes, which was the thought that drove my initial reaction.
“If you are lonely when you are alone, you are in bad company.” — Jean-Paul Sartre
So people are mad because they lose productivity because they are too busy complaining about weed? Brilliant
[GitHub] Incident with Actions and Pages
Looks like GitHub is having issues. Our actions runs are failing, and zip downloads seem to also be not working (at least for us).
Ewww what's with this terrible trend of wasting the majority of the screen space on a 16:9 monitor like this. Let it fit the window width, if someone needs it to be narrow let it adjust itself appropriately.
Giving it a narrow set of pre-programmed movements defeats the entire purpose of building a human shaped robot. The goal is for it to be general purpose. If they wanted to perform a single discrete task they could design a way more efficient machine for doing that task.
I haven't moved up in about 8 years as a midlevel. It is far from blissful. There's tons of pressure to do better no matter what. And of course no real reward compared to the people making 150% what I do because they play the politics.
> …but now they’ve decided they - Amazon - know better, thank you very much.

Or, a less cynical take is that they really can have more impact by focusing on fewer charities. Another commenter posted Amazon Smile's Form 990 from 2018 [1], the most recent year on Pro Publica's website that has a full listing of all the charities that received funds.

The total PDF is 2121 pages long, and the list of charities starts on page 18. They made about $37.5 million in total donations that year. The top charity, the ASPCA, received $1.8 million that year (note that the ASPCA had total revenue of $267.7 million that year). But the main point is that the charity on the top of the second page, which is only about 100 charities from the top (ordered by total amount received) received just over $10,000, and the charity at the top of the third page received $5659. And there are still over 2100 pages of charities to go!

So it seems imminently reasonable to me that, rather than give a couple hundred bucks a year to thousands and thousands and thousands of charities, to instead consolidate that to fewer charities where it can do some sizable good.

1. https://projects.propublica.org/nonprofits/display_990/46262...
This looks neat, how do I try it out? Semgrep is nice for simple modifications but poor at multi line. Comby works well a lot of the time but I really need something more sophisticated. More sophisticated often means language specific but I would like to have a language independent tool like this.
I've seen you comment so many times and I honestly can't tell if you're serious or a parody account
Can’t tell if you’re trolling at this point, but it’s not a contradiction, and you’ve ignored the numerous counterfactuals more applicable to America.
According to Amazon, I generated $326.89 in donations. I feel good enough about this impact to have installed Smile Always on all of my browsers and resisted using the mobile app entirely. It’s not super impactful but it’s still kinda sad to see it go.

I think based on the Amazon’s statement, which states that it didn’t have the desired impact, they could’ve just rolled it out as the default. The reality is that it’s now 5% back to Amazon and you can trivially calculate that back in missed profits they didn’t get.

Belt tightening or legitimate disappointment with the impact?
I’ve had trouble with html -> pdf when it comes to tables. Most of the packages out there don’t have a way to say “if only the first few rows of the table will render before a page-break, then put the page-break before the table”. Or getting a table to not break at row X when that row has a cell that spans more than one row. Or getting table headings to repeat on the next page when a page-break mid-table is unavoidable.

These are all things that good page layout software can deal with easily.

HTML to pdf is also pretty slow and unreliable when you want a table of contents or an index with page numbers. On a fast machine, a 200 page PDF can take several minutes to generate. PrinceXML is the only software I’ve tried that does a good job of it. For very simple documents (no CSS, limited Unicode) HTMLDoc is pretty good and very fast.
Couldn't they just make the charity list much shorter? While still giving users a choice?
What prevents you from donating to your local charter school without Amazon Smile?
I don't really know anything about the particulars here, but the idea of people in power resigning from power is baseline extremely high positive valance.

The primary concern of people in power should be how to distribute their power amongst more people, and whether they've held it too long and should abdicate.

On a completely unrelated note, Diane Feinstein...
Easy and medium. I wasn’t asked any hard questions in my interview.
To be fair, friendlyjordies has pissed off a lot of people, I think as far as motives go, there are plenty of likely and unrelated parties who would be capable of doing that.
I'd think the most common failure point on a GFX card is the cooling fan, so if they have been run continuously for years the bearings on the fan are probably getting pretty worn out.

Hopefully manufacturers aren't still gluing the fans on the boards. I lost a couple of GPUs thanks to that, turning what should be an easy fix into a replace the whole damn card situation.
Nice post! As a software dev of more than twenty years myself I nodded along with most of this list.

I disagree about the value of opinions. They’re generally bad, often wrong, and don’t solve anything. Have them, sure, but keep them to yourself unless asked. We like to think our opinions are reasonable, well researched, and unbiased but nothing is further from the truth.

Be open to changing your mind, let evidence and results guide you, always be open to learning new things! Opinions change with what you know so don’t hold on to them.

For me the biggest difference between a senior engineer and a junior engineer is experience. The former knows enough about the state of the art in their area of the field that they can train other people in what they know. Those people that they train go on to become senior engineers themselves.

One thing I’d add: if you’re a software developer, think about your principles. What maxims and rules guide your thinking? What do you value? I encourage writing those down and re-writing it every few years to see what has changed. Maybe one day you’ll be writing a list like this.
It did pay well, but it also was fairly interesting work with a lot of room for exploration and growth.

Maybe I’m just frustrated and looking back with rose colored glasses.
Remove DALLE 2 Watermark v0.2.1
Last update: Now you can remove watermarks everywhere in DALLE 2
It's possible to simulate JSON contains in SQLite using a devious subselect.

Here's an example:

https://datasette.io/content/plugin_repos?_facet_array=tags&...

That page shows every row where the tags column (a SQLite JSON list of strings) contains the string "Data Import"

Here's the underlying SQL:

https://datasette.io/content?sql=select%0D%0A++rowid%2C%0D%0...

select
rowid,
repo,
tags
from
plugin_repos
where
:tag in (
select
value
from
json_each(plugin_repos.tags)
)
order by
rowid
limit
101

I haven't tried it yet, but I have a strong hunch that this could be dramatically accelerated using a join against a FTS table on that "tags" column in order to first filter the rows down to a likely subset.
Ooh I bet cops would pay so much money for access to that DNA database
But smaller organizations will be missed entirely. My charity is a cat shelter in St. Louis. I’d rather they get my cut than a larger charity that means less to me and has bigger fundraising machinery.
Upon considering the scenario you described, my first thoughts were on how lonely an experience that would be.

That's the point. You can't be understood to a gratifying degree by people who don't share your culture, and simple words aren't going to fix the disconnect.

helpful and caring people that don't understand what's wrong can't provide very effective support.

If you saw someone from another country looking starved and miserable, you couldn't buy them food and direct them to shelter?

Loneliness means anything from not having enough people to chat with today to not having a soulmate who understands and affirms your every view.
PostgreSQL 16 – random_normal() to provide normally-distributed random numbers
"Amazon closing AmazonSmile to focus its philanthropic giving to programs with greater impact"

https://www.aboutamazon.com/news/company-news/amazon-closing...
Synthetic voice acting for deceased artists.
It was later shown that the whole part were the Tesla goes out of power was staged.

The car did inform them it would run out of battery on the way. They made a segment about it and failed to inform the viewer that they had ignored several warnings given by the car before reaching the « oh no we are out of battery in the middle of nowhere » point.

This is not what I would qualify as a « fair review ». There are no « false claims » (they did run out of battery, after all !) but the information are given and presented in a way that paints the reviewed product in a specific light.