skysight-inc/HackerNews huggingface dataset:
> There's no technical reason this cannot be offered

this actually isn't true. and I say this as the person who pushed for a 32->64bit upgrade path at microsoft in longhorn. at the most basic level - it is easy for the core OS. but any apps you've installed are going to be a crapshoot to see if they work, with their installers only expecting a 32bit OS, registry, etc.

upgrade is hard enough as it is so risking the experience to a customer of breaking many of their apps with no good path to resolution isn't worth it versus waiting ~3-5 years for a PC purchase cycle and their next preinstalled version of windows being 64bit and going from there.
I think we've all now seen what it looks like when someone who is unqualified for the job and doesn't want the job is given it.

In fact hereditary offices are a form of sortition, and they have proven not to be a particularly good system.

(I've never been a fan of Aristotle anyway)
Some UUID and Guids can be made sequential.
You should probably read some news stories about that...
Very rarely have I found natural keys that end up working long term. I always default to a single column surrogate and use natural keys as exceptions.

As to your question, any introduction to RDBMSs book will teach all these concepts.
VCs wont pay for rides forever.
> As a monopoly, you usually have no reason to change.

But they don't have a monopoly and haven't for several years. I mean changing from phone dispatch to apps has to be done in 6-12 months not 6-12 years otherwise yes they will go under.

So what you are saying is that they are too slow to change? What's the reason for that? Is it that the taxi operators are small businesses and they are a too diverse group to be willing to take large risks/investmentst together such as for improving their common dispatch? In that case - the system is almost a perfect storm.

So would you agree that at challenges to traditional taxi in medallion-cities include:

- Small taxi companies (single car to maybe 100 cars) rather than large operators (1000 cars or more) that would have the money to evolve when needed

- Expensive medallions causing overhead compared to Uber/Lyft

- Long history of monopoly causing an unfamiliarity with rapid changes

- (Possibly) regulative hurdles to overcome before you could e.g. pre-charge for a ride or dispatch with an app rather than phone?
I'm not sure what you're referring to. If you mean a formal background check, which summarizes your criminal history or your credit history, then candidates are entitled to copies of the specific report the company claims to rely on in taking an adverse action, but nothing else.

If you're referring to private reference checks, of the type that would surface "personal issues people might have with formal colleagues", you're not entitled to anything whatsoever.

If you're a hiring manager in an organization where HR handles background checks, you personally as the hiring manager are entitled to nothing. I would venture further that it's inappropriate for HR to provide criminal/credit background check information to hiring managers.
> they would just be accused of "embracing and extending" the technology

Well, that didn't happen with TypeScript. I think the perception of Microsoft has changed a lot since Nadella took over because they have really worked really hard to avoid the IBM trap.
> The hardest part, I find, is starting.

To me the hardest part is finishing. To start stuff is very easy for me but to actually grind away at something day after day until it is finally done is very hard.
Simply: it took skill to pilot an RC plane or helicopter until the current round of autopilots.

The amount of time you had to expend until you could simply keep the thing in the air without crashing was large. This tended to keep the idiots out of the hobby.

With modern drones, there is no such entry barrier. Any idiot can throw a drone in the air and make it go somewhere.
> ...something the mob would cook up together with crooked politicians...

It's Chicago. The crooked politicians are their own mob. Vice crime may be contracted out to the local gangs, but the rackets are kept strictly in-house.

That way, when you want to buy a senate seat, there's no pesky middleman in the way to jack up prices. You can just go straight to the governor and hand him an envelope of cash under the table.
It is historical. See:

http://mysqlserverteam.com/mysql-8-0-when-to-use-utf8mb3-ove...

http://mysqlserverteam.com/sushi-beer-an-introduction-of-utf... (Problem #1)

(Author is the first link here.)
> You pay by number of requests, not number of messages, so it reduces costs and makes it significantly faster to gulp down messages.

Are there any other technical changes you've made to your application code specifically in response to AWS costs? Any other recommendations when designing a new application?
I agree with your point that terrorists aren't a real concern. I love this essay, Terrorism is not Effective which goes into much more detail on this: https://www.gwern.net/Terrorism%20is%20not%20Effective

However sabotage is a real concern against rival nations. Iran basically lost their nuclear program because of sabotage. In world war 2 the Nazis were constantly set back by sabotage in many different areas. There are probably many more examples we don't know about because this stuff is usually top secret. The victims sometimes don't know it was caused by sabotage or don't make it public because it embarrasses them.
Just take it in again.

MacBookPro13,3 is just a device identifier string, meant to identify the model, not the screen size in inches. So that is probably not wrong. (updated to remove some guesses). Here's where you can look up your model using that string:

http://www.everymac.com/ultimate-mac-lookup/?search_keywords...

You could make a genius bar appointment and paste that imgur link into the notes field of the appointment, and then show it to them again when you get there (since they probably won't have looked at it). Basically just reproduce the problem in front of their eyes. If it's doing this in safe mode, it should have nothing to do with your files.
> In what context would a primary key change, even when sharding?

The only time I've seen that happen is when a DBA evangelized for just using 'natural' keys, which in this case were slugs based on the item name. The problem came when users decided they wanted to rename things and then wondered why the IDs they were seeing in URLs didn't match the new names.

I'm not a believer in natural keys anymore.

> If you need sorting in your table, provide some kind of indexed timestamp.

A v4 UUID contains a timestamp. So it seems a bit wasteful to add the separate timestamp column. Why not just use the timestamp built into the ID? This is what MongoDB's internally-generated IDs do. (Though they're not quite UUIDs.)

There's a catch with v4 UUIDs though: the timestamp portion of the ID is not the most significant digits, so a simple ORDER BY doesn't do what you want.

I like the solution developed by Instagram, which Rob Conery discusses at the link below. It uses a pretty simple plpgsql function to generate a 64 bit integer based on the current time, a shard ID, and a per-shard sequence. This lets you generate 1024 IDs per second per shard. It also puts the timestamp portion of the ID first, so if all the shards' data ends up in Hadoop or something you can order consistently across the whole set.

http://rob.conery.io/2014/05/29/a-better-id-generator-for-po...
>the one near me has poor selections of most basic grocery items with weak produce

Same here - the last time I went they didn't have lettuce.

I haven't been back.
> As far as I know, all Bay Trail devices are running a 32-bit copy of Windows because of this.

Can you not just boot it in BIOS mode? Should be possible for the OS to escalate from there.
> In the US the law is that you MUST fly your drone within 121 meters of buildings, vessels, or the ground.

That's true! Except just the ground, not buildings or vessels. So, not true at all.
I had thought of using multiple SoCs for compartmentalization, instead of VMs. Rather like a hardware version of Qubes. I was very inspired by Tinfoil Chat.[0] Using optoisolators, one could have a secure device with strictly text-only communication with other components.

But it's over my head. I lack knowledge and equipment for measuring RF leakage among SoCs. So it goes. Maybe the Qubes team will do it :)

0) https://github.com/maqp/tfc
I keep hearing this, but I also keep hearing that Lyft and Uber drivers have to go through a background check. Why should I believe that taxi drivers are less likely to be crazy?
Have you never needed to merge datasets, that grew separately, in parallel? It is a royal pain when the rows have consecutive sequential primary IDs. Something has to make way for the other.

IMO, this is one thing Mongo got right: keys, by default, are a timestamp + some random string. This way, they still sort nicely, but don't collide with their cousins in a different instance of the DB.
Maybe drones should require liability insurance coverage. That should create a market forces that encourages safer drone technology.

Disclosure: I work for an insurance company and previously owned a commercial drone business.
Lucid never developed for Lisp Machines.

Lucid's business was Common Lisp for Unix.
Those customers can use emulation to cover their needs. The point of the article is that whatever benefits exist of the 32 bit skew, they are outweighed by its costs.
This seems to match my experience.
Might be worth mentioning about Docker's native support for multi stage builds: https://docs.docker.com/engine/userguide/eng-image/multistag... (still quite a new feature, plenty of people won't have it yet I guess)

Edit: oh, you kind of do. Well, it's not upcoming any more, it's in the latest Docker CE :)
I think there are similar related downsides that could be said about ride-sharing too. If we are giving anecdotal experience then I will say that ride-sharing drivers in Chicago are much more likely to blow through yellow/red lights or park in a cross-walk. The reason is not hard to ascertain: I can easily call 311 on a taxi as a pedestrian with the taxi number.

Personally, I see a lot of people happy killing all of the problems with taxis (particularly in Chicago) but I fear that we are "throwing the baby out with the bathwater". Taxis in Chicago have a ton of problems, but I still have concerns about ride-sharing too.
Imagine though the millions of photos a phone would shoot in a pocket.
> In what context would a primary key change, even when sharding?

If you're using natural keys, and one of them is displayable text, and then the business says "We decided to rename the 8th sales district. Can you change it for us?"

Was this a good design? Maybe not. But legacy happens.

We're dealing with a vendor right now that has references to look-up tables based on display text. They should have used surrogate keys of some kind. Or at the least, code columns so that the database is mostly unaffected when values shown to the users get renamed. (Also useful for I18N work)
We are and continue to be vulnerable. Bruce Schneier used to run a competition about plots until he got too spooked with how vulnerable we are:

https://www.schneier.com/blog/archives/2006/06/movieplot_thr...

We are fortunate that terrorists, by and large, are dumb.

The solution is that you keep trucking along and you ignore terrorists. Many other things in life have a much higher probability of killing you, and you don't fret over them.
Show HN: Varyaml – environment interpolation in yaml configs
Leaked Uber sex memo throws new spotlight on frat-house culture
Question: why did Firefox ask if it was allowed to "take and record video" on this page?!?
Scheme has a really nice way of representing numbers. The socalled numerical tower can be hard to implement for the language implementors, but it is really nice to have as an user.
The British election reveals astonishing changes in the political landscape
True, but you've just shifted the goalpost a little. Instead of brute-forcing a random token I'm now brute-forcing a MAC, or a secret key. You don't really need to use a MAC if you're already implementing rate-limiting and time-based expiry (in addition to use-based). That's just a performance hit. You might as well send a token generated by a good PRNG and skip the integrity checks.

It's unrealistic to brute-force one well designed token in the absence of authentication (if it's long enough you could go without any other security controls, including expiry or rate-limiting, but that's also a performance hit at scale). Adding one with an integrity check is effectively rate-limiting anyway.

Funny story though - I was once on an assessment in which a company used a scheme just like that. The UUID was HMAC'd for a password reset request, and UUIDs could be found by messaging another user. Unfortunately, they used the same secret key for password reset HMACs as the one embedded in their mobile app for HMAC signing requests. Worse still, password resets didn't need to be activated, so you could effectively takeover any account by retrieving the HMAC secret key from the app and running the victim's UUID through it.
What if those customers want to run legacy 16 bit apps in NTVDM? I have a few games I like that I occasionally fire up a 32 bit VM for just for this reason.

If you're using 16-bit Point of Sale software for example you might just decide to stick with 32-bit Windows as the VM wouldn't be worth it and would add more complexity for users.
Some databases will pre-sort a stream of primary keys in order to read a table sequentially.
How do you handle having side projects with your employment contracts?
I'm about to deploy a data mining web app and I've got an interview data engineer. The side project and job will have many crossovers in terms of work and I'm wondering about the implications of IP assignment and conflict of interest. I've mentioned my app in earlier discussions with the company and it stands to reason that it probably helped me get this interview. I'm curious if others have been in the same situation and/or know how I should go about protecting my IP?
Temporarily knocking out power to a local area doesn't really instill terror. Maybe if we called them "nuisancists."
You can still have conflicts though, sometimes more than you think due to the UUID generator used. It's rare but it seems like an edge case that should be handled.

Doesn't invalidate your point about being able to make them offline though. Another option I considered to create PKs offline was a userid/timestamp pair.
Ask HN: License Key API Provider for Desktop Apps
I'm doing some market research to gauge interest for creating a license key API provider for desktop apps. For example, you could have your app make a simple HTTP call to validate / assign license keys which are maintained by the service. The system would have 100% up-time with easy integration and license management.
Houzz raising $400M at $4B valuation
These arguments come up a lot when discussing this topic and there's some points that don't really hold, usually because the apologist either doesn't know the world of sweatshops or doesn't want to bring it up.

The people working in sweatshops start as young children, often sold by their parents to pay debts. Often pay is withheld and they just become slaves or they are fed just enough to keep their fingers moving and their brains starved. The sweatshop may provide enough income for that child to grow up to produce more children, who then become sweatshop workers themselves, child prostitutes, or slaves, or they may just die on the job.

Nutrition deficiencies and stress get baked into their genetics: congratulations you now have a permanent underclass living worse than some animals, and similar to livestock, crowded populations, poor medical administration, and hellish living conditions result in festering and evolving pathogens that you and Paul Krugman may soon be more interested in. The result of providing just enough for them to survive to make children is not "less poverty", it's more poverty, more death, more child slavery or prostitution, and if emotional arguments don't register with you, exotic pandemics coupled with antibiotic misuse just might.

Secondly, America does not have a clothes shortage. The unfathomable amount of (often expensive) clothing thrown away by both consumers and suppliers in disgusting. Shrewd families from the lower income to the middle class buy used or keep hand-me-downs. Once or twice during move out season on campus my partner and I raid the rich dormitories and find upwards of thousands of dollars worth of designer clothing among other things. Many stores throw their out of season clothing straight into the dump.

The defense of a situation where hundreds of millions live in hell to produce mountains of goods that end in landfills, on an economic argument, is absurd.
Isn't this the same thing import.io or kimonify were trying to do some months ago?

Not that they have succeeded in any way, maybe this will.
Man, I really need to move to the U.S.

Canada is becoming hostile to speech and the family with M-103, C-16, and Ontario Bill 89. Britain had to choose between a man who doesn't understand the nuclear deterrent and who would screw them in their biggest negotiation for decades, who would probably end up controlling the internet for antisemitic causes rather than ostensibly counter-terrorism causes; and a lady who doesn't understand any of the technical implications of the whoops-tyrannical policies she presents (in the middle of a campaign no less, are they all daft?). And because the UK Tories didn't do the smart thing and hang on to their popular moment for dear life to secure a supermajority, there's a hung parliament, which is only slightly better than the probably-antisemitic national socialist labour party getting a majority.

Prime minister doesn't even pretend to be meritocratic, denigrates his cabinet by saying that they were picked for their gender. The Social Justice Tribunals (actual name of the institution, not hyperbolic slur) are out of control. At least the U.S. has a real constitution, which at least purports to protect freedom of speech, the right to petition, and the right of the people to keep and bear arms.

Britain and Canada are sinking into the earth's core under smiling faces, and DJT is somehow making America better despite being a rough buffoon. Every day is opposite day.
Thanks - will update that link now that it's out.
By your logic, absolutely any sort of traffic violation should be good for at least 5 years in prison. You're being ridiculous.
I mixed up uuid versions above. v1 are the timestamp ones, and v4 purely random.
What is the bug? I'm curious.
It seems you're guilty of the same cognitive biases. "Screw those finance guys! Rosencrantz and Guildenstern over Oskar Morgenstern!"

Edit: On my first job interview out of college I was turned down by the head of engineering because I didn't have enough experience in C++. "Silly college kid can't do shit." I was called back and offered a job because another manager was impressed by my work at the speech recognition lab at my school. Three months into my employment they filed a patent on an algorithm I devised to build databases that were searchable through speech interfaces. The engineering head ate crow.

Hiring developers is a crap shoot, but it's hard nowadays to hire a truly incompetent developer. I've really only encountered one in my lifetime who was incapable of basic development tasks.

In the 15 years I've been a working engineer (and 25 in general programming), I've noticed the level of knowledge and skill required to build usable products has been greatly reduced. Why? Because there's been 15 years of advancement by seasoned engineers, prompted by business people, to build tools and frameworks that fit large swaths of business needs.

That cycle is ever present in tech. The obscure things become clearer and more accessible to laymen through the efforts of the experts. And you can bet those experts have deeply studied CS topics, whether at a college or on their own.
The ultimate problem with natural keys is that their uniqueness is a property of business rules. Unless you live in some magical fairytale land where business rules are stable, sensible, or both, depending on them for uniqueness is asking to have problems.
I think there is a legitimate question about how long the status quo can keep being propped up though.

It is interesting how angry people get about the bank bailouts though, as if it was narrowly targeted at the owners of the banks and not targeted at preserving the entire economy.
Closest alternative to RStudio (on principle, if not in practice): http://rodeo.yhat.com
Apologies, I did not mean to minimize it to the point of not being a concern at all. I do think these are concerns, but it isn't like they are being completely ignored. Rather, it turns out these are very hard problems.
They will fix it, you just need to do all the troubleshooting. Set it up without restoring your backup to show that it isn't your files or software.

Service Warranty. For all service orders, Apple warrants that (1) services performed will conform to their description for ninety (90) days from the date of service, (2) except for batteries described in the subsection below, all parts or products used in service will be free from defects in materials and workmanship for ninety (90) days from the date of service, and (3) batteries installed as part of Apple’s battery replacement service for Apple portable Mac computers will be free from defects in materials and workmanship for one year from the date of service. This warranty is an express limited warranty. If non-conforming service is provided or a defect arises in a replacement part or product during the applicable warranty period, Apple will at its option, either (a) re-perform services to conform to their description (b) repair or replace the part or product, using parts or products that are new or equivalent to new in performance and reliability, or (c) refund the sums paid to Apple for service.
You can fly a plane into a restricted airspace and get off without criminal charges.

About once every two weeks, somebody seriously violates restricted airspace in the US, and it leads to a close encounter with an F-16, F-15, or one of Homeland Security's helicopters. They will be forced to land. So far, the USAF hasn't had to shoot down anybody, but general aviation pilots who've been intercepted report it is a scary experience. Once they're on the ground, they will be detained and interrogated by law enforcement.

Once it's established that they're not a terrorist, the FAA takes over. There's usually a check ride with an FAA examiner before they get to fly again. A $10,000 fine is normal. A suspension or revocation of the pilot's license is possible. For a second violation, likely.

Current enforcement policy, from AOPA: [1]

[1] https://www.aopa.org/news-and-media/all-news/2014/december/p...
Thanks for the correction, you are of course right.
1) Improper list, or a cons cell. Quote and dotted pair notation are pretty common "in the wild".

http://download.plt-scheme.org/doc/html/guide/Pairs__Lists__...

2) Yup, complex number.

3) Another improper list.

4) Imaginary number in polar coordinate notation

5) # at the end of a numbers are to express inexactness, and are equivalent to a zero digit, so that express is 100.

6) The first one in that list (#i+1) is actually just 1.0, no imaginary part. The #i notation is for inexact numbers. The other two are the complex numbers i and 1+i.

http://www.delorie.com/gnu/docs/guile/r5rs_54.html

7) Yes, an exact complex number. Interestingly enough, Dr. Racket in R5RS mode accepts that just fine, but Guile doesn't seem to like it.

8,9) Yes.

For the full syntax of scheme see:

http://www.scheme.com/tspl2d/grammar.html
Maybe they would rather use another exchange like Kraken or poloniex in order to also trade pairs like BTC/XRP or BTC/VTC.
Sup also works well

https://github.com/pressly/sup