skysight-inc/HackerNews huggingface dataset:
Disagree on joins and foreign keys: normalized tables make for smaller tables in my experience. Sure you might denomalize for reporting but it’s best to normalize and then demoralize as needed not avoid foreign keys because you have to write a large number of joins
> But I have quickly realized that it's almost useless in real life projects

there are plenty of real life projects out there that would beg to differ
No. There are a bunch of billionaires pushing their various agendas. Billionaire pet-causes is pretty much the only way things change in this country anymore. Democracy is dead, all we have left is billionaires fighting each other.
I spent much of the summer after my senior year of high school working temp jobs, earning minimum wage. This was the early 90s in Northeast Ohio. There was a lot of light manufacturing and I mostly worked in factories in Twinsburg. One job I even shrink wrapped Sun OpenWindows manuals. It was clear to me then that the factories required the temp agency to fill out the workforce, especially for the less desirable jobs like stacking boxes on pallettes at the end of a manufacturing line.

One day I was sent to a medical equipment warehouse. Another worker and I were assigned to untangle a pile of hospital beds easily 12 feet high. We were supposed to climb on it and free each frame. The bedsprings were snagged on each other and the pile was unstable. I called the temp agency, said the job was too dangerous and walked out. I wanted the money but I was lucky enough that I didn't need it.
Luckily no one was harmed.
Citation needed. Also, is there any reason to believe this isn't how it's always been throughout history? Those with lots of capital set things into motion that impact everyone else?
My smoke detectors made a boast on the packaging they featured a fool-proof low battery indication, without going into any details.

I bought half a dozen of them to install in our new house years ago, thinking the nightly find-the-beeping-^+=¥€ games were finally a thing of the past.

When one started beeping, I did the rounds, figuring I'd be back in bed in minutes. Well, I wasn't. Turned out the fool-proof indication was to have the normally green LED flash red instead.

Did I mention that I am colour blind?
It's also what the "web" link on hn lets you do. No crazy add-ons required.
I've been using Django + Django ORM for a decade, and it has covered vast majority of database usage. Entire applications written with zero SQL, and clean DRY code describing data and allowing to use it in the code. And yet other application written with lots of SQL.

The real question is, why anyone using an ORM not learning SQL, how the the thing they are mapping to objects actually works?
We're talking about huge sums to run the country. Hundreds of billions of dollars every year. Even if you magically find some private investors with that kind of cash, they will quickly run out of cash. Then what? The problem is getting dollars/euros into the country.

There's one solution I see: allow cryptocurrencies to be used as legal tender throughout the country, and for imports/exports too. But then you have zero control over money printing. It would be an interesting experiment, but I doubt Russian government will do it. Besides, they announce banning of cryptocurrencies like every other month.
24-hour trading volume for Bitcoin is $4.86 billion (https://www.coingecko.com/en/coins/bitcoin).

Most active NYSE stock last Friday was Bank of America, trading about $3.1 billion (http://www.wsj.com/mdc/public/page/2_3021-activnyse-actives....).

I don't understand why you'd compare a single security's trading volume to an entire stock exchange's volume. It is not a meaningful comparison.
The only way this could be true is if the number of regulators for a company is larger than the number of total employees. With a few exceptions, I doubt most companies are that small.
I disagree. ORMs dont bring value, they dilute value and piles abstractions upon apstractions. Your application becomes hard to maintain, database hard to refactor, queries slow.

ORMs seems nice for simplified problems but becomes a horrible mess for real problems imho...

I've worked on some rails apps, and the ORMs caused more problems than they solved...
No worries, by the time my kids manage to run into a wolf they are already run over by cars multiple times on the way to the forest. Or stung to death by wasps, bees, ... bitten by the neighbors dog, attacked by a boar, drowned in some water, ...
They are betting on us like greyhounds in a cosmic TV show back at ther ship
Haha yes. It'll be like , if I watch lots of war drama, then they will show artwork of noah as soldier from The Notebook. Man, that will be epic
Graph theory offers one nice illustration of the transpose (for square matrices). Here's a directed graph:

⬐---------¬
n₁ → n₂ → n₃

It can be represented by this adjacency matrix:

X = [ 0 1 0 ]
[ 0 0 1 ]
[ 1 0 0 ]

See how there is a 1 for each row i and column j where there is an edge from node i to node j?

Okay, now look at the transpose, Xᵀ:

Xᵀ = [ 0 0 1 ]
[ 1 0 0 ]
[ 0 1 0 ]

If we interpret this matrix as an adjacency matrix, its graph looks like this:

⬐---------¬
n₃ → n₂ → n₁

Taking the transpose of a directed graph's adjacency matrix just reverses the direction of the edges!

P.S: some more cool things about adjacency matrices:

Imagine that a vector represents a node or set of nodes on a graph. Like this:

n₁ = [ 1 ], n₂ = [ 0 ], n₃ = [ 0 ],
[ 0 ] [ 1 ] [ 0 ]
[ 0 ] [ 0 ] [ 1 ]

Watch what happens when we multiply X with n₁:

X*n₁ = [ 0 0 1 ] [ 1 ] [ 0 ]
[ 1 0 0 ] * [ 0 ] = [ 1 ] = n₂
[ 0 1 0 ] [ 0 ] [ 0 ]

So the adjacency matrix is not only an index of edges, it's also a little machine that can push nodes around on a graph. You can even do it with two at a time:

X*(n₁ + n₂) = [ 0 0 1 ] [ 1 ] [ 0 ]
[ 1 0 0 ] * [ 1 ] = [ 1 ] = n₂ + n₃
[ 0 1 0 ] [ 0 ] [ 1 ]

If you're interested in diving further into algebraic representations of graphs, check out the Leavitt Path algebra: https://arxiv.org/abs/1410.1835
I have a tiny PR for the python redis client. Makes it even easier to see the power of this pattern.

I'm in the process of using streams to shift away from legacy tight coupling of databases to async operations.

The real killer feature for us is being able to grab a prod backup, spin it up in a Dev environment and watch it pull all the unprocessed messages in, until it has caught up. Really powerful and safe for replicating unexpected behaviour..
You know what is a concrete danger for my kids (and all other kids, in both rural and cityareas)?

- cars

and if you worry about animals

- dogs (which are wolves, bread for insanity and not fearing humans, and sometimes trained to attack people)
- chicken (salmonella probably kills a few kids a year)
He wrote:

"Attribute creep and excessive use of foreign keys shows me is that in order to use ORMs effectively, you still need to know SQL. My contention with ORMs is that, if you need to know SQL, just use SQL since it prevents the need to know how non-SQL gets translated to SQL."
Why would you hear about it from Canadian sources, if they're getting gagged?
This is an alarmist response. From my own experience, a person CAN change their personality traits dramatically over time. Simply acknowledging that this is within your power doesn't change anything. Socially imposed "personality requirements" already exist anyway.
Anyone remembers Stuxnet [1]? I wonder what's next ...

[1] https://en.wikipedia.org/wiki/Stuxnet
I know. It's really funny how people seem to have a knowledge of history that begins solely with the colonization of the new world. They have zero recollection of the horrors of past civilizations. As if, somehow, the founders of the USA, are responsible for all evils in the world and everyone else was just getting along and hugging up until 1776.

And I recommend those people ask for a refund from their history teachers, because anyone who tells you history is black-and-white, good-and-evil, is selling you something. Humanity is one long stream of moral ambiguity. Any moral lessons derived from it are done by omitting contradictory evidence. A simple cruise through a Wikipedia article offers plenty of moral ambiguity--and that should be the minimum starting point for considering yourself knowledgeable in a subject.

Even the archtype of evil himself, Hitler, (and likewise Stalin with Russia) still managed to re-vitalize broken countries into industrial titans that we still benefit from today. Russia was literally a pre-industrial society before WW2. And it's interesting how people who believe in rigid good-guys/bad-guys have no problem driving a VW Beetle, or a Mitsubishi--they made the Kamakazi Zeros, by the way. And both companies benefited from slave labor. It's not even hidden knowledge:

http://www.nytimes.com/1996/11/07/world/volkswagen-s-history...

http://www.slate.com/blogs/the_slatest/2015/07/20/mitsubishi...
Um, you actually missed the point.

Self-driving cars see the dog and the child somewhat close to the road and classify them as a hazard IMMEDIATELY and start adjusting for them. And, if they lose track of them, the car goes into "Unseen Idiot" mode. You don't need the dog running out to focus their attention like a human does.

Self-driving cars don't have the attention span problems that humans have. Self-driving cars can watch more than 7 +/- 2 objects (much more) without diverting their attention.

Which means that self-driving cars can watch all 6 of those little kids walking, as well as the 4 on bicycles, and the two playing with the dog over there.

This is why self-driving cars will win ... and quickly.
The lid seals the entire Instant Pot, not the insert (which is the thing that would go in the fridge).
It's ironic, but I don't feel too bad about it.

1. For all of the things we mistrust the US government for, the FDIC is, as far as anyone can tell, rock-solid. If, by some catastrophe, the FDIC were no longer able to ensure deposits, we would likely all have much bigger problems than trying to get your cash out of GDAX.

2. It spreads risk. GDAX itself is a centralized authority. Instead of putting all my trust in one entity, I now only need one of GDAX or the SEC or the FDIC to be functional.

3. It brings legitimacy. For better or worse, your average person is not a crypto cyber hippie, and neither are executives at most traditional companies. If we are to start seeing crypto currency actually become useful as currency in the USA, rather than just the speculation instrument, we need adoption by both average people and business executives. When they see that one of the top exchanges is based in the USA, and is fully certified and regulated by the US government, it ought to help allay some fears about the safety and usefulness of digital currency.

4. Some things I don't trust the US government for any further than I can throw it. Other things, I trust it pretty thoroughly. This falls in the latter category.
> providing abstraction for database-specific and driver-specific quirks

That is quite theoretical. My PRs for fixing non-spec compliant behavior in pgjdbc get rejected because they might break some ORMs (mostly Play). My PRs for adding MariaDB sequence support to Hibernate get rejected because there are additional MariaDB features that Hibernate doesn't support as well.
Perhaps Chrome is also supported by the testing infrastructure, but they chose to use only firefox?
> A very clever person then decided that readers should not be allowed to place bookmarks inside the book, and must instead write down the page they are up to on their diary.

> This is the design of Apache Kafka, and it is a very resilient design

This is confusing. Kafka used to store consumer offsets in Zookeeper and now it stores them in a dedicated consumer offsets topic.
Parents have influence on how well their children do. Nature and nurture. Is this not the whole point of parenting?

If millionaire parents are only twice as likely to have millionaire children I would be surprised.
If you are working with Node.js and Postgresql, give tabel(https://github.com/fractaltech/tabel) ORM a shot. It is an unconventional ORM that works with pure JS objects and arrays, instead of "Model" classes, and "Collection" classes, and what not. It has quite a few other nifty features too.
I had something along these lines happen to me years ago. It was sound-related, but didn't turn out to be electronic.

I was renting in a century-old house that had been converted into apartments. Every night, around midnight, this very high-pitched hum would start, and continue until almost dawn. None of the other residents ever heard it when they were around. While the exact timing varied, the time during which it happened overlapped with my sleep schedule (I was working a late tech support shift at the time) and it kept me awake. Earplugs didn't really seem to help.

There didn't seem to be any obvious source. I did exhaustive work to try and track it down - even got the permission of the owner and my fellow tenants to try shutting off the power at the breaker box in the middle of the night to see if that helped. (It didn't.)

It wasn't always constant, but it was around enough and preventing me from sleeping enough that I was going slowly insane. I had my ears checked for tinnitus - nope, I had and still have darn good hearing. I started reading about the Taos hum, looking into resonant frequencies, and finally stumbled across the answer.

The noise started a little while after everyone in the building went to bed. It stopped shortly after they got up in the morning. It was the sound of the century-old plumbing system at full pressure. If I just left a tap open a trickle, and the noise went away along with my sleep-deprivation.
Corruption at the scale we're currently seeing was pretty much illegal until the Citizen's United ruling. Dark Money groups spent $600 million on senate races in 2016.

The Koch brothers alone were planning on spending nearly $1 billion to influence the election. It's no wonder that congress is racing to pass an historically unpopular tax bill that almost exclusively benefits these very same donors. Hell, Lindsey Graham gave away the game in a response a few weeks ago when asked what would happen if they didn't pass the bill:

> "The party fractures, most incumbents in 2018 will get a severe primary challenge, a lot of them will probably lose, the base will fracture, the financial contributions will stop, other than that it'll be fine!"
Two related things-that-should-not-be-related bugs that I have encountered:

The WiFi on my girlfriend's laptop would fail when an HDMI cable was plugged into the laptop. Changing the channel on the router "fixed" it but we never could figure out the ultimate cause.

I can pause my Roku box using the Kodi remote app on my phone. This occurred when I inadvertently used the wrong remote to pause the Roku. It appears only to work if the Raspberry Pi running Kodi has gone into some sort of standby mode, possibly making the Kodi remote app send a wake signal which is interpreted by Roku as the pause signal.
ORMs were pretty limited at the time I began writing my first platform, phponpie.com . I remember looking at Propel and Doctrine at the time.

Since then, I've written our own ORM which works in both PHP and Node.js, but we're the only ones that use it. It's been battle tested, though, with millions of users and variations. I would say that many of the issues the author brings up were things we had to face, and we solved them.

1) Schema – the ORM should have a script to regenerate base classes from the database, so that your schema only lives in once place. The nice thing is, after that, your IDE can help you out instead of writing sql by hand. It can use your language syntax to catch unbalanced parentheses, and more.

2) Adapters – the ORM should be modular so you can hook in adapters for MySQL, PostGres, SQLite, MongoDB, and various key-value stores.

3) Joins – the ORM is supposed to be smart enough to describe relationships and automatically write the most optimized JOIN queries for you. For example $article->getTags() . You could, of course, implement this stuff yourself manually but it gets tedious, when the code could easily be autogenerated with stuff like $article->hasMany('tags', ...) kind of like this: https://qbix.com/platform/guide/models#relations

4) Insight – using an ORM makes you pass actual values in a structured way, instead of interpolating them in a string. Thus you don't make the catastrophic mistake of forgetting to escape them, allowing SQL injections by Mr Bobby Tables. Also our ORM can do SHARDING in the app layer, especially useful in Node.js where it can issue simultaneous queries to several databases and combine the results. Although I recommend using CockroachDB these days :)

5) Flexibility – the ORM should support fetching partial objects, but with the Primary Key so they can be saved back. Recently we even added support for vector-valued lists, something we needed for extra flexibility.

6) Transactions – the ORM should be smart enough to handle transactions, in fact support nested transactions on various shards. Since the database engine usually does not support nested transactions, you need to emulate that in the app layer. For instance, when you start a session, you might want to begin a transaction and lock the session for update.

7) Methods – objects which are fetched can have user-friendly methods added, like $stream->exportToClient() and so on.

It's free and open source. Here are examples of usage:

https://qbix.com/platform/guide/database

https://qbix.com/platform/guide/models
> Before that date, roughly, more money moves through one stock exchange in a single day than all of Bitcoin in a year.

Calling the NYSE "just" one stock exchange isn't exactly a fair comparison. The NYSE is somewhere in the region of 20% of the total stock exchanges by market cap. It's twice the size of the next-largest stock exchange (NASDAQ), which is itself about twice as large as a "normal" large stock exchange (e.g., London or Tokyo).
What about forex trading?
It depends on how willing you are to allow your object graph to match your relational schema. The key is to let SQL be SQL. I wrote one that allows you to load data using standard SQL resource files, but it handles the persistence automatically:

https://github.com/bgard6977/sqorm

Flyway & jOOq take a similar approach:

https://www.jooq.org/

Taking the SQL-first approach also allows you to serialize without circular reference problems, since you don't just load the data, you also define a path to decompose the graph into a DAG.
Is all of Machine Learning dumb? (Pt 1)
Sure. I mean in all the real life projects I've seen from the inside, using ORM instead of SQL felt like roaming a forest on a gyroboard.
> Democracy is dead

According to the article the TPA's (and by extension the Koch's) campaign failed and the KentuckyWired project got the go ahead. Better funded, more powerful opposition lost a merits-based argument and did not get their way. This is an example of democracy working, wouldn't you say?
VMware server products launched in 2001 and EC2 launched in 2007. VMs were pretty widespread by the time the cloud hype struck.
I'd just like to be able to do things in less than like 20 clicks + mouseovers + impromptu game of "dodge the UI" + now do all that at single-digit FPS.

What the heck happened to their UI? It used to be quick, and reasonably useful. At this point, I'd rather go to Amazon and try to guess which search result (and on which page!) is the video I've already purchased.
If there weren't any forest rangers/firefighters organization to back-burn, then the lone person trying to do some good may be the only way forward. But for forest fires, such an organization does exist, and no-one should be burning by themselves.

There is no such organization for the internet. So we are left with lone white-hats who risk personal safety to do some good. I wish there's a better way.
Chainer Chemistry: A Library for Deep Learning in Biology and Chemistry
Motocross ATV Bike Racing Stunts
Get ready to play Motocross ATV bike Racing Stunts game, it is an amazing and thrilling game moreover the different environment made this game more interesting and addictive. Other ATV bike game is all about the race and speed but this Motocross ATV bike Racing Stunts game is different than other atv quad bikes game.
By this logic, no bad practices exist.
I think you might want to consider context-free vs bound actions and their respective moralities. If an action is wrong, when context-free, can it be right when context-bound?

"A kills B" wrong

"A kills B".bind("B tries to kill A") righteous?
> I will say that when Japan agreed to accept payment of taxes, with Bitcoin, they deemed it to be money.

I'm really interested in figuring out if this is true. What source is saying this? From what I can tell some taxes might apply to Bitcoin in Japan but in no way can you actually "pay" taxes in Bitcoin (you can obviously convert it to Yen first though).
Nice explanation. I appreciate that. But it's too late to lock the stable door because the horse had bolted.
Sorry guys.
Volvo cars and Volvo trucks are separate companies. Volvo Group sold Volvo Cars to Ford in 1999 and now Volvo cars are owned by Geely.
> But why did bitcoin become popular with American's in the first place?

Because it looked like a get-rich-quick scheme, and Americans like those as much as anyone else. More, in some cases, because there is a lot of cultural baggage in the US around the idea of becoming not just comfortable, but fantastically, fuck-you wealthy, from nothing, by getting in on the ground floor of some expanding industry or company.

People went crazy for canal stocks in the 1790s, railroads in the 1840s, industrials and utilities in the 1920s, Nifty Fifty in the 70s... and more recently, of course, dot-com stocks and then real estate. Lot of people out there looking for the Next Big Thing.

Most people in the market don't give a shit about Bitcoin as anything other than a vehicle for speculation.
Web Design Trends to Watch Out for in 2018
How Do Web Browsers Work?
Also Alea GPU [1]

[1] http://www.aleagpu.com/release/3_0_4/doc/introduction.html
+1 - personally I really like how SQLAlchemy doesn’t abstract away the database so much where all modeling and power is lost. He and the contributors have done an excellent job.
Where the Heck Is Microsoft’s “Edge?” (Left Behind for Dead)
Breakthrough in Alibaba Cloud Computing Capabilities
There was no danger of harm. In fact, though this was a stupid decision by the surgeon, I'm of the opinion that he should not be removed from his post.

He was proud of his handiwork and signed off on it. Have we enough skilled surgeons to remove them for a harmless boast? Reprimanded, sure, but removing him from his post is both an over reaction and unfair to society which is already lacking in skilled healthcare professionals.
Don't forget Growth and a big and growing Market to boot !
Often stated as "the rich get richer and the poor have children".
Large blocks scale just fine. Even with today's consumer tech we can have gigabyte blocks. It takes 0.8 seconds to transfer over a 10-gigabit connection. Storage is cheap, 4TB drives are under $96. Modern CPUs are incredibly fast at cryptography. And all of it is constantly getting cheaper.

And we won't need gigabyte blocks for a few years.

Then if you look at cutting edge tech, we can already do terabyte blocks.

https://www.reddit.com/r/btc/comments/7jtlm6/terabyte_blocks...

http://blog.vermorel.com/journal/2017/12/17/terabyte-blocks-...
I think that depends on your definition of "harmed". If I used a laser to burn my initials into your underarm in a place that no one would ever see it.... would you say that I harmed you?

Is it certain that a couple inches of laser beam scar tissue in a liver has not, and will not in the future cause any medical issues for the patients in question?
A New Sensor Gives Driverless Cars a Human Like View of the World
This is why taxing wealth is done at the time of inheritance.
Related sketch, "surgeon pranks": https://youtu.be/MR76R4gaC48. Doesn't seem as absurd now.