skysight-inc/HackerNews huggingface dataset:
If given the choice between do it half-assed but quickly and do it right but using how ever much time is required to arrive there, the PostgreSQL team always choses the latter approach.

This conservatism works well for me considering we're talking about a database here.

One of the contributors has written an interesting article explaining why upsert is difficult to get right (if by "right" you want it to complete reasonably quickly and without any chance of corrupting your data):

http://www.depesz.com/2012/06/10/why-is-upsert-so-complicate...
Looking at the source, its an iframe for this site: //www.redditmedia.com/r/angularjs/comments/2f7ziz/i_quit_my_job_to_teach_you_how_to_launch_a_full/ckbhk0m?embed=true&context=0&depth=1&showedits=true&created=2015-05-04T04:25:24.511Z&showmore=false
There are AVRs that can reasonably "do" SHA2, but many have text size limitations, which motivates vendors to minimize the number of primitives they use (for instance, it might lead someone to use CBC-MAC instead of HMAC).

Also: however capable your hardware is, if you're doing long-range RF (and not GSM), you've got a much more significant space and round-trip constraint to deal with.
The citizens of a representative democracy have the right to know what the government is doing on their behalf, either domestically or abroad. Saying that the Snowden revelations damaged relations with another country is like an adulteress complaining that her snitching boyfriend damaged her relationship with her husband. The crime occurred long before the revelation...
We went through a SAQ D Service Provider 3.0, and paying for an ASV didn't hurt nearly as much as filling out that 80 page questionnaire... In fact, it reminded us apply some recent CVE's to our system before taking it to production.
We used Comodo HackerGuardian which is $250/y, so you don't have to pay $1000s.
> Yes let's make it easier for youngsters to get themselves in the hock for that hit of instant gratification. Get 'em on the never-never instead of teaching them to save.

I think the people that are more likely to save are also the ones less likely to default on loans. Maybe it's just over-simplified thinking, but I think the reason Affirm works wonderfully is because they keep audience in mind. They pull in a ton of data points to assess the risk on investments, and I would love to see the percentage/demographics of people that get loans.
Nope, this is just a particularly funny example of what standards committees routinely produce.
Thanks a TON! I am Frequently Slightly Annoyed by pressing control-. and having to re-import things, declare things, etc. I'm looking forward to using this.
I come from a SQL Server background and recently jumped over to a Postgres shop. It seems like I came in at a really exciting time.

I was really missing SQL Server's powerful MERGE statement, so this is welcome news.
Most REPLs will only accept connections from localhost by default (a sensible idea). In this case you just need to setup an ssh tunnel to the machine and connect through that.
Yep! Exactly why I stop using them and will not consider them at all. It's a crowded market and they are not standing out.
Why no body mention such a great service – open build service?
German secret service BND reduces cooperation with NSA
Does it handle locking (aka no deadlocks) correctly?
I love that it's there now. I've been waiting for it for a long time, but one thing I don't get is... why does every single implementation have to have their own slightly different syntax?

pgsql -> on conflict

mysql -> replace / on duplicate

oracle -> merge

mssql -> merge

sqlite -> insert or replace

firebird -> merge / update or insert
"Deceptive is your word. I said 'whitewash'. A whitewash is [...] ultimately deceptive."

I don't feel like I'm so much trying to use debate tactics against you as to observe how uncomfortable even you seem to be with the idea that Hal Abelson was deliberately deceptive.
Uber Submits Bid of Up to $3B for Nokia Maps
I have attended on many occasions top AI conferences and have spoken to more researchers than I care or could count. I can tell you there is a very little interest in "intelligent machines"[1]. Rather, everyone I have ever met works on different types of problem solving techniques. What constitutes a "problem" and what makes a successful "technique" differ wildly. Taking a step back however and analysing the field as a whole you will find one commonality: almost all the research can be described as searching and sorting: i.e. stupid mathematical tricks.

The AI of today is not so drastically different from the AI of our academic grandfathers; what's changed is our ability to scale up to larger and larger versions of the same searching and sorting problems. Certainly there are worrying implications in this; machines that are able to parse and sift through very large data sets present all kinds of headaches for privacy and safety but let's not kid oursevles: there's nothing intelligent here. Tomorrow's AI is almost certainly going to be just a better version of today's AI; i.e very fast and dumb as a bag of hammers.

[1] The exception is when researchers need to sell their wares to funding bodies and the media. It is much easier to impress upon the lay person an idea involving "intelligent machines" than it is to explain what we actually do.
Who decided the syntax? Why not use MERGE ... INTO ... USING ... ON ... WHEN like Oracle and MSSQL and apparently ANSI SQL [1]? I'm not aware of ON CONFLICT being standard.

[1] http://en.wikipedia.org/wiki/Merge_(SQL)
I met my - now ex- - wife when she sent me an email to commend me for publishing my first web page about being manic-depressive.

It wasn't that she fell in love with me over that page, but because we began to correspond regularly, then I worked up the nerve to ask her phone number, then to tell her I was attracted to her then - before we'd even met in person - to tell her that I loved her.

I've met three girlfriends when they were fellow patients in psychiatric hospitals. One of them we started dating after we were discharged, two of them we carried on right there in the ward.

The last girlfriend I had, I asked her for a lift home after we met at a gas station at three in the morning. I really wasn't looking for romance that night, I really was tired and didn't want to walk home.
I remember about 10 years ago using UPSERT in a Teradata database to do delta-diff updating of tables.

Basically, I was updating a table from an external file, and I wanted to add what was new, leave what was the same, and delete any records no longer in the external table. Using UPSERT to insert new rows, update a timestamp on existing rows, and then afterwards delete any rows who's timestamp was before the UPSERT operation. Because of the nature of the file, doing an external patch/diff approach was difficult, but the UPSERT operation worked like a breeze!
So... Do "programmers" think of "matrix" and "tensor" as "synonymous"?

edit: that was actually a serious question, because i really don't understand this idea that programmers have a common notion of what a matrix is.
I'm not concerned with ads, exactly, but with analytics. That is I'm completely cool to look at an ad, provided it doesn't look back at me.

127.0.0.1 www.google-analytics.com
127.0.0.1 ssl.google-analytics.com
127.0.0.1 www.hosted-pixel.com

I've got some more I'll dig them up - they're on my other computer.
They put a product out a little before the curve, but now all cell phones can run accelerometer logs in background and there are more prestigious and advanced smart watches.

Maybe if they played nice and opened their API / allowed devs to play with the damn thing, they could compete more with Apple, which does the same for its products.
style['border-width']
Face Detection by Bing
Even Obama thanks the pope for crackers
Bootstrap HTML5 History Tabs
Because the devs pay attention, and take the time to do things right. See https://wiki.postgresql.org/wiki/UPSERT for a glimpse into the design that needed to go behind this.

I feel a lot of Postgres fans (myself included) put their "money" on Postgres circa late version 7 or early version 8, back when MySQL was the more featureful and performant of the two, while Postgres had the reputation for being more, shall we say, robust. (Remember, those were the days before InnoDB was the default in MySQL.)

The payout for investment in Postgres the past few years has been substantial -- native replication, true serializable transactions, foreign data wrappers, index-only scans, native JSON support, updatable views, and materialized views are among the features added to Postgres in the last 4 years. It's matured from being an "entry-level" RDBMS with few features that all work reliably, to a much more enterprise-friendly RDBMS with many features that still work reliably.
Its the easiest way to monetize them. I'm really surprised it took this long. One of the interesting things to look at is CTR and affiliate payout, you may find that only 30 - 40% of the affiliate links "stick" only because so many people between where the link is and the vendor end up trying to stomp on the affiliate tie in.

It is an affiliate eat affiliate world out there.
Good. There's no love lost between me and companies that make significant money doing PCI assessments (they tend to be the bottom-feeding remora of the infosec economy), but the one criticism you could not level against the PCI certification program over the last 10 years is that it was too hard to get certified.

Use Stripe. Move on.
Exherbo is the singular item on that list which does not use ebuilds; the lack of progress and technical stagnation of Gentoo is what led to the Exherbo founders starting their own distribution and develop a new package format. The package formats have diverged greatly to deliver important features (such as this one, among many others) Gentoo was unwilling or incapable of delivering.

It's unlikely changes like these would ever be introduced in Gentoo, for multiple technical and more importantly social reasons. Gentoo has a big problem with accepting sound technical ideas because they come from politically incorrect people.
GPU-based malware, the evolution of rootkits and keyloggers
Javascript will run anywhere you have something to run it on, same as Java, or any other language.
Why You Are Not Feeling Well at Home?
It's not solved, because method arguments are evaluated eagerly. It means that message argument may not be an expensive expression, because it will be calculated independently whether debug is enabled or not. In case of macros arguments of this method could be evaluated lazily.
Many of the comments on this thread have been about their Surge product and comparisons to the Apple Watch. Though the Surge is their "flagship", in reality I see the One and Zip a LOT more. For people who aren't interested in a smart-watch or wearable (and believe me, there are many people who don't believe in the value of one yet) the Fitbit One fills a great market between a high end fitness tracker, and a cheap free pedometer that you got from work.
One is the shared versions as mentioned in another comment. The other one is security updates. If you release Widget that needs Gadget =1.2.3 that needs Tool =2.3.4 that needs ssl-wrapper =3.4.5 and you find out that ssl-wrapper 3.4.5 has a security issue (fixed in 3.4.6), then you can't just upgrade Widget. I would have to wait for 3 different projects to update their dependency lists to get a secure system again.

Provided that everyone does anything even resembling semver, you could just use Gadget 1.2.>=3, Tool 2.3.>=4, ssl-wrapper 3.4.>=5 instead and still be fairly sure the api won't suddenly change to something incompatible.
I don't get the money saving aspect. If you want to be frugal, just grow stubble or a beard. A $3 razor will last for over a month.
Imagining a Better Future for the Soils of Champagne
There's some extended discussion of the issue on the wiki[1]. A future full MERGE implementation might have slightly different semantics or performance characteristics than ON CONFLICT (which might also differ from other DBMS).

[1] https://wiki.postgresql.org/wiki/UPSERT#SQL_MERGE_syntax
https://news.ycombinator.com/item?id=8150346
This is the device that BC Hydro uses I think:

https://www.itron.com/na/productsAndServices/Pages/OpenWay%2...

And here is the spec sheet on the CENTRON itself:

https://www.itron.com/na/PublishedContent/OpenWay%20CENTRON%...

According to the linked to paper and the data sheet, they use the same standards so I would wager "yes" on BC Hydro's power meters being affected.
Thank you! Hope you're enjoying the game.
MERGE is actually a separate feature. We're still considering implementing it. But it's syntax is too cumbersome for many usages. There's also some unrelated complexity - so implementing merge support does get easier by the infrastructure in here, but a fair amount of work remains.
Got it. Would you send me an email at hello@getonboarded.com? I'd love to show you how you could implement a non-modal flow with Onboarded in ~5 minutes. Would love your feedback.
Free e-learning tutorial on Spring
Yes, but everything other than HRM is available in the vivid it itself.
Well what about grattipay then? I think it's pretty obvious with their latest blog post that it's not just as easy as moving onto stripe and your done.
What would you use instead of flickr? My usecase is uploading a bunch of photos to an album to share with friends/family.
There's a great discussion here: https://wiki.postgresql.org/wiki/UPSERT#Syntax_discussion It basically boils down to that the different syntaxes mean slightly different things. The PG devs (IMO rightly) don't want to adopt an existing syntax that does something slightly different than what they are willing/able to provide, thus confusing users.
Free e-learning tutorial on Hibernate
Thanks, I was aware of AutoDMB and Munki, but the rest are news to me. We'll check them out.
There is a section in UPSERT wiki about this -
https://wiki.postgresql.org/wiki/Value_locking#.22Unprincipl...

EDIT: rather the whole "Value Locking" page -
https://wiki.postgresql.org/wiki/Value_locking
Spot on. Energy, storage tech, large consumers, and maybe producers.
As much as I hate the high cost of international tuition, I would say this would end up being beneficial to you. In addition to the boost to your credentials, you'll also become eligible for employment on a special visa once you graduate that will allow you to be employed for I believe 18 months with option for 12 month extension thereafter (even longer extensions allowed if you work for an educational institution). This allows you to get your foot in the door somewhere and then work that into a really well paying job here.

Source: Multiple Indian and Thai friends who have followed this path in life.
Crate and Google Cloud Platform
Le Film Captain America: Civil War Accueille Martin Freeman Au Casting
9 Challenges Faced by Mobile Game Developers
Linking with Hydra and JSON-LD
I quite literally met my wife on a street. I was a volunteer in a strange city and she was driving by and needed directions. I had absolutely no idea how to give her directions to our donation center so she said we could stop by her apartment to pick up her donation and give her directions for future reference.

She and I started talking. I ended up coming back again to take another donation (she sure did donate a lot of stuff...). A few weeks later she was needing some help moving out of her place and I said I wouldn't mind helping. That led to even more chatting, which led to late night chatting, which led to eating together, which led to dates.

Probably far more detail than you were wanting. We've been married for just about 13 years and have numerous kids together. It wasn't really a conscious decision at first to "be together", it was more like the most natural and wonderful friendship ever.

Yours will come my friend. Be patient :) there it time.
Rooftop greenery. Which is only mentioned in an aside or comments of the article.
Elon Musk reveals a tentative timeline for the $35,000 Tesla Model 3
$600/mo is less than the price of a filthy studio apartment in the cities where most of HN's jobs are.

$100/mo for rice and beans, $70/mo for water,trash,electric,heat,telecom ; $400/mo for rent, ???

Do your kids have their own jobs? Your spouse doesn't, because someone has to watch the kids, and that is over $600/mo alone.
Nokia bought NAVTEQ back in 2008, and that became part of the HERE business unit.

My old Garmin standalone GPS used the NAVTEQ maps, and they were really good. Whatever it is that Google and Apple use now just doesn't compare.

So why hasn't Apple bought them? $3 billion is a rounding error to Apple. To a VC funded company like Uber, $3 billion is some serious coin.
> late version 7 or early version 8, back when MySQL was the more featureful and performant of the two

MySQL was never more featureful. The reason I started migrating back in the 7.1 time frame (when TOAST tables were added and you could finally store more than 8K of text in a TEXT column) was the lack of sub-selects in MySQL.

Even aside of that, Postgres was far ahead when considering basic SQL support: stored procedures, views, subselects, check constraints, triggers, actually enforcing foreign key constraints and so on.

It was significantly slower than MySQL, but it also scaled much better under load. Back then, when you had low load, MySQL would be about twice as fast as PostgreSQL but then as the load increases, MySQL's performance would drop sharply and Postgres would stay consistent.

By now, MySQL has mostly caught up feature-wise, but there's still stuff left that Postgres just does better. Also, even plain ideological reasons (community project vs. oracle open-core project) would want me to stay with postgres.

I also have anecdotal evidence that MySQL still has serious issues in the robustness department which I've yet to see with postgres.
Thinking about the future of one's career seems like one of those things that Everyone has been telling us to think about, in some manner, for our entire lives:

- "Keep fresh on skills, because future career needs will arise (at this job or the next)"
- "Keep interviewing skills sharp, because we have little control over company loyalty/success"
- "Most companies have little loyalty to the cogs within, and it's foolish to expect them to be"

Obviously, exceptions exist for such things, but it certainly seems to be the conventional wisdom.

Asking which company would be better for one's career, Foo Corp or Bar Inc, seems like the sign of someone who cares about _having_ a career future. Wanting to learn more means that they're critical enough to _care_ about your culture, what they might learn there, etc. This is _especially_ true for someone who does not have personal contacts within those companies.

In the hypothetical case where I had an offer from both Google and Facebook at the same time, I'd certainly be trying to find out which would help me grow better as a developer and as a person.
At least in development, if you use rvm gemsets you can avoid having to type `bundle exec`. In fact I learned recently that nowadays you don't even need gemsets:

https://rvm.io/integration/bundler
I think it would be good to write a clear disclaimer or explanation that no amount of obfuscation can protect someone from reverse engineering the code[1] before someone goes and trusts that tools like this are sufficient to ^protect^ their code. An interesting SO thread about this:

http://stackoverflow.com/questions/261638/how-do-i-protect-p...

[1] in fact, for this obfuscator, IMHO, all you need is search/replace capable editor, the dis module and time
Click embed under a comment and it will generate embed code for the comment.

Example: http://www.reddit.com/r/angularjs/comments/2f7ziz/i_quit_my_...
World Password Day - May 7th
صباغين بالكويت هاتف 55090348 – مؤسسة فهد المسيليم للمقاولات العامة للمباني
Unfortunately, 'Thank you Snowden. Fuck you NSA' also translates as 'Fuck the owner of this laptop, yours sincerely, TSA'.
For a lot of people, me included, writing about things is the same as thinking about things. I need that written output to be able to work through things and inspect them deeply.

And if I've spent all that time distilling my thoughts into a readable form, I might as well post it.
The simple/typical use case of Django's ORM, sqlalchemy, Rails ActiveRecord, etc. is not much more than a native API for composing SQL queries, and the automated mapping of table rows from the RDBMS into native data structures in the application (which happen to be objects because of the language).

When you claim that you are not using an ORM, a reasonable person would take it to mean that you are forgoing the use of query builders and automated mapping from SQL results to application data structures.

So, it may be true that classifying these libraries as ORMs is incorrect, but the "user experience" as a developer between these libraries and typical ORMs appears to be pretty much the same. Or is that unfair?
It's generally transparent redirects in the other direction. You load JS from their servers, the form posts to their servers, redirects back to yours. Often even the form isn't hosted on your infrastructure, but instead embedded into your page through some JS that is hosted elsewhere.

If your responsibilities weren't waived or significantly lessened, I'd imagine companies like Stripe would be significantly less successful.
MBTI is missing some of the dimensions of Big Five but it has a more positive, and non-pathological look on personality. Who would want to measure his "neuroticism"? There is this "aha!" moment when you first read about your type and identify all those little quirks of behavior you thought were your own as a type thing. It's liberating in the sense that it equally accepts all the personality types as normal - this shows there is more to being a woman than ESFJ - the archetypal woman type. There are also INTP women and they too are normal. No need to feel weird about being a little different. That's what I got from MBTI.
شركات صيانة التكييف المركزي – مؤسسة فهد المسيليم للمقاولات العامة للمباني
Can someone explain the purpose of step counting?

From all the academic research I have seen regarding nutrition and exercise getting a few thousand extra steps will have no meaningful affect on your weight and health.

Is the pedometer really just a psychological trick to get people thinking about their weight and health more often which leads to people actually eating less?
Try telling us about your projects and updates on Glitch Club, this is exactly what it's for: http://glitchclub.com
That is incorrect. Tuition and property tax is not the same as income tax.
Blockspring (YC S14) is hiring a lead product designer
I agree, and that's why looks very promising. It's just that the cost scares me a bit. Anyways, thanks a lot for sharing your insight :)