skysight-inc/HackerNews huggingface dataset:
Maybe I did make a small error which would clarify things.
s/Most of the moral decisions western society/Most of the decisions that stand the test of hindsight as having a moral basis that societies have taken/

Whereas your position seems to be - things are a little bit shit anyway so what is the harm in making some more bad decisions.

> As I understand your comment, you're saying that there is no "morally justifiable" moral framework under which torture would be acceptable. Other people here obviously disagree, using e.g. the trolley problem as an example scenario - would you torture 1 person to save X people from death? This is a legitimate moral question, and I don't think it's anywhere near "decided" at this point.

This is not a relevant question. There is a simple question - are you prepared to hurt the person tied down in front of you in cold blood?
Companies definitely try to inflate their rankings with fake or forced reviews. But these are usually pretty easy to spot. They are often short vague 5-star reviews.

Read longer reviews and judge for yourself. Don’t trust the star ratings.
Negative reviews are accurate I believe. Obviously you have to take them with a grain of salt but the positive ones seem to generally be written either by HR or through exhortation of the employee base to paint the company in a great light.
Anyone up for feedback about this?
It's actually per table:

https://cloud.google.com/bigquery/quotas#import
Ethereum's Existential Threat – Where Are the Next 100M ETH Users?
I don't know who you are or what you do but I know for sure that you're not a USD billionaire and I can also predict that you will never become a billionaire.
The fact that I can make this prediction has nothing to do with who you are as a person and everything to do with probability.
I'm going to give an analogy in response to your EDIT AGAIN.

I claim that it's morally indefensible to torture a fish. Even if thousands of humans are to die unless I torture this fish (for some reason), you must refuse. It's torture. To advocate otherwise is to normalise torture, and to go against every moral decision societies have ever made. (Let's ignore the fact that factory farms exist, a moral abhorrence on a gigantic scale if you care about the welfare of animals; whether or not that abhorrence is balanced by an even greater moral benefit from the wide-scale eating of meat they enable. To be clear, I'm explicitly not giving an opinion on whether factory farms are a net benefit; to discuss that aspect further would be to miss the point of the argument entirely.)

If I took your moral system and also assigned worth to the well-being of fish, it's quite possible that I could end up with that. But I hope you agree that the views of my second paragraph are at best ridiculous, and at worst abhorrent. So something must be wrong either with the generalisation of your argument, or with the assumption that the well-being of fish is worth defending.

So either caring even a little about the well-being of fish makes me a moral vacuum, or some part of your argument doesn't generalise away from "torture of humans". Do you at least see that your argument doesn't have overwhelming force? I'd hope that a worthy moral framework would generalise more easily than this facet of yours that you've presented.
> Don’t personally guarantee anything for the business

How do you do this though? Banks/creditors generally demand a personal guarantee on any small business credit cards, loans, etc. Specifically because small/new businesses are very risky.
This is really nice. Good job!
Google's Learning Software Learns to Write Learning Software
Show HN: Slack Machine – A sexy, simple, yet powerful and extendable Slack bot
i agree, but not everybody does because i do find this sentiment repeated in such debates in different forms. for instance: https://i.warosu.org/data/g/img/0504/16/1442936748844.png
I know and the piece is spot on, not to mention the fact that with PostGIS its the best database for spatial anything, much better then expensive proprietary solutions. Thanks postgres!
AAC support will be available in Fedora Workstation 27
True, though "man in the middle" can be as simple as serving up free WiFi anywhere people have laptops.
What Allan Bloom Got Right
I've actually always appreciated that we have that... coming from a less liberal place, it made me feel like the state really cared about peoples' safety over the safety of corporations, and it's usually easy enough to find more information online about the compounds.
A three-dimensional look at data protection regulation
Why can't both be true?
A game about AI making paperclips is the most addictive you’ll play today
Iceland switches on negative CO2 emissions plant
Publii Static CMS brings experimental WordPress import
Chris Dillow is a good read on this topic

http://stumblingandmumbling.typepad.com/stumbling_and_mumbli...
Personally, I've worked at companies far worse than described in this letter, and if you think places like this don't exist you're young or foolish, or both. I've seen real emotional, and psychological violence at companies treated as everyday business. As an employee I was threatened for almost any reason whereas managers sexual/racial harassment, rape, yes rape, were dismissed as "he's just like that."
So your moral system requires that its adherents view incompatible or competing moral structures as inferior. So what? They can do the same to yours.

You can say that people with other types of morality have no morals, but that does not make it true. The reality is that they may actually have morals, and you just don't like the ones they have.
Says the guy who's likely posting this message on company time from an air-conditioned office.
To clarify, the quota is 1,000 loads per table per day, and 50,000 loads per project per day[1] for batch loads.

In practice, I've never hit either of these quotas, because our data architecture is such that we'd have to have some kind of major operational screw up to encounter them (e.g., a run-away failed import job that somehow manages to fail 50,000 times in a single day). Regardless, you can work around the per-table limit by using Wildcard Tables[2].

In my case, the source of my data is strictly batch-oriented, so importing data into distinct tables with a common prefix solves this problem for me. Where I do use partition tables, the likelihood that I'm going to update a single partition 1000 times in a day is highly unlikely (I'd be curious about any use case for that).

The DML features of standard SQL are probably best viewed as a "helpful backup" rather than a general solution. Yes, you can run UPDATE and INSERT statements against your non-partitioned tables, but you probably want to limit that to situations where you are trying to correct something specific, or on an ad-hoc basis, and not as a general solution.

In any case, there are a number of tools you can use to not be impacted by this particular limitation. For example, you could use streaming[3]. And while streaming has it's own quota (100,000 inserts per project per second)[4], it's straightforward to ask for an increased quota.

The trick is to think of BQ like you do Hive or other "non-typical" SQL databases: yes it has a SQL query interface, but if you treat it like PGSQL or Oracle, you aren't going to get the benefits out of it.

If you are going to try and perform OLTP operations against BQ you are going to fail. It's a data warehouse, not a transactional system. Working with log-structured data, or append-only data, is where it really shines.

[1]: https://cloud.google.com/bigquery/quotas#import

[2]: https://cloud.google.com/bigquery/docs/reference/standard-sq...

[3]: https://cloud.google.com/bigquery/streaming-data-into-bigque...

[4]: https://cloud.google.com/bigquery/quotas#streaminginserts
+1 it's a great piece of software that delivers tremendous value to users and continues to add amazing features every year. Cheers and thank you to all the maintainers and contributors.
> Sick leave policy is up to the company

I am really astonished that this is considered normal. Sick leave should not be up to the company, at least not for normal employee contracts. In many countries it isn't up to the company and they work just fine.

EDIT: to further elaborate, I'm not saying that companies should not be able to hire only single white males in their twenties, what I'm saying is that if you want employees that don't have a normal life, you should be expecting to put on the table more than the average salary for the role.
I have two counter-examples to this from my own experience.

The first is when I was asked to do interviews for my replacement after I handed my notice in at one company. Everyone knew that I was leaving because I hated it, I didn't even have another job lined up. But I was the person on my team _least_ likely to give a bad impression of the company.

The second is when I was interviewing for a startup tech lead role. One of the engineers gave me a tech test, then we had a chat, and I asked, "What's the worst thing about the company?" She told me: "Basically the CEO has no idea how software development works, or agile development, and we have loads of arguments and it's really frustrating. We're trying to hire a tech lead to shield us from that." Needless to say, I didn't take the job...
Yeah, the most obvious ones: cost of living compared to salary, local language, visa.
Yes, I have a small patreon at https://www.patreon.com/marijn. Right now I'm also running a crowd-funding for the new edition of my book at https://eloquentjavascript.net/3rd_edition/
I wouldn't trust one bad review. There are a lot of "haters" out there that like to unfairly review some companies.

I would trust the ensemble and the overall tone of reviews
How U of New Hampshire Turned a Quiet Benefactor into a Football-Marketing Prop
People will pay for what they don't want to do, even if they know they could do it.

A business client will be focused on their business. Their website, while important, is likely not their core competency. So it makes perfect sense to outsource that and they won't care what the underlying platform is.
Horrifyingly enough, extracting the truth isn't always the point of these interrogations. In conversations with my friends about this (when I can hold my composure well enough), the main objective of "enhanced interrogation" is to terrify the target population into compliance, or failing that extract bloody satisfaction on the victim.

Not like this is without precedent, Vlad the Impaler is named for his negotiation tactics, and the Roman Empire would on occasion react to a lawbreaker by murdering the city, crucifying the entire population. Modern Westerners (to our credit) don't have the stomach for such shocking brutality anymore, but I don't believe this vicious urge has completely gone away.
The West's media cartels are its kingmakers.

"In 1983, 90% of US media was controlled by 50 companies; as of 2011, 90% was controlled by just 6 companies"

https://en.wikipedia.org/wiki/Concentration_of_media_ownersh...
I'm also starting to follow people and communities that work with deep learning in new ways. Here are some of my favorites:

[1] http://colah.github.io/

[2] https://iamtrask.github.io/

[3] https://distill.pub

[4] https://experiments.withgoogle.com/ai
We need more of these ;-) I started reading afraid its a thin-veiled complaint and was positively surprised as well :)
There is a comedy show on in the UK the moment called Bad Move in which the central character (played by Jack Dee), is a web designer.

His father-in-law enjoys pointing out that this is today, a rather absurd career. Anybody can go online and create a website using a builder in an evening and get near professional results.

I don't wish for a moment to suggest that this business is up against it, but I will be curious to see how businesses will react compared to some years ago: most people who want an online presence, are either happy enough with nothing more than a social media presence, or are able to get something together that's good enough in wix.com or similar.

Of course for premium brands, they will hire in marketing agencies or even in-house staff, but that's not this niche market approach.

It could be a challenge to make a profit at this sort of gig soon!
> (as in, must necessarily be) very little implications of "Brexit"

On the contrary, it is necessary for the EU as a political project that there are negative implications of Brexit, and that those negative implications are perceived by everyone.
> If public opinion on Brexit changes, then it might be different. I don't see that happening yet though

I think it might. Polls on the subject have been tightening, and even showing signs of moving towards halting leaving[1].

I think as more of the leave voters die off (as they were predominantly older voters), and realisations about the actual real-world consequences of leaving filter through to the public consciousness, the process may be halted, softened, or reversed.

That's mostly conjecture (and hope, honestly) on my part, though.

[1] https://twitter.com/MSmithsonPB/status/918740988365074432
This is pretty interesting, I had not realized that any of the carbonate producing ideas had gotten this far.

I also wonder what future geologists will think :-)
I think it is more a matter of time because that is what mature relationships of the sort that take the good with the bad and acknowledge gradual change and value stability require. It's what separates love songs to Lisp from enthusiasm for React.
GLib tools rewrite
> But the grandparent actually mentions the short-lived approach, and is asking about cases where you want to have longer-lived tokens. And where you still want to be able to revoke them.

If that's actually what you want, then of course you want online-validated tokens. But I think generally it's not what you actually want: you actually want short-lived self-validating access tokens and online-validated tokens.

Note that talking about an online-validated token's lifespan is a little silly: there's no good reason for it not to live forever (until revoked).
Neither of these things look like directions I want to go in. Thanks for the suggestions though!
IoT Company Canary starts charging users for free service
It doesn't matter how left-wing a politician appears to be, or even how left-wing they are in general; if they hold an odious reactionary opinion, they can be called out on that opinion.
MariaDB has the unfortunate burden of being a drop-in replacement for MySQL which means all the warts, oddities and downright horrifying stuff are still there.
I shave one every morning. Works well.
> Everything connected to the internet is a potential security and privacy risk.

Yes, that's true. What I'm saying is that not everything needs to be connected to the Internet, and requiring things to be connected to function fully is stupid and anti-consumer. By requiring the label on things that don't essentially need an Internet connection, it would allow those of us discerning consumers to avoid the crappy products.

> But ya, take out the internet connection, and no more problems. Take out the battery and the risk of fire/explosion also goes away.

The fire/explosion risk doesn't go away (power bricks have been known to cause fires). And electricity is essential to electronic devices functioning; Internet connectivity is not.
Nope, actually moving back to the midlands since I'm fed up with London at the moment.
> followed by HR getting wind of it and burying them in a ton of fake positive reviews.

Or even worse, from https://www.glassdoor.co.uk/Reviews/Lab49-Reviews-E257101.ht...

> * Requiring new joiners to write a Glass Door review as part of their on-boarding process, presumably in an attempt to improve their rating.
coaching does not equal teaching. teaching is learning information, coaching is ensuring skills transfer and achieving desired personal qualities.
Sure, I get that - it's probably just me, but I'd expect a site I'd commissioned to be built 'for me' and become 'my property', not merely a fulfillment service that locks me in to two external suppliers.

I just find it odd, is all.
Torture worked the first time. The other 182 times that month were just for the fun of it.

https://shadowproof.com/2009/04/18/khalid-sheikh-mohammed-wa...
Ugh, hey Troy, thanks for making the post NSFW with that featured vibrator image...was it really necessary to make the point of the article?
Some lessons learned about using JaCoCo for manual testing
I'm guessing it's because they recently launched support for 3rd party data connectors.
Well, all the horrifying stuff, minus Oracle.
Runtime Memory Patching on x86/x64
Dynamism is certainly available to statically typed languages, but I believe the problem comes at how difficult it is to write dynamic code in static-typed languages, and to use the common building blocks that help you solve real problems.

Writing dynamic code in static languages is like running through mud, just like writing static checking in dynamic languages is.

I think both paradigms are important and valuable for different applications, but I have never seen a language that does both in any truly useful way.
>Perhaps unsurprisingly, a couple of extremely positive reviews by current employees have suddenly cropped up for that company as well. So positive they feel a bit like HR plants.

Most of the responses here are spot on but I want to address that one specific point. It's highly unlikely those new reviews are HR plants. Instead, the company is clearly aware of the negative review and the fact that it's getting publicity and has asked/encouraged their current staff to post their own reviews.
I started a keto diet 2 weeks ago.

As far as my research into keto goes eating too much carbs kicks you out of ketosis (duh!) and eating too much protein triggers gluconeogenesis which also kicks you out of ketosis. Which is a shame because I'd be happy to eat fatty steak and fatty pork all the time!

Keto guidelines generally say 30g carbs per day and that's what I'm going to stick to (net carbs; I want to eat avocados!). So typical keto diet should work fine with what you say about carb requirement.

I don't have any particular desire to go all the way to 0 (or some really low number) and if I have some carb budget left I'm happy to get a latte.
Starbucks says grande almond latte has 9g carbs (5g sugars). Perfect to tidy it up to just below 30g/day.
Hooked: how slot machines are designed to be addictive
In this case there are plenty of sources saying the same thing so it does not make sense to shoot the messenger.

https://www.startpage.com/do/search?q=corbyn+marxism
Do we really need to turn this article into a hot take on the 2016 election? This isn't useful and the responses amount to bickering over talking points/political messaging and signaling.

Concocting "Us" Vs "the political class wanting to manipulate us"/"the system"/"Clinton's hectoring"/"the parties and their disdain for voters" narratives does not advance political discussion in any way.

It may not be easy or convenient, but people need to step up and start participating in politics (at all levels, not just national) instead of viewing it this way. Why don't we call out charismatic political figures for casting politics this way? It advances individual politicians, with their own flawed views, over democracy as a method of solving problems that everyone must participate in.
There are many business owners who would look at the SquareSpace interface and be completely lost. We as technical people have thousands of hours put into understanding how the web works, but many people just haven't, and don't have the desire to learn (because they are doing something else). That, or they don't have time to it, and it makes sense to delegate. You can make a good living using tech for other people.
Another Way to Localize Application
Good thing there is a shortcut :)

Can you do `alter table` on pg_tables?
I'm familiar with the 24 hour clock but not that notation. That looked like a hexadecimal number. I'm used to seeing 1:00 PM rendered as 13:00 or 1300.
...Or newly manufactured ones.
Postgres falls into the category of things which should be considered defaults. Yes, sometimes an alternative choice is indeed the correct one, but generally if a project isn't using Postgres it's wrong.

It really is excellent.
Could you also open an account on [Liberapay](https://liberapay.com/)?
This self serving 'general public don't care' argument by software folks is becoming tired and cliched.

The general public doesn't care about freedom of press. Let's take that away. The general public doesn't care about elections. Let's take that away.

People use these self serving assumptions of ignorance to empower themselves. You have a ton of devices and things you use in your everyday life. Why should a doctor or civil engineer need to understand the details of software and hardware technologies to get value from it? Do all software folks understand the details of medical stuff or their home construction?

That's why you need regulations, so vague terms like the 'general public don't care' are not used to abuse them.
Once you bring in animals, the morals really change. We humans draw a very strong boundary on super precious human life vs everything else. Not here to debate why we do it, but that's how we've done it for ages.
For one thing, UK employees don't need to fund their own healthcare nearly as much as US ones do.
this is not true for all people and urine tests are not considered reliable. I can get into ketosis in a single day of fasting
Well I didn't mean to do that, I apologize if I'm misunderstanding/mischaracterizing your statement.

(I'd also be grateful if you want to tell me what I'm getting wrong.)
Are rich people meaner? Two teams find errors in each other’s work
> In the early years you had the standard format of index b-tree that most database engines leveraged. Then quietly but confidently you started adding more. Then came K-nearest neighbor, generalized inverted indexes (GIN), and generalized search-tree (GiST), only to be followed by space partitioned GiST and block range indexes (BRIN). Now the only question is which do I use?

I also wonder which index is appropriate for which case. I googled out this [1] and obviously all the chapters from 62 to 65 at [2]. I'm putting them on my reading list and posting them here just in case somebody else is asking the same question.

[1] https://devcenter.heroku.com/articles/postgresql-indexes

[2] https://www.postgresql.org/docs/current/static/internals.htm...
Big fan of Tiddlywiki for its nonlinearity. You can see how it works without signing up or downloading anything; the site is itself an instance: http://tiddlywiki.com/
> Not so much when you're doing exploratory computer science

I'm not sure. The following experiment is outdated (I'd love to see it redone more rigorously and with modern languages) and has several methodology flaws, but "An Experiment In Software Prototyping Productivity" (1994, Paul Hudak et al) shows that Haskell and static types are actually great for rapid prototyping and exploratory programming, even in the face of vague or incomplete requirements. This runs contrary to common sense, which is why the experiment was fascinating.
Here's a couple reasons:
- call functions(stored procs) as tables and join to them
- regular expressions
- order by in your views & functions
- order by INSIDE your aggregates
- create your own aggregates
- make your own window functions
- left join on your recursive CTE
- put temp tables in your function(stored proc) that you can also call as a table (see above)
- lateral joins
- filter syntax to do pivots
- WITH ORDINALITY
- generate_series
- dollar quoting
- write-able CTE's
- arrays
- ranges
- intervals
- jsonb (which can be indexed)

1. transformative/analytic functions
2. huge variety persisted formats
3. ability to store logic in the DB tier and re-use it