skysight-inc/HackerNews huggingface dataset:
Isn't it harder to create well designed abstractions for business logic in SQL compared to a full-fledged backend application server?

I know SQL has stored procedures and the like, but is it correct that SQL is limited in how it can express domain logic, compared to languages that backend application servers are generally written in?
P5 centric, and old P5 centric, and the videos aren't funny. He could have just said "Perl 5 sucks" and left the stage and the videos would have been of equivalent value (as in, they aren't worth anything).
Yeah I take my 100Mbps connection lightly, developing an image-oriented web app for the Philippines and holy crap the one guy was lucky to get 0.3Mbps.

So... had to severely redo the code to pull 50px wide images, blur them in, and only load the visible (depending on screen dimension) then a 2-second max refresh thingyyyy (yeah I'm just making this loader-interrupter thing) it's been a mess I feel pretty stupid sometimes. Why can't I get this... JavaScript. Yeap I am lucky to have Google Fiber (and I have the cheaper plan too)
There's already a good number of US-citizen PhDs in non-CS/"tech" fields who are being underutilized. Perhaps such moves will help prioritize them and adjust some of the supply/demand issues.
Just manage your account on your device yourself. It seems stupid to me to trust apple or microsoft with owning my password auth on my own device. I am shocked any dev does that.
Outside of very high cost of living cities, probably yes
I think a big problem with H1-B is that it's hard to switch jobs. While an American engineer can easily quit and go somewhere else, a non-resident is pretty much forced to leave the country. This makes the worker's bargaining position very weak, and overall lowers the market rate for immigrants.
> You seem to work at a horrible place, with abrasive characters.

Or a normal place with poor-mediocre leadership.

Documentation doesn't happen by magic, and documentation is a skill. If it's not a priority from management, folks will be heads down getting their own tasks done, not thinking about what the other person/team needs.
This still feels unsatisfying, since the target language is really just the source language with slightly modified surface syntax. Connecting languages with nontrivial differences is where writing compilers starts to turn interesting.
It's funny because it was actually a group of girls that decided to go to the strip club and then just invited me at the last second because I was there.

I didn't touch the stripper, but the girls did. I didn't pay to have her rub her boobs in my face, but the girls did.

I'm not saying something can't be sexist if a girl does it, but I am pretty sure it blows that commenter's assumptions out of the water. I actually hadn't yet said that they were female strippers at that point either.

Personally I don't like the idea of assuming a stripper doesn't like their job or is being taken advantage of or objectified. I don't see why it's any of our business to tell them how to feel about their job or make assumptions.
The L1 has no quota so it is used to get around the H1B quota. They just have to form a shell company in the other country, have employees stick around for an year and then come over under the L1 visa. There are no education requirements unlike an H1B. There are no prevailing wage requirements unlike an H1B.
My understanding is that the $300,000 person already has a job locked down. An employer has already agreed to hire him for $300,000 as long as his H1B visa is approved. And since $300,000 is super high, it would get approved before any lower paid people.

So the process:

1) You have a job locked down with a company for a specific position at a specific salary. You + Company apply for an H1B.

2) All of those H1Bs are sorted by salary and the top N are selected. No random lottery anymore.
Because the same companies will open training programs that provide $50 worth of education to the Americans and pocket the rest. Probably even make them do mandatory job training alongside the H1bs and triple dip.
Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems.

- Jamie Zawinski
Nice! We will keep that in mind. If you find yourself in Helena feel free to come hang out at The Shop co-working space. More tech in Montana is awesome.
> Raising tech salaries and reducing the ridiculous exploitation of immigrant tech workers is good.

> tech

Are we able to replace "tech" with other types of workers? Or is nationalism only ok when it protects this particular class of workers?
First come first serve: https://keybase.io/inv/ae76df3488. I have more if you message me.
Just to be clear, those settings are global per query, not global for the entire server. Still that makes them almost useless for large queries, but I would not exactly call them scary.
0. As long as I get 6-7 hours of sleep I can be pretty productive throughout the day. Have you tried going for a walk during your lunch hour?
His advice has nothing to do with page count. I imagine that he would think Anna Karenina a work of genius. The book he recommends at the end, The Elements of Style, goes into more detail about exactly how to prune. Here's one of its popular quotes:

"Vigorous writing is concise. A sentence should contain no unnecessary words, a paragraph no unnecessary sentences, for the same reason that a drawing should have no unnecessary lines and a machine no unnecessary parts. This requires not that the writer make all his sentences short, or that he avoid all detail and treat his subjects only in outline, but that every word tell."

Of course that just is an introduction. The books goes on with many guidelines and lots of examples that really made it sink in for me.
Windows open-sourced? Maybe an older version (you can already get the kernel source for XP/2K3 under a restrictive license, but nonetheless you don't have to be an MS employee for it) but I don't see MS open-sourcing anything newer for the forseeable future --- otherwise I bet someone will just make a fork with all the telemetry and other invasive features removed, which certainly doesn't help MS.
I never claimed it to be anything different. And it is, rightfully, in my opinion, downvoted as such.
Gears of War 2 Registration Code
>...but thanks to thought police HN is still free of people trying to subvert open source software by releasing research tools for free? Yay. We're saved.

You're free to take your baseless claims elsewhere. I said if the title did include that, then it is false. Perhaps the original title did have that, I don't know. What you would do in that case is discuss that, and not make up things about thought police.
South Seattle, West Seattle and some parts of North Seattle are still fairly affordable, for an engineer at least.
Quora is unusable on a slow connection. It literally shows a popup that obscures content if you lose high speed connectivity or drop packets.

However, the web is even worse if you have no connection at all. This is important because if we provide internet access at a municipal level, we can reach 100% adoption among our pluralistic educational system and progress to primary learning materials that are web based (CA 60119 for example prohibits any primary educational materials not available to all students both in the classroom AND AT HOME).
Location: on the beach in CA or FL
Remote: yes
Willing to relocate: no
Technologies: javascript, php, python, SPSS, R, machine learning, bitcoin
Résumé/CV: see below
Email: profsummergig@gmail.com

------------------

I'm a computer professor in the business school of a university in the Rocky Mountain area.

I get summers off. I want to visit FL or CA for 3 months during summer 2017 to learn surfing.

During that stay, I'd like to work for a start-up or some such. Don't need pay, but sweat equity and a place to crash would be yuuuuuge.

My ideal schedule will be to surf 4 hours a day, and spend 8 hours a day working at the start-up.

I consider myself well-versed in human communication, cognitive biases, UI/UX design, pricing, coaching.

Programming languages I dabble in: javascript, php, python.

I'm an expert at SPSS and can work with R. Have knowledge of machine learning, bitcoin (I did the Stanford MOOC for both).

I'm well read. My regular reads (and YouTube and Twitter addictions) include:

- Hacker News

- Nassim Taleb

- Daniel Kahneman

- Marc Andreessen

- Paul Graham (Y Combinator)

- Scott Adams (creator of Dilbert)

- Derek Sivers

I'm huge into hacking "learning." I have a PhD, and hope to do a J.D. one day. Good cook, regular meditator. Originally from India, I have my green card, and expect to have citizenship by summer.
It's not name-calling. This person really is a troll, a term with an unambiguous definition: http://www.urbandictionary.com/define.php?term=troll . He tries so hard to earn the label that it seems unjust to withhold it.

In the days of Usenet, before there was an Internet, this sort of language was regarded as neutral and informative -- it's not abusive when it's accurate. But the Politically Correct movement in social media is seeing a revival, such that even accurate use of these terms is regarded as counterproductive.

In the Usenet era, some individuals would strive to earn the label, and applying it would save people a lot of time trying to engage in constructive conversations with people who were manifestly unable to rise to the occasion.

Bottom line -- it's possible to take PC to a pointless extreme. And I'm hardly the first to make this point.
>> Having never used postgres, this seems extremely scary. I've only ever needed index hints a couple times in other databases, but when you need them there isn't usually an alternative. Messing with global knobs is a good way to cause more problems than you are solving.

You've got the plot exactly. The last such battle I was involved with ended in creating a materialized view to substitute for several tables in a larger join; without the view there was no way[1] to get an acceptable plan. Creating this view was effectively just a form of programming our own planner. And yes, the need to update the view to get the desired result is an ongoing problem; one that's scheduled to get solved with a migration to another DB.

Like you I've never been all that quick to employ hints. I tend to use them while experimenting during development or troubleshooting and avoid them in production code. But there have been production uses, and you know what? The world did not end. No one laughed at or fired me. No regulatory agency fined me. It did not get posted on Daily WTF. No subsequent maintenance programmer has ever shown up at my home in the dead of night. It just solved the problem, quickly and effectively.

Sure would be nice if people purporting to offer a fit-for-purpose relational systems understood the value of a little pragmatism.

[1] given the finite amount of time we could sacrifice to deal with it
Surprised to not see any mention here of legal and regulatory risk. One of the reasons moving money between countries is hard and expensive is that it is often done by people either trying to avoid tax liabilities, and/or by people involved in illegal activities and as a result governments are understandably keen to tie transfer agents up in rules regulations and liabilities. Ask HSBC...
Why You Need Software Project Estimation: The Expected Result
Wouldn't SQL count as goal based, by their logic?
Huh, over 30 stories posted in the last 24 hours with "Trump" in the title, only 2 with more than 20 points, and they're both relatively pro-Trump. Interesting.
I think by highest paid applicant they meant have an auction system instead of a lottery system. The highest paid job offers up to the quota will get accepted instead of picking them randomly. But there is still issues like valuation of stock options in such offers. Also cash strapped startups may have a hard time against big companies like Google. Maybe it needs to be a combination of pay and some random factor?
In Australia, if you are a salaried professional employee then YES. The rationale being that you are employed for your specialist knowledge. Unless the IP is in an area that is not even remotely related to your job description and any of the employer's areas of business, then you might be able to defend yourself.

The general advice is to either get an agreement from the employer that they make no claims upon your IP and that you develop that IP using your own equipment in your own time. In most cases, it is easier to leave and then start working on your new idea. Even then, in some cases non-compete agreements you signed upon starting or even possible upon leaving might prevent you for entering the market for a specified period of time.
I was working for a company that had access to a nice trail where I used to walk for 30 minutes every day after lunch. It helped digesting but didn't change much in terms of productivity.
> I don't think that's particularly fair on immigrants. It sets a double standard as to what people are worth.

How so? The minimum wage for H-1Bs is over 4x higher than the minimum wage for Americans.

If Americans had a minimum wage of 60k per year and immigrants were getting paid $7.25 per hour then that would be one thing, but it's currently the other way around.
> How can you actually shut down mining?

You may not be able to shutdown mining, per se, but if you are the PRC government, you may be able to isolate miners in China from the network (especially if it is important enough to you to accept false positives), which has the same pragmatic effect.
Please keep it up. We need more companies like you.
Please try to alter a schema of a live multibillion rows table before pretending that it works. Unless they changed how is implemented recently then such an operation can take hours.
I love postgres for many reasons so i would like to be proven wrong.
>The scheme seems more designed to punish companies from hiring immigrants than actually ensuring only high quality employees make their way to Silicon Valley.

I'd say you're exactly right (perhaps replace "punish" with "disincentivize" for more broad agreement), as concerns about the place of domestic labor in the face of foreign labor was the major campaign issue, rather than a desire on the part of the US electorate to refine/optimize the talent pool of Bay area international workers.
If they're a troll, don't feed them. That goes back to Usenet as well. There's never a reason on HN to be uncivil.
It used to be hard to switch jobs under H1B, but that got fixed ~15 years ago. The visas are now pretty much transferrable to another employer.

What's still a problem is that Green Card applications are tied to a specific employer, so that clock will be reset any time you switch jobs.
I'm 43. I haven't accomplished much yet, don't have enough money to get by, but I don't want to lose my sleep over it. I never lose hope and stop being optimistic.

Looks like you're suffering from burnout. When you are not your normal self, you can't think properly. See if it's just wealth, success you're after and see if these are the culprits. Like moraya-re said, balance is the key.

Take a break. Empty your mind. Talk to people around you. Spend time in nature. If you can, exercise, run. It's important that you have healthy sleep habits. Stay clean.

Maintain your physical and mental health, or you won't be able to achieve what you want in life.
This headline is really bad. No evidence whatsoever was provided to suggest that being black causes you to get a lower salary.

What it does tell us is that black people ask for less salary on average, which might mean that either they are applying for lower paid jobs, or that their negotiating skills on the whole are poorer in this sample.

> The average African-American candidate is nearly 50% more likely to get hired in tech but gets paid about $10,000 less in San Francisco and New York, putting black tech workers at a significant disadvantage, even compared to other minority groups.

This figure of $10k is false if you look at the data in the graph, but even if we were to accept the artificially inflated figure, would a job seeker prefer an 8% increase in salary IF they are hired, vs a 50% greater chance of actually being hired?

These kinds of topics are always full of emotion, and with that comes a lot of bullshit unfortunately. I wish reporters wrote articles that told us facts, rather than trying simply to push an agenda or point of view. If you care about a cause, making terrible arguments for it makes it look like there isn't actually any issue to deal with, and that it's all overblown. I think this is a real shame. Wouldn't it be nice to have an honest, fact-based conversation about these topics once in a while?
Unrelated, but how would one get started creating a proper parser for textual content? For example, I have

{
"key"
{
"key" "value"
"morekeys"
{
"key2" "value2"
}
}
}

The markup would be seperated by newlines, with the key-value pairs on the same line, always in quotes. I've solved it with regex and a crude parser before, but I've always heard of things like Bison and such but never found a 'good' way to impliment a real parser in a language like Python.
>Secondly, it will let _you_ confirm you know the divisions.

Absolutely. Which is why I draw the line at "conceptual units". If there are rational sub-divisions that don't require context, go ahead, divide! If you're baking in cleanup + feature + bugfix + convert tabs to spaces, you're mixing things in the same way that you would usually avoid when coding. Same thing with too-large commits - we avoid 10,000 line files and functions, do the same with commits.

I caution only against artificially small diffs. Small is a fine target, but there's a lot of dogma around it everywhere I've been, which is why I think it's worth calling out. Breaking things up too much can remove context, which can be dangerous.

---

If you're introducing a large thing in 1 vs N units (say a full feature in one go, which is unusable until complete), the line is of course fuzzier. In some ways, sub-units may be more reviewable - that's a solid benefit, though they're not likely a dozen or two lines of code (if they are, and it's a large feature, you probably now have dozens of reviews). But you aren't getting any additional safety, because it's all either on or off - which is half of the post.

For the other half of the post, if you're not getting the same reviewer(s) for all the pieces, unless you've had a detailed architectural review[1], has anybody but you read and understood the whole system? When it's turned on and it breaks in a subtly-interacting way and you're on vacation, does someone else know where to look? Doing it all in one go, as it will be when turned on, forces an architectural review of the system implemented, not just the plans. Say it takes a day or two to thoroughly review - is that bad?

---

Always tradeoffs. For the situation described in the blog post, where large reviews get insufficient attention, I don't think small diffs will solve the problem. The problem is the lack of attention given to reviews - fix that. It's critical regardless of diff sizes.

[1]: No place I've worked for has truly done this, which I would claim is the (vast) majority, but I wholly believe some places do. I would probably even like it! But it's perceived as slowing things down, so it hasn't happened for me yet.
Thanks, I wanted to save the page to my local computer, but I couldn't figure out how to do it..
My unstated assumption was that when calling something like imagetragick you would be doing the appropriate privilege dropping using setuid and setgid. This is obviously not necessarily the case, but it's at least a lot more common than people cleaning up the ENV before creating a child process.
> Nothing thrills me more than debating physics.

You aren't debating physics.
Tech workers in SV seem to hate Trump, but tech workers are not only in SV. There are also tech workers at defense contractors all across the deep south, and they definitely do not hate Trump. They might roll their eyes at his antics or prefer a tougher stance on Russia, but "lock her up" is a very real desire. The H1B issue kind of resonates with them, since many are older people with families, though obviously the competition with H1Bs is indirect due to citizenship requirements at defense contractors.
well there is also https://www.techempower.com/benchmarks/#section=data-r13&hw=...

Point being when someone says something is faster without providing verifiable numbers... it should not really be taken seriously
Disagree. I'm from the Midwest and live in SF now. Couldn't be happier with my change.

Data point of one:

- $2200/mo 1BR apt in SF (Inner Sunset). Not trendy, but nice. I got it 3 years ago.

- Working for a major tech co.

- Roughly $275K/yr in total comp (salary/equity/bonuses). It goes up around $10-20k every year, as my equity bumps compound and I get raises.

- Putting away $18k/yr in 401k + $9k company match.

- Average bills of $1000/mo. Mostly leisure spending, but also includes the occasional Lyft, etc.

- Mostly eat at work for free. Minimal food in the house for dinner, which I don't eat that often (I snack a lot at work and don't feel hungry). I think I eat out about 2x/week.

- No car, though I occasionally ZipCar or mooch my GF's. CalTrain and Clipper card are paid by my company.

My net worth on Mint has increased roughly $50-100k/year since I began working here, due to cash savings and stock vesting. I take an international vacation every year, and visit my family 3x/year.

I previously worked in the Midwest and life wasn't nearly as fun, nor was I making as much money. More importantly, I didn't have job flexibility. The workplaces were terrible there (SV culture, silly as it can be, is much friendlier to employees), and there weren't as many jobs. They also didn't pay for public transport, give you equity bonuses, pay for your meals, or had office snacks. A spacious house couldn't make up for all of those differences.

I'm glad I came to SF, despite its downsides (like less space, commuting, etc). There is a big trend in bashing it, but if you're good at what you do and know how to manage your money, you can do pretty well here. Not to mention have a higher quality of life. And if I decide to move back (which is likely, so I can be closer to family) I'll go back with an amazing CV and probably better career options.

Stop listening to haters. Don't knock it till you try it.
I think I still prefer the logical diffs to be at a PR level. I know at least personally that I commit a lot of experimental code that I back out of for the eventual implementation.

Doing git fu to reverse that is not worth the time imho. I'd rather invest time in factoring (and testing) tiny deliverables.

At least then, you still have the diff as a travelogue.
Kinda like a certain defunct university....
Tell that to the Winklevoss twins
Not if the hands have fallen off.
I would go with a simple recursive descent parser, unless you are interested in learning a DSL, the intricacies of the parsing algorithm your particular parser generator uses, and willing to debug one --- IMHO not worth it. Even "real", production-quality compilers like GCC, Clang, MSVC, and ICC use recursive-descent; and some, like GCC, switched away from parser generators.
Your schema might sit in code, but you've got to reinvent the wheel on all sorts of validations and guarantees your database would provide. Whether you have queues and APIs is irrelevant, your persistent store should be a strong one.
Depends on the schema change. If you have a multibillion row table there are plenty of other things you need to pay close attention to as well, as you're probably all-too aware.
Anecdotally, Atlanta has a great tech scene. I'm earning SF salary and comp, and my cost of living is extremely cheap. The culture here feels much more heterogenous, too.

Atlanta has a lot of fintech and medical tech companies, and it sports a cottage startup scene at Georgia Tech and the ATDC. We've seen a number of local startups do really well: Airwatch, MailChimp, etc.