skysight-inc/HackerNews huggingface dataset:
SQL is SQL is SQL. I have no problems jumping between different flavours of SQL, however what defines my use of them in my own projects is the toolsets I have for managing and maintaining databases.

Over the years, I have built up a collection of tools, drivers and utilities that just makes working with MySQL an absolute breeze across Windows and OS X. There are times that I want to use ODBC to dump a MySQL table or view into Excel/Access for a client, or copy data from a production system to a test system, or set up replication or do some performance reporting, and I like that I have tools set up which can do these things for me at literally the push of a button.

Sure I still use the CLI for MySQL a lot of the time, but nowadays, 75% of my time is spent in GUI tools of one sort or another.

If someone can give me an equivalent suite of these sorts of tools for Postgres that can let me be productive in short order, then I don't much care if the SELECT statement of one system is several milliseconds faster than the other. I don't deal with such huge volumes or mission criticality. I just want ease of management/maintenance.
> STM32F103T8U6 (ARM Cortex M3, clock frequency 72 MHz)

That's one powerful chip for a soldering iron.
This is really about database semantics. If you think database semantics matter, you'll almost certainly prefer postgres.

A lot of people simply don't care about database semantics though. Possible reasons:

* They are more interested in a particular application (e.g. wordpress), and use whatever default database it seems to prefer.

* They are more interested in a particular framework/library (e.g. django), and use whatever database it seems to prefer.

* They don't see any reason a database should have interesting semantics, because it's just a place to stash data until you need it again.

* They really care about programming languages, but see SQL as a second-class citizen that looks archaic and is really just an obstacle to work around using cool language features.

I believe database semantics do matter. It's hard to make a single argument that will convince everyone, but here are a couple things to consider:

* SQL catches errors that may be impractical to catch even with haskell. For instance: you could have had a bug in the application three versions ago that lead to an inconsistent database state (e.g. a duplicated item ID), and you are just finding the bug now. SQL to the rescue: if the unique constraint exists, then you are fine, and the error would have been raised three versions ago before it ever got in the database.

* Few languages have anything that comes close to ROLLBACK. Erlang kind of does, in the sense that it's a mostly-functional language and a process crash mostly resets you to a good state. But the guarantees of ROLLBACK are much stronger and clearer. I believe this is actually why erlang never really took off widely -- a PHP script hitting the database is a better version of the same concept: the PHP code can crash, and that will cause a lost connection and a ROLLBACK in the database, getting you back to a known-good state and the other requests just continue working (security and other PHP jokes aside).

Rambling a bit, but I believe postgres really is the leader when it comes to database semantics, and I believe that is one of its most important contributions.
I am, personally. It's just the quickest way for me to manipulate images. I don't have Photoshop installed, and macOS' Preview only gets you so far.
i am working on a labor platform to help educate labor as well as provide, and develop, tools to assist labor in understanding and asserting their rights

http://www.alaborplatform.com
To be fair, then, they should just get rid of that word salad paragraph and only show the videos and descriptions of the tools.
A unified approach to solving seven programming problems (functional pearl)
When I say profitable, I'm assuming someone factored in antitrust risk (an all-time low given our current policies here in the US, mind you), as well as the lost customer satisfaction, possibly revenue from users of those other browsers, etc. weighed across the cost of man-hours to support other browsers. Obviously, Google supports iOS quite well, because that platform brings with it a massive amount of users, and hence a massive amount of money.

And FWIW, I recognize that the engineers are usually not the same as the businesspeople who make the business decisions. :)
Yes, yes yes. Thank you for this defense of one of my favorite meditation-as-novels.

In a similar tone, I actually love the Tartovsky film. A very weird piece of work, and a hell of a thing to experience a few weeks before a summer spent in Russia...
Windows Experiences Substantial Market Share Drop as Linux Posts Record Growth
Pricing Psychology: 7 Clever Tweaks to Make Customers Buy Again – Post Funnel
What it took to keep a TX grocery chain running in the chaos of Hurricane Harvey
Just for the record, the parent comment comes from a Google employee.
Could you clarify? How is it not a useful distinction - they pretty clearly outlined the differences.
IMO, it's the psychological mind-games that fb uses to draw you in, and deters people from using it "just a little bit", that makes it so toxic.

the general concept of social networking does deserve a chance if it can be separated from gaming / preying on our psychological weaknesses.
List of Top Reviewed Door Mats for Dogs
HotSpot is a JIT engine separated in parts C1,C2. This is part of the OpenJDK codebase and part of OracleJDK, Zulu and RedHat's shipping OpenJDK version. The C2 hotspot layer might be removed in favour of graal[1] in the mainline over next years, but that is open too.

IBM has their own in J9 JIT infra which is also (being made) open source. [2]

Most shops use OracleJDK which is more habbit than anything else as the other OpenJDK derived versions such as Azul Zulu or the ones in RedHat cent-os are very much from the same branch and also pass the TCK.

[1] https://github.com/graalvm/graal
[2] https://archive.fosdem.org/2017/schedule/event/openj9/
Judism also doesn't consider fish meat for the purposes of Kosher-ness.
I wonder if functional programming might be something to implement with a "flock" of unikernels? I'm not even sure what I mean, but it seems like decomposing into unikernels might allow entirely new architectures. (Perhaps analogous to a VM allowing better use of hardware resources, unikernels might allow complete abstraction away from, and across, hardware??)
Ask HN: What are key indicators of on the job success in a candidate's interview?
The SD Cars Gold Rush Winner
Show HN: I Extracted the FCC “Restoring Internet Freedom” Comments into BigQuery
Nobody mentioned patents yet, so: Go full patent-troll on users of OpenJDK. This would also sink the Java ship because nobody would dare depend on the graces of Oracle and their Java support anymore.

Oracle's Java patent grant doesn't seem very broad on the face of it, since it only grants patents that are "essential" and only those for implementing the "Java language specification".

"essential" would seem to exclude implementation technology like HotSpot/JIT technology, and
"JLS-only" would seem to exclude a lot of the defacto Java platform that real world apps depend on.

So what's left is the GPLv2 implied patent grant, which more of a legal theory and is untested.
You're confusing "the American left" with the Democratic Party. The US left exists, it's just terribly unorganized and has little political power. Their opposition has simply done a better job of marginalizing them compared to left movements in other countries.
I've worked for companies in the journalism space. Calling up legal to see if we had an NDA with a company before reporting on them was not exactly a part of the routine for the reporters. If this reporter had no reason to suspect NDA -- and the way in which press inquiries were responded to certainly wouldn't give that impression -- then it's not on the reporter.
> am I prepared to sacrifice some configuration options in return for being able to get quickly setup?

The best part about create-react-app is the `eject` option. So you never have to ask that question. You can just get going with the defaults, then 'eject' your config files to tweak once you uncover your specific needs.

I am convinced this 'no lock-in' approach is the way to go for scaffolding builders and frameworks in general.
If we have a program, e.g. a custom text-filter, that can strip html tags and other markup (formatting) from original text (content), then why do we need a browser?

The very early ideology of HTML was to describe structure and content fairly minimally so that browsers could display it in whatever manner was right for the user.

But it turned out that content producers had more influence with browser makers than did content users (who after all don't pay anyone but the ISP). And they want to have control over the user's screen, speaker and (ultimately) brain. Hence pixel-perfect formatting, advanced CSS and of course JavaScript.

But that has sort-of changed for Mozilla. Their competitors have all the close relationships with content producers, so they are trying to become friends with users again. And thus their incentives have shifted to trying to recover the original virtues of the web out of the current set of technologies.

It's a tricky thing to do, and I wish them luck.
You're wrong, and Apple made a mistake: https://arstechnica.com/gadgets/2016/06/zfs-the-other-new-ap...

From the article: "Finally, and perhaps most significantly, personal egos and NIH (not invented here) syndrome certainly played a part. I'm told by folks who worked at Apple at the time that certain leads and managers preferred to build their own stuff rather than adopting external technology, even technology that was best of breed. They pitched their own project, an Apple project that would bring modern filesystem technologies to Mac OS X. The design center for ZFS was servers, not laptops—and certainly not phones, tablets, and watches—and the argument was likely that it would be better to start from scratch than adapt ZFS. Combined with the uncertainty above and, I'm told, no shortage of political savvy, the anti-ZFS arguments carried the day. Licensing FUD was thrown into the mix; even today folks at Apple see the ZFS license as nefarious and toxic in some way, whereas the DTrace license works just fine for them. Note that both use the same license with the same grants and same restrictions."

It's still not too late for Linux to merge ZFS:
https://youtu.be/6F9bscdqRpo?t=5m14s
I got mine from Audible at the link below. If you do use it, please SKIP THE INTRODUCTION. If you haven't read or listened to the book before, it gives away some major plot points as part of the author's update.

https://www.audible.com/pd/Bios-Memoirs/Zen-and-the-Art-of-M...
Yep. I don't disagree with either of you. I was really responding to the comment that your comments should form a kind of running commentary of the code (something which I completely bought into when I was younger, but then moved away from). There are certain things you can't express with code. I don't want to suggest that you stubbornly refuse to express it at all in those cases :-). It's just that it's a technique of last resort, not a technique of first resort (if that makes any sense).
require fast boot time

Why? Aren't they either usually on, or at most sleeping?

EDIT: no → on
I bet the vast majority of these linux users are using laptops which came with windows installed though
Countering the State Sponsored Conspiracy to Destroy Pedro Hernandez (pt. 3)
Jason Roberts has been doing an awesome job rolling out a high level math program in the Pasadena school district. 6th, 7th, 8th graders learning Calculus. They even have an anual competition at CalTech called Solve.

Info and video of kids in action here:

https://www.mathacademy.us/solve/

Direct link to video:

https://vimeo.com/224720563
Not all non-required consumption is about status.

Some people just like things.

I cycle, and I like Rapha Brevette jerseys. Yes they are expensive, but I like the way they fit and some specific features. I know I could get 99% of the functionality for 40% of the price.
Wow, after reading the comments here, it strikes me how Google can do no evil in a lot of people's minds.
Laravel 5 Implementing Scheduled Themes
When asked about coverage for a constituent's son who works in retail, Rep. Warren Davidson responded

“OK, I don’t know anything about your son, but as you described him, his skills are focused in an industry that doesn’t have the kind of options that you want him to have for health care. So, I don’t believe that these taxpayers here are entitled to give that to him. I believe he’s got the opportunity to go earn those health benefits,”
This is a good idea. One thing you might try is also to do the same thing with unit tests. Can someone discover the intent of the code from the tests? I have found this considerably trickier to do than it seems because there is a tendency to introduce a lot of noise with the tests in order to get good coverage. I personally found it illuminating to refactor the code and tests so that I get the same kind of coverage without the noise.
Back in the .com days they also had Perl.

Is also a way to extend the SQL languages, and to bring existing code into the server side.
For what it's worth, I somewhat hesitantly bought one of these soldering irons a few months ago off Ali Express. After having used it a lot since then I can now highly recommend it as a fantastic bit of kit - I've almost become emotionally attached to the thing! It heats up quickly, holds a consistent temperature, solders very well, plus has lots of features and configuration options. For example it can be set to cool down to different temperatures depending on how long it had been stationary (thanks to its build in accelerometer). The open source firmware is the icing on the cake.
Not as much as before, because the cost of cable to hold down the turbine is the only thing that gets more expensive with deeper water (the part connecting the floater to the "bolt"). These cables are relatively cheap.

The other option's jackets or monopiles (95% of the market) require almost a 500 kg of steel extra per meter (very rough guideline). This means that at depths more than 25meter the monopile/jacket is more expensive than the wind turbine on top. With the hywind style floaters, this is not the case.
1) In the alternate reality where you did invest in AirBnb and Uber, how did you manage to concentrate your investments in those two companies, and reject thousands of contenders who eventually folded down? If you also invested in 10,000 photo-sharing apps and "Yo" clones, what are the total portfolio returns?

2) In that alternate reality, what advantage did your money have over YC, Andreessen Horowitz or Benchmark money? Were you able to connect founders to top government decision makers, or bulk up their growing management team with hard-to-get candidates? If the answer is "yes", you could've been awarded advisory shares in Uber and AirBnb without being a qualified investor (a gift is a gift, after all). But since more likely the answer is "no, my money is no different than money from a joe schmoe down the street", you will likely be required to overpay for a ridiculous valuation at seed stage. What effect would that have on your portfolio as a whole?
coupled with http://www.ign.com/articles/2015/04/30/why-youll-never-beat-...
I'm a co-author on the paper, and a couple of interesting quick notes:

* BitFunnel processes every query that comes into Bing, but (at least when I left MSFT) indexed "only" the superfresh tier.

* Dan and Mike spent a few months removing cruft and porting it to Linux before we open sourced it: https://github.com/BitFunnel/BitFunnel

* It did win best paper at SIGIR (probably the most prestigious IR conference) this year.
I think it's vastly overblown. For AI to be scary we would have to connect it to some real outputs. If somebody makes a general AI and let's win in go or tic-tac-toe over everyone so what? If it's going to govern our FB feed or optimize some logistics, that's great! If we let AI decide whether we should go to war that's a problem, but that's not gonna happen for quite a while.

If you want to be scared of technology worry about CRISPR instead. Very easy to do, lots of people have the basic knowledge how to do it. It's only a question of time until a terrorist picks it up. It's easy to buy viruses with safeguards against spreading built in. With CRISPR it's possible (ok not easy but possible) to remove the safeguards and change the immune system signature. BAM a new epidemic.
I also listen to SE Radio (mainly back episodes as they don't release often). This other one look great!

My contribution would be FLOSS Weekly with Randal Schwartz (most of the time).
The best way to learn math is to study physics.

Or engineering, as in your case.
If conservatives care so much about wildlife why do they support things that lead to deforestation and desertification and loss of biodiversity and pollution and...?
Needed for those smooth animations in the UI. Yes, animations.

Seriously, this iron got style.
+1 from me too- it's really nice soldering iron for the price.
This conversation should go something like:

PostgreSQL has transactional DDL. MySQL does not.

...and the conversation is finished.
There's a service called TweetDelete that will automate this. Given the nature of Twitter as a ephemeral communication platform, there's very little value to having old tweets anyways.

I have mine set to purge anything older than a month.
Super Primes Up to Million [video]
I use PostgreSQL but are not sure it was the right choice. In MySQL it is easy to set which collation to use for a query to get the correct order in the users language when using order by. In PostgreSQL it depends on the locales installed on the OS making it much harder to get a correct order by and requires more work when setting up the servers
You could just as well say that when I pay a bill the money is 'destroyed' in my bank account and 'created' in theirs, it's just accounting.
Not sure why you think I'd tear you a new one, that was a well thought out reply, which I very much appreciate.

You bring up a great point about the self policing. That's why HackerNews, ProductHunt, and many of the smaller subreddits do quite well.

But what differentiates an old fashion comment thread from a better solution if not the "technical tricks"?

Also, "in the days of yore", when community design was a hotly debated topic, what were the debates about? I'd love to learn more about that discussion.
For marketing and sales: https://growthhackers.com/posts

It's been up for a few years (and looks good!), but hasn't gained much momentum. This is one of those segments that seems to lack a certain something, that causes a community to coalesce around a central interest.
except for all the false positives. every time someone gets a new phone in a group chat, someone has to ask "did you change your phone or is someone snooping at you", which creeps them out, because it's off by default, and so we ask less and ignore it, "probably changed their phone".

it's terrible ux for security, it could have been much more transparent and actually encouraging proper security behaviour.
> This VM would not have an IP stack but a small, secure, and well defined interface. It can basically do two or three things to communicate with the host: [...] All of these mechanisms can be transported out of the VM through hypercall (like VMCALL).

So how is this better than using existing IPC mechanisms and using the "user" abstraction to separate privileges?

And how is this more secure then IPC to a process running under another user given

> The browser takes a careful look at the pointer and the data it is pointing at. This code will need to be properly vetted as a buffer overflow here could potentially allow the unikernel to execute code outside its hardware prison.

(The long list of CVEs tells us how good programmers are at "properly vetting" buffers).
https://dev.mysql.com/doc/refman/5.7/en/json.html
Culture is not a F*CKING document
How government policy exacerbates hurricanes like Harvey
I get your point, but the two semantics you pointed out, work in MySQL/compatible engines too.
The later chapters on ILP, software pipelining, optimizing for parallelism and locality are completely new. Basically, chapters 8-11 have been either re-written or written from scratch. On the other hand, the 2nd dropped the Want to write a compiler and A look at some compilers chapters.
With the exception of Apple and Google OSes, because being a UNIX is almost an implementation detail.
> The guy has deliberately changed a default setting (strict_mode) to make MariaDB/MySQL look worse. When someone pointed that out in the comments, he left it unresponded.

I don't think the comments read like that. Someone pointed out that some MySQL variants have changed the default in a recent version and the author criticised the defaults, so the implication is that he wasn't using a bleeding-edge MySQL installation and got the previous defaults.
This could also be related to China's recent crackdown on VPNs.

Eliminating ways to export value without controls by the government, in retrospect, seems like one of the more obvious reasons to control the flow of information. There's suppression of nationally embarrassing facts, but only recently have things actually gotten more serious than providing a high (but climbable) wall.
Not as meat. For some Hindus anyway mushrooms and leeks are prohibited just like meat.
> It's my right to apply my own discernment to what are good and what are bad investments.

Let's say, hypothetically, that someone is not as good as you at stock picking, and they make extremely bad investment choices, added and abetted by an army of "wolves of wall street" all selling penny stocks that "are guaranteed to go big".

Once they arrive at their 0% ROI at retirement stage, don't they rely then on a government-provided safety net for various survival needs? Shouldn't the government then have a say, or at least some interest, in decreasing the probability of such extremely bad choices?
Love this sort of thing.

I did a Tetris game for a led-matrix clock I got from Banggood: https://github.com/hollobon/jy-mcu-3208-tetris
He was sentenced for selling "VPN software", which Win10 has built-in. Did he also run a VPN server (not mentioned in the article)?
Yeah, immutability was something that got kind of glossed over in that article (I'm the author). And Functional Programming was a lot less mainstream then. Maybe I should do an update.
Ask HN: Blogging vs. Product
Today, I have seen people starting a new blog every day and teaching to make money through blogging. On the other hand, there are people who are building real product like course teaching a skill, a service or solution to a problem.

What should I do to add value to community and make money as well?
Consider that any complex language runtime (e.g. Erlang's BEAM, the JVM, etc.) has its own scheduler. If you convert such a runtime into a unikernel (such as in Erlang on Xen), the runtime scheduler is "the" scheduler.

Besides languages, though, plenty of complex applications have their own schedulers. Databases, for example. Postgres-as-a-unikernel would make a lot of sense, because it's already doing its own equivalent to everything that OSes do.

If your program is complex enough, it likely will already have an "optimized" form of internally-managed shared memory/message-passing multithreading (with core affinities et al) to allow it to allocate tasks to cores better than the OS can without the "insider knowledge" of what it's trying to accomplish. At that point, your program will end up with a scheduler "inside" whether you set out to build one or not.

On the other hand, if your program isn't that complex, then it's very likely you'll get better performance out of your code by just making each process into a single-core unikernel and then packing instances onto however many vCPUs the hypervisor host offers.