skysight-inc/HackerNews huggingface dataset:
I'm replying due to this same part/paragraph. I've been dealing with some manifestation of EXPLAIN since Oracle 6. In the last few years I've become handy with PostgreSQL's EXPLAIN as well, and this reminds me of my biggest hang-up regarding PostgreSQL; their hostility toward optimizer hints.

Like Mr. Stein I too have found myself in bad places with PostgreSQL's optimizer. This is commonplace with relational systems; every such system I've ever dealt with, including all versions of Oracle since the mid 90's, Informix, MS-SQL, DB/2 (on AS/400, Windows and Linux,) and PostgreSQL eventually get handed a query and a schema that produces the wrong plan and has intolerably bad performance. No exception. None of these attempts to create flawless optimizers that anticipate every use case has ever succeeded, PostgreSQL included.

With other systems there are hints that, as a last resort, you can apply to get efficient results. Not so much with PostgreSQL. Not implementing the sort of hints that solve these problems (as opposed to the often ineffectual enable_* planner configuration, unacceptable global configuration and other workarounds needed with PostgreSQL) is policy:

"We are not interested in implementing hints in the exact ways they are commonly implemented on other databases. Proposals based on 'because they've got them' will not be welcomed."

How about proposals based on "because your hint-free optimizer gets it wrong and I require a working solution without too many backflips and somersaults or database design lectures." No? Then sorry; I can't risk getting painted into a corner by your narrow minded and naive policy. PostgreSQL goes no further than non-critical, ancillary systems when I have say in it. And I do.
2 weeks is standard. i left 2 gigs and eqch time i felt it wasnt enough time at all but both times they were ok with it. they know how business works. even if you are the ceo, 2 weeks is expected.
Analysis of the State of Clojure 2016 comments
Fantastic suggestion. Getting it now.
I was under the impression that you can just set up a corporation for your freelancing, with you as the only employee, and have your corporation offer a very generous 401k plan that matches individual contributions up to the maximum legal amount.
If you're curious about how to set up a modern JS frontend on top of Django, I wrote up a tutorial recently.
It might be helpful if you're debating between trying a Single Page App approach or some other design: https://medium.com/@theSquashSH/reconciling-djangos-mvc-temp...
If you had to bet, which do you think will happen first:

1) The singularity/General AI is achieved

2) The last smalltalk article to make it to HN front page gets posted

I'm going with (1).
> While we'll probably end up in a house with a yard eventually

How, might I ask? Assuming $1.5M for a townhouse or a house in the Bay Area, Google's mortgage calculator says ~7k monthly in payments. At $160k and 25% tax, you're left w/ 10k/mo; you'd be spending 70% of your income on housing, not counting maintenance. You'd need to make a significant downpayment (which even then, IDK if it helps, since I've seen housing easily range to more than $2M+, and I feel like I'm lowballing it (ha!) at $1.5M) or have your partner also pull a decent income, no?

(I've never bought a house, so please, feel free to inform me, b/c from where I'm standing, it's incredibly daunting.)
There are no studies showing this process to have any effect on human tissue or blood.
I had one call at home that I kept on for over 30 minutes, just coming back every 5 minutes or so and saying, "hold on, I'm just doing something, I'll be right with you", "sorry, just need to do this, I'm really sorry about the wait", etc, etc.

I did put some music on in the background so they might have enjoyed that.
ClojureRemote – Day 1 Round-Up
I believe there is a mistake in the user interface section. They use the word "esthetics" when they mean aesthetics which is
> a set of principles underlying and guiding the work of a particular artist or artistic movement.

The root of the word is possibly Germananic (in German: Ästhetisch) or Greek Aisthetikos.
It's not clear that there is a difference from any citable source, however deductive reasoning suggests that escetics is concerned with cosmetology and estheticians.
The argument to be made that its the Latin dipthong AE is simplified to E is not valid in this case as inspection of Greek shows.

Edit: update. One given definition of esthetics is > relating to, involving, or concerned with pure emotion and sensation as opposed to pure intellectuality. [dictionary.com]
> The ADM-3A also explains why shells use ‘~’ to represent the home directory.

Is that also the origin of '^' being start of line in a regex?
Hmm I wonder only the better students apply for these kinds of job?

Or perhaps your university is just good? :)
Color me shocked. This is nothing but an encore of the age old union m.o.: identify success and prey on it, siphoning off those sweet, sweet dues.
Jeez, This is heart breaking.
And if you're going down the React + Redux + REST framework path and need a boilerplate to start off on, I'd highly recommend Seedstars': https://github.com/Seedstars/django-react-redux-base
Anytime our guard pages detect a stack overflow, an abort is issued with no chance to unwind. (The segfault bug mentioned above is caused by crafting data on the stack such that you bypass the guard page, which would go from a segfault into an abort in the presence of stack probes.) I did not intend to imply that there was any chance that a stack overflow wouldn't bring down your process, only to clarify Rust's stance on the theoretical memory safety implications. :)
Naruto Season 1 Episode 33 Battle Formation, Ino Shika Cho
Sure, there are transient booms and busts. But as you imply, those are exceptions. Long term, apartment rents are constrained by wages and likewise monthly payments on mortgages are constrained by wages. Those monthly payments are directly related to interest rate and total asset price.
By standard he means there is a formal document you can point to and say "this is GraphQL"[https://facebook.github.io/graphql/]
We had session tickets disabled already so weren't affected, but you'd be surprised some of the sites that use these devices. I believe AT&T has quite a number in use.
It is contrarian. As someone who has worked remotely to a significant degree for quite a while, I also find face to face get togethers (whether in an office or elsewhere) incredibly valuable.

You're welcome to your own preferences of course but, as someone on a largely remote team, I consider regular get-togethers in various forms pretty much essential.
Kudos to the entire team, as another commenter said, please don't be discouraged by the petty comments. It takes balls to admit mistakes in public. You have earned many people's respect.
People seem to have some subtle insecurities around broadcasting their activities which contributes a lot to the problem of distributed teams. Ideally all communication goes to everyone and everyone can apply their own client-side filters for what they want to care about. The problem is people want to present a certain face up the org and a different one to their peers so they PM each other and create isolated channels of communication (distribution lists, slack channels, etc). Now have some cognitive overhead of whom to loop in when which creates some other complications because it means if you're receiving a message it's explicit rather than implicit. TLDR - broadcast everything to everyone by default and create a culture of transparency.
Requirements of being a programmer
> A lot of affiliate marketers start out very consumer-focused in order to build a strong brand that consumers trust. They later find it very hard to resist the temptation to maximize revenue by making bad but profitable recommendations later on.

spot on! this is one of the reasons why we want to entirely avoid any sort of lead-gen or affiliate business models that depend on revenues from sellers of software or services. we're planning to make money from buyers with higher value tools that help them after the discovery phase -- for example, providing insights into pricing, helping automate the RFP process and potentially helping them manage billing etc. early days though!
> ...our actual consumption for my family of 3..

> I don't plan on living in the Bay Area long-term...

Just my initial observations. I think these are incongruent
That's impressive. Do they use open channels to communicate everything? compensation? Financials?
Wavebox – three dimensional scalar wave simulation
Just so disturbing. We pride ourselves in tech on being a meritocracy. But it's not really true, even now. I'm a starchy-assed white guy, who was born in Asia and married a dark-skinned woman, so you'd think maybe I was different. But when I ran engineering organizations 25 years ago, I interviewed and hired precisely 0 African Americans and 0 Hispanics. I promoted two white women, and two white men, and nobody I recall of Asian, Indian or Middle-Eastern background.

But articles like this help. Keep pounding in the message, and eventually people will change ... or die off.
Code-level change data capture doesn't work well for e.g. many-row updates, one off queries... a ton of different stuff. That's not to say it doesn't have uses, but wanting global-DB-update monitoring is not one of those things where it fits cleanly
Get off your moral high horse, you can't possibly know the full circumstances of the OP to make such assumptions. This SJW mentality has to stop.
Depends entirely upon the agreements you signed when you were hired. Most companies will not claim ownership of an invention or IP if it was not created on company time or with company resources.

Some companies also employ a non-compete contract that forbids employees from starting businesses within the same market.

Hopefully, you kept copies of all of the documents you signed! I believe that you are entitled to copies upon request in the US, but your mileage may very by state/local laws.

If you are planning to start a business around your IP, I would strongly encourage you to contact a lawyer for a consult, if not out right retaining a lawyer's services. Going over the fundamentals as well as clearing any potential regulatory hurdles before you start making a profit will save you a lot of headache later. small mistakes in the area of law have a way of becoming exceptionally burdensome for small businesses, often at the worst possible times.

Also, a good accountant is worth their weight in gold for a fledgling business! Don't let capital gains taxes and general business account requirements surprise you. The government is far less forgiving than the market.

Nine out of ten businesses fail in the US. If only one of those nine fail due to accidentally running afoul of laws or tax mistakes, then you've doubled your chances of success by being prepared.
‘Fake news’ war is free speech war
Great notes. Thanks for writing this!

Architecture review distinct from deploys is key, as is a separate operability review. And it's also important to mentally decouple the feature release to end users from the code releases.
Republicans are reportedly using a self-destructing message app to avoid leaks
Ask HN: How do you make your personal projects look nice?
I've nearly finished writing the main functionality of a Rails project, and I have to start thinking about how to actually design the site, if I'm going to use a CSS framework, etc.

I typically have the most trouble with this part. If I use Bootstrap, I end up with an ugly Bootstrap-looking interface, or a badly customized one. And if I write css by hand, I have no concept of how to make a button or content area look nice. Typically it's white square boxes with a black border and a #eee page background.

How do you go about designing and styling your projects? Do you use a css framework or any design tools? Examples and links would be welcome as well.
SQL Server on Linux? HELL YES Linux on Windows 10? Meh
If you covered things like parking lots and sidewalks, it would reduce the heat island effect and hence air temperature, and so reduce AC some more.
I have used UKForex a few times, and have been happy with the service. I've only used them for US <-> UK transfers though.
FiveThirtyEight Dataset are now on Kaggle.com
Everything is just a step up the abstraction ladder. Parsing with prolog is kind of magical. PAIP has a nice implementation.
Goal based programming generally implies non-determinism of some sort. In a way, it is "just" higher up the abstraction ladder, but it is pretty profound in its presumptions in terms of how you program. Languages like Prolog or SQL have a master algorithm behind the scenes that accomplish your goal, and so you spend a lot more time expressing the data and constraints on the data than on how it's done. In particular, it is hard to make assumptions about computational complexity or performance. In practice you wind up in an dual problem solving pattern where you alternate between goal/problem expression and tinkering under the hood with the system internals to improve performance.

Whether that's good depends on the problem... certainly SQL has been pretty successful.
https://www.joelonsoftware.com/2016/12/09/developers-side-pr...
This opinion is stated frequently. What size of data is big data, in your opinion?
Doing it is one thing. Distributing for free is taking it a step further.

If enough people take those extra steps then eventually the value of programming as a skill is diminished for everyone.
Sebastian Thrun is working on a new stealth food tech startup
The site is down. I wonder which paradigm covers "build for scale"?
You're absolutely correct. Optimizer hints are a source of contention in Postgres. I'm sure you're already aware, but just for completeness, here's some more information on optimizer hints and Postgres from Simon Riggs back in 2011. I don't expect this to sway opinion one way or the other. It's useful to read more on Postgres' policy.

http://blog.2ndquadrant.com/hinting_at_postgresql/

From the introduction:

- Introducing hints is a common source of later problems, because fixing a query place once in a special case isn’t a very robust approach. As your data set grows, and possibly changes distribution as well, the idea you hinted toward when it was small can become an increasingly bad idea.

- Adding a useful hint interface would complicate the optimizer code, which is difficult enough to maintain as it is. Part of the reason PostgreSQL works as well as it does running queries is because feel-good code (“we can check off hinting on our vendor comparison feature list!”) that doesn’t actually pay for itself, in terms of making the database better enough to justify its continued maintenance, is rejected by policy. If it doesn’t work, it won’t get added. And when evaluated objectively, hints are on average a problem rather than a solution.

- The sort of problems that hints work can be optimizer bugs. The PostgreSQL community responds to true bugs in the optimizer faster than anyone else in the industry. Ask around and you don’t have to meet many PostgreSQL users before finding one who has reported a bug and watched it get fixed by the next day.

Now, the main completely valid response to finding out hints are missing, normally from DBAs who are used to them, is “well how do I handle an optimizer bug when I do run into it?” Like all tech work nowadays, there’s usually huge pressure to get the quickest possible fix when a bad query problem pops up....
'7. Pity the readers' follows from the curse of knowledge, namely that's it's hard to imagine what it's like not to know what you know. This applies in novels as much as in technical writing. For example, descriptions of landscapes are often ambiguous because the writer already has a picture of the landscape in mind.
It’s not just Google. Snap has a $1B cloud services deal with Amazon, too
Trump's visa plan leaks: American techies first
Changing C2 to a JS-backed website that runs a lot more slowly is probably one of the worst things to happen to hacker heritage in the last few years.

If I'd known Ward wanted something more modern I would've volunteered to do a rewrite for something that was faster myself.
11 SEO myths that will kill your blog traffic
Zut alors Uber wrecked my marriage, fumes French businessman
>This is a perfect example of why "average" metrics for such values aren't that great and are often overused as vanity metrics.

The average human has, on average, one testicle and one ovary, but there aren't many humans who can actually fit this description.
It's generally easier to fix an incorrect program than corrupt data.

You're not wrong, but the magnitude doesn't compare.
> You ever check out the OS your bank is running?

Does it matter? I don't care what Fidelity, Vanguard, etc run under the hood, I have no loyalty nor switching costs.

Vanguard's interface is garbage, plain and simple, but they have the lowest cost index funds; I'd use paper and pen to correspond with them if necessary. I moved from Betterment, who has a very delightful iOS app and web interface, because the fees were lower at Vanguard.
I'm from Ghana and visit all the time. I lived in 3 countries for at least 2 years each by the time I was 10. Please don't insult me by claiming I live in a "bubble"

Bitcoin does not end up being a solution to problem you described in the slightest. The "US-dominated credit card system" and websites that take Bitcoin very rarely overlap.

The whole point I made was that the credit card system is still dominating major online retailers and that Bitcoin has existed almost completely outside of those retailers.
The life of P-22, the big cat sharing Griffith Park with millions of people
It would be awesome if he/she used whichever one would best enable it to actually withstand being posted on hacker news and still work. I'm not even sure what its doing while its playing that loading animation because it ought to be static content one would think. Unfortunately it never loads and is also not available in the internet archive. Anyone have a copy of the text?
Is it even possible to get even 10TB of ram on a single commodity server?
The idea is to give companies an incentive to make tough stuff by increasing their revenue for such products. But let's do both!
I actually like private company RSUs and the lack of data around them.

I can get super amazing offers from Microsoft of Google who will throw RSUs at me based on the assumption I actually had such great offers from the last company, even if it is private.

The secret is to tell them that there's a huge secondary market and lots of liquidity. There, the secret's out, they have no way of verifying, and the secondary market for private tech company shares is a huge and growing and fragmented area.

So at first they'll try to low ball you because you weren't with a "unicorn IPO". But then you reveal all the liquidity you have and thats that
Just setup dual boot to auto load some lame duck OS with some lame duck user activity, for laptops anyway. Any attempt to load the other boot without some special password results in a "drive not found"...ahem, yah...not found. Encrypted drives of course, the people doing the inspections don't have a clue. Worried about phones, you are pwned already, hell, Intel ME pwned all of us!
Postgres doesn't fancy many small and frequent updates (like rapid counter increments).

It is workable, though, via combination of batching, ensuyring indexes on hot fields have appropriate fillfactor, and making sure Postgres can use heap-only tuples.

Here's my old SO question on this and a well-comprehensive answer that's still actual and could be helpful for some cases: http://stackoverflow.com/a/1663434/116546
Analysis of Soviet smoke detector plutonium
A concise yet useful Recommender Systems tutorial
Postmates is down
Would it be possible for someone to post a portion of the text? Even when I whitelist the site in NoScript, it doesn't seem to load up
Exactly. In retrospect, I'm actually not sure I've done something quite so stupid in a long time. However, I'm sure I did it ~10 years ago on Gentoo and/or FreeBSD when I was much stupider about dependencies. Either way, what I should've said is outlined below in my last paragraph, and mostly what I mean by polluting global site-packages (with PKGBUILDs!)--and trying not to clobber things.

As an aside first: I sometimes make a PKGBUILD for most things just on the merit that it's better for pacman to manage site-packages on its own--or anything, really. It's a terrible idea to stuff things into global library directories that aren't managed in general (although incautious use of things like npm or pip can certainly do that for you--still an awful idea).

However, I do recommend installing packages into a virtualenv for anything with modest complexity, because some applications have requirements/install_requires that lock specific versions which may not be mutually compatible with others, and there's also the circumstance where official packages aren't new enough but you still want the package manager to maintain the dependent package. I guess you could go with versioned packages in this case, but since the official ones will inevitably find themselves updated at some point, I see it as easier to circumvent the issue in the first place via a virtualenv.

Anyway, I did the above polluting nonsense once when building a package with quite a few dependencies: Trying to maintain a half dozen individual PKGBUILDs just for dependencies and pestering easily a half dozen other maintainers to update their respective PKGBUILDs versus modifying the application's setup.py (either with patch or sed) to match older versions were both terrible ideas and scaled poorly. It's far easier to simply build what's needed in a virtualenv and avoid polluting the global site-packages even with the package manager handling them on its own. This is especially true for complex applications with many dependencies that may already be installed (but with conflicting versions).

Sorry for the rant, you just reminded me and tickled all the right spots! :)
Anyone else having trouble accessing this site.
Thanks, I will check this out!
Is Django restful in current version? Or I still need these if request.GET and if request.POST ?
Assembla is good. I've used more of their SVN than Git, but still good.
For some additional context, Sirens of Titan is one of his earlier works. The grammar is also more "standard", and is a more straightforward read than some of his more famous works.
How to play blu ray iso with DVDFab Media Player 2
And a really fast transfer protocol that unfortunately drops its packets when it goes through the Swamps of Sadness.
This is the original Wiki from 20 years ago , recently restored from backups and thus probably not expecting to be Slashdotted^H^H^HHacker Newsed ...
One of the important things to remember when reading C2.com pages is that they aren't written by a single person. They're more akin to wikipedia talk pages without signatures (variations of formatting are the hints to "someone else wrote this").

Reading it without this background may seem like the writings of a ranting crazy person. With the federated wiki remodel, this history was flattened.

The "Actually" part is likely a different author. And another author after the {hr}. And the bullet points under the missing padaradgim are other authors. Then another author for the hr block, and another author after the next one, and then yet another author at "I don't know..." and another author italicizing, and then one that signed as top and... so on and so on.
Due to network issues in AWS us-west (https://status.aws.amazon.com/) or conincidental...
... and you have your answer to the prior question.
>I regret to inform you that your code has to be deployed

haha
Yeah I guess you're right about that. My wife works far west of Boston, so I've only looked at the towns in between.