skysight-inc/HackerNews huggingface dataset:
Wonderful project.

The database seems to be growing rather slowly, it has about 100 entries globally; only five entries have been added in 2022.

In sure HN visitors would like to add their own favorite niche museums. Is there an way to add an entry or submit a suggestion?
Yeah, but that ZFS server is likely in the same rack that's going to get knocked out when the data center gets sucked into a tornado, or whatever. Weather it makes sense to have someone on staff swapping tapes, rotating backups, shipping them offsite, and keeping records of what exactly is where not to mention handling AND TESTING restores really depends on what your data's worth. For most places, it's cheap insurance.
> Tougher but damaged.

You're thinking scar tissue, which analogously would be a maladaptive response to criticism (inflating ego, projecting fault).

Muscle strengthening doesn't cause permanent damage unless you overdo it.
Not surprised.

Enterprise software is always *enter-pricey*.

Lots of $$$ poured into consultants and very little to the folks who actually do the work and implementation.

And of course, a project (or program in corporate speak) of this magnitude will have a lot of meetings involving a lot of people that usually ends up in very meaningless decisions.
> Councils are I think too small to access GDS?

Councils probably don't want to access GDS. Why lose all those sweet vendor kickbacks? Free ticket to this, free travel to that...

There is a lot of corruption in Britain at the lower level of government. It's all in plain sight, it's all legal, and because it benefits the same networks (someone would say "classes") that are structurally in power in Westminster, nothing gets done about it.
No, sorry. It's just polling HN via the Agolia API, so if you post on HN publicly, anyone can poll for that data.
> Unfortunately this constraints the argument order

In both C and C++, it drives me absolutely bonkers that declaration order matters so much.

Point of personal preference, but they're the last languages I use with any regularity where you can't just reference a symbol that will be declared later in the file. In this case, the compiler should be able to figure it out without any of that hinting; the scope of potential valid bindings is in the parentheses. It's a very constrained scope!
After reading these comments I am very grateful that I have never seen any of this garbage. The main places here that use the QR menus are those reinvented food courts (don't know the hip new name). With those you order through the website, it texts you when the food is ready, and you go pick it up. Some of them make you pay at the website and other you pay when you pickup. The advantage is that that you get to spend more time together at the table socializing rather than dispersed standing in line at various restaurant stalls. The downside of course is that you then get text spams after leaving.

How do those PDF menus even work? Do they have a waiter come around and take your order? Do you order up front and the QR menu is just a convenience in addition to a large menu sign?
Aliens and Terminator 2 revealed something about sequels I think.

The first movie in each case is horror, the monster is invincible and the hero is super weak, just trying to survive. By the end, the main character has survived and is now a certified badass. There’s no way to make a horror movie sequel without resetting the main character’s development. So instead, they made action movies, which was the perfect decision.

This is also why there couldn’t be a good third movie, there’s nowhere natural to go after action.

Maybe one could slip a disaster movie in between the horror and the action…
IMO the biggest reason folks use pgbouncer is not for load balancing (which it can do, -ish) but instead for connection pooling. Postgres connections are expensive for the db server (one process per connection not one thread) so if you have say thousands of web application pods you need to use pgbouncer or similar as a proxy to multiplex those thousands of connections down onto a more manageable number (~200). So no, not really.

(EDIT: if you don't know this already - the _establishment_ of connections is also super expensive. so another reason to pgbounce is to keep connections persistent if you have app servers that are constantly opening and closing conns, or burst open conns, or such like. Even if the total conns to pg doesnt go super high, the cost of constantly churning them can really hurt your db)
You know, you could consider getting therapy. Being sensitive to criticisms often results from something deeper, such as insecurity or some kind of vulnerability. There are lots of different therapeutic modalities, but CBT may work well, since you can look into the roots of this mindfully, and develop meaningful changes. The outcomes can be more than better coping or masking.

I’m going to go out on a limb for the next two suggestions, particularly the second one.

Psychedelics with a strong therapeutic intent, can not only help loosen the psychological armoring we create to shield us from vulnerability, but also help make changes when belief structures can be cleaned up and changes. You would want to work with people who do this way (instead of partying with it), or with therapists that administers this with a clinical protocol. These should include integration sessions to help bring the insights and changes to your daily life.

There is also the option of working with acupressure or acupuncture, with the caveat that most licensed acupuncturists do not know how to work with this. They usually take a holistic approach and stick to what are called the twelve ordinary meridians. If the roots of sensitivity to criticisms is in your physical health, this may catch it. Holistic treatment though, means the provider won’t specifically target what you came in asking help for.

If you are lucky and find a provider that works with the eight extraordinary meridians, there are two specifically related to sensitivity to criticisms. These are the yin and yang qiao mai, with the yin qiao mai directly expressing your consciousness’s ability to receive criticism, as well as insecurity, vulnerability, etc. Yang qiao mai expresses your ability to give others criticism without being a jerk.

It’s not as if using these methods are like using a magic pill. However, they can greatly accelerate whatever therapy you are working with.
> Remove filler, upsells, click bait and other low or negative-value annoyances.

https://github.com/taylr/linkedinsanity
I'm pretty sure consul builds on top of hashicorp's Raft implementation so I'd say end result, yes, but that this post goes into the Raft implementation.

And I'm sure consul does plenty my silly key-value state machine doesn't.

I'm not super familiar with it.
Mullvad. I like their service, I've never had any issues with their application or network and I like how they do their business (the amount of privacy they provide).
Haven't really checked how they stack up price-wise. Feels like they are not too far from others and when it is a high quality service I don't really care to price compare too much.
I design products, sometimes for others and sometimes for myself. A lot of that process is visual design. Everyone has an opinion when it comes to visual design. I stopped letting criticisms bother me because they had one of a few outcomes. 1 - it created an improvement of the product. Great! and I got to learn something 2 - someone had an opinion. None of these things warrant having your feelings hurt.
Glad that post resonated! <3
Was this because of a missing index or because the optimizer vomited on the queries without an index to provide it statistics? My gripe with RDBs is generally the query optimizer is non deterministic with respect to the query, I.e., it can make a great decision with certain statistics and flip to a terrible one with slightly different statistics even though the original query would have performed basically the same.

I’d rather have a database that query performance degrade gracefully and predictably with scale than some sort of black magic mumbo jumbo wake me up in the middle of the night because it lost its statistical little puny pea brain simply because it couldn’t compute a bounded expectation any more.
Unless the small data changes often -- then DBMS needs to change both data and each index.
This is a cool idea too! The easiest thing to do here would be to schedule it to run daily or weekly instead of hourly. But you can also build this aggregation thing too on Val Town. Lmk if you want a hand with that!
> low self esteem from ... non-constructive or overly harshly presented critique

ok firstly Comments about the individual in a CR is way out of line.

There is a massive difference between "This code will fail in <a certain way>" and "You failed <, again, like you always do>" ... The latter is out of line and should be addressed head on with a manager present or a person who will enforce it's toxicity.

Now that said, criticism of code should always been allowed. It either has certain properties or it does not. A discussion of economics (scope/timelines/applicability) are a middle ground. But either the code has a race condition or it doesnt. It's easily read (which is best judged by the reader, not the writer)... It's missing some property that is desirable.

If one takes a criticism of code as a criticism of self, that is ego crossing over to where it doesn't belong. I like to remember The bridge will either hold the load or not regardless of how one feels about it. "This wont hold 1 ton" is better information than "Have you considered what happens if you put 1 ton on this?" .. The former informs you of something that must change, the latter leaves uncertainty and obscurity where infact the answer is already known.
Your perspective should be that you are on the same team trying to achieve a common goal.

Do you get upset when you’re playing soccer and a teammate calls out for a pass? Or when you’re playing a video game and a teammate calls out an enemy approaching you from your blind spot?
Part of this reads as if you're not allowed to be criticized for some reason. How is "I am not a perfect coder" really different from "I'm inherently flawed"? Being flawed just means you're not perfect. People are flawed. Everyone is. One doesn't have to feel bad about it. One only needs to take responsibility for it. And then one can actually feel good about having acted responsibly.
Speculating, but presumably this table only needed consultation during creation of a new user session. That’s probably a pretty heavyweight operation to begin with, so adding a scan of a few KB (user IDs being modestly sized integers) for every thousand currently paying users is NBD.
Breakpoint: Add breakpoints to GitHub Action workflows
Elon Musk Fails to Launch Ron DeSantis in Disastrous Twitter Space
Add breakpoints (static or on failure) to GitHub Action workflows; and SSH in to understand and debug failures. Open-source.
> CloudWatch Logs Insights, Snowflake, Grafana Loki

And the common thing in this list of tools? They're all laggy and not a nice experience to use.

Even if queries are rare, there is often an actual human sitting waiting for the results of a query. Whereas while ingesting logs, there is no human waiting. I would prefer to burn more CPU time to save some human time.
Algorithmic fanboy
I have yet to meet a software engineer who is highly competent and also suggests rewriting a working application in Rust at the 11th hour. In fact the people you are talking about are mostly juniors who read something in an article on a random webpage.

By the way you are talking, no, you have not worked with people like me. Most products are garbage because of poor planning, poor market research and bad/rushed engineering.

Tell me you don't know anything about Apple without telling me that you don't know anything about Apple. A lot of their engineering is absolutely bleeding edge. Right now I am working on improving/adding features to a real time ray tracing renderer that works at 30+ fps on the latest iPhones 14 Pro. Most people's desktop PCs cannot do real time ray tracing and yet Apple does it on a phone. But I guess that is not bleeding edge...
The State of Israel (including Area C under the Oslo Accords) had a population of ~9,650,000, of which ~7,100,600 are Jewish (for reference, about 600,000 are settlers in Area C, 250,000 of whom are in East Jerusalem). ~3,990,000 Palestinians (Muslim & Christian) live in Areas A and B. If Israel were to annex Areas A, B, and C, the total population would be ~13,650,000, with 7,100,000 Jewish people and ~6,550,000 Muslim + Christian + Druze people [1]. So, a slight majority would still be Jewish, but that would completely change the demographics of the nation.

---

[1]: https://en.wikipedia.org/wiki/Demographics_of_Israel#Definit...
I had read a Joel Spolsky post about how they used to get an email every time they made a sale (“Ding!”) and the day they finally turned it off was full of pride. (I did that too, originally not even filtered out of my inbox.)
No questions, just solidarity and a wish for your future successes.
That's the thing that I find unconvincing about webauthn. There seems to be no other way than to associate several key devices for every website you are using if you are concerned about losing a key device (or get a new phone, new laptop w TPM).
Evil Dead went on the same journey, more or less.
I didn't realize one of the larger Luddite revolutions of my time, would be how folks want to order food when they go out.

Are there some annoyances with implementations? Of course. I've also had terrible cashiers before. YMMV is true of the old and the new.
Past history suggests they'll get away with it extremely easily: https://en.wikipedia.org/wiki/North_Korean_abductions_of_Jap...
By definition, the changes will also be small. It's just not possible for it to blow up in a way that would cause a problem, because we're only talking about tiny tables. There's nothing you can do in a single[1] index for a table with 350 rows that will cause any heartache vs. an unindexed table with 350 rows. 4 of the 5 examples in the article are just "this table is too small to care."

[1] Edited per discussion; a large number of indices on a small table can still get you in trouble.
Indexes are such an easy thing to add. I don't get it. Seems like under optimization when you consider the tradeoffs.
When AI takes your job, you may not even know it
Tesla has a 10% market share in China.
Mis-remembered the phrase, it's /r/LinkedInLunatics.

Thanks for the callout!
The pro tip is to attach your self worth not to your skill, but to it's first derivative!

That way any criticism that helps you improve your game, no matter how unpleasantly delivered, is a power up.

I say it glibly, like it's easy, but it works if one can internalize it.
Can you give an example of "insults"? I have to say this line of thinking really bewilders me... perhaps I've never worked in an environment with this kind of toxicity.

Typically the sensitivity level of feedback in my experience has encroached into things like "Don't give 10 comments on a PR, its too many and people feel bad" (regardless of the number of faults in the code).
There are browser plugins that will do this. I use one, it does wonders for my mental health.
Well your question was vague and not actually what you are referring to: it was a simple “would you rather.” I think the comparison is useless given that comparing the entirety of the life experience of people in two different eras does not actually contribute to a conversation around the core point being made here: having ridiculous levels of wealth is not the same as having a decent paying job in which you are still reliant on the income to survive and therefore are essentially tied to that opportunity of labor. A more valid comparison would be, as I pointed out earlier, between billionaires and any class of people who “have to work for a living”
MS Word, huh. Hmm... Yes I guess it satisfies this one condition I have. Haven't used it for ages. But it's a key feature for me not to be cornered right from the start, so I would think it's ruled out anyway. Also, moving along the axes should be difficult without changing the document first, which is quite annoying, iirc.

Maybe I shouldn't have mentioned a Microsoft product, since I like Unix more. I just thought the problem is understood more easily that way.

Treesheets seems quite nice. Maybe I'll try it out, but I'm still hoping to find a cleaner alternative.
Whenever you do a one day full of updates and fix small issues but also gain new features and performance, just remember there is someone who uses some super old db no one wanna touch it again and the migration of that old thing will take weeks!
There are no Jewish settlers in Gaza, they were forcibly removed by the IDF during the disengagement in 2005.
Humans used to do agriculture work and hunting. Now we don't need to do that, but we do exercise.
Indexing doesn't add much for very small tables. It also doesn't really help much if the cardinality of the data is low.

I usually index any columns that are used in joins, or frequently used in predicates.
Many tram lines were built by developers at a time before cars were affordable. Otherwise there would have been no way for the homeowners to commute to work.
What is about HackerNews and the obesession with the decision to remove Nuclear Power, which was only a minority component at it's peak, from the German energy mix, as somehow being the dominant factor in the entire German society and economy?

A while back someone unironically described Germany's nuclear power policy as "the single most catastrophic decision ever made by any government in peacetime".
It shouldn't be, but it is. The latest scams all involve calling people from local looking numbers (same area code), since it's more likely victims will pick up.
Nope; it was used every time we needed to look up whether someone was a subscriber, which was cached for some things but not all of them.
> then why am I being asked to bail out a generation's college loans

because the previous generations fucked it up and pulled the ladders up behind them.
A New Rule of Education for the Age of AI
https://pimbook.org/ Read this instead
Indexes got me from 15 seconds down to under a second. I'll always use them even if they wind up being as much space as the actual data. MySQL is just weird that way.

Edit: believe me, I tried it all... refining my queries, multiple tables, bigger hardware, faster disks, changing all the tuneables... nothing was as good as adding a whack-tonne of indexes.
The downside to allowing blocking is that the site works best when you downvote that kind of content, because then everyone else doesn't have to be subjected to it. It's why we resisted a block feature on reddit for a long time. Because the site only works if bad stuff is downvoted.
What is the rule that you use on which fields to index? I've been following the general when adding fields: if the field is mentioned in a sql WHERE, ORDER BY, or GROUP BY

EDIT: JOINs
Maybe not outright exiting the EU. But maybe exiting the Eurozone and removing some other problematic economic straightjackets like overly large tax-financed subsidies.
It's hard for me to even believe you have actually raised chickens if you're going to say there's no real difference between factory farming and home slaughtering of poultry.

A chicken coop on a farm with a couple dozen birds has the birds freely roaming around the yard or within a protective fence, getting to eat bugs and scraps of vegetables from the family dinner table. The death is as simple as putting the chicken's neck against a tree stump and swinging a blade. Yes, it's bloody, but it's not an assembly line of birds screaming as they head down a conveyor belt to their death.

There's no filtering machine on a factory farm that filters hundreds of baby chicks in a dozen minutes and sends the male chicks into a blender and the female chicks into the factory.
This is trying to have your cake and eat it too. Imagine "supporting the state but not everything the government does" in Germany in 1938, or South Africa in 1980.
There are many more Israeli civilian casualties as a result of terrorist action. Though there are Palestinians who have been killed by Palestinian terrorists as well. But I would add them to the tally of civilians casualties of palestinian terror. Not clear where you’re getting that more palestinians have died from terrorism.

The IDF doesn’t regularly bomb refugee camps to take out one terrorist. They often have precision strikes that take out a single person. The IDF has very often canceled a strike due to civilians/children getting too close.

The first link appears to be an actual battle that was rebranded a massacre for optics. In an active battle during a war non-combatants will die. Calling that terrorism is simply dishonest.

The 2nd link was blown wildly out of proportion, a group of Israelis rioted and burnt down… a junk yard. The before and after don’t look that different. This was again a large effort by anti-semetic western media to paint the Jews as in the wrong and totally ignore the multiple murders/terrorist attacks committed by the local Arab population in the very recent past (as in same day). This was an angry mob response to an unjustified killing…hmmm does that sound familiar, are you calling the 2020 protests terrorism?

This is as simple as it gets: the Arabs take every chance they get to murder Jews. The Jews take great pains to defend themselves and protect all life in the vicinity. Do they fail sometimes and kill someone unintentionally? Sure but they also hold themselves to account, and take every (even unreasonable) effort to only target those who are actively threatening other people’s lives.

I don’t think you’re being honest in your argument.
Germany’s Cybersecurity Architecture [German]
2000 wasn't that long ago either, but I still see people using 2 digit years.
Kudos on making the update! Makes sense that you might not find it if you didn't know it was there. Python's "batteries included" means most things you may want to do, you should check to see if there is a standard lib option, as well. Sometimes it is barebones enough that you may want more, of course. So, really nice to see all of the options you presented.
Yeah, nothing within 450 miles of where I'm at. Personal local favorite: https://en.wikipedia.org/wiki/House_on_the_Rock
They add overhead to updates and inserts. If you don't need them, why take that hit. Know your data.
Yeah that was my thought too, and I thought about fishing out the unbranded $1 1Gb microsd in my drawer I use for 3d printing to help him out with his 0.5Gb storage challenge
Certainly not, but one wouldn't need to catch every satellite launch for space weapon- one or two would be enough evidence to go public and warrant further scrutiny. There are a number of extremely savvy amateur astronomers across the world that track suspected military launches and publish their findings:
https://sattrackcam.blogspot.com
Birmingham council is run by Labour but Westminster is run by the Conservatives. Unless by classes you mean all politicians, it's not the case that it's all linked back to central government.

Besides, corruption isn't needed to explain this. ERP projects fail all the time, with SAP as well.
I wonder if this can be achieved with uBlock Origin.

Like delete the div where div > div > span=WirelessGigabit.
Obligatory reference to great website Typeset In The Future [0], with an analysis of fonts used in various movies:

"The five minutes to destruction are typographically uninteresting."

[0]: https://typesetinthefuture.com/2014/12/01/alien/