skysight-inc/HackerNews huggingface dataset:
> queries such as `SELECT COUNT(*)` tend to be a bit more expensive in PostgreSQL compared to MySQL/MariaDB

As far as I know, that's true when you use the MyISAM storage engine (which is non transactional), but not when you use InnoDB (which has been the default for years now).
Why This Outdoor Gear Is Designed to Last 61 Years
No. I'm saying Hunger Games isn't a representation of how the "Western society" as a whole views the collective future.
Maybe you're asking the wrong questions or are from an undesirable area. I mean the example question you're using is just trivia and not difficult to learn when a problem arises. I'm not sure how much more you want compared to "local variables, return addresses, parameters" tbh.
If it's like Assembly, the coins/tokens themselves don't have value _per se_, they just represent ownership. Basically, in this case, it's acting more of a ledger to represent equity than as the commodity it's typically used as.

An example:

UserA posts a great idea, and wants help to implement it. UserA is an MBA, has a business plan, a rough idea of execution, etc., but is not a programmer, or a graphic designer, or anything like that. UserA realizes she needs help, so she posts bounties - with features relative to the importance of the success of the project. "Need a landing page" might be a feature, with tasks broken out like "design a logo", "build a wireframe in Sketch", "convert Sketch wireframe to React frontend", etc. Each of those tasks will have a value, represented by Ether.

UserB, a graphic designer comes up with the perfect logo, which is worth 100 ether. User C, a frontend developer picks up the wireframe task, gets consensus, and then bangs out the React work, for a total of 250 ether. Other work gets done and an MVP is launched. The MVP was built, and a total of 5,000 ether were distributed as bounties were claimed and completed. User B has gone on to do a bunch of other graphic design tasks, and has a total of 600 ether, while User C left the project after completing the frontend work. The project's MVP launches, and makes $10,000 in profit. Because UserB has 600 ether, and 5,000 ether have been issued, UserB's share entitles him to ~12% of the profits, so he is disbursed a payment of $1200. UserC's share entitles him to $500.

As the project grows, UserB takes on more and more work, and more and more ether are issued. UserC doesn't ever come back on, but is still entitled to profits on the work they've done, though their share of ether will keep being diluted as the project goes on.

Hopefully I've been able to illustrate that the coin in this case is used not as currency itself, but as a representative stake in ownership.
I saw those 4.5 watt chips on Intel Ark, but I thought that maybe you could fit the 15 W models in the enclosure.

At least this probably means no fans! Oh and that it uses DDR3. :)
I was quite surprised how much text you can fit into a single QR code nowadays. 2778 bytes of lorem ipsum generates a massive code (1000x1000), but it can still be read passively with an iPhone's camera. For comparison, a Google CA cert is only 1363 bytes. You could theoretically dump your cert and private key onto their own (big) single page codes, then just scan them back in when you later need it. That just leaves the possibility of your printer holding onto something it shouldn't.
Makes sense, thanks =)

In the above example this would require `nil` checking of the retrieved value every time. I'm not sure if it would make the API cleaner
Have some Erlang:

sieve(N) -> sieve(lists:seq(2, N), []).
sieve([], L) -> lists:reverse(L);
sieve([Prime|T], L) -> sieve([X || X <- T, X rem Prime /= 0], [Prime|L]).
Why do people writing this kind of post need to use "you" instead of "I"? This is a very subjective view, I have been working remote for 4 years, and although I can relate to some of these points, I think it would be less pretentious to add some subjectivity to this point of view
Firstly you're comparing today's Chrome with an Edge copy from more than 2 years ago. Secondly, html5test scores are bullshit. It gives a points utterly arbitrarily; you still get 5 points for continuing to implement rejected specifications like Web SQL, while actually useful features like the FileSystem API or WebAssembly gets you nothing.

I've never used Edge and have no particular interest in it, but html5test is basically a way for Chrome users to feel good about themselves.
> git doesn't check the validity of sha-1 hashes in your commit history. Meaning if someone compromises your hosted origin, they can quietly compromise your history.

That second part of the fuller quote makes the first part irrelevant.

Git, sans GPG, does no validation of the given username and email - it is trivial to configure my laptop to stamp commits with hannob@ instead fragmede. All I need to do to frame hannob, then, is write access to a repo that they contribute to.

In the centralized world of github, that's a little bit more tricky, but at larger organizations where large groups (eg, all of eng) simply have write access to the repo(s), if git blame says hannob wrote the commit that stole passwords/money/etc, guess who's getting fired?

With GPG, I'm able to configure git so that commits that actually come from me have a GPG-validated signature. Snarkily, the blog post claims "no one" does this but I do. Given that this feature is known to be infrequently used, I'd believe it if git would accept commits with a bad signature.
Internships are paid a decent amount too. More than the average American by some distance.
Can you elaborate on this a bit? What are the advantages to keeping everything in a single repo for the organization vs. a different repo per project?
It's not quite as elegant as chrome, but you can go to about:profiles to manage profiles from within firefox. It allows you to create/delete profiles and launch a given profile in a new window.
A friend of mine runs a rural radio-based ISP, while raising... four? kids or so. It's entirely possible that some of his downtime was caused by someone accidentally spilling juice into something and letting the magic smoke out, but I've never asked.
US as well.
Yes and yes. This is the big pitfall i see so many ignoring - the real challenge if you're trying to interface with the outside world is establishing what the internal token means in the outside world without depending so heavily on a centralized weak link that the decentralization of the blockchain's maintenance is pointless. If the actors in a system don't trust each other enough to make changes to the database unilaterally, why would they trust that the other actors aren't lying about their on-chain/off-chain holdings?
Yes, most engineering applications end up doing all sorts of simulation that can be summed up as 'run as much math as fast as possible.' There's just routing traces on a PCB, there can be heat or stress simulations on a part built with constructive geometry, and a lot of other things that lets an engineer simulate/try something interactively and not simply 'draw a part.' This is where good workstations can definitely make a difference. An example product that is definitely going to need the local beef: https://www.autodesk.com/products/cfd/overview
I have some real fond memories of reading slashdot before classes in high school. I think my favorite was the day Rob proposed, and I was late to AP chemistry because I was frantically reloading the page to see what happened..

Through it i discovered the EFF, the jargon file, the FSF, and much else (hot grits, anyone?), and I miss that community. I haven't spent any serious time there in about 8 years.
A developer that knows just one tool has not shown the aptitude to handle a continually changing toolset.
In other words, the worst kind of combo of Windows-isms and Mac-isms...
You could use Optar http://ronja.twibright.com/optar/
It's not a matter of when class war will break out in the US, but rather when enough of the working class will realize they've been losing it for decades.
Jonathan Blow: Techniques for dealing with lack of motivation, malaise
`select count(star)` is fast only on non-transactional MyISAM storage engine which locks the whole table for a single writer and has no ACID support. It's not what people usually mean when they say they want an RDBMS.

When ACID support is required, you use InnoDB, and that has the same `select count(star)` performance as other database engines.

What workload do you have that you need exact count of rows in a big table? Because if the table is not big or if inexact count would suffice, there are solutions (e.g. HyperLogLog).
People will complain if the colors change. I mean it's not great when things change from under your feet, but it's a OS update is a "we're doing this for you"-kind of deal. People who upgraded knowingly are generally satisfied.
But apps should be update-able separately, not as part of an operating system update. That doesn't make much sense. Especially on mobile when you might want to only update single app currently relevant to you without blocking your phone for 40 minutes doing a huge update of everything. Also limited bandwidth.
I just wish they'd make up their mind about the buttons that surround the arrow keys.

Sometimes it's page-back / page-forward, sometimes it's pgup / pgdown .. with both options being equally annoying.
The rule is memcpy(x, y, n) is undefined if x or y are null. Making it defined if n is zero is a special case inside that rule.
Recently, the new of the moment is pretty weird though. In retrospect, the things warranting criticism were easier targets, and there was a lot of low hanging fruit.

These days, a lot of what used to catch some well-deserved flak has been refined and corrected for. The things that deserve criticism lately are a little more obtuse, and it's hard not to sound like a whiny, petulant critic, when everything's not perfect. #firstworldproblems
Kazuo Ishiguro on writing _The Remains of the Day_ (my favorite): https://www.theguardian.com/books/2014/dec/06/kazuo-ishiguro...

> So Lorna and I came up with a plan. I would, for a four-week period, ruthlessly clear my diary and go on what we somewhat mysteriously called a “Crash”. During the Crash, I would do nothing but write from 9am to 10.30pm, Monday through Saturday. I’d get one hour off for lunch and two for dinner. I’d not see, let alone answer, any mail, and would not go near the phone. No one would come to the house. Lorna, despite her own busy schedule, would for this period do my share of the cooking and housework. In this way, so we hoped, I’d not only complete more work quantitively, but reach a mental state in which my fictional world was more real to me than the actual one.
Been there, done that with my Yubikey.

The process is surprisingly involved, and there's a lot of opportunity for error given gpg's dreadful user interface (not saving to keep the key on both the host and the keycard? wtf?).

I think there would be a lot of value in creating tooling around the "best-practice" setup, even if it's just wrappers around gpg commands. Scripts to setup the main key & subkeys, revocation certs, smartcards and backups, all that jazz. A Raspberry Pi image to act as an "air-gapped" computer for sensitive operations might also be part of this.
Linux on laptops is like a disease. It's rare that everyone gets sick, but it's bad enough that many do. Even at Red Hat, where the employees collectively know more than anyone about making Linux run on laptops, internal mailing lists were often full of gripes about issues. If it wasn't the Big Three that I already mentioned, it was fans running constantly and batteries being sucked dry, switching monitor resolutions or dis/connecting a second monitor leaving things in a weird state, the utter impossibility of getting trackpads to work as well as they did under Windows/MacOS, international keyboard layouts not behaving properly, camera remaining locked when it shouldn't, and so on and so on ad nauseam. If you never hit any of these then good for you, but I can say with absolute confidence that such an experience is exceptional.
While the other comments talk about the benefits of switching to pgsql (and I concur whole heartedly) it seems no one has addressed your specific case. Your company isn’t really “switching” to anything, MariaDB was a fork of MySQL when the license kerfuffle was going on and there were issues with the stewardship of the project. It’s more of upgrading to a newer release of MySQL than switching to a different database engine.

i.e. “switching” to MariaDB is probably just a sysadmin upgrading the software and no changes to your code or database queries (unless replication is involved) but pgsql will certainly require more involved changes to the software.
I never publicly announced this but I loved Slashdot’s friend/foe system so much that I built it as a cross browser extension for Hacker News. It’s called Hacker Smacker and it’s on GitHub.

https://github.com/samuelclay/hackersmacker

Supports not only friends and foes but also friends of friends and foes of friends. Makes it easy to scan the HN homepage and comment threads and see what’s good. Much like how Slashdot’s friend foe system highlighted the good stuff in threads.
I wonder where sites like slashdot and digg will continue to fit in to the news landscape over time? If I'm looking for tech news straight from the horses mouth, I often end up at arstechnica, anandtech, or verge. If I'm interested in the zeitgiest I might look to HN or reddit. Is there a middle ground to this that's viable?
ECC increases reliability on older systems as well, increasing lifespan of any product. Silicon degradation is a thing.
Hm... looks like it's mainly focused on distributed stuff. Instead, I would hope they focus on the bare essentials as well.

I've recently started working with PostgreSQL and stumbled upon a problem with their UPSERT implementation.

Basically, I want to store an id -> name mapping in a table, with the usual characteristics.

CREATE TABLE entities (id SERIAL PRIMARY KEY, name VARCHAR(10) UNIQUE NOT NULL);

Then, I want to issue a query (or queries) with some entity names that would return their indices, inserting them if necessary.

It appears that's impossible to do with PostgreSQL. The closest I can get is this:

INSERT INTO entities (name) VALUES ('a'), ('b'), ('c')
ON CONFLICT (name) DO NOTHING
RETURNING id, name;

However, this (1) only returns the newly inserted rows, and (2) it increments the `id` counter even in case of conflicts (i.e. if the name already exists). While (2) is merely annoying, (1) means I have to issue at least one more SELECT query.

We like to mock Java, C++ and Go for being stuck in the past, but that's nothing compared to the state of SQL. Sure, there are custom extensions that each database provider implements, but they're often lacking in obvious ways. I really wish there was some significant progress, e.g. TypeSQL or CoffeeSQL or something.
The people of Hong Kong are hardly winning supporters within China. Much is made of the disdain that Hong Kong people have for Chinese mainlanders, but less is mentioned that it is equally true in reverse.

There is a commonly held belief (which I haven't researched and thus don't know if true or not) that they didn't make nearly as much of a ruckus when they were under British colonial rule, when they were de facto second-class citizens. As such, the independence/pro-democracy movement is viewed as a Western-backed attempt to destabilize China, with supporters (generalized to the whole people of Hong Kong, depending on how many of them you believe support the movement) viewed as submissives to the West. (If you add in a racial dimension, where the Hong Kong people are Asians willing to submit to "whites" while fighting back against other Asians, adds to that disdain).

Any attempts to "help", as some on this thread have suggested, is only going to help affirm this belief and harden the mainland Chinese stance against Hong Kong.
There's a drawback with any choice of technology, but PostgreSQL's are pretty well known.

Replication can be a bit of a pain to set up compared to anything in the MySQL family since the tooling to manage it isn't part of the core project (there are tools out there, like repmgr from 2ndQuadrant).

Similar story with backups, bring your own tooling - again, 2ndQuadrant has a great solution with barman, there's also WAL-E if you want to backup to S3 along with many others.

Uber certainly presented a valid pain-point with the way indexes are handled compared to the MySQL family, any updates to an indexed field require an update to all indexes on the table (compared to MySQL which uses clustered indexes, as a result only specific indexes need to be updated). If you have a lot of indexes on your tables and update indexed values frequently you're going to see an increase in disk I/O.

Someone else can probably come up with a more exhaustive list, but the first two are things I've personally been frustrated with - even with the tooling provided by 2ndQuadrant I still have to admit other solutions (namely Microsoft SQL Server) have better stories around replication and backup management, though the edge is in user-friendly tooling and not so much underlying technology.

On the other hand, PostgreSQL has a lot of great quality of life features for database developers. pl/pgsql is really great to work with when you need to do heavy lifting in the database; composite types, arrays and domains are extremely useful for complex models and general manipulation; full-fat JSON support can be extremely useful for a variety of reasons, as can the XML features; PostGIS is king when it comes to spatial data; and a whole hell of a lot more.

PostgreSQL is hands-down my favorite database because it focuses on making my life, when wearing the database developer hat, a lot nicer. With the DBA hat on it complicates things some compared to other products, but the tooling out there is at least decent so it's not a huge deal.
Prison sentences can't prevent the next Madoff, in the same way that they didn't prevent Madoff.
Italians are insane about the ubiquitous availability of espresso at all times.

I once took a BUS TRIP from Abruzzo to Rome. they had complementary espresso made on the bus from a machine tucked into a nook next to the toilet entrance. Try that on your Bolt Bus !
Well it's a question of ROI. How many Linux users are there really that can't wait to install Microsoft software on their desktops? People who use Linux as their desktop operating system are probably using open source alternatives of any MS client software.

And for Office they would use browser version which works fine. It makes no sense for MS to invest resources into this since there isn't enough interest to justify the investment.
Binutils 2.25 (released in 2016) is compatible with GCC 1.27 (released in 1988) - this is pretty amazing.
As for the other libraries, they are not needed.
All GCC versions implement simple multiprecision integer arithmetics internally, so GMP is only required by later versions of GCC for correct handling of corner cases, especially cross compilation. GCC 1.x does not use MPFR or any other software floating point library (and this can be problematic for cross-compilation).
ISL is a relatively new dependency (it's a library used for some experimental loop optimizations). Needless to say, it is not relevant for GCC 1.x. Similarly for MPC - a multiprecision complex number library.
Nah no single resource, it took me a lot of time to understand monads, going over many resources.

Just remember Absolutely ANY design pattern / data structure can be a monad as long as you can get an internal value out of that abstraction and define a bind operator to compose monads together.

This rule tells it all:

(>>=) :: m a -> (a -> m b) -> m b

m is the abstraction wrapper and a is the internal thing that is wrapped. You can wrap it in a type string, a list. Even like a binary tree can be a monad.

You can define the bind operator to do whatever you want, it just needs to follow the type signature above and be associative.
What’s the biggest food delivery service in your city?
> You talk about the majority position. But what about these minorities? Do they feel the same way?

Many countries don't have the obsession over multiculturalism that America seems to have. Their priority isn't to have a diverse population, but rather is to raise the quality of life for as many people as possible as quickly as possible, hence the focus on the majority of the population. A homogeneous culture has many benefits during growth, like lower interpersonal conflict. Concepts like democracy and freedom mean very little if the quality of life is low.
I considered ThreadRipper, but I'm going to overclock 8700K. Multiple cores are good to have sometimes (clean rebuild, reindexing), but 99% of time there are 1-2 threads and their performance is most important. If AMD would improve ThreadRipper IPC and frequency at least to 5 GHz, it would be much more interesting choice.
It depends if you are talking only about open source or all projects. In the latter case I'd say Photshop still has no competition. There are alternatives for some subtasks (photo editing for web), but for print work nothing comes even close, afaik.
Why not use a stored procedure?
ZFS doesn’t need ECC. Obviously it’s better for data integrity to have ECC, but ZFS without ECC is still better than any other file system without ECC.
Oh wow, that's a bit embarrassing :) The urls are now restricted to http and https only. Thanks for noticing!
Wow, just realized something totally crazy.. Honestly, I ended up where I am today because of Slashdot. In 1999 I wanted to build a Slashdot site but had no idea what I was doing. So I sat down and just learned how all that stuff worked, ran phpSlash for a while, then Slashcode, then Drupal. All the while I kept learning to code and run servers because of my little site. All the while new doors opened, and I kept working and learning... and now 18 years later I'm doing what I do because of your site. I've had a great little career, so many thanks for helping me get here :-)
This one is huge among the kids here in NE Seattle: https://en.m.wikipedia.org/wiki/Chopsticks_(hand_game)

The roll-over and splitting variations are standard here, which makes the game more interesting.
In case of Russia, it would help, if it wasn't robbed during 90's.

So of course, anybody who stops the robbery is authoritarian then.
"There’s no accountability. All I get is excuses."

Clearly they didn't change everything. Given that statement, they failed to change the CEO's understanding of his role to becoming a servant leader vs. 'managing' a bunch of peons. If he's still walking around trying to tack accountability on anyone but himself at that point, he's the source of the problem and needs to fire himself.
What Is a Neural Network?
MariaDB is a great choice over mysql, any day.

MariaDB compared to postgres is a difficult choice, both have a multitude of features. MariaDB 10 was a game changer for the mysql landscape.

To make postgres 10 as easy to scale as mariadb 10, and for query semantics in mariadb 10 to allow for the complexity that postgres 10 allows; both require tradeoffs in management tooling, development practices and understanding.

Neither of them are a silver bullet. They both require effort, like any RDBMS. But both are great choices.
Yep, the 5 year window seems reasonable, but starting from a single point doesn't. It'd be very interesting to see a breakdown of when 'god' would be fired for each of the possible starting points.
Lenin did get troubles in 1917 with border crossings and accepted contribution from Germany to get a safe pass to Russia. German government was interested in getting political emmigrants from Russia to return to the Motherland. They hoped it will destabilize political situation in Russia and weaken the country. The plan worked...
Here's hoping someone writes an alternative to pg_upgrade to handle this automatically. Hell, I'd be willing to throw some money in.