jkeisling/hacker-news-corpus-2007-2022 huggingface dataset:
Can an MS SQL Server expert explain why creating table variables inside sprocs is so popular? I've done lots of Postgres & MySQL (and long ago lots of Oracle), but now I find myself maintaining some MS SQL Server projects, and I see `DECLARE @intermediateResults` all over the place. I thought it was just the past developers being more familiar with imperative style than SQL, but it seems to be part of the broader MS SQL Server culture, and somewhere I came across some passing reference to read locking being a reason, but it was too brief for me to understand. Is there any reason to do this so often in MS SQL Server vs other RDMBSes?
Not sure about Google Cloud, but Elasticsearch on AWS doesn't support x-pack security. You can only secure your instance via IP restriction, otherwise you have to sign your requests, which is not always supported on Elasticsearch DSL libraries that are commonly used.
I'm one of the people who switched from Vim to Emacs due to Org mode, and I've never regretted the decision. In the past year, I've used org-mode to take all my notes in class, write documents and as a task manager. All in all, the gain in productivity due to org-mode massively eclipses the time it took to un-learn vim and become decent at emacs.
Insiders subtract the false or useless bytes (an action easily captured in statistics and then maligned on the internet by pundits), but also look at the true and useful bytes, fact-check them, and then leave them in place. This contribution --- curation --- is not captured in any statistics. . . . Unfortunately both sides' conduct may be scaring away the people who are actual experts on those long-tail topics.

Correct. But not just long-tail topics, but any topic that can only be properly treated by deep immersion in the subject, and especially any topic that is controversial. A lot of point-of-view pushers on Wikipedia do a lot of their POV-pushing by "framing," just making sure that some wikilinks to articles they like persist, while others are deleted, or that navigation templates or article categories play up the articles that best represent their point of view. And that's before we even get to the issue of deleting reliable sources.
Neat, but I can't help thinking "oh goodie, URL's I can't type..."

I mean, there's always Unicode tables/charts you can copy the symbol out of, or perhaps keystroke combinations, but Unicode has 65,533 characters.
> Finally, a few alternative editors are genuinely useful, nano - it might be inferior in pretty much every regard to Emacs, but it's not possible to shrink Emacs to nearly the size of nano so it does seem to serve a valuable purpose for when disk space or memory footprint is an issue.

I'm an emacs user too, and I now use zile ( http://www.gnu.org/software/zile/ ) instead of nano. The ability to use the same keyboard shortcuts that i'm used to is a godsend.
I use Lua on similarly-sized embedded systems. As a result I get readable code, easily ported (and debugged!) under Linux. It really changed the scope of what we could embed.
Why should the reader? The author doesn't care about the reader!
Image is not so much about who you are, but about how you would like to appear.

It'd be pretty funny if Apple's success rested merely on people's desire to be perceived as creative and aesthetically discerning rather than on people who are creative and aesthetically discerning finding it to be the better product.

I don't think that's accurate, but it does probably make up some measurable amount of their sales.
"If they feel the need to compete with anyone on price in order to protect their business interests, they can do so with price cuts deep enough and long enough to drive most potential competitors out of business."

If they try to drive competitors out of business by pricing below cost, this is illegal. Apple is already getting looked at by regulators, and I doubt they want to invite more investigation, which slows a company down and may prove really harmful to the culture (see: Microsoft).

If this just means Apple might be willing to cut their margins, then yes, I agree. So the key is to make something with a lower cost structure than Apple has. Not going to happen for iPads in the near-term, but this industry changes pretty quickly...
yes, but Craigslist doesn't give you "your website" to organise the garage sale.
The idea is to let people create and customize the website, specifically in situations when they need to sell many things.
It would be interesting if this could aggregate in the data from Salary.com, PayScale.com and Glassdoor.com, to kind of generate the mean/range/etc.

Also, integration with the other-recent HN salary tool - http://salaryshare.me/ - would really be a nice addition and the complementary services could feed users to each other.

Insert obligatory Android app request
Isn't this essentially the same thing as OpenID? Why not move to promote OpenID across more platforms instead of rebuilding the wheel?
this is actually my first app for android so i don't know very much about marketing stuff.

which app are you actually using ? =)
>A "no" to what question?

How'd you market it?

Why did it "fail"?

What made you decide to sell?

How'd you settle on a price?

What do you plan on doing after this?

Are there employees that come with this?

What's it written in?

I was asking you these questions because as it was (and is) there's not any information here, you're just posting a link to an ad. This would be like me posting a link to craigslist, and if anybody asked me about it, responding that they should just read the craigslist post. I figured if you could give us some actual information, it would have gotten you more points, and more eyeballs on your link.
Interesting, I developed a very large kiosk platform in Lua and the experience was fantastic. I found the stack based C integration to be far preferable to any other FFI I've ever used. Also the whole complaint that Lua is somehow paradigm-less (whatever that means), is very strange. Nobody who worked on our system had an issue with that.

There are very few libraries for Lua and that's its main weakness. However, because the C interface is so awesome, that never really hurt in practice—at least for our application. For something like a web app it would be completely untenable.
The problem with saying speech is a "dog whistle" is that there is no defense against it. If people in power do not trust my words, then how can I convince them that they are trustworthy without appeasing them?
I think that list is only Minneapolis. There are more.
Coincidence.

It happens all the time. Even with things that seemingly arrive 'out of the blue'.

Both the Germans and British invented jet engines within months of each other. They also both invented radar at around the same time.

I have invented things that were later patented by others, too. This was my most important, I invented it about 10 years before it was patented, but (stupidly) did nothing with it: https://www.youtube.com/watch?v=CjTa3SeKuaE

Millions of people have the same background knowledge that you do. Any one of them could have done the same as you. The thing about one-in-a-million chances is that when you have ten million opportunities you will very likely get ten hits.
Yes, I do. To live in a bubble and not expose yourself to things you don't like is to live a life of blissful ignorance.

That may work for you, but I like to be educated and have insight.
Not once they're part of a mob there isn't.
> when looking at my CPU logical core usage during the single and fake threaded version I could see tiny spikes in all the cores

What do you mean by 'fake threaded'? Ruby threads were already fully concurrent OS threads. They're likely scheduled on different physical cores, so will spike your different cores each time they manage to get the GIL and run.

> if the Ractor implementation was optimized across my 8 logical cores?

There's synchronisation. Many VM services are global.
Thought crime? Grotesque.
This is the same as with cash money.

Money can only be seized if the safe is found. And the combination is handed over by a willing party.

The difference is that money is actually more secure because you don't have a public ledger telling you that it exists and who owns it and how much of it they own as you do with the public cryptos like Bitcoin and Ethereum.
I think it's very cool that FOSDEM is happening on Matrix!
Seconded. I can’t stand the guy, but contrast his leadership to that of our Mayor and he comes out looking like a hero.
> but realizing this story was not true is making my eyes water right now.

I didn't realize it could have such a powerful impact on you, sorry to hear that. I also saw something to that effect, accepted it, and moved on. I don't think there is really a way to consume information without trusting some things, but seeking deeper validation for things you may think are important. In light of other news, this didn't seem like something worth validating, so I assume many many people have internalized it as truth somewhat.

Such is the nature of disinformation.
Top 10% is like 700m people, a.k.a most Western World population. Not a lot of “class-warfare” can happen if you classify countries as just having a single class.
https://github.com/openresty/luajit2

It has a few extras but they agree with the original luajit authors opinion that not every 5.2 feature can be made in jit.
Spoken as someone that is not struggling to run older hardware on modern Windows. Windows 10 likes to screw up my audio (Creative X-Fi Titanium) every major update. No problems on Linux with updating the kernel almost every week for many years now.
It gets maintained, but that's pretty much it. Last commit was a small fix ~2 months ago.

I had high hopes for moonjit, but development on it has ceased. There are other forks—openresty and raptorjit come to mind—but they don't have feature parity.
It takes a high level of skill and maturity to articulate such failure stories. The thing you missed is obvious to others, the "bug" you found is actually documented somewhere, and you can mitigate and move on from disaster without completely drilling down and reconstructing the problem. So thanks for posting.
BitTorrent does the same thing and used to be a lot more common, just typically not between hosts close to each other.
I was specifically responding to a comment which said:

>"Living in Finland I met a man who was perpetually on the dole, but he was an extremely active Wikipedia editor, for example. I have often thought if that basic income existed, I could finally do some of the huge OpenStreetMap expeditions I had in mind (adding house numbers for the entire surrounding region, for example.)"

It is my opinion that those are examples of vanity projects which provide little benefit to others, which is why I said:

>>"Your comment actually illustrates one thing I find repulsive about basic income proposals..."

I never said that this was true for any and all people, or that:

>>>"[I] just don't like what you think people would do with their time, if given the chance because they're not chained to a job"
> Email today is very, very reliable.

Not in my experience. Email is as reliable as the weakest link in the chain. The weakest link is often the other party's email system which was set up years ago, buggy and not maintained very well. Amongst small businesses, misconfiguration is very common and much buck passing goes on as few of those involved have the understanding to diagnose a fault. Lame DNS delegations are particularly common which can cause the same DNS lookup to sometimes fail and sometimes succeed.

However, I think that most suppliers would take immediate extra steps if it appears that their emails aren't getting through. If this is happening repeatedly then I don't think that unreliable email is the reason.
Downvotes? Uh, okay.
That's something I'll be going into in the next stage - feature identification. Some routines used for, some used while, some used do, and some used switch.

Yes, switch. Addmittedly not as the looping structure, but for the internal decision process of the loop.

Some of these choices are indicative that the programmer isn't a native idiomatic C programmer, but some might be genuine choices for one reason or another. That's when style choice exposes internal concepts.

More later. (On current work load - much later. It's taking about 2 weeks per article here, so it won't be quick. Sorry.)
Your statement is more fallacious: the iPod Touch has the same hardware, but a TCO exactly equivalent to its retail price. Similarly, you could buy an unlocked iPhone and then just turn off the 3G radio. It would still be strictly more powerful.
I think that many HNers could have an edge in the tech sector. Most of us could probably not beat the Wall Street guys with analytical trading or whatever it's called (analyzing charts or detecting some patterns), but we could certainly predict which tech companies are likely to succeed in the foreseeable future and which are likely to fail. Does it make sense? I am totally ignorant about finance/trading, perhaps someone can correct me if I'm wrong.
At the very least, I think Tom Watson MP will call this out.
I could imagine only using the client part and sending the data to our python web server that is already enabled to send monitoring data to stats/graphite.
Do low karma users not have access to this option? Don't see anything in me settings.
In case you accidentally boiled some eggs.. Science give us hope.
I'll click the ad if it is for a company I don't like and have to use. For example, particular ISPs.
I appreciated most comments that replied to my post. I made it clear that "i thought" that way, because i wasn't sure if my thoughts represented facts or not. Most of the other comments take the time to provide helpful information and educate me, which is cool and what i hoped for.

Only you take the time to belittle me based off 2 sentences.

In the same vein as you presume to proscribe to the rest of the board that they need to lead better lives, i ask you to please try and lead a more compassionate life. :)
I think there was a Coding Horror piece years ago titled something like "We don't buy software here."

There is a big segment of software developers who literally don't buy anything. Some of them use free software entirely, others use whatever software management bought. (For instance, I worked at a place that had a MSDN subscription so we had all the Microsoft tools we could have possibly wanted)

If you picked a topic truly out of random out of the great encyclopedia of the situation, you would probably make something around $1-$2 per page view with Adsense.

If you pick a topic because it is something you like (i.e. "programming", "blogging", "japanese aninmation", etc.) you join a group of other unfortunate people that are likely to be getting $0.10-0.20 per page view really because (i) there is too much of that content, (ii) the people interested in that content don't spend money.
So basically it comes down to insignificant performance and size boost. The reason for being able to mix them is so you don't need to escape quotes by using the alternative type.

I think consistency makes code look nicer and perhaps a bit more readable, but lets not kid ourselves that this leads to any meaningful improvements.
Looks like great fun!

I doubt it has close resemblance with medieval long sword fighting, though :-)

It must have been a lot slower fighting in leather, chainmail or plate armor than in this ultra light modern equipment.

And, I assume a medieval fighter would take far smaller chances than these modern hobbyists knowing a counter blow could be (almost surely would be) fatal.

Also, these guys fight one on one. But in a war you would have to guard yourself from blows and cuts not just from one enemy but from a crowd of enemy soldiers, left and right.

The guy you were fighting might be using a sword or he might have another weapon. Maybe he was using a shield and you didn't. And if he had a sword, he might not have read the memo that it should be max 4 feet long.

And fighting on some uneven, damp meadow he might be fighting uphill or downhill, and just keeping ones balance when striking or blocking would be hard compared to fighting indoor on a floor.
We built this for the recent Gopher Gala distributed hackathon. We have a long list of things we want to add or fix (the event is only 48 hours long). We'd love to get any feedback HNers have to offer!
Because even if it turns out to be vaporware it demonstrates the community's desire to see tooling developed for React Native.
Videos are easy to find
Sounds like America.
Thanks for your comment. I kind of mentioned it before, but I'm not some silver spooned trustafarian with nothing better to do. I'm a blue collar guy that's worked since I was 13. Retail, food service, whatever to get by. My first "real" job was teaching and coaching debate at a top 30 liberal arts school at 22 without a masters or phd, which were job "requirements." I called the dean of students, who was hiring for this specific job, and basically said "you're crazy if you don't consider me." In retrospect probably seemed insane, lol.

I applied on a Tuesday, called his office half a dozen times on Wednesday, flew out Sunday, was offered the job Monday and packed all of shit and drove nearly a 1,000 miles to a place I'd never been just a few days before.

He gave me a shot and I coached a team to final four and it was the school's second best finish in its debate teams 110+ history of debating. Some of my students were essentially my age.

My students were really bright, but I'd like to think I had something to do with it too, :-).
Schedule/stagger the deliveries so you have a person/group that does the unloading work for an entire plaza or area?
As far as I can tell the TI graphing calculators are riding entirely off of mind share/familiarity, both among students and teachers, and teaching materials, which reinforces the former. Specifically textbooks and teacher training all use TI graphing calculators. Presumably tests are therefore made with the capabilities of a TI graphing calculator in mind.

CollegeBoard actually has a wide range of calculators it allows for the SAT (https://collegereadiness.collegeboard.org/sat/taking-the-tes...), but very few test takers take advantage of this.

TI graphing calculators are based on sufficiently old hardware that it is probably faster to emulate a TI calculator on something with the power of a Raspberry Pi. Indeed an open source third party emulator already exists (https://github.com/CE-Programming/CEmu). Does anyone know what the legality of selling a calculator that is a dedicated emulator of a TI graphing calculator (not just an online one like Desmos, but a purpose-made physical calculator that does nothing else)? I'm curious why this hasn't already been done before.

EDIT: I mean a dedicated emulator that can do nothing else but be a graphing calculator, e.g. not something on a smartphone.
Access to navigable waterways has always been immensely valuable to humans. It's much easier to trade, travel, and transport.
This is not the article linked above.
Over the past decade, companies spun off from her brand have been more profitable than several major startups, so her success is indisputable.

But her connections and surroundings most likely helped get her that initial momentum. She wasn't just a rich lawyer's daughter, she grew up in Hollywood circles and was close friends with Paris Hilton, who set the template for this kind of success. She took those lessons and scaled her brand far beyond what the former accomplished.

That might not have happened if she was a regular person who moved to Hollywood at age 18 without any inside knowledge of how things work there.

It's not significantly different than Bill Gates' mom introducing him to an an IBM exec who she knew because they were both on the board of United Way. While the homebrew hobby club was giving everything away for free, Gates no doubt understood how enterprise software was sold, and made his fortune by getting into that market early.
Travelling like a submarine underwater is the same as flying isn't it?
Surely that's the role of the courts? The legislature is there to provide broad guidance in the form of laws; it's judges and juries who agonize over these details and enshrine them in case law.
The point of carbon taxes is to price the negative externality of carbon emissions. Since we aren't allowed to dump nuclear waste or human refuse in public parks, why should we get to dump GHG's and child-asthma-gasses into the air for free?

What is done with the revenue from the carbon tax? That's up to the policy, it could be revenue neutral w/ a progressive rebate that helps the poor, or the revenue could be used to support EV chargers, renewables, efficiency upgrades, it's all up to the policy makers. In WA, USA, they tried to pass a carbon tax, but it failed because some moderates/GOP wanted revenue neutral w/ taxpayer rebates, whereas the left wanted climate equity and green-new-deal-type policies. So, there is real, carbon-tax-killing debate over what to do with revenues.
I agree and disagree with you.

From my experience with depression/anxiety, and hallucinogens like LSD/Psilocybin I would say that has the capability to put you in a state of mind where you can see yourself from a different perspective (because it makes you a somewhat different person for a short time). This lets you learn things about yourself that many people don't pick up on the day to day. In fact, in my experience with LSD I've found that if there's something in your life that your ignoring and it's causing you some emotional trouble it's almost guaranteed to come up when you trip.

On the other hand, the best way I've found to manage depression is simply going outside and running really fast for a long time.¯\_(ツ)_/¯. It's free and you don't have to wait for scientists to study it, politicians and activists to debate it, or find a dealer you trust to give it to you.
I would be surprised if there were a driver out there who hadn't gone above the speed limit.
I would guess that many HN readers tripped over the Boston Dynamics example because it doesn't seem to fit with this talk's overall theme of surveillance. Of course we all recognize Google is doing a tremendous amount of mining and predicting, but they aren't sending out cat-bots to collect the data, which makes it a bit of a non-sequitur.
I'm afraid this isn't going to produce much beyond anxiety in your candidates. This leads to the sort of interaction where I'd end the interview early, thank the interviewer for their time, and high-tail it out of there never to return.

It's a trivia quiz. And frankly, who cares if you know what iBeacons are? What's the likelihood a project requires knowledge of both iBeacons and HealthKit?

HealthKit AND HomeKit?

HomeKit AND Apple Pay?

Why ask about something as deeply specialized as Metal, a brand new 3D graphics API, when so few projects are likely even to need it—except in game dev shops?

And in what conceivable universe does someone need to know the screen resolutions of any given piece of hardware? I've been building iOS apps for six years now, and I barely remember at any given moment.

Anyone looking for great interview questions for iOS devs should instead consult Black Pixel's excellent post here:

http://blackpixel.com/blog/2013/04/interview-questions-for-i...

It talks through concepts as much as technologies, hitting the most common cases for what a developer will actually use.
lmao, "isomorphic"