skysight-inc/HackerNews huggingface dataset:
in PG (such as using an ORDER BY)

You can use order by in a CTE in mssql, you just have to specify a TOP clause.

;with bar as (
select top 100 percent *
from foo
order by foo.name
)
select *
from bar
Any plans to be able to use these modularly and combine several shipping containers?
I really wish toxic articles like this were not submitted.
Unless I've misunderstood all these years how pawn shops work, they would indeed have trouble operating under the same business model as average wealth in their area increased. Resale shops and such would be fine, but the difference is that they don't sell stuff they've acquired when people defaulted on what amount to short-term secured loans.
To affirm your anecdote, I had a friend who bought a fourplex in a somewhat depressed area, lived in one unit and rented the other three. It was an unmitigated disaster and a terrible experience. I spent some time with him trying to help out around the units and also discussed his experiences with him. I concluded from that I would never, under any circumstances, want to be a landlord.
Gotcha. Thanks for the reply.
The series \sum a_n\cos(n\theta) + \sum b_n\sin(n\theta) and \sum a_n\sin(n\theta + \pi/2) + \sum b_n\sin(n\theta) are literally, exactly the same; it is purely a matter of convention which one you choose to write. In more programming-type language, 'cosine' is just syntactic sugar (or 'sine' is, if you prefer; or, I would rather say, both are, for the real and complex parts of the exponential); but sometimes syntactic sugar is handy!
I know this discusses a few strategic plays Amazon is making but shortfalls of the self-checkout project (AmazonGo) are interesting:

"In its video touting Amazon Go, the company said it was aiming to open the site to the public in “early 2017,” and it hasn’t provided an update to that timing. But the technology has been crashing in tests when the store gets too crowded and requires human quality control, people watching video images to make sure customers are charged for the right things, according to a person familiar with the plan."

Not super familiar with image recognition but do you think that's just a failure of the training data set or a much more complex technical problem?
An exploration of unicode domain names and how they're interpreted
My mom uses her's constantly (mostly as a Kindle). I use mine about once ever 2 months. I keep thinking I should give it away or sell it but I keep it around just in case there's some app I have to check out. I also wonder if I'd actually use it more if it was a pro with the pen but I doubt it.
I just bought a house, and I will say, I'm glad I had a realtor guiding us. Because I am the buyer I had to pay her nothing, she just gets her 3% - 6% on the sale, and honestly I have no idea what that number is. The seller pays.

That being said when I sell, I definitely do not plan on using a realtor. As you said, it's super easy to sell online and I agree. I even found the house I bought without the realtor, we literally just said "we want to see this house." What she did provide was insight into the market, the area, she showed us comparable houses, explained the history of the builder, etc. This is where she brought value.

In selling a house, the only value they bring is customers. That usually (car sales, medical sales, etc.) is a percentage of sale type of transaction. So, to me it appears fair to give them a percentage. If you choose not to use them, you can!

Unfortunately, I believe in the state I am moving to I am required to pay for the buyers realtor (although I am not 100% sure). That's typically 6%, but technically, I don't have to sell to them. Sooooo I can negotiate and work with them to get say 3%.
On a tangent, take a look at Numenera [0][1]. It's set a billion (!) years in the future, but different from other ultra-science fiction or post-apocalyptic settings in that it primarily explores what Earth would be like after accumulating multiple layers of incomprehensibly advanced supertechnology, the true purpose of which cannot ever be understood by the current inhabitants, and at best they can only reverse-engineer a fraction of the original functionality.

[0] http://www.numenera.com

[1] store.steampowered.com/app/272270/
Payday loans. Check cashing. Rent to own. Overdraft fees, minimum balance fees. Interest on credit cards, late fees & fines. Debt collection. For profit prisons. Selling the same crappy built-to-fail cheap consumer products over and over again.

I think you underestimate that when you say "loan sharks" that when you're poor every bank and financial institution basically feels like a loan shark when you pile on all the fees and hidden charges. There's no escape.

The poor are a hugely profitable market where their poverty is used like a weapon against them.
Daily Deals 03/21/2017
The fatfinger anecdote happened a lot so I feel you. As far as the network effect, I think all ages can benefit. I know many older users are getting hyped using these "younger" technology. I once met a nursing practitioner who is probably in his late 40s, early 50s. He plays Pokemon Go and he's almost done with the Gen II after ~3 weeks into the new release, while I, in my mid 20s is struggling to complete my Gen 1 pokedex.

There's something about the older generation that some people dismiss as the minority, but the facts are (1) like you said, older folks have higher spending potential, and (2) the effect of kids using technology will influence how kids' elders use technology. So being family friendly is quite a product attraction. I don't use Snapchat because my friends all use FB and Instagram, so I prefer sticking to the platform where my social circle is. I did try Snapshot a few years back.
> But it's not a problem created by business owners providing housing to poor people (or ones evicting poor people who cannot pay). It's a problem created by state and municipal governments that make it illegal to build dense housing, housing on small lots, housing that isn't to code, etc.

I concur -- awful zoning laws are a root cause of the undersupply and overpricing of housing for poor people. Criminalising the sheer act of dwelling (or renting to people who dwell) in any sprinklered building is utter depravity, especially given how many people are homeless or live in warehouses that are deadly firetraps.

However, currently-existing residential landlords/property-owners have extremely strong reasons to preserve the currently-existing legal regimes that limit housing supply. After all, if it suddenly becomes legal to {build,live in, rent out} dense housing / housing on small lots, there'll be people who indeed will do so, which will increase supply and lower prices.

That's the profitable element in the current state of affairs -- all the current landlords who can charge higher than they would be able to if the government wasn't making lots of potential competition illegal.
Bolt EV being discounted by $5,000+ as deliveries stall
Do you know what would make this idea more approachable for you and your friends? Maybe more serious/relatable filters and stickers, easier to use, or not too self focused? I'd be interested to know.
Interesting. What encoder exploded at the large float? I ask because I would be surprised if an encoder/decoder from one of the major languages couldn't handle that.
https://www.kidton.com/products/zoob-fastback-h2h
We won't stop selling DRM-free but this is the second time we've had a problem like this with Amazon.
Making the web an enjoyable place with React
You can hire a lawyer and pay a flat fee for labor if you want to avoid the percentage comission model. There are also discount brokers out there that take less. That can work if your more DIY about buying and selling houses.
If the transaction didn't also benefit the buyer, they wouldn't voluntarily enter into it. If I have a dollar but would rather have a soda, buying the soda makes me slightly better off. I might prefer a free soda, but I'd still rather have the soda than the dollar. If I perceived the soda as being worth less than a buck, I would have kept the money. There are a million other things I could have done with my dollar, but I chose to exchange it for a soda; that simple choice reflects a profound truth about the market.

Nothing is "absolutely worth" anything. The same bottle of soda is worth 25 cents at Costco and $4 at a ball game. It's up to the customer to decide whether the product is worth the price it's being sold for.
A judge can compel someone to work without pay? Is that not slavery?
Pretty nice code.
Me too. (yes me too)
sure but you often have to fight tooth and nail for the right to invent anything yourself in a lot of modern web-based environments. The idea of actually inventing something yourself is seen as crazy and dangerous in a lot of places.
Another reason to not buy Makerbot is due to their unethical business practices towards the open source/hardware community [1].

[1] - http://hackaday.com/2016/04/28/the-makerbot-obituary/
The article by Russ Cox [0] (from which the initial Perl vs. Thompson NFA graph is taken) is a much more informative read. Also, I'm not sure why this always gets brought up as being a big deal: CS is all about making the right tradeoffs and I agree that sometimes there are cool tricks that let you _almost_ have your cake an eat it. But here, there is no such trick: backtracking has always been exponential and finite state automata have always been linear.

No surprises.

[0] https://swtch.com/~rsc/regexp/regexp1.html
Whoops, I meant for Windows. I can't get it to install on Windows...
I think on a philosophical level everyone should be able to justify their work at any time. But on a practical level this can be distracting to the people doing the work and it gets us into the begging/funding/publishing cycle we're stuck in now. Maybe the reward system just needs to be changed.
That 3% that the seller 'pays' for is really yourself paying for it. You could probably negotiate that fee away if you didnt have a realtor on your side for example
Interestingly Kindle Direct Publishing does/did do some sort of content check. They flagged me because some of the book content in something I was publishing a few years back was adapted from various blog posts that I had written. I just had to send them some links and confirm that I was the copyright holder or otherwise had rights to use the material.

As far as I remember though, the same book wasn't flagged by Createspace.
Our support and sales teams have been using this email relay tool to nice effect. We send gifts to our prospects and users within Streak and Desk to demo the product or win back customers.
Oh my - so, it's actually a lot more complicated than that. Let me run it through for you:

- You have to build enough of a retry algorithm so that you start renewing well in advance of the expiration date.

- You then have to build the mechanism for warning customers that there was an issue renewing for one of a variety of reasons

- You then have to deal with situations where LE has issues, which happens fairly often

- There's a queueing system, where you have to handle not sending too many certs at once

- You will end up in scenarios where users will migrate off of you, not tell you, attempt to issue another LE cert with another service, and fail, and then blame you

- Similarly, you will have users who connect and disconnect domains, and your system has to be smart enough to properly revoke certificates without locking out a domain from too many retries

- and then what happens when you can't renew a cert for whatever reason? Do you break the user's site? Do you fall back to http?

I'm not saying it's millions of dollars, but at scale, it's complicated. Here's a blog post about how Squarespace did this (disclosure, I work there):

https://engineering.squarespace.com/blog/2016/implementing-s...

Saying it's "just" a 4x acme request annually demonstrates a real lack of understanding of supporting this kind of system at scale.
for permanent installs, I really like the idea of containers as side supports to a quonset hut. like this, but with 3-4 containers: http://alarconbohm.com/
This comment itself is pretty ignorant. At some point, everybody needs to understand that there are no simple solutions. Every proposed solution has pros and cons. Just giving more money to poor people could, under certain conditions (like the kind of tight housing market you see in most cities) lead to a kind of rent and asset inflation. Before dismissing solutions as "economically ignorant liberalism" you might carefully weigh the theoretical pros and cons.

The next step is to not stop at theory and look at the actual facts on the ground. This relies on looking at the data. People love to rail against the minimum wage because everybody knows "in theory" that higher wages lead to less unemployment and higher prices... but in fact, careful review of the actual data shows this not to be the case. Similarly, people who rail against rent control and stronger tenant protections seem to have little to no actual understanding of how highly competitive markets like the real-estate US/North Eastern markets actually work. Rent control and rent stabilization in Manhattan, for example, has been well studied and demonstrated to have several positive network effects (by keeping families in place) and negative effects (by keeping families in place). It's never cut and dry. The reality is "theoretical arguments" are worthless because they often rely on simplistic models that have nothing to do with reality.
Hmm, the impression I got from the training video I watched was that it would be unlikely for Google to approve your outside project most of the time. But maybe it was just the way the specific presenter worded it.
I have been using MySQL for a number of years. I will probably use Postgres for any new projects I start. But my current work is maintaining a system written by someone else, so MySQL it is. Its not that bad a database, but there are enough quirks to it that I feel that PG would be a better choice.
> and anybody that tells you that you can't negotiate to create your own contract for a deal should be prosecuted for coercion

As long as you can decide not to sign it, it's a negotiation. Pretty shitty and one-sided negotiation, but still negotiation.
I only buy when is sold directly "by amazon" if the seller is not amazon then all bets are off.
True but those tools have nothing to do with the 'story' concept. The iOS camera already does filters and markup of text/scribbles. I just find it odd that all the tech press are comparing it to something it's not trying to compete with.
It wasn't explicitly stated, but the founder did not agree to modify the IP clause? I've had the experience of checking an IP clause and insisting that the founder modify it and coming to an agreement.
We put a lot of thought into the paper and cover finish on all of our titles. I like to produce books that I would buy. These cheap-looking knockoffs are painful to see.
They still do ALPR from cameras to determine where to send the bill/ticket if you go through the lane without a pass.
Haha like most of my complaints I think...
They give two reasons to use this, but I guess another would be that you want to run the same Javascript code both on the client and the server, and your server is running OCaml.

Would they support this scenario?
While I agree that perhaps SXSW has "jumped the shark", at least the interactive part, you'll find that enrollment and participation at many other startup-focused events is declined in 2017 year over year versus 2016. I would bet that Web Summit, CollisionConf, TechCrunch Disrupt, and others are not as full as they used to be or are facing similar challenges with startup numbers, and sponsorships especially.
Microsoft Widespread Service Outage
And you'd be surprised how few people actually do this kind of validation before building a product.
I've been an early adopter of react native for a long time.. and this was exactly my experience... it's very demoralizing and why i switched to exponent and try as hard as possible to do all I can with just JS (without detaching project form expo).

So far it's been amazing!
Its a bit like PHP, its easy to install and get started compared to PG (I need to look up the docs every time I do a PG install to get the initial users started - Mysql often offers me that from the OS package manager).
Multi-month approval sucks, but to be honest I wish more companies were more skeptical of adding 3rd party dependencies. At the very least, do a code review of the dependency (and it's dependencies..) and acknowledge the actual cost associated with the addition you are making.

Hardly ever happens.
Easy to bypass, just turn off Javascript temporarily and reload the page.
This simplified algorithm doesn't distinguish between learners (readers) and proposers (writers) to the value. I'd say this conveys the core ideas of paxos, and it makes sense to treat learners as a (performance-critical) extension/optimization, just like the many optimized paxos variants in the literature. Another benefit of treating read/write as a single operation is that it serializes reads and writes (e.g. in a distributed log).
Does a months severance pay eliminate the need to pay for 6+ months of unemployment?
I think I read Norway just moved into #1 happiest country in the world...
Pikka got an update
The media focused on the wrong thing during SXSW
Depends on how amazon's lawyers looked at it. I suspect they assumed that section 230 of the CDA, and the DMCA would cover them. However because physical paper copies are being generated that voids both the protections provided by both laws. Amazon is most likely criminally and civilly liable here.

I am not a lawyer and nothing here should be considered legal advice merely personal opinion
Support the estate tax! And do it vocally, it will be coming under fire soon.
What features would improve Pubmed?
292 Billions years ought to be enough for anybody
I agree and I acknowledged this ("the buyer is getting whatever good or service they paid for"). But I still tend to frame it as the buyer having incurred a cost, not having profited. The seller is the one who ends up with money in hand, that can be invested elsewhere. The buyer usually ends up with something that either starts off with no resale value, or that depreciates, or that (if you're poor) does nothing but keep you alive -- like a roof over your head let's say.

Mind you, since that last category consists of things one really needs a lot, it makes one that much more eager to engage in the trade and pay the stated price. If you can afford to walk away from a negotiation, your position is a lot stronger.
I'll be a believer when it can handle a Thomas Crown scenario - multiple people in the same outfit crisscrossing around each other. While a bowler hat flashmob is unlikely, a group of similar dark jackets etc isn't.
>experience with humans

So true. That said, thinking 38 years into the future is usually not sensible for most businesses, because it's very possible that they're bankrupt before then. Thinking 21 years into the future also offers poor ROI for the same reason.
Oh I should say, I did the exercises too. My background is in math and I'm very accustomed to the meat of the book being in the exercises (I'm looking at you Springer).
This algorithm appears to minimize infill time while still supporting the shell during printing. That's useful for prototyping form or fit, but I feel like 3DP for prototyping has been beaten to death already.

I would much rather have algorithms that can improve the performance of production parts. For FDM, that means infill algorithms that vary cell size and structure to optimize some user-defined metric, whether that's rigidity per dollar, per print time, etc. Just having denser infill near the shell like a bird bone would be a nice start.
> it's not all that hard to file your own taxes the old-fashioned way

> Each time, it has taken me a full 12-16 hours

You have a strange definition of "not that hard".

This is exactly my experience trying to do it the old fashioned way. The IRS's documentation is written in accountant speak so deciphering what each means is an effort and all of the time it takes adds up. Who else uses the word "schedule" to mean "form"? And then there are so many places where it talks about "qualifying" this or that without telling you how you know if something qualifies.

And that's before you get to the nightmare if you own stocks. My wife inherited some telecom stocks from her grandmother. Her grandmother got them as part of her paycheck when she worked at AT&T. Unfortunately she didn't keep any of the original documentation for them (my wife had to track down the stock management companies and get them to reprint the certificates). These stocks were then of course split across all of the baby bells and merged and split a ton of different ways over the years. Then one of the companies merges and we get a payout for a fractional amount of a share and have to calculate the strike price of the stock for the sale.

As an average person this seems like an impossible task. We just enter 0 and pay a ton of extra tax because how in the hell are we supposed to do that calculation? As far as I can tell we can never sell these stocks.
I think it's the terminator in the literal sense. Person who terminates things. But if referring to the literal word, why put it in quotes? Why capitalize it?
As a "Content Creator" and frequent advocate for U.S. Copyright Reform, this is one of the few instances where I think the full willful infringement penalty is absolutely justified. There's only a paper thin "Well they didn't inspect every book!" defense, which immediately falls apart when Amazon is making money by way of the transactions and doing market harm to the actual Copyright holder. It's not "incidental" infringement like photocopying a chapter from a book and emailing around the office or the Amazon corporate mailing list. That's more innocent. This is some straight up commercial hustle we're talking about.

I'm tired of the refrain "It's too much effort / money / investment to check X, Y, Z on our system" when that system is the only goddamn reason a company exists in the first place. Want to be a Middle Man? You get the Profits and Responsibilities of one. Caveat venditor.
Any reason to scrap the thin layer of JavaScript from other languages and plop the big lump of it right on the top? It's not like Node.js captured more than 2% of market.
2038: Odyssey 2.5
AMT only really affects people who make like $200,000+, right? It's a reasonable point, but I think it only applies to 5% or so of taxpayers.
Exactly. Same with interest rates on loans. If you have a bad FICO your interest rate will be higher because you're considered riskier. Higher risk, higher the reward that's how business works, generally. Business != charity.
I can't find the decision, but I doubt he was forced to by the judge. It seems more likely that he negotiated this for a discount on the stupendous court costs.

For instance, here's a 2002 report on the loss which doesn't mention the requirement.

https://www.theregister.co.uk/2002/08/12/alcatel_owns_us_emp...