skysight-inc/HackerNews huggingface dataset:
I've done it twice; the context is completely different on why though.

Job #1, we were a heavy PHP/MySQL shop with a smattering of Ruby. I had come from a PG/MySQL shop and knew the merits and pitfalls of both databases (PGs auto vacuum being a particular point of contention at my job before this one), and informed the CIO that going to PG instead of following the upgrade path to MySQL $latest had a number of minor improvements and since our SQL was /mostly/ standard on the frontend we could attempt the change.

I was in charge of testing and automating deployments of the test environments, so I set about massaging the data into PostgreSQL-types. However, we found that our data had been being silently corrupted over a long period of time. Dates were often very incorrect, values of not null columns were filled with the "empty" of whatever it was (0 for int, "" for string etc).

We managed to get the data into postgresql and a lot of our tools stopped working, the commerce site itself was working thanks to the efforts of two really committed developers, but the back office tooling was not ported. Due to the sheer amount of queries we had which were running silent failure modes (which postgresql does not allow to run) we ended up going back to mysql rather than fixing them.

I don't work there anymore.

Job #2, We were a heavy C++/MySQL shop, MySQL just because it's what everyone knows, and because everyone knows it, it becomes a standard that is hard to move away from. I was tasked with getting 50KiB~ binary data blobs to be saved with a high update frequency, strong consistency and ideally alongside its locks.

We tried to coerce mysql to do the right thing for a very long time, we rented this huge iron server which had 42 directly attached SSD's in RAID0 (to test the limits of the software as a control, not for prod-like environments), 60 CPU threads, one of the best raid cards you can buy etc;

What we found was that MySQL couldn't climb above 600qps for this workload, no matter what you did, we even ended up recompiling the kernel with a faster implementation of sockets and ipc, and changing the memory allocator mysql used (which was unsafe), but we couldn't get it to move much faster than that.

So, on profiling we found that it was spinning on an internal lock, something we couldn't engineer around.

600qps was well below our target, so we started looking at alternatives. It should be noted that one of the requirements was that the data be fsync'd before returning OK to the application. I say that because 99% of noSQL databases only ensure that their data is in VFS.

We tried postgresql as our only non-noSQL test, since it's similar enough to mysql's syntax and easy to test. The C++ developers fell in love, instantly with the C++ SDK for pgsql, instantly referring to the mysql equivalent as "braindead", and the database scaled linearly with I/O, even as we added a additional arrays of drives eventually saturating our 40GBit NIC.

Now we run postgresql as our only RDBMs.

I still work there.
Don't have any links handy but apparently keto and lowcarb increases survival odds.
This entire discussion is very interesting, with arguments for and against the idea that the underlying materials technology was (or was not) sufficient for a bicycle to have emerged 50 or more years earlier.

This discussion is similar to flawed arguments about evolution. It assumes that at any given point in time, there was an exhaustive search of solution space (in this case for personal transportation). In discussions of evolution, people often propose that a particular solution occurred because it was optimal in some way.

But neither evolution, nor technology development, involves an exhaustive search. Things happened by chance, and some things were not tried as early as they might have been (or they were tried and tried and found lacking in some way), until, by chance, the right conditions allowed the technology (or evolutionary trait) to emerge.

The role of chance is often under appreciated.
> poorer people aren't poor because of low IQ, if anything it's the opposite

What kind of data would you accept as falsifying this belief?
> In a capitalist society, something being a right has no bearing on whether you need to pay for it.

Right, which is why there are no purely capitalist societies in the world. Every "capitalist" society in the world regulates "free" enterprise in some way to protect that society from the consequences of unbridled capitalism.

Edit: Am I wrong? FDA doesn't just say "let the free market decide what risk is acceptable for a drug", or "you can just pay more for food that doesn't have a high chance of making you violent ill". The FAA doesn't just say "oh consumers can decide whether they want to fly on an unproven jet". They recognize that the damage will probably be done long before the free market reacts to it. I don't see how protecting privacy is logically different.
IndieAuth is an open protocol, the others are companies with proprietary products.
Well that's fascinating...
Why not let that word live it's own little life?
Depends how big the dish is. But at the size where it would become competitive for endurance and risk tolerance you might as well charter or buy an aircraft that'd do a better job.

If you want a drone that's safer than the average helicopter, you're going to be paying a lot of money.
I love having business logic in the database. Nothing changes faster than your customers minds. Having it in the DB allows for quick and easy changes without having to go through a painful tedious build and deploy cycle, which can be especially painful when you have a billion front ends touching a smallish number of database servers. Also, if you're trying to "hack" SQL by attempting to code interfaces and classes, you're doing it wrong. SQL is not your application language, please stop! Perhaps study SQL for a minute or two before attempting your needless hacks. Your DBA will thank you.
I agree with most of what you wrote, yeah. It's a real problem, and the second sentence of my previous comment was meant to affirm that.
Gitlab (YC W15) Is Hiring an Engineering Manager, Ecosystem
I still don't understand how that works. How do you avoid having two unique, mutable references to the same value in that case?

For example (pseudocode):

void f(shared_ptr<Foo> a, shared_ptr<Foo> b) {
g(&mut *a.field, &mut *b.field);
}

This is unsafe because a and b might point to the same object.
It is important conceptually because it involves essentially a petition of government power and a check on abuse on both sides.

If they provides absolutely horrible public service as in callously calling the rape victim a slut who deserves it and then later denied the misconduct and circles the wagons that is important.

Or if the abuser of the calls isn't held accountable.

Transparency vs privacy isn't a straightforward matter and there is ample room for debate and differences in opinion.
> Just hearing this stuff, I would never imagine this production is profitable.

It sounds like NBC doesn't even make money off their re-broadcast of it: https://www.velonews.com/2019/07/from-the-mag/inside-nbcs-to...
IRBs are not legally required, and most IRBs are excessively risk-averse (an IRB doesn't lose anything for denying a study, but a study with a bad outcome can give those on the IRB a bad reputation).

Suppose you are ethically allowed to do A (show ads), and are ethically allowed to do B (not show ads). Then you are ethically allowed to run an experiment in which the only thing you do is A or B.

You can definitely argue that showing ads (or certain ads) is ethically bad. You can also argue that there should be legal requirements for ethics reviews on all research (which is not currently the law).
Everyone I know at Google hates these “protests” and can’t stand the entitlement. It sounds to me like they are a vocal minority.

This has nothing to do with transparency and speaking out against your employer. The issue is not that they have a voice, it’s how they choose to use it.
From the actual article: ```She was one of six women who organized massive walkouts after reports that Google paid handsome sums to executives accused of sexual harassment.```
a 200hp hot hatch already has more than enough power to make a quick right turn or merge into a faster lane. you don't really need more unless you're trying to race people on entrance ramps, which is a race you will eventually lose to some insane tuner no matter how much money you spend.
This is proving my point. Look at the lap times on Laguna.

https://fastestlaps.com/tracks/laguna-seca-post-1988

Most of the stuff around the 1:45-1:47 mark is a hot hatch, a grand tourer, or a muscle car.

Seriously, you gotta understand, I'm super hyped for the electric GT series with the Model S to take off, but these are not supercars. They're comparable to an M series BMW or a nice muscle car, which is fine.
Tesla's are inherently very safe because they have such a large frontal crumple zone with no engine and the floor is a solid battery which helps with side collisions.

https://techcrunch.com/2019/07/04/watch-how-tesla-model-3-ea...
All check valves leak to a certain extent. Not arm-chair quarterbacking here, but (without seeing their fault tree) I would expect them to know that.

Expecting them to see the 'water hammer' issue is a different story
White CEO Wanted
AWS Aurora also lags Postgresql behind its MySQL offerings.
You could be direct with the coworker and call them out on their ulterior motive to pad their resume, but if you've misjudged their motive you'll look silly. If being direct is not an option, attempts to dissuade the coworker from using shiny tech overall won't work. Two suggestions --

* A more granular pushback is needed, for instance, "we shouldn't be using package X because it's not MIT license" or "the package has a higher memory footprint for what we need, have you tried package Y instead."Document these pushback arguments into a checklist to ensure your coworker has checked off before using new shiny tech.

* Convince others rather than your coworker of arguments against using shiny packages, articulated in terms of delay, extra cost, problems down the road, etc. It's an indirect approach but you won't be alone in pushing back on the coworker's scheme.
Not really, I cannot access to EAP/ER (Early Access Program/Early Release) books. Only published ones.
My entirely vague understanding was that the Orthomolecular Medicine folk were semi-quacks (the same ones who brought us Vitamin C Megatherapy). I'm not terribly familiar with the field though, is there any real reason to be suspect of this research? It looks like it might be cherry-picking studies.
Ajit Pai’s new gift to cable companies would kill local fees and rules
That's irrational.
Related to this, you may find many of the youtube videos by Dr. Eric Berg interesting. He covers many topics related to this, including many of the things to avoid and to include to minimize risk of cancer and numerous other poorly understood chronic issues.

I have been super-dosing vit D, K2-MK7 and magnesium chelate to reverse calcification of the arteries. It is slowly working. My BP is slowly coming down.
We need to weigh the purposes and drawbacks of policies and try to strike a balance in practice. In the case of public records, the purpose presumably is to fight corruption and maintain an informed electorate; the injury to personal privacy a major drawback.

100% agreed. Monetary costs for records is a common approach to this, although many agencies allow for the costs to be waived at the request of the querying individual. It's entirely up to the queried agency to decide if they want to waive those costs or not, and it's a roll of the dice if that agency will bless you with waived fees.

Another way agencies have added "cost" to the requesting practice is through complicated and lengthy forms that are mailed to the local agency (and some agencies, I will offer, absolutely will NOT let you just walk in and hand over a form ABC-123, and require it to be mailed with a postmark). At least, complicated for the individual making the request. These forms though I think do a very good job of helping records divisions enumerate the type of requests that come in, the volume at which they are received and provides an excellent catalog for the types of data most commonly requested by the public to make searching and disseminating the requested records more expedient for clerks and court reporters.

But I absolutely agree, additional policy crafting is necessary to answer some key questions:

1) What should be released and how

2) What is the appropriate mechanism for making a request and what systems of work are engaged by jurisdictions in issuing a release

3) What are the conditions for a legally appropriate and publicly-interested release

I think this is as true for 911 calls as it is querying a comptroller for city budget items.
SysAdmin Day Sales – Linux Foundation
Rowboat politics. If one of the rowers decides that she doesn't like the direction the coxswain is steering and starts to row in the other direction, it tends to annoy the other rowers. This is true whether she is right or not. If she can't change the coxswain's mind it's better for both her and the rest of the crew for her to find another rowboat.
Humans may be accidentally geoengineering the oceans
AI Portraits Ars – Realtime painted portraitsin classical style
So many arm chair lawyers on HN. The parent is wrong. It's illegal because it violates the NLRA, not whistleblower protections.

"Protected concerted activity".

If you want a good primer, "Labor Law for the Rank and Filer" is a good one.
> Unlike Audible, however, it's easy to game the system by subscribing and quickly unsubscribing.

You can do this on Audible without problems. I have an Audible library of 15 books that I accumulated over a few years through various promotions, never paying more than 33% the normal cost of a subscription.
As others have said, Khan Academy is great. I used it to prep for the GRE after being of college for 5 years. I took my answering very seriously, so I would only move forward if I got 5 questions in a row correct. If I continued to answer wrong, review the session.

If you have the time, community colleges are also a worthwhile approach (if you have one). Their entire purpose is to help strengthen the community. Many are taught as distance courses or even night courses because they recognize that the people that need this education probably can't afford to attend during traditional school hours. Finally, it adds a small level of accountability to your education. You paid money for the class, there is a specified time and grading rubric for class which forces you to continue while something like KA or other MOOCs have very high attrition rates.
"Using elephants to visualize how much fuel a Saturn 5 used per second" https://imgur.com/gallery/5Zl5NmT
Ask HN: How do you organize, maintain and collaborate on Jupyter notebooks?
We are starting to have large and important jupyter notebooks, that multiple people work on. The primary use cases we have are in-depth analytics and building machine learning models.

It typically works fine when you first create and build the notebook for the initial task. But as soon as we iterate on it with other team members and new features or questions to be answered, it leads to messy, non-DRY and hard to review code. In addition, there's always uncertainty as to whether changing a function breaks other parts of the notebook.

This paradigm feels a bit different from the traditional paradigm where we have different files, modules, and various kinds of tests for each of them.

How do you and your team maintain, organize and collaborate on notebooks effectively?
>We're ostensibly talking about records that were made public by law so I think that focus is 100% warranted.

One last comment. Yes. But I'd argue (and I imagine you agree) that many of the tradeoffs considered when those laws were passed reflect, among other things, that "public record" didn't originally often equate to big publicly accessible database.
What you're describing is smart business.
Seriously? Leaders who hired you and pay you are entitled to direct your work. What planet are you from?
That looks very bad.

On the other hand, if you're organizing a walkout, you're probably pretty fed up already. How far are you from quitting at that point? Probably not very. If you organize the walkout and nothing changes, even if there is zero retaliation, do you quit?

At a minimum, this probably indicates that there was not enough improvement, fast enough, at Google.

Note well: I am not saying that there was not retaliation. I am saying that this, by itself, does not prove retaliation.
> But as it is, I also need to think about how I'll sound if this call is being played on the news or Twitter.

If that matters, perhaps it wasn't an emergency that required the use of 911?

I imagine if you had a short-lived mental issue that caused you to go to court over it but were eventually found innocent, that might also be viewed as highly private, but the records would likely be public.

There will always be edges around any law or policy where positive outcomes are not includes and negative outcomes are. It's trivial to come up with negative outcomes for almost anything, the question is whether frequency of magnitude of the positive and negative outcomes result in a net gain of enough to make the law useful overall.

The question is not whether 911 calls include private information. They do and invariably will by their nature. The qeustion is whether the gain by making them public outweighs the loss, and whether we can incentivize the positives while mitigating the negatives.

One possible way to do this might be to make them gates through providing your SSN and name (which is then attached with a timestamp to future requests as an access log), severely rate limiting based on requester's SSN and name (with the ability to petition higher limits based on profession/need, automatically expiring over time), and licensed by the governing institution to only be used/copied in specific ways.
It's a production with actors. Sometimes expensive ones. It's surely along the same continuum that explains why a 90 minute movie or season box set is more expensive than the book it's based on that takes weeks to consume. Wouldn't surprise me that consumers value it higher than "just a book."

Another way to look at it: that's 21 hours of content for $35. Doesn't seem crazy compared to, say, going to the movies or buying a $60 video game that might not even have 10 hours of gameplay.
This was a fake wanted ad but I routinely receive recruiter emails invidiously discriminating on the basis of age by specifying a max experience level.
Just something to note the company Ortho Molecular is a company that sells high end vitamin supplements, probiotics and other similar things.

Not that it undermines the findings, or makes it less true just something to keep in mind.
If you're the one paying for the work, you're entitled to say what the work will be. In this case 'you' is Google shareholders, through their representatives.

Nobody is entitled to be paid to do what they choose. If you want to do something for your own personal reasons, do it off the clock.
The leaders? You're quite right, but maybe not the way you think. Trump said plenty of truly outrageous things, but he wasn't the one who generalized 50% of the population as "the basket of deplorables". Maybe Bernie is not overly bigoted, I'll give you that.
If the system returns the same result word that was in the query, doesn't that just mean that the word doesn't have the intrinsic meanings you thought it did?

Besides that it's actually "King - Man + Woman = Queen [Regnant]", which broken down into smaller pieces should be "King - Man = Monarch", "Monarch + Woman = Queen [Regnant]". Then you also have the complicating factor of "Monarch + Wife = Queen [Consort]" and "Monarch + Husband = Prince [Consort]". It seems obvious from this, and "Husband - Man = Spouse" and "Wife - Woman = Spouse" that "Monarch + Spouse = Consort".

This allows a little thought experiment. If the king marries a man, you have a king and a prince. That's fine; no ambiguity there. If the queen [regnant] marries a woman, you have a queen and a queen. This is confusingly ambiguous. Do you rename the queen [regnant] to king, or do you rename the queen [consort] to princess [consort]?
I think the communication problem here is that you’re arguing against the notion that FP is a silver bullet, but no one here has made that argument, so it sounds like you’re arguing that OOP is superior. I buck pretty hard at this because everything uniquely OOP (e.g., inheritance) is generally only problematic. And OOPproponents love pointing out that good OOP programmers don’t use these bad features/idioms/etc or they only use them where they don’t cause problems, in which case their code ends up looking the same as it would in any non-OOP imperative language (e.g., Go).
So what's the name of the new algorithm?
A Mathematicians Delight by WW Sawyer
That would be senseless. Neither employees nor management would like that. Why do you think you should be able to tell them how to deal with each other?
If your project is already on MySQL and you have no issue => Don't change anything

If your project is already on MySQL and you have issues => understand the issues you are facing and make sure that moving to Postgres would fix them (99% chance it won't)

If you have a new project and have very precise informations about the constraint you will face (pretty rare) => Do your research and choose what's best for your use case

If you have a new project and have only got a vague idea of what you are going to need/face 5 years down the road => Postgres is a slightly better choice than MySQL due to the feature set. Unless you have some other reason to go for MySQL (expertise, ...)
I don’t really understand the response. Is your claim that, if something bad happens to a woman without simultaneously happening to a man, that automatically makes it a gender bias issue?
sverige: none of your links work. You seem to have copied only substrings for all of them
https://en.wikipedia.org/wiki/Orthomolecular_medicine

> Orthomolecular medicine,[1][2] a form of alternative medicine, aims to maintain human health through nutritional supplementation.

Seconded. If this is what HN becomes, I want no part of it.
It depends on which protections you're talking about (note: IANAL either). From what I can gather, it's true that the organizers may not be covered under laws protecting employees who report concerns internally or file EEOC or OSHA complaints. However, any activities related to collective bargaining (which may absolutely include organizing and participating in protests) are legally protected under the National Labor Relations Act, and would not be affected by "contractual duties" or "utilizing good faith channels for whistleblowing."

Whether the organizers were covered by the NLRA is another matter; those with direct reports are likely excluded by the 'supervisors' exemption, which has been expanded over the years to cover pretty much anyone in a managerial role. For those who are covered, Google's actions could absolutely meet the legal definition of retaliation.

As an aside, the legal standards for what constitutes 'retaliation' are not the only ones that matter. They may manage to avoid a lawsuit, but they will suffer harm to their reputation regardless. I, for one, could not care less whether the law allows them to retaliate against the protest organizers. To me, this is just one in a long line of reasons why I scratched Google off my "short list" of potential employers.
Bias is a boolean quality. A random distribution is not biased. It really is not a "trick".