skysight-inc/HackerNews huggingface dataset:
I don't think that transactions count as deep database knowledge. Those are the absolute fundamentals that most developers need on a daily basis and not some dusty computer science stuff. If you have never heard of them it is fair to say that you should take a step back and learn the basics of your profession before being allowed to touch a production database. But the thing is of course - you don't know what you don't know.
Upvoted.

A friend of mine likes a local deli. The third or fourth time I joined him there, I remarked that the portions seemed sized for people doing hard physical labor all day--digging ditches or working on a loading dock--but that the clientele didn't seem to be laborers. He remarked that with comfort food, the ingredients are the least part of the cost.
Read OP quote again, parent missed the part that shows this is what they are talking about.

>> If the court follows this argument the ...

Op is referring to precedent potentially being set, but I'm not sure it would actually apply in practice. (Different laws)
Bubbles and Tailwinds
> Pretty sure anarchists were (...) shot (...) for setting off bombs

And you would be wrong. In the USA, you can look up the Haymarket Square affair or Sacco & Vanzetti trials, for example. These are just the most famous examples, but obviously not the only ones. More recently (1950-70s) you can take a look at Cointelpro which oversaw the assassination of dozens (hundreds?) of revolutionary militants.

In the history of France, the Paris Commune (and other Communes) have been repressed in blood by the government, killing dozens of thousands of civilians. Defecting from a military draft was also punishable by death, eg. during WWI when "decimating" was the norm.

But beyond that, the rule of law explicitly states that you have basic human rights that should be respected no matter what. In a democratic country, you don't execute people because they may have killed someone else previously; you arrest them to stand trial.

> I get the romantic appeal of anarchism

I don't see anything romantic about it. In my view, it's just the only fair system (or rather, systems) we can come up with to ensure freedom and equality for all. It's very pragmatic: changing chiefs has not helped us, so why not change the rules of the game entirely and let everybody decide?

> It was unions, not anarchists, who were advocating for 8 hour work days

Some unions are anarchist. Famously, IWW was founded by anarchists (such as Lucy Parsons) and they for sure advocated for the 8 hour work day: not as a great solution to all problems, but as a rallying point for further social change through a global revolution. General strike was articulated by Émile Pouget and other anarcho-syndicalists back when the CGT (in France) was anarchist, as a tool for the exploited to demonstrate their power and help topple the capitalist system.

> attacking strike breakers and immigrants

Not saying it couldn't happen, but i'd be interested in sources and numbers. Especially in regards to immigrants, considering labor unions and anarchist circles in the USA were especially populated with immigrants who published propaganda in their own languages.

> some of them were pretty violent themselves

What does that say? Desperate people calling for justice will defend themselves against the oppressors crushing them. It cannot be compared to the cold violence used by bosses and politicians to silence any form of opposition. Or, put as a meme: https://i.imgur.com/LMCJBpU.jpg
Yep, see this classic HN thread on Spotify and SongShift: https://news.ycombinator.com/item?id=24764371
I know the death of drill blog was normal marketing by Starburst, but I'm kinda agreeing with them.

Drill is one of those technologies that people don't think to turn to today if they're starting a new project.

What does Drill offer that would make it out-compete the other candidates for a fresh new project?
If you have the right kind of business, you can tell your customers that it's Google and Microsoft's fault (“they want to keep people on Gmail so they keep blocking everyone else”) and suggest using another email address “while you get it sorted” – they might just do that.

Of course, that is risking significant amounts of money out of your own pocket just for a stupid nerd turf war…https://xkcd.com/743/
In a global but not-remote company the team responsible for the particular service that failed is probably still concentrated in one office. Bringing in people from other offices who aren't familiar with the problem service probably isn't that helpful.
Researchers are discovering surprising capabilities among a group of arachnids
None of that is true, in fact it really is opposite.

Google has to entice people into voluntary exchange, yes the power is imbalanced but it is possible to remove yourself from google, thousands have. You can not remove yourself from government, if you try they will kill you. Google will not kill you if you stop using their services

if I disconnect from my city utilities, if I stop paying taxes, if I grow an unapproved plant, if I do anything the government does not like well men with guns show up...

Further this idea that the government is beholden to the will of the people, even in the ever lauded (and seldom understood) "democracy" is provably false, many many studies have been done that prove the will of the people hardly ever changes the will of government so I am not sure what factual factual basis you have to claim that governments must follow the will of the people.
France throwing shade at everyone else, on a contract that they were Way over budget on, had cancellation language that they knew was a issue, and we’re using a cornerstone of their china policy is breathtaking. Marcon is using the same trick that every single petty dictator of the last hundred years has used. If something is screwed up domestically or you have a election coming up, blame the United States.
Q: Is it unprofessional to leave a new job where everything is a mess?

A: No.

Notes: personally I would have either abandoned it during the first month or at the end of the probation period, depending on severity, otherwise I'd force myself to stick around for the year, so I wouldn't get questions during further interviews for why I stayed there only X months. A "hack" would be to endure until somewhere in January next year and then in your CV write only the years of employment like this:

2018 - 2021 Old boring job.

2021 - 2022 Shitshow job (but don't actually write anything bad in the CV about them, only positives).

2022 - present Awesome new job.

If you write it with the number of months, some (not all) recruiters and hiring managers will get suspicious. I've personally had people (colleagues at previous employers, but also random people at random meetups) tell me they trust people less if they see that on their CV, or even filter out such CVs early as they fear you'll do the same there, even though they had the same situation themselves when I checked their linkedin profiles.

I personally don't care at all about the month range when I conduct interviews, and if anybody brings that up I fight against it, as something I've learned from personal experience is this: most jobs suck, most employers suck, I've had to deal with some, everybody I know has dealt with such; then I switch the subject to what's really important: what can you actually do so we get to hire you.
I definitely see Netflix as a Media Company, much like Disney. Disney and Pixar have great tech too, but they are not tech company in any shape or form.

How Netflix got lumped into "FAANG" aka Big Tech is still a mystery to me.
One of the greatest values of good technical manager is to run interference/shield for your team. Establish a chain of communication, or if there isn't one in place BE the active reporter, to ensure your hands-on-keyboard people aren't interrupted every 5 minutes (and this is a realistic timeline) for updates from various managers, execs, C-levels, and so on.

Otherwise, it's mostly things you can do before and after an incident like this.

Depending on your role and place in hierarchy, yes DO sit on calls, even if you are quiet; to understand what's going on, to help prioritize if needed, to see if your experienced "spidey sense" catches some risk others may not even though they're closer to the problem (or precisely because of it), encourage, guide, and focus; but all of that without being overbearing or making them feel watched. You need to feel like an ally, part of the team, a friend as opposed to political officer. This again is best achieved ahead of time by demonstrating your value to the team by being supportive and effective always.
I was hoping for a list of items that this person tracks. For example, I only manage to track my lifts and run times on a daily basis. I would like to measure blood pressure, sleep time, amount of sugar consumed, eyesight, and working memory, and maybe typing speed too. What about you, what's important to you?

Number of emails is so, so far down my list of things I care about.
It sounds like you’ve already made up your mind and are looking for validation. Not your Circus, not your Monkeys.

Sunk cost fallacies are when you’ve spent too much time/money/energy to make a change…you don’t have a lot of sunk cost here.

That said: Never quit on a friday, make sure you have a place to go if it’s not actively affecting your mental health, the best time to look for a job is while you already have one, yadda yadda.
OK, so you guys are stuck. We get it.

There is no need for this issue to be "solved" per se. Academia can keep up the charade with journals if it needs to, as long as the rest of us can obtain papers via SciHub, this grey status quo serves all parties just fine.
Jai isn't available to public, sadly. That's why I said Zig is "already in the open". Jai has been in private beta since early 2020 and there are about 150 people that have access to the compiler beta AFAIK.

The reason for the language not being available is that the designer (Jonathan Blow) doesn't want to release something half-baked to the world (because "there is already so much garbage software out in the world", or some line of reasoning similar to that). I don't agree with his reasoning, but I understand it TBH. He also has the reputation of taking too long to develop his games, but when they're finally released they're pretty good.

Anyway, it doesn't look like it'll be released to the public soon so like I said, Zig is the best alternative right now -- and it's gaining more and more users, so when Jai finally gets released, Zig might have already won.
NYTimes digital revenue is mostly subscriptions. Other publishers with lesser brand names are much more beholden to Google.
I agree wholeheartedly. I've run into this in interviews after short stints and most places will allow you to explain without being accusatory up front. If they are, that's generally a red flag for me. I will often explain to recruiters/interviewers that an interview is mutually beneficial and if what is told to me in an interview is not true, or intentionally hidden from me, and the reality of the work situation does not align with my beliefs/expectations/morals/etc after asking a number of people about those things then why should there be any expectation for me stay to meet some hypothetical minimum on amount of time in a role? If I couldn't perform my role within 90 days they'd let me go. Why is the double standard OK?

I've been in trainwrecks where the market really wanted things the company wasn't delivering on as paid for product. And it could have been really great. Great brand recognition, great people - yet a CEO that had in their mind they could do no wrong. I left, and received a lot of flack for it, yet within one year that company divested because they couldn't sell anything then magically I was looked at differently. It's often hard to get a good read on a tech company in a few short interviews. Especially those on the smaller side or startups. But I don't think anyone should stay somewhere that was not as advertised and have to deal with a penalty for a "short run". Being candid about the situation without disparaging the company (as the parent comment stated) seems to go a long way and most good recruiters/interviews will be understanding.
>If you go back and read the stuff from Brin and Page at the time, they do actually go to quite some lengths explaining how crucially important it is for search results to be relevant, and the original PageRank paper even outlines methods for reducing manipulation from commercial interests.

What else could they write, even if they were already Satan incarnated?

"We could not care less about search relevance as long as we make big bucks, and if we can sacrifice it in the future, we will"?

I doubt it would have helped with Google's adoption.

Whatever they wrote is just marketing. At best, they believed their own marketing, but they still made a for profit company.

People who don't do it for profit, don't go to build a for profit behemoth. Even in 1999, everybody could tell where Brin/Page stand relative to someone like Linus or Jonas Salk, for example.
The part which was more problematic for me was the correlation between having a comp-sci degree and working backend, it felt like a subtle form of gate keeping i.e. you could interpret this as: haven't got a degree? you will be working frontend/ui.
I find it weird how anyone would want to have a cat - especially if they claim to love animals. Why would you want a little tyrant in your house that occasionally goes outside to kill and torture smaller animals for fun and shit in your neighbours' gardens?
I think people should draw parallels between sci.publishing and social media. They also ask unpaid individuals to publish their writings, then ask other unpaid individuals to review and rank them, then use their algorithms to editorialize and pick the ones they like and then make exorbitant profits. Some of then like youtube will subsidize that with increasingly dwindling payouts , but overall it is a scam based on monetizing content created for free by clueless individuals. Participating in unpaid social media should be considered an equally extortionate thing to do.
>In the good old days they had a trusting relationship.

It's almost like there need to be clearly defined and agreed upon rules for everyone to operate under, with clear consequences for failing to follow those rules. Sort of like some kind of, well, legislation.

Trust and social norms setting expectation is fine when it works. But it will eventually stop working.

So what's the answer after that? How do we fix it without making it worse via legislation or regulation?
>”citizenry who have been convinced by propaganda that government can never be effective at anything and therefore should not be funded properly.”

People are treating the Texas ice storm like it was some comeuppance event but the truth of the matter is that Texas rarely experiences this kind of winter weather and that’s the reason why it didn’t handle the big freeze the same way as a midwestern or northeastern state would.

The reason why cities like DFW do not maintain a fleet of snowplows isn't because of anti-government propaganda, but because it is completely uneconomical to do so. Even during the big freeze there wasn’t a foot of snow on the ground. The major roadways were salted, though, and you could drive on them.

Snow and icing events tend to only happen for a day or two each year in my part of Texas. And it is often the case that when temperatures do dip below zero there isn’t preceding rain or snow. But when that does happen, most people just ride it out for a day or two and wait for things to melt.
I'd argue its more unprofessional to lend your Senior-level software experience and expertise to a dysfunctional org that does not want to make an attempt to hear you out and improve things than to leave after 6 months.
It's possible to keep cats indoors all the time.
How is this HN?
Honestly, the N+1 query problem with ORMs is more important for most web developers than the data structures used and their complexity.
> Adding an option to track food would not be hard.

This would actually be very hard to do accurately!

> online service

An online service isn’t what is needed for the vast majority of people who live with diabetes to improve their management of the disease. It’s either: access to more affordable medication or the desire to manage the disease more effectively.

Yes, Apple entering the space would help the subset of people who are motivated to manage their diabetes (I am one of them, albeit a Type 1). But it would do very little for the overall population of people with diabetes.
This is not a pg specific thing, for instance in SQL Server this is referred to as “spilling to disk”. Large sorts can spill to disk, and the query planner may assume this is going to be done in RAM, based on what stats it has about the relevant indexes, but later have to spill to disk, so pick a plan that is sub-optimal.
Interesting that such a blocky and traditional looking design can claim to get a Coefficient of drag of 0.21

The Mercedes-Benz EQS (similar luxury class) is much more gloopy looking and claims 0.2
there is a difference between 'keeping information from the public' and 'being concerned that partial information is being presented'.

Free Solo is one of my favorite movies of the last decade. In the movie, they are fundamentally and consistently transparent about the sheer danger involved. It probably seems obvious to everyone, but there is danger. If the movie was just artistic shots of Alex Honnold climbing rock without a rope, that were shot in a way that 'simplified' the narrative to the climbing instead of the danger I would have a problem with that.

no one called for keeping information from anyone, they expressed concern that the method of communicating left out critical details that could injure children in a way they do not understand. You can point and laugh at me for doing the 'think about the children' thing but honestly you see children do stuff like this fairly often, because they are children. Your same logic could be used to say we should let children vote, drive cars, own guns, etc. Screw the game operation or doctor with friends, lets give them real scalpels!
It is dead simple. What you're describing (two children, no constraints) is basically a cons cell. Yet I suspect that most people don't use cons cells as binary trees. Which is probably why I didn't understand that apparently rather nebulous topic as being this generic.
If you can't work efficiently in these conditions and can't fix anything, either because they don't let you or because you don't have the abilities, then you should leave, for yourself, for the company, and hopefully, for your next job.

I see two possible outcomes for your project: either they manage to hire (hopefully very well paid) people with the necessary skills and authority to clear that mess, or everyone competent will leave and only the most desperate will stay, and it will be terrible. If you are not a respected project savior and if you are competent and not desperate, then your place is elsewhere.
THIS advice is Spot-on!

I might add as a prospective new employer— what did you learn from this experience?

Essentially, I’m looking for leadership acumen and decision quality.
Oh for fucks sake, every month this topic comes back. It honestly doesn't matter if the fundamentals are useful or not. What gets me is that programmers want to be hired by top-tier companies and earn massive salaries without putting a single drop of effort into actually acquiring the knowledge that justifies that position.

Can we just collectively swallow our privilege and stop whining that an employer is asking for proof that you've actually put the effort to be an engineer before they dump a river of money onto you? Look at how lucky you're before whining that the world is unfair, and shut the hell up about fundamentals.

The interviews surely aren't perfect, but the constant whining is ridiculous. Why not just study it and be done with it already?
Relearning How to Learn with Tim Ferriss
Call it driving with hand brakes on.

You have bought your 1000 hps car and are driving it as-is since you left the car dealer's parking place. Nobody told you to release the hand brakes.
Can you share your sources on this?
An alternative to hacking your resume is simply leaving the short position off altogether. Your resume doesn't have to be a total transcript of your career. It should just be a highlight of most relevant experiences for your desired job.

The same goes for really old jobs too btw - having a detailed explanation of your exploits in Java Swing on page 4 of your resume is likely distracting and irrelevant. Consider making your resume a single page with older jobs grouped together like "1999 - 2008 Various software gigs for Employers1 thorough Employer5"
To me non-ACID means you can never use any logical reasoning to have an idea of what there is recorded in your database at any given moment. ACID means you execute a piece of code in a transaction and if something goes wrong it fails altogether returning you to the pre-transaction state. Am I wrong?
No, it's not unprofessional and don't let anyone convince you otherwise.

A couple of years ago, I joined an analytics / big data / data engineering shop. I joined because I was in the process of finishing my thesis in physics, they gave me an offer early, and I didn't want to keep looking as I needed to reserve time for preparing for my final exam. Also, I was interested in data engineering, as it was a good mixture of math and software engineering practices.

When I got there, the skill levels of the developers surprised me. They knew very little, when I told them we should have an easy to setup dev environment, automate deployments, write tests, they looked at me like we didn't speak the same language. They just didn't get what I was saying and many of the concepts were totally new to them. The projects were boring and the technology was outdated. Nobody had a clue about communication, agile dev, XP or anything else that I value.

I stayed 6 weeks in total. 2 weeks to realize that their culture is terrible and it would make me a second (third?) tier, unhirable dev if I stayed. 2 weeks to find a new job and get a much better offer from a much better company with amazing people. 2 weeks because that was my notice period. Didn't regret it for a second and nobody else cared about it since, either.
If you’re not happy there then move on. Sometimes jumping ship sends a more vocal message than any thing else
I think it's a bit too specific. But for sure someone can relate to similar experience. Something like "For sure I haven't dealt with Druid specifically but in my job I tackled with a similar problem for a different set of tools...".

BTW from my experience we are streaming a lot of data (similar to 10TB but definitely more) produced in JSON then converted to Avro using Spark and finally loaded into Vertica and the analysis pipeline. I have never used Druid but from Googling it is a column based data store which I guess is not too different from Vertica. Is there any specific difficulty you think would be encountered with Druid? Because the wording seems to indicate that Druid is not particularly good with ad-hoc analysis.
Google Takeout exports MBOX files for Gmail. I don't know how well they follow conventions supported by other MBOX-supporting tools though.
So this is just a rehash of same court document few days ago?
> the foreign user is potentially liable for felony criminal charges in the US

US law does not apply to non-US citizens. How could a foreigner possibly be liable for anything?
"vote with your wallet" is a useless aphorism when it comes to implementing systemic change. In order to stop Google from abusing its dominance, billions of people would have to simultaneously choose not to use the best (?) and most popular set of products. Free market activism doesn't work for consumers.
Prepare your own magical drink that helps you lose weight without dieting