skysight-inc/HackerNews huggingface dataset:
If your really serious about enhancing your SQL skills the following should take you from beginner to expert with time. Udemy and other online resources are nice but they will not take you to your maximum potential, only the books and official documentation will as that is where the experts get there information. The videos and tutorials are good for overviews and helping with certain scenarios but not the best resources if you want a professional high end learning path to the top.

If you want working with SQL to become extremely easy to you, you will need to start creating websites, bring traffic to those sites and implement the scaling procedures you have learned from the books below.

As if you go to a job interview and want to blow it out of the water it is to your best advantage to know for example MySQL in and out so well you make the interviewer smile inside and go yes we have found the one. You will probably see a little smirk as the interviewer is trying to hold in their smile when this happens but you will know when this occurs very easily. Upside to this is you will be very comfortable getting started on day one and the only training you will need is the current architecture and backup or non existent backup plans in place so you can get to work.

I recommend the following hardcopy books in order:

MySQL:
http://www.amazon.com/MySQL-Developers-Library-Paul-DuBois-e...

www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/

http://www.amazon.com/MySQL-High-Availability-Building-Cente...

If your wanting to do Microsoft SQL Server, I recommend the following:
http://www.amazon.com/Microsoft-Server-2012-Step-Developer/d...

http://www.amazon.com/Training-70-461-Querying-Microsoft-Ser...

http://www.amazon.com/Training-70-462-Administering-Microsof...
I think they're being down-voted by listing some opinions and finishing with 'these are facts'.

Maybe networked door locks are a poor idea, maybe they're not. There's nowhere near enough of them in use right now for consumer risk to be assessed and determining 'facts' is a long way off. That kind of arrogance is obnoxious and should be down-voted. It doesn't add to the discussion, it doesn't add to anyone's understanding of the risks involved, it just acts to shut down conversation and is negative and damaging to the community.

Looking at similar advances in car locking technology - where 'keyless entry' or 'keyless go' is a common high-end car feature, suggests that it might actually be possible to have this balance of convenience and security.
So Europeans have better credit cards than us because they have less regulations? And New Zealanders have easy peer to peer transfers because of what less regulations?

And all of this could be more easily done by getting rid of banks except for a single federal bank.
I don't think the EFF has adequately answered the concerns raised by Marcy Wheeler about the risks and weaknesses of this bill: https://www.emptywheel.net/2014/11/12/why-i-dont-support-usa...
It's easy to see that they may need this service. I'm wondering more why the rest of us proles need to be told about it. Sorry to go off ToS a bit but the concept is grating.

More on the subject, this relates to the common discussion on benefits of scheduled vs. free time for kids. Many lament how the up and coming generation has no free time to be creative etc. Any parents with older kids care to chime in how things turned out? Having a two year old, I have a vested interest :-)

On one hand I can see the overscheduled approach being kind of soulless, maybe lead to loss of creativity etc. But on the other hand, it's not the 50's any more, and it seems like it's not practical to leave kids alone these days. There is also a bit of a network effect at play; if all the neighborhood kids are off learning piano / playing soccer, leaving your kid home alone is no use if the neighborhood is deserted and there aren't any others to play with.
Here is the full text (PDF):
http://cl.ly/YZzg/download/J%20Psychopharmacol-2014-Gasser-0...
The BSD equivalent is Bhyve[1] which was only added to a release version of BSD this year. There is also very little in the way of tooling to make this easy to use.

FreeBSD is available as an EC2 AMI.

For what it's worth, Nearly Free Speech[2] offers jailed hosting on FreeBSD and has recently improved their ability to handle persistent processes.

[1]: https://wiki.freebsd.org/bhyve
[2]: https://www.nearlyfreespeech.net
Such a big deal over trivial things - Just change the name if you want to, it becomes a big deal because they made it seem like a big deal by long winded comments. Its a library name change, not freeing of the slaves.
Shipster and Shyp cure your shipping headaches for $5
I've long been a huge fan up bup, and have even contributed some code. I might be by far their single biggest user, since I host 96748 bup repositories at https://cloud.sagemath.com, where the snapshots for all user projects are made using bup (and mounted using bup-fuse).

Elsewhere in this discussion people not some shortcomings of bup, namely not having its own encryption and not having the ability to delete old backups. For my applications, lack of encryption isn't an issue, since I make the backups locally on a full-disk encrypted device and transmit them for longterm storage (to another full disk encrypted device) only with ssh. The lack of being able to easily delete old backups is also not an issue since (1) I don't want to delete them (I want a complete history), and (2) the approach to deduplication and compression in bup makes it extremely efficient space wise, and it doesn't get (noticeably) slower as the number of commits gets large; this is in contrast to ZFS, where performance can degrade dramatically if you make a large number of snapshots, or other much less space efficient approaches where you have to regularly delete backups or you run out of space.

In this discussion people also discuss ZFS and deduplication. With SageMathCloud, the filesystem all user projects use is a de-duplicated ZFS-on-Linux filesystem (most on an SSD), with lz4 compression and rolling snapshots (using zfssnap). This configuration works well in practice, since projects have limited quota so there's only a few hundred gigabytes of data (so far less than even 1TB), but the machines have quite a lot of RAM (50+GB) since they are configured for lots of mathematics computation, running IPython notebooks, etc.
If you're looking to use Node specifically for web development, I've found http://scotch.io to be quite useful.
I found this link and I think it's super cool how cold it is!
5 upvotes in 1 minute?

Please don't invoke a voting ring.
If your justification for creating a new language is "I made snake in a bunch of different languages!", I am extremely skeptical.

And, as is often the case, it is impossible to have a universally beneficial compromise in programming language features. There are some things you simply cannot have if you don't lean strongly one way or the other, and you end up with a mediocre in-between with none of the benefits of either extreme. Case in point: type systems and the ability to compile to tight native machine code. In a dynamically typed/untyped language, you need to have multiple layers of indirection.
Is there anything out there that does continuous incremental backups to a remote location (like obnam, attic, ...) but allows "append only" access. That is, you are only allowed to add to the backup, and the network protocol inherently does not allow past history to be deleted or modified? Pruning old backups might be allowed, but only using credentials that are reserved for special use.

Obnam, attic and similar use a normal read/write disk area, without any server side processing, so presumably an errant/malicious user is free to delete the entire backup?
> You drop a key in water and it's okay.

Exactly like an RFID token.
I wonder how they picked the term "concierge". It brings to mind a functionary at an upscale hotel, a gentleman of a certain age, dispensing discerning advice about the local bars and call girls.

It sounds a bit off for a service designed for kids.
Does anyone else on here have any recommendations on where to learn more about this stuff? I'd really like to learn more.
What does "unbiased" mean in the context of a group that has a stated advocacy purpose?

Why would we expect or want anything else?

You're free to act or not upon the EFF's urging - but at least they're honest about their goals.
Frederic Brown, The Weapon

http://writenowisgood.wordpress.com/the-weapon-questions/
another http://www.motorola.com/us/accessories-bluetooth-headsets/Mo...
This is some great progress!

But I should say that there is still too much overhead in using STM; you will still be able to very easily (and by a large margin) outperform STM-4 by running 4 instances of Tornado with HAProxy or some other lightweight router ontop. A comparison graph for this should have been the benchmark.
YBSD (their FreeBSD fork) is still prevalent if the conversations by the Yahooligans on the FreeBSD team are anything to judge it by
> There is not an effective limit to the damage that can be done, but there are limits to liability.

What does it have to do with Free Market?? This has to do with regulation more than anything else.
Well, except that I'm pretty sure it's very difficult, very suspicious, and possibly illegal for a random person to own a school bus, but anyone with enough money can own a Mercedes.
A client who tries to control your time of availability or location (requiring on-site, for example) may (may) be committing a 1099 violation.
If anyone is looking for mid-price dumb earplugs, I read this article today.

https://illmethodology.com/2014/11/tried-earplugs-amazon/

TLDR: A working DJ tried all the mid-price dumb earplugs on Amazon, and recommends EARASERS.
Prolog is neat. There is probably a Prolog embedded in some of the C++ type checkers. The problem is that the world at large is often in a flux and can't be conveniently described in terms of static relationships, which makes Prolog programming at large challenging to do (or you augment Prolog with features that make it more or less imperative).
Note that KVM has no trouble hosting FreeBSD as a guest OS.

You can also vote on this suggestion on the DigitalOcean website: https://digitalocean.uservoice.com/forums/136585-digitalocea...

I've had a lot of luck getting bleeding edge Arch linux kernels running on DigitalOcean using kexec to essentially turn the kernel DO gives you into a bootloader. It should theoretically be possible to get FreeBSD running in a similar manner, but it would obviously not be officially supported.

If you're looking for other hosting providers, EC2 does have FreeBSD images available.
And yet another widget that needs to be charged...

What happens when I forget charging?

Will I miss my alarm in the morning or will it wake me up with a low battery alarm in the middle of the night?
Okay, judgmental 20- and 30-somethings, 40-year-old here with 2 kids. My wife and I both work full time; doing so allows us to do things like go on vacations with our kids, live in an expensive city, and pay tuition. If our kids are going to have afternoon activities even occasionally during the week, we have two choices - shift to part-time employment, or arrange for transportation.
I find it ironic, given the number of 'live your dream' and 'go for it' startup posts on HN (oh, the humanity!), that the assumption is that working parents should just pack it in to provide high-quality transportation for our youngsters. It smacks of hypocrisy.
And, for what it's worth, kids who live in the city can't exactly go play in the creek and ride their bikes. I wish they could, but they can't. It's not 20 or 30 years ago.
Well this is what I mean. You say expensive; I say damn cheap :
https://www.kickstarter.com/projects/192833321/pebblebee-the...

This is why you need to open up the API in whatever form you can. Developers are going to want to use your tool in ways you aren't thinking of.
Pay Phones in NYC Will Become Free Wi-Fi Hot Spots
Was the keynote posted online?
Partial Application with Substitution
OK, after a decade extremely cold and in a vacuum.
UNR professor thinks GPS may be key to dark matter detection
>production box only contains data from the last 3 days, but the backup contains data from the last 12 months

Even if the source can only perform new backups, it's a timing attack with a deduplicating system. The attacker can attempt to back up chosen data to infer properties of the existing backups.

You can remove this only by removing deduplication (or by crippling deduplication to work only at the server-side, and incur wasteful network requests)
YOU MUST CONSTRUCT ADDITIONAL PYLONS!
If I'm not mistaken, this is EFF's latest analysis of the bill, as well as their justification for supporting:

https://www.eff.org/deeplinks/2014/08/understanding-new-usa-...

The bill isn't perfect, but it'll mean that the government collects less information on innocent people, there'll be greater transparency, and an advocate for citizen privacy in the FISA court. Beyond that, it's the most likely vehicle for NSA reform. We're unlikely to see anything stronger if this doesn't pass. And it seems like a better bet than trying to push for Section 215 to sunset next year.
I have a crawler downloading 160 million websites a day, almost all in Haskell. It is a much more practical language than the alternatives.
So true. I thought Spider Programming was the current best language ever, but apparently that is so 9 hours ago...
Uber Executive Suggests Digging Up Dirt on Journalists
Show HN: Stealth Key , Type without looking at phone
Type on iPhone without looking using simple three-finger sequences. Send SMS or save notes without looking down at your phone.
Any feedback is much appreciated!

Link:
https://itunes.apple.com/us/app/stealth-key/id936518615?ls=1&mt=8

Promo Codes: http://codehookup.com/57dc0492
Show HN: Handy web-based coding – Write and run Hello World in 10s
Tarsnap.

You can create a key that has write only access for your automated backups and a different key that has full access for administrative purposes.

That is what we do anyway.
Personalized Recommendations at Etsy
Really? The state apologized for approving an injection well when then shouldn't have. Where do you see any culpability on the part of the company?
Debug a running Python process without printf
Another group of folks who pay for the 1% cash back are the merchants who pay fees well over 1% for transaction processing. http://www.cardfellow.com/blog/credit-card-processing-fees/
Just went out: http://arxiv.org/abs/1411.4555
I was also lost at functor...
Fewer kids are dying now the than they did back then, so I feel saying "Generations of kids grew up that way and they all turned out fine" is misleading.

http://www.hrsa.gov/healthit/images/mchb_child_mortality_pub...
Are you in oilfield service delivery or Baker's product development/support side? If the former, your skills will be trivially transportable to Halliburton and the industry generally. If the latter, Baker still have a lot of cool stuff that I imagine Halliburton would keep running for quite a few years yet - just look at all the other acquisitions made in the industry, Eg. when Schlumberger bought Pathfinder, they have kept the Pathfinder business running for years even though it directly competed with their own (admittedly they seemed to pivot Pathfinder at the budget end of things, at least in Australia - but still).
John Muir's Mechanical Desk (2011)
Show HN: FREE pedometer pet game for iPhone 5S, celebrating Thanksgiving!
Write email to marcos@dediced.com to get promotional codes
>In my opinion, learning Haskell makes you a better programmer.

No, it makes you a more dissatisfied programmer.

Dissatisfied with how poor the tools in other ecosystems are.

You can't take Haskell with you. Erik Meijer is wrong about this. You can't use monads productively in Python. You can try, but it doesn't work well.

You need Haskell. Laziness, FP, immutability, types, the whole shebang. It all hangs together in a well designed way. Not even Scala can do FP well.

https://twitter.com/bitemyapp/status/534498324296921088

https://twitter.com/bitemyapp/status/534498480430284801

https://twitter.com/bitemyapp/status/534498423870066688

https://twitter.com/bitemyapp/status/534498512398864384

https://twitter.com/bitemyapp/status/534500037901176832

To quote mwotton:

"here is a lightsaber, an elegant and powerful weapon. After you practice with this, you will be much better at stick-poking." is absurd.

More powerful abstractions tend to invalidate more and more combinations of terms. This means the space in which your program will be correct gets narrower and narrower.

The good news is, it means your abstractions will more precisely represent the correct program you want.

The bad news is, you'll want help from the computer and a well-designed language.

I have a video of my Haskell workflow here: https://www.youtube.com/watch?v=Li6oaO8x2VY

It's worth considering in this context what Haskellers mean when they talk about "type tetris".
All commits are also not equal, just like not all LOC is equal. Very often I see folks with a lot of commit on github, when I look at the diff, it's 2 lines, 1 line. I'm the kind of person that will probably write 20 lines before I commit. I think companies are more likely to have done something bigger, tested it, used it for a while then committed, but individual developer could just commit on a line or two for say bug fixes. This is not to make an excuse for commercial entities, I still think they can do much more in helping projects, but if too much money flows into open source, it just will end up corrupting the community.
It wouldn't be a bad idea to use both. It could be nice to study a monolithic kernel-based OS (xv6) and a microkernel-based OS (MINIX).
In 6.828, we read xv6, and we implemented parts of JOS, which is exokernel-based. Since exokernels are kind of like microkernels on steroids, I suppose it makes sense that we didn't focus on normal microkernels too much.
I guess it depends on what you consider normal. I could easily see myself enrolling my kids in, say, martial arts (3 sessions per week), music (1), and swimming lessons (1). That's less than one activity per day, making it very reasonable by my standards.

If there are no overlaps in times and nothing is within walking distance and the local buses aren't an option, that would be 5 trips per kid per week, so 10 or 15. I'd be looking to organize some sort of car pools with the other parents, at a minimum.
Inexpensive prototyping tools to quickly test your idea
http://www.pg-versus-ms.com/
I disagree this doesn't fit, this is a collection of things and many of them you can play with.
1/3 of a year's salary (headhunter fee) is rarely justified by just sorting through resumes. The headhunter has to provide one of the following:

1) Confidentiality in the search

2) Access to people not currently looking

3) Access to candidates that are perfectly suited for the job

4) Strategic advice

For better or worse, most are only capable of #1. The ones that can do #3 and #4 are worth their weight in gold.
Note that this recommendation is for DJ purposes, not maximum sound attenuation for sleep.
The Oberon/Modula-2 family happens to be among my favorite languages. It's one of the easier languages to implement and Amazon happens to have cheap Modula-2 compiler books. Wirth's own Compiler Construction book is free, though it's the definition of terse. I rather liked Julian R. Ullmann's Compiling in Modula-2 and John Elder's Compiler Construction.

There's still interesting work that is out there to rediscover involving the family. Luca Cardelli wrote a rather good paper on typechecking in Modula-2[1]. More recently there's projects like Modula-2 R10[2] in the works, which could prove to be a rather fun language to work with.

I thought University of Cambridge's track for teaching Standard ML to C via Modula-3[3] was a fantastic idea.
(I also have a lot of love for SML.) By learning types and modules via SML or Modula first, it will ease understanding more advanced C concepts. C's weaker typing and implicit conversions make the value of types less clear and easier to ignore. I feel that C's headers and abstract data type construction are clunkier than they have to be and also devalue the idea of modules.

I would love to see renewed interest in Modula-2 in particular. The death of the commercial compiler industry has neglected it. It eschews garbage collection and I think it resembles a fixed C. For roughly ten years General Motors used it for embedded work.

Another excellent resource: http://oberon07.com/

[1]: http://lucacardelli.name/Papers/BasicTypechecking.pdf
[2]: https://bitbucket.org/trijezdci/m2r10/src
[3]: http://www.cl.cam.ac.uk/~pr10/publications/plc93.pdf
Multitasking is the most efficient way to half ass everything
I still don't know what you're talking about. What laws? What company? Gore hasn't held public office since 2001. As far as I can tell, his green power/carbon credit ownership/investment didn't start until Generation Investment Management in 2004.

And Apple seems to have done this voluntarily, and not because of some legal requirement.

Hypocrisy isn't corruption. I'm plenty fine to say that he's a hypocrite. Could you explain the corruption?
Finding Android SSL Vulnerabilities with CERT Tapioca
MICA – Intel Smart Bracelet
Do you have some sort of evidence for that observation?
> I'm sure you can probably find the source as well (though it's not officially provided like xv6).

Listed on some course webpage was this:

http://pdos.csail.mit.edu/6.828/2014-jos.git
If you follow it through, even though sales have dropped 3% year over year, 8.9 billion cases were sold. Each case is 192 liquid ounces. Divided by 365, divided by 316.1 million, that's still 14.8 liquid ounces per person per day - on average, about 0.8 gallons of soda per person per week. I wasn't too far off ;)
Netflix does contribute, in addition to money paid to the foundation, they also have quite a few developers working on FreeBSD almost full time. You can see lots of commits with 'Sponsored by: Netflix'. nginx and Yandex also do a lot of commits.

http://freshbsd.org/search?q=netflix
Since no one in HN has called you out, let me do so. You sir, are a liar. 150k LOC? GTFOH! Seriously, how many did you throw out? BS! Being that you are on HN, you definitely have free time, what's your github?
FYI, DMT production in the human brain is not supported by any scientific studies. There were studies that found negligible amounts in rat brains, but those have not been successfully duplicated. So it's possible that it's there, but it's commonly stated as a fact when in reality, we just don't know.
That could be said of Microsoft in the server business as well, but Linux still managed to gain a big share. It's possible for a RedHat model to develop in networking - sell services and support, but not hardware. See Cumulus for example. (Disclaimer: I work for a Cisco competitor, but not Cumulus).
Intel Introduces Smart Bracelet
Only hope cover by me
> By pulling backups, you're giving the backup box full control over your computer

Not really. On my production boxes, I usually set up a "backup" account and give it read-only access to paths that need to be backed up. Nothing fancy, just standard POSIX filesystem permissions. The backup box uses this account to ssh in, so it can only read what it needs to read, and it can never write anything to the production box. I wouldn't call that "full control".

> Desktop pushes to site A; then site B pulls from site A.

What you described is similar to my own two-tier configuration, except I pull first and then push to untrusted storage like S3 (using encryption, of course). The first step uses rsync over ssh. The second step is just tar/gzip/gpg at the moment, but if I want deduplication I can easily switch to something like tarsnap.
From a bystander point of view this looks amazing!

Do you have a comment on the diversity of approaches across the papers? (did everyone take more or less the same path to do the task?)