skysight-inc/HackerNews huggingface dataset:
The rollout map includes Kanto (Tokyo), Kansai (Osaka, Kyoto), Chubu (Nagoya), that is the majority of population in Japan: 42,607,376 + 22,755,030 + 21,714,995 = 87,077,401 out of a total of 127,110,047, 68.5%

Bigger map on homepage: https://coincheck.com/en/blog/2353
Just last week I played with a project that involved inserting 40M words (and their tuples, triplets, quadruples, ...) into in memory SQLite database. Even though the db was about 600MB a query which grouped the tuples by their frequency finished in under 5s.
We're seeing the same recovery in Europe which is to be expected after a recession (although long overdue). I'm not sure why HN sees it as "left-wing political theater" and "establishment propaganda".
One of the reasons I don't use sqlite in my projects is the lack of an easy unaccent solution, to make queries that automatically suppress accents. All my projects are in French, and if you want to make a search function in French you absolutely need that. Almost nobody will search for "éléphant" with the accents, especially now that Google, Facebook etc. do not require it.
Mea culpa.
What is the advantage of this? Here in Japan every creditcard is giving you some kind of bonus program and encourages you to use that card for your bills so you automatically aggregate amazon / rakuten (japanese amazon competitor) / ANA / etc points.

I mean, I guess I could exchange every month my yen into bitcoins and then pay with it, but why?
> lvh.me

This looks interesting, but how would one ever find out about this?
I stopped contributing to stackoverflow, but it's not declining
Yes, I like Apple products as well

My point is that while there are a lot of people that buy it for aesthetic reasons only, they do a lot of things right and a lot of tech savvy people use their products as well

(Hence the usage of "the sheep" was a jab at those who consider Apple customers sheep, it was not a critique of the users themselves)
A subset of the tiles are paid advertisements. "Completely harmless" depends on your point of view. Personally, if I have a choice, I'll opt for the browser that doesn't show me "sponsored content" on first boot, just out of principle.
I use a few libraries. The roguelike one I use is rotLove[0] for LÖVE[1] for Lua[2], which is a port of rot.js[3], which is itself a libtcod[4] port. However, fonts are handled by LÖVE. I have a bug filed with them right now where Chinese text crashes though, so I wouldn't call it ultra stable. Then again, it's just a fun project to learn Lua, so I'm not in a hurry.

[0] https://github.com/paulofmandown/rotLove [1] http://love2d.org/ [2] http://lua.org [3] http://ondras.github.io/rot.js/ [4] https://bitbucket.org/libtcod/libtcod
Only the engine is free software. The game data is proprietary.
A bunch of other relevant features of PostgreSQL:

- table elimination/join removal (MariaDB supports it but MySQL doesn't)

- asynchronous protocol (the new X Protocol supports it but not the standard protocol)

- table functions (for example the generate_series function which is very useful in PostgreSQL)

- LISTEN/NOTIFY (a built-in pub-sub mechanism)

- WITH (Common Table Expressions)

- Window aggregations (very useful for reporting and stats)

- Row Level Security (introduced in PostgreSQL 9.5; very useful for multi-tenant applications)
I agree - but on the other hand, I feel desktop is in a bad place in general. I'm a regular macOS user and I miss the Linux days, will probably install Linux on my Mac again. macOS incredibly glitchy and unstable (at least for me), and I'm not happy with the usability either. Windows doesn't look like a valid option at all to me. Had to use Windows 10 to fix some bugs the other day. No.

So, while the Linux desktop is probably in a very bad place, it's not so bad if you compare it to the other two alternatives.
> I thought a sequential scan was slow because it was limited by disk I/O

Not necessarily. Suppose you have a fairly big table that fits in the shared buffer cache and you run a query with a predicate that returns only a handful of rows. Then you would be better off scanning parts of it in parallel and then combining the results.
I was wondering the exact same thing -- how can CPU-parallelism improve on a task which (to me at least) seems to be disk-IO bound?
I'm guessing that my assumption of the task being disk-IO bound is incorrect!
That's a tremendously bad idea - what happens if you post something e.g. wrongly accusing someone less famous of something?
The world might be chaotic and exhibit 'sensitive dependence on initial conditions' (One year ago, how many people could have predicted the snowball of Donald Trump's campaign?), but it would be disingenuous to claim that biographies are complete noise. Even the genre of Fiction, despite its nomenclature, elicits truths about the world, possibly even the most profound truths that non-fiction cannot otherwise capture.

Right before coming here, I had just watched 'The End of the Tour', a drama about a Rolling Stones journalist writing a biography about writer David Foster Wallace (and now I'm writing about it, how meta is that?). In my opinion, David Foster Wallace's work is a paragon of fiction eliciting those profound truths. Ironically enough, one of the themes explored in the film was about being in-tune versus out-of-touch with reality specifically in the context of success / fame. I leave you with an excerpt from the film (Spoiler Alert):

All your protesting "I'm just regular guy". You don't crack open a thousand page book because the author is a regular guy. You do it because he is brilliant. Because you want him to be brilliant.
Sales tax also applies to the services.

More over, as labor is highly taxed in Sweden, it makes local repairing disproportionally more expensive compared to the manufacturing in a country with smaller labor costs.
A nation-state actor is testing methods for a massive takedown of the Internet
> Or should I say "in his/her/its/Apachehelicopter" past

You may think that's funny, but it does a disservice to your argument.
Never prioritize your roadmap based on customer feedback
The tax is clearly not high enough to keep people playing nice.
> As an example, instead of starting another desktop project (lxde, razor-qt, lxqt), some could have contributed to or collaborated with xfce.

As a former Qt (and KDE) developer, I can very much understand wanting to develop with the language and framework you're intimately familiar with. At least at the time (~2010), C++ with Qt was light years ahead of C with GTK.
One nifty trick to avoid writing new or delete even when you need manual heap allocation is to always use std::make_unique (or std::make_shared, as needed) instead. That way you're forced to spell out any transfer of ownership as it is happening, and so someone's always be sure to delete the object. You also dodge the bullet with indeterminate ordering of new's and constructors, that might result in memory leaks if one of the constructors throws.

An important extension to this trick is that unique_ptr and shared_ptr are specialized for arrays. So e.g. to allocate a dynamic array of size n, you can do:

auto a = std::make_unique<char[]>(100);

or

auto a = std::make_unique<int[3]>(1, 2, 3);

and then use it mostly like an array - a[i] is overloaded and work as expected, for example.

The reason why you'd want to do this rather than using std::vector is because you don't get the overhead of overallocation (since vectors distinct capacity and size) and default-initialization of the elements.

With these, it's quite possible to write >100 kLoC of C++ without a single new or delete in sight.
Linux did not outperform anyone. Companies did. Companies used and abused linux in such a way that the other simply followed the trend.

That's a unfair caricature of what really happened. There were competing systems with business-friendlier licenses. Obviously, Linux wouldn't be what it is without corporate contributions. But it also wouldn't be what it is without Linus' management and extreme pragmatism. That combined with the momentum introduced by the distribution ecosystem and advocacy that sprung up in the nineties.

Don't forget that by the time that IBM started pouring money into Linux (Peace, Love, Linux was in 2001 IIRC), Linux already had a large following among the tech crowd, which was stealthily replacing commercial UNIX installations with Linux.
My answer would be that any change that did not help increase the fish production was a change too far. The insurances over market over-supplies are designed to break a fundamental feature of free-market and were not installed with a central planning to counteract, so I would draw the line there.

> everything created by finance industry has found some demand among fishermen

Casinos and drug dealers use the same excuse. "People want our shit!"

I really believe that, while it is interesting to measure economical activity by the amount of money exchanged, it should also be measured by the amount of actual "stuff" produced: MWh for energy, calories for food, etc... It is much harder to measure, but it helps notice when an economy's growth relies too much on the financial sector.

I see finance a bit like the cardboard box industry: it does help and is necessary, and its activities grow when other activities grow, but it is an anomaly when it grows without the rest of the industry following it.
That is jws's website (not an image), a site I expect every HN member to be aware of.
It's largely a problem of Web sites making mobile Web pages not follow the Standards but rather use browser specific code.
The major difference between QML and the UI approaches from Oracle, Apple, Google and Microsoft for their layout engines, is using a JavaScript variant instead of XML, but the spirit is the same.
> especially disappointed with the clusterfuck KDE has become...

Can you elaborate? I'm on Plasma 5 and quite satisfied with it, though my use of KDE applications has constantly declined over the years. (Which has nothing to do with KDE specifically, just with my workflow becoming more and more CLI-centric over the years.)
I think the Elder Scrolls series usually target high end gamers that are interested in a very immersive experience featuring cutting edge graphics. In that regard, many players moved on to Skyrim, and Bethesda may not perceive OpenMW as a competitor.
Well, I guess we're not eating out every day anymore.
Cheers! I'm self-employed, and hopefully I'll be able to remain that way so that won't become a risk for me :)
An Outside Perspective: United States of Amateurs
No, that would be akin to thinking someone who is gay shouldn't have the same rights as someone who is straight. Although not quite as bad as that since political views are chosen.

Anyone who holds such discriminatory views should recognise that it will reduce their ability as a team player; it may not be enough to justify them losing their job, but it definitely counts as a negative against their skillset.
Free energy for the next couple million years. What else could you want?

Porcupine Bank goes all the way up to 200 meters deep. Seems very doable for a very determined multi-billionaire. 200 meters of rubble is not that hard to stack.

The main problem is that there are a couple people drilling for oil around there and I suppose they'd object to being in someone's territorial waters.

OTOH, negotiating protection and sovereignty in exchange for very lax law about oil exploration could make an independent country viable.

How tragic the island of Hi Brazil would be born out of such dirty interests...
TEE BILLZ EXPOSES TIWA SAVAGE SEX VIDEO WITH JAZZY IN Their BED
What's Inside Blue Ballpoint Pen Ink?
It's taken surprisingly long for an open network like this to become common! You'd think that would be the only concept with longevity and "punch", due to the very nature of communications: unwalled always wins. I mean, that's why e-mail is still used. I also hope we'll get rid of these silly games by Google and others in the future.
For me the question of "flexibility" ties to the tools. Anyone who's ever tried to do FPGA development will know that it's not exactly agile. Third-party improvement of tools is blocked, because the "bitstream" format is confidential. Imagine if Intel or ARM refused to give you an instruction set manual and made you use a slow proprietary compiler with encrypted outputs.

Without great improvement and opening of the tools, FPGAs aren't going to be a general-purpose accelerator. It'll be a question of building one specific piece of firmware for one specific project and then deploying it semi-permanently with minor revisions across the cloud.

Wake me up when Visual Studio has an FPGA backend.
> The sum is always negative no matter how low the risk of extinction.

That makes this model rather useless for arguing what must be done. For example, it's ridiculously, incredibly unlikely that making tea will lead to extinction by nuclear armageddon. But it's not impossible. As such, making tea would also have an infinite, negative expected value. It would be effectively as bad as just pressing the nuclear button.

That being said, I think your only problem is in assuming that the human race is infinitely valuable. It's not. There's definitely a limit to how much an individual would give up to prevent extinction.
"I used to give the the option of doing either MySQL or SQLite"

SQLite is good choise for absolute beginners.

Later, when teaching "real" multi-user RDBMSes, although MySQL may be more popular, it makes more sense to teach PostgreSQL as "default open source database". Both will do the job, but PostgreSQL has got more stuff right from the beginning, which is especially important when learning. Think PHP vs. Python, PHP may cut few corners but it's not ideal language for teaching generic concepts.
Actually GMail and YouTube are the only tolerable experiences using FF.

Try watching random FB video, Twitch streams, etc. on a Linux FF and you'll get greeted with a nice "please download Adobe Flash" or some such nonsense.

With Chrome it just works, it bundles Flash, I don't have to care which version it is, how to get it for my system, etc.

I would like to use FF because the theme makes it match my Gnome theme (silly but it would make me switch browsers) but it just breaks on multimedia.
> SQLite supports an unlimited number of simultaneous readers, but it will only allow one writer at any instant in time.

This is the one that usually gets me. For whatever reason, I tend to prefer side projects that are "take a dataset and make a tool out of it". It often ends up with simultaneous bulk writes when the dataset is updating.

I'm a big sqlite fan. Just throwing this out as a limitation for anyone deciding if it's appropriate for their project.
Kind of shocking lack of empathy in that last sentence. Don't get me wrong, I hate the "you shouldn't say anything offensive" brigade, but equally, no reason to be so caustic. Overwork is a big part of tech culture sadly, posts like these are helpful, even if they are only reminders of things we already know.
For certain tasks, I like to work on streams of JSON records too. jq(1) makes it really easy. However, requiring records to be line-delimited is a point of failure when accepting input from external sources. There should be no difference between:

{"foo": 1}{"bar": 2}

and

{"foo": 1}
{"bar": 2}

or any variations of common whitespace between the objects. Just parse objects incrementally, one at a time. Most JSON libraries supports this.

As for general logging: I prefer it to be structured text written to stderr, and have a PEG parsing it for me. stderr is pretty much a catch-all log stream, and some 3rd party software insist on writing to it (most do however offer a way to override this behavior, e.g., chromium-headless, libxml2, &c). Having a PEG for those cases means I can still get JSON for everything if I need to, even if the data in the log is unexpected. If I need to, I can then modify the PEG for that use case.

Of course, it's a case-by-case, pragmatic decision. If I only want to log certain data and disregard stderr, or if I can guarantee everything that gets written to stderr will be valid JSON, writing logs as JSON may be better.
> The public at large will never be swayed to use less convenient alternatives for ethical reasons.

There have been countless practices which were once the convenient norm but are now seen as archaic or barbaric, at least in some parts of the world;

Slavery, serfdom, monarchies, dowry, arranged marriage, virgin sacrifices, involuntary circumcision, blood feuds, war crimes, excessive pollution... I'm sure the transition period in each of those cases was anything but convenient, and in some places it's still nigh impossible to convince people to stop these practices.

I think it's not so much "swaying" the public at large but continuing to provide sufficient education to them, and the technology to ease the transition, then at some point the transition just happens on its own. Of course the inverse is also possible and people sometimes revert to old and worse practices.
Reporting issues to both Chromium and Firefox is a pain in the ass. Valid issues will be closed for arbitrary reasons (Chromium, mostly) or are ignored for months/years despite making parts of the browser unusable.

Contributing to either feels like a waste of time.
> Same thing. That only works if the hunter values food. If he has enough (or knows how to get enough), he might not value food.

I think you're confounding value and marginal value.
I find it scary when a browser window appears from nowhere.
Slightly off-topic but I love their sql docs[1], those diagrams are just beautiful.

[1] https://sqlite.org/lang_createtable.html
> The service is the first of its kind in Japan, where Bitcoin is still a novelty in daily consumer life.

Where is Bitcoin not a novelty in daily consumer life?
Face recognition in porn
In the current lobbying environment you're more likely to end up with a statutory minimum of lead in your ISP (surveillance, filtering, anti-competitive measures, anti-net-neutrality, etc)
> * hibernate when closing lid

This is actually systemd territory today.

(One of the reasons why I like systemd in practice. They may run counter to the Unix philosophy in every possible way, but at least shit now works the same across nearly all distros and desktops.)
The fact is, after releasing IE6 around the year 2000, MS dissolved the IE team. Only around 2006 a new team was formed to create IE7 (which wasn't much better).

Conspiracy mixed with facts is... At the end of the nineties, Netscape was pushing to make the browser the platform, instead of the desktop. MS was quite worried about that, they had a monopoly on the desktop and used that to create a monopoly with their browser, so Netscape had no chance to do what they wanted.
MS succeeded, as in delayed the process, it took maybe 15 years, after the death of Netscape and the rise of Google, to have Google and others make a platform out of the browser.
Having the web stagnate and locked in to a browser like IE6 was for MS a desirable situation.
The Holy Grail of Dynamic Remarketing Strategies
In C++, you can't "accidentally" move something that's a non-const ref, since a move from one would require explicit use of std::move.

The only things which can be moved accidentally are rvalues and rvalue references. But for rvalues, that doesn't hurt anything; and for rvalue references, the only reason why you'd use one is if you intended to play tricks with move semantics, which implies that you know what you're doing.

Basically if you write C++ as if move semantics didn't exist (i.e. never use rvalue references or std::move), you won't shoot yourself in the foot by those means. Of course, this also means that compiler assumptions are fairly pessimistic, so many places that could be a move aren't, because the move has to be explicit.
If those views make them less good at their job, or less good a fit for your company, sure - why not? In fact, if I were a potential employee I would want to know that you held those opinions because I would prefer to not work for you; everyone wins.
The economist has no clothes!
Couldn't agree more; no idea who is downvoting you, this is the most insightful comment here. Also, it's fucking hypocritical claiming to support 'net neutrality' while hand-picking sites to receive support of a massive private-fiber global conglomerate with very strong senior management political affiliations. Engineers with ethics at google should start a rebellion.
How is this different from Iridium browser?
The irrational step is when people start to believe that they need money, when in fact they need fish. When people start to believe that they need loans, when in fact they need nets and boats. In the end, they deem this made up number called GDP more important than fish and hunger.

See, with fish, it's obvious that catching more than the community needs to survive and piling it up in one's basement is wasteful and counter-productive. Yet, with money, not only does it seem like a good idea but it quickly becomes the ultimate goal of the participants.

Money (especially with positive interest rates) is a terrible abstraction of value.
It's a bit like how a lot of people refer to '#' as 'hashtag' these days, without knowing about 'the pound symbol' or 'sharp' (if you are a musician). :)
I work on a lot of different projects locally, so the username / password auto fill for them needs to be different. Using local host for all wouldn't work.
Absolutely, but you'd be a nice guy if you factor out the essential and common parts into C libraries, so that others can make use of it as well (from any language and framework) which increases collaboration and decreases fragmentation.

Some might see the need for C libraries as evil and unnecessary (I personally don't), but it's the situation we're in.
He was the head of the company. The figurehead.
Looks like a cool idea. "Contact for a price" to get more than 1,000 rows is ambitious.
El Capitan runs on mid 2007 and newer iMacs, no?
I use dev.projectname.com
> I could never see myself accidentally working until 9pm.

I think this happens, amusingly, largely because of the efforts to which remote workers go to separate their personal and work lives.

If you shut yourself off from the world, don't be surprised when you're unaware what the world is doing. I've never made a hard distinction between my work and my real life and my life has never let me make the mistake of giving a company more of my time than they've earned.
or octothorp
"the carrot"

I see what you did there.
I fail to understand why Scandinavian politics always manage to make sense.

Is that cultural, historical, economical, or does the tough climate force people to think a little bit more about how they manage their society?
What we really need is financial penalties on companies that make stuff deliberately hard to repair. Set up a department of the Consumer Rights Bureau (or whatever it's called) where people can report devices the've been unable to fix due to deliberate obfuscation/etc., and that forces manufacturers to refund the consumer the entire purchase sum of that device no matter how old it is.

Anecdote: my washing machine recently broke the main bearing, and I was going to fix it. Even found a nice teardown/reassembly vid on Youtube of the exact same model (a bit older than mine). After 2 hours of work, I discover Bosch has gone from using screws on the outer drum to plastic welding it shut. So fixing it means replacing the entire assembly, costing 2/3 of a new machine and with a four week delivery time for the part. I learned this is only done to screw consumers over, and that all manufacturers do it now. The drum still has all the mounting tabs for being screwed together, so they're literally just saving $0.30 on screws.
It would be convenient if you have an income or savings in Bitcoin.

Some people are attracted to using Bitcoin as a day to day currency and payments system, to reduce their dependence on mainstream banking. The "be your own bank" philosophy.

Admittedly right now Bitcoin seems like a novelty, but it will never reach wider use without small "pointless" steps like this.