skysight-inc/HackerNews huggingface dataset:
I'm all for rock stars expanding their horizons if they score better than those nerds. Though the education is even in that case likely better invested in the student aiming to get a career in the field, rather than in a rock star's recreational studies.

The "real players" could also visit as guest lecturers on your music theory class, assuming they have good enough merits on the subject.
I recently encountered a Reddit comment that might clear your confusion, paraphrased thusly: "We never see the any teachers union consistently come out in defense of pedophiles amongst their members"
I think it's the certain style and design liberties subway style maps use. For comparison, look at the general sizing or shape of Central Park in NYC subway maps [0].

[0] https://new.mta.info/map/5256
The effect will be relatively similar -- you arrive at a new database with the proper schema/structure in place, but the difference is in execution. Doing this _within_ the database engine is likely 10x faster than loading the schema through a client library making a series of CREATE and ALTER statements (ala the schema:load rake task).
Steps to Take Before Automation
That all depends on how many customers you expect to have in a single database, and how many tables each one needs. EDIT: also, transaction volume.

Ok, so let's imagine your application requires 100 database tables.

If you have 1 customer, you have 100 tables. Every transaction performed in this database (including updates) will increase the age(datfrozenxid) by one. You now have 100 tables you need to vacuum.

If you only had one schema, that's no problem at all. Even with the defaults and a high number of writes, the default 3 autovacuum workers will quickly deal with it. Even though they can only vacuum a table at the time.

Now your business is growing. 1 customer becomes 10, 100... 10000?

At 10k customers, you now have 1 million tables (maybe more, as TOAST tables are counted). Every single transaction increases the 'age' of every table by one. It doesn't matter that 99% of all tables have low TXIDs, the overall DB "age" will be on the table with the highest count.

The default 3 autovacuum workers will definitely NOT cut it at this point(even with PG launching anti-wraparound autovaccums). You can augment by "manually" running vacuum, but in that case the overall database age will only decrease once it's done vacuuming all 1 million tables, so start early(before you reach the ~2.1 billion mark)

Alternatively, you could write a script that will sort tables by age and vacuum individually. This may not help as much as it seems, as the distribution will depend on how much work your autovacuum workers have been able to do so far. Not to mention, even getting the list of tables will be slow at that point.

So now you have to drastically increase the number of workers (and other settings, like work_mem) – which may also means higher costs – and you'll still have to watch this like a hawk (or rather, your monitoring system has to). There's no clear indication that the workers are falling behind, you can only get an approximation by trending TXID age.

You can make this work, but it is a pain. Even more so if you haven't prepared for it. For a handful of customers or a small number of tables or a small number of transactions this may not matter. Our production systems (~200 tables, excluding TOAST) started to fall behind after a few thousand customers. We have had at least one outage because we didn't even track this at the time and the database shutdown. 20/20, but nobody remembered to add this to the monitoring system.

Another unrelated problems with multiple schemas is: database migrations are much more complex now, you have to upgrade all schemas. This is both a blessing and a curse. Database dumps also tend to take forever.
Because they’re lazy and can afford it.
The best k-12 schools in the US are in states that have teachers unions, so maybe go rethink your hypothesis.
I use standard web requests to get raw html and parse the data from it, no headless browsing. I guess all the news pages I've met so far were static.
This is what the new portals api is about
Ten years isn't enough to safely "invest well" — you could be buying the next Apple or Google, but for all you know, you might be buying the next Theranos or WeWork. If you diversify, ten years likely won't give you that big a bankroll unless you start out with a fairly-hefty one.

EDIT: And even if you do diversity with a hefty bankroll, you could be investing in, say, late 2007, just before the start of the Great Recession and its attendant massacre of so many stock prices — or in February 2000, just before the dot-com bubble started to deflate (a painful memory for many of us).
Comments and commit messages are complementary. The commit message describes the changeset and includes things like the above, the whys and the necessary context to understand the change. The comment describes the actual code as it is, and should describe how it works and how it interfaces with other code. Comments tend to be, as you say, forever while the code changes.

Both are well worth the time to write. Nicely written ones might even take a full minute or two to write, but how many cleaned-up and rebased commits does one produce in a day? A few, at most, unless they are absolutely trivial. Those minutes per workday are well spent.
People are downvoting you because you are clearly not arguing in good faith, using phrases like "think of the children," which is a phrase used nowhere near as often as certain groups claim it is, while they parody it to shut down opposing viewpoints in discussion.

That being said, I'd also like to point out that "abolish the police" isn't saying "remove police entirely." It is saying that police, in their current state, should not exist. It's saying that police not be the ones who handle someone having a psychotic episode, and that part of the money going towards police should fund trained healthcare professionals instead. That police shouldn't be handling the homelessness problem, and we could redirect some of their funding to create public housing instead of throwing them in jail over and over. We shouldn't have police handle truant students, and arresting them certainly shouldn't be the only option available if they continue to do so.

It comes down to the fact that police forces and unions have too much power. And of course that leads into the larger discussion of the fact that police can say "we thought this person was committing a crime" and steal everything in your car with almost no recourse to get it back. That police have incentives to make any given arrest at the end of their shift to accrue overtime, and that most police organizations have no limits on the amount they can accrue. That police forces are getting increasingly militarized even as violent crime is going down worldwide. Or that they can shoot and kill almost anyone and say "well I felt that my life was in danger" and that's the end of the discussion. And that if in the unlikely event they are fired, they still keep their pension and can be hired a precinct over with no repercussion. That there are no means for reasonable oversight of these organization to make sure they are acting in the public's best interest. That police unions actively fight to keep all of these policies in place instead of working to build trust in their organizations so that we don't have these problems in the first place.

It's not a discussion of "I only want the parts of the government that I like to have funding," it's an objective look at an arm of the government that has far more power than it should by pushing every existing law and statute to the limit while everyone looks the other way, and an objective view at what society-benefiting services we could fund (that would reduce the need for police in the first place) if we chose to fund them instead of massive police forces. If we had an education system where you had one teacher the entirety of your career, who had no oversight on the curriculum they taught, could assign grades at random based on how they liked each student, that was unable to be terminated, and if they did lost absolutely nothing, you can bet that we'd be here protesting that as well.
Not to mention our new 4th branch of government: bureaucracy. They do tremendous work, but I don't think they should have the power to draft regulations that have the force of law.
The United States isn't close to the drug war it causes the drug war. Guns flow across the border in one direction and drugs flow the other way. Guns already inside the United States are of course going to be used in crime as well, of all kinds, not just in drug related crime.

Ownership of a gun and homicide correlate poorer than having a kilo of coke and homicide but still correlates a lot better than no gun and no coke.
>is the way that gun violence data has been continuously and specifically suppressed by those who oppose gun control

Last I checked they were happily singing out about the data because legal gun owners shoot statistically nobody and military style arms kill statistically nobody compared to career criminals with boring old handguns (who mostly kill each other because they can't rely on the courts to mediate their disputes).
Unless it's an exit node. 251 of 1,249 exit nodes reside in Germany, or roughly 20%. Exit nodes aren't supposed to modify traffic, so if the compromise is happening upon leaving the exit node en route to whatever destination, that would still trickle back through all the hops.
There should at least be a setting akin to "show dead" that inhibits the censorship^Wdownvotes-coloring.
> Note that "trust" here doesn't mean "their conclusion is definitely correct"

Totally agree.

> This isn't quite the apples-to-apples criticism that it appears

Fair, but I have have two responses to that.

The first is that the ability to discover and access high quality writers (not just Scott) directly means that the NYT brand has less value.

The second is that people increasingly feel that NYT has an agenda (not merely a bias) that colors the quality of their reporting.
> I don't support trying to redress ills from over a century ago whether we are talking about restoring native reservations, or paying reparations for slavery.

This position assumes the ills from over a century ago have been fully resolved _right now_. Watching the news, that does not seem to be case.

(I try not to put these words in your mouth, you're stating "And strongly support fixing our ongoing treatment of them."!)
You could, for example, use the Certificate Manager in Firefox to delete specific authorities you do not trust.
Hunh, interesting. I thought this was going to be similar to vortex ring state, but seems it's different.
The biggest problem facing Amazon workers isn't unionization. It is the not having alternatives to earning a similar wage in more humane conditions.
"Big Sur brings with it some really big visual changes, but also major changes under the hood. For instance, Apple has been progressively deprecating 3rd party Kernel Extensions or 'kexts' which Fusion needs to run VMs and containers. In order to continue to operate in this model, we’ve re-architected our hypervisor stack to leverage Apple’s native hypervisor APIs, allowing us to run VMs without any kernel extensions. On macOS Catalina systems, Fusion operates as it always has using kernel extensions to provide functionality. However on Big Sur systems, Fusion operates entirely without kexts."

Reminds me of the discontinued Veertu app: https://blog.technodrone.cloud/2016/01/native-mac-osx-virtua...
Maybe you'd prefer it reframed as: elected officials want to minimize spending on line-items they don't care about in order to spend on things they do care about.
>I guess I trust the Supreme Court more than I trust Congress

It's quite a damning indictment of US-style democracy that people trust a small cabal of unelected lifetime appointees without any meaningful oversight, over a larger pool of democratically elected officials.
Probably not a priority for YT; they have a lot to lose from leaving up "bad" videos, and less at stake from erring on the side of removal.
I think they could, but even if it matched the SCoutUS decision it could only apply going forward or it would be unconstitutional via Section 9.3 on barring ex post facto laws. Now if Congress were to pass a law saying not that something 100 years ago meant XYZ but that as of the sign date the reservation no longer exists, that might pass 9.3 but if that bill hits the courts, lower courts would need to reference this case and probably conclude that it isn't a correct application and ax it.
Not sure if you're familiar with how these major investigative articles are written, but something this big can take months to put together.

Scott had his panicked meltdown the second this guy started asking questions, which was probably just the beginning of the investigation.

You think the outfit that took down Weinstein cares about some SV tantrums?
DigitalOcean managed DBs adds support for PostgreSQL 12
Putting aside a lot of nuance and complication, both parties have an 'ideal state' in mind. They will make decisions that move the law closer to that ideal state. It'll be happening all the time, neither of them think the ideal state is compromising with the other.

And if you want an example of the Democrats doing something similar, maybe the immigration situation? It is also nuanced and complicated, but the appearance isn't that the Democrats are consistently working to uphold the consensus position as found in the law. There is a lot of demonising.
This is a case for events! The store opens when the owner unlocks the door..... but since you are in that nebulous time when it is "closed" the next "open" may never happen.. so maybe what really needs to happen is a giant disclaimer around times for things...

like in your search results for let's say some M-F 8-5 business... it would say "Hours: 8:00-17:00, Closed right now, in 72% of the cases, the next opening time is tomorrow morning at 8"
Folio was going to ship, but Jobs canceled it because it wasn’t good enough yet but let the team adapt it to a phone.

And I worked on the Pen Mac about fifteen years prior, so with that and Newton, Apple was working on the concept forever.
Yep, disabling fsync, synchronous_commit and full_page_writes ONLY for this PostgreSQL integration testing strategy gives us an additional boost of ~35% in overall testing speed. https://github.com/allaboutapps/go-starter/blob/master/docke...

Regarding being language agnostic: YES, clients for languages other than go are very welcome. The integresql server actually provides a trivial RESTful JSON api and should be fairly easy to integrate with any language. This is our second iteration regarding this PostgreSQL test strategy, the last version came embedded with our legacy Node.js backend stack and wasn't able to handle tests in parallel, which became an additional hard requirement for us.

See our go-starter project for infos on how we are using integresql, e.g. our WithTestDatabase/WithTestServer utility function we use in all tests to "inject" the specific database: https://github.com/allaboutapps/go-starter/blob/master/inter...
On its face, this is really a bad idea. Price caps never lead to good market outcomes in a competitive market. You end up with an imbalance where the people who are willing to pay more aren’t getting served and demand isn’t getting met and you are reducing the supply where the suppliers could have made more money. This isn’t good for either side.

However, if this means that the supplier can’t charge the restaurants but can charge a higher delivery fee and it’s explicit. That seems like a win. A free market operates more efficiently when all parties have enough information.
This is a bizarre claim. People getting labeled as "diversity hires" and being assumed to be less competent than their peers is a decades-old thing.

It wasn't even a particularly new observation when South Park literally named a character after it almost 25 years ago.

(Probably many of the same people getting labeled that way for holding high-level positions today were similarly judged in their entry-level positions back then! But if people are no longer suspicious of women or minorities in "regular" roles and resume their judgement for upper-level roles, I guess that's a change in the right direction, at least. :| )
>We want AI agents that can discover like we can, not which contain what we have discovered. Building in our discoveries only makes it harder to see how the discovering process can be done.

I think these lessons are less appropriate as our hardware and our understanding of neural networks improve. An agent which is able to [self] learn complex probabilistic relationships between inputs and outputs (i.e. heuristics) requires a minimum complexity/performance, both in hardware and neural network design, before any sort of useful[self] learning is possible. We've only recently crossed that threshold (5-10 years ago)

>The biggest lesson that can be read from 70 years of AI research is that general methods that leverage computation are ultimately the most effective, and by a large margin

Admittedly, I'm not quite sure of the author's point. They seem to indicate that there is a trade-off between spending time optimizing the architecture and baking in human knowledge.

If that's the case, I would argue that there is an impending perspective shift in the field of ML, wherein "human knowledge" is not something to hardcode explicitly, but instead is implicitly delivered through a combination of appropriate data curation and design of neural networks which are primed to learn certain relationships.

That's the future and we're just collectively starting down that path - it will take some time for the relevant human knowledge to accumulate.
I agree in principle, but achieving that kind of harmony between languages is analogous to the world‘s governments agreeing to “save succeeding generations from the scourge of war”. That sounds like an exaggeration, but even if language maintainers are all enlightened enough to compromise, the communities are not necessarily going to comply. The minute a language changes how it deals with dates and times, it’s more than likely someone will, very loudly, announce their intent to fork it in order to preserve the old way of doing things.
The reason for fighting standardized testing has nothing to do with transparency.
You’re not the customer. Any organization that has sufficiently large has a need to know who is accessing what, and when.

Tools like this help manage all that when you could have hundreds of logins a day.
I have nothing against graph database concept. I used it myself in some server applications. But reading this article:

>"Relational databases: a software engineering fail"

I would tell this to the author: it is a bad marketing strategy trying to diminish competitor. Don't worry about relational databases. With the comment like in the quote it is clear that you are either incompetent or spreading BS on purpose. Not all of your audience are single cell organisms and they are perfectly able to judge claims on merits rather than propaganda.
Note that the dissent in Obergefell (the case ruling that states had to recognize gay marriage) actually explicitly said "It is striking how much of the majority’s reasoning would apply with equal force to the claim of a fundamental right to plural marriage."
Makes sense.

Note that now we have lots of smart people funded by new cash-rich industries (search, social networks, SaaS, etc.) poking at the problem with "black-box" approaches. I will be interesting to see what comes out of it.
The post you're responding to addresses your questions in the paragraph immediately after the one you quoted.
The instruments involved may look mild because they're common household items, but I don't think it's safe to conclude there's therefore a discrepancy in the experience. If you're being skinned alive with a common kitchen knife, you're still being skinned alive.
Particularly in America, the police exist primarily to enforce class/racial divides (this is not hyperbole -- one of the best quick introductions I know of came out quite recently and is a very worthwhile read or listen: https://www.npr.org/2020/06/05/870227945/nprs-history-podcas... ). This is fundamentally contrary to the politics of a labor union, which is to empower those who perform labor to negotiate on equal footing with those who would claim the bulk of the productive output of that labor.

Both would fall under the aegis of "collective bargaining", but the social aims of the two couldn't be more different: the maintenance of a stratified class system vs the dismantling of same.
One of my favorite bits of trivia: What would Git be like if Linus stepped away? Oh yeah, he stepped away after a few months and Junio Hamano continued running it for the next 15 years[1] (!!).

[1]: https://github.com/git/git/graphs/contributors
What you're referencing is probably a "prescriptive easement" and is legal (depending on your jurisdiction).

If your jurisdiction does not have "adverse possession" or "prescriptive easement" laws, you can probably tear that fence down or do whatever else you want with it. (IANAL and please just talk to your neighbors first!)

None of this is related, either legally or in spirit, with the sentence you cited. The cited statement refers to an unlawful act, over time, attempting to override the law. In most (all in the US?) jurisdictions a law regarding prescriptive easements or adverse possession probably makes your neighbor's actions legal. The entire point of this ruling is that congress never passed a similar law to make this sort of action legal.
On average, the S&P 500 will double your money in 10 years.

But point taken; if the years are not average you might wake up broke.
Stock reaction statistics based on millions of financial data events
We created Opstreet because we had a hard time evaluating the stock price movement after the companies report its financial data.

Often stock price moves in a different direction than the investor expects.

And usually, it seems, without any reason.

So, we started to calculate statistics on how stock price reacts after the company reports financial data.

Please, try out. Feedback is welcome.
OpenSSH can already do all of these things that you listed.
The city made it illegal to charge the restaurants - not to add a higher delivery fee.
Professionals actually do use the Touch Bar. Oak Felder seen here using it back in 2018 to produce on the go:

https://youtu.be/FUHcYX1-9Y8?t=178
Tips for self-study and independent research
Sort of related, this type of thing isn't difficult if you use Thunderbird. All your email is stored in a big sqlite file. You can query with all the power of SQL.

A few things I've done: use it to ignore my email except for a small number of senders while I'm working, viewing only starred messages the majority of the day, and copying email threads as html documents inside a project folder. There's something nice about being able to look at an "email inbox" that's a plain html page with six messages.
Thanks for the info; I hadn't heard about the increased life of paper bills.
According to archive.org, it's been around for at least 6 years https://web.archive.org/web/20151204211651/https://addons.mo.... This is well past the time when you can use the "it's an MVP" excuse.
The corporate boycott of Facebook is illiberal
Well, one thing, at least with web dev stuff is that competing against websites with years of backlinks is not exactly fun or fair for that matter.
Many places charge extra for pick up.
This is interesting.

The way I understood the work of von Neumann and Morgenstern on game theory, there is an extensive discussion of utility and the derived ordering on preferences.

I interpret recent work on behavioral economics as building on their work to call into question the claim that one can easily estimate such a utility function for an economic agent in a manner invariant to the internal state of that agent.

This train of thought seems like it should leave laissez faire capitalism in the dust.