skysight-inc/HackerNews huggingface dataset:
I think the best ORMs are those that just leave out the "Relational" part entirely. So... "OM"?

For example, in Go, I use Gorp, which has a Select() function where you pass in the SELECT query string (plus bound values) and the target type, and it loads every result row into an object of that type. So you can have an arbitrarily complex SQL query as long as it starts with `SELECT one_table.* FROM`. That's a marvelous design.

And when you have to do a query that returns results from multiple tables? Guess what, you just use the normal SQL module from the standard library.
How much it will cost you to develop an online marketplace like Wish
Sorry, I should have been more precise. Not all ORM's are designed the same, far from it.

Many ORMs are built using the Unit of Work / Data Mapping patterns. Such ORM's map your data into a separate domain model and manage this model for you. If your orm has something like an "EntityManager" it has likely implemented this Unit of Work pattern.

A key thing the Unit of Work achieves is to commit changes to the database in a single transaction. You often need to update multiple records in an atomic way within enterprise software.

You might not be faced with such challenges in a simple app, but in monolothic enterprise software it's a core feature of what a good backend server does.

Active Record-based ORMs or query builders aid you only a little in this task; they expose the transaction handling logic so much so that it starts to read as a normal SQL database transaction (and might only be cumbersome to use at worst). Here you, the programmer manages it, similar to a normal SQL transaction.

The Unit-of-Work based ORM is more intelligent. It manages the database transaction for you and figures out any changes that were made to the managed entities. In my experience all Java-built enterprise software (I used Hibernate, EclipseLink and Toplink) are designed this way and make heavy use of it. I've used it with Doctrine in PHP quite a lot, and my guess is C#'s Entity Framework is also built around such concepts. That is a big slice of the ORM market.

Here is where the state comes in; different parts of the applications contribute to creating a single database transaction until flush-time. You as a programmer should know when "flush time" actually happens and understand which entities were marked dirty. That is a lot of hidden state that is managed for you; it is in fact the core of what such ORM's do; managing state until it's ready to be flushed. To make it really advanced, powerful ORMs (the popular enterprisey ones) do a lot of caching too, at different times and at different scopes.

When tackling with such tools the distance to normal SQL becomes very large. I think that is where quite a bit of the hate comes from. It's become very powerful magic.

I've been in places where I had to really understand how this magic works to solve serious performance issues with it. I learned a lot, solving problems that shouldn't have existed in the first place.

I don't like magic. It makes me hide in the corner and cry a little.

My comment was targeted towards the UoW / Data Mapper stuff and much less so to Active Record ORM's.
Oh please.. I was a kid in Polesie in eastern Poland, huge forests all around. Played in the woods almost every day in the summer/winter vacations, never even encountered a wolf, despite them being there.

Stray dogs are a bigger threat. Rabid bats or foxes are a bigger threat. Ticks are a MUCH bigger threat. And if you drive a car - you're much more likely to kill a human being than all the wolves in the world combined.

50 years, whole world - over 211 deaths. ~5 per year.

> In the half-century up to 2002, there were eight fatal attacks in Europe and Russia, three in North America, and more than 200 in south Asia. [1]

For comparison, just in one year, just in USA - around 20-30.

> At least 4.5–4.7 million Americans are bitten by dogs every year and, according to the Centers for Disease Control and Prevention (CDC), 20 to 30 of these result in death [2]

Wolves avoid people.

There's something irrational in people's reaction to wolves.

[1] https://en.wikipedia.org/wiki/Wolf_attacks_on_humans

[2] https://en.wikipedia.org/wiki/Fatal_dog_attacks_in_the_Unite...
yes yes yes!
the point is NOT "learn sql"
you already know sql, FINE!

the point is: use sql, not orms!

migrations are best done in pure sql,
i'll contend that model-inflation is best done in pure sql also.

another thing: if the format is json, that's already a nested "joined" blob of usable data! it's what the end result of a sql join would achieve, the client often just has to drill into that data blob and everything needed for the entity in question is already there!
But we're not talking about holistic dating here. The paper only deals with "attractiveness". It's just one aspect - albeit a huge one - of dating.
I remember old feature phones which had a fancy light on the back, which started blinking whenever a call was about to come through. Was a pretty nifty feature when you were expecting calls ['twas a time when I used to give "missed calls" for a callback].
Hoe+werkt+nekstenose
When article says “plus or minus $500”, it’s not talking about the bid/ask spread on a given exchange, but the price difference from one exchange to the next, which is exactly what your own second link shows.

And sure, you can cash out, and see a number in a balance statement. How hard is it to get that cash out of Bitfinex into a real bank though? (I’m not even going to address the inherent hilarity of citing Bitfinex as proof that things are A-OK in Bitcoinia.)
Maybe. But if an institution were to accumulate $1bn of Bitcoin through exchanges, I'm pretty sure that would drive up the market cap a lot more than $1bn.
It almost seems like semi-rural areas are a better place to start, as they're less regulated (no "cable monopoly", no NIMBYs) and the properties are too far away to have the options of Cable/DSL.
This was actually a normal pressure cooker (early 90's in college, there were no Instant Pots way back in those primitive days).

Not sure it was necessarily contrary to "how it was meant to be used".
What is the difference between Selenium 2.0 and Selenium 3.0?
Any good library for matrix and linear algebraic operations ?

I would be interested in anything that can serve as good building block material that has a good set of primitives built in.
"You can have more than you've got because you can become more than you are. On the other side of that coin: If you don't become more than you are, you'll always have what you've always got"
-Jim Rohn

I believe that anybody who has put in any effort into bettering themselves knows for a fact one can completely change his/her own self-perception, and in-turn, their personality.
Yes, and if all your stored procedure is doing is execute a query and return a cursor to the result set, it's using just as much database cpu as with a regular query.
I am Deaf. In the night you would need to break into my flat, too, because the flash indicating the door bell is in the living room, not the bed room. Nobody and nothing disturbs my sacred nightly sleep.
Who would you suggest?

AT&T?

https://arstechnica.com/information-technology/2014/06/att-m...

Verizon?

https://www.fiercetelecom.com/telecom/verizon-sued-by-new-yo...

Comcast?

https://qz.com/213995/comcast-promised-poor-americans-cheap-...
Reality is, tons of doctors have all kinds of issues (my fiancee is a doctor in one of the biggest hospital in Switzerland). As mentioned - substance abuse, tremendous pressures at work and massive overtimes (suicides aren't that rare, some just quit profession or downgrade to become a nurse).

Ever thought that when you are admitted, doctor will quickly check youtube to look FOR THE FIRST TIME how to perform some minor (or not) procedure? Ever thought that patients would die or get seriously, permanently injured just because somebody forgot to do some checks? You thought that most senior surgeons are just workoholic egomaniacs, dependant on various legal or illegal substances that healthy person shuldn't touch, ever? And this is Switzerland.

In ideal world, you're completely right. In real world out there, where ALL OF US make mistakes all the time, including doctors, this is really 'meh' category that I wouldn't mind at all on me, as long as doctor's performance is consistently solid.

Maybe slap on the wrist in form of demotion / ban of practice for a year or two. Put a mandatory psychological treatment for true reason of this behaviour (we're society after all and should help each other, not banish them to hell for any mistake). Otherwise, if your would apply super high standards consistently across all staff, you would see plenty of people dying due to no staff in hospitals. Sad but real.
They are a barrier to further civilisation.
Now let's talk how Netflix "personalizes" Most Popular and Trending titles - on 3 different accounts I've seen there 3 different set of movies in each of the hit lists.
I mean lose at the polls.
SaaS Ecommerce Platform Advantages for Business Investment
They care about things that you cant alter, like the shoulder bone structure and jawline. And of course height
Thanks to the Citizen's United decision that Chinese transnational corporation has the same free speech rights to contribute to a political than an individual US citizen has. While a foreign country can't directly give money to a politician its trivial for them to use a cutout corporation to pass money and influence. And since we recognize corporations as people the US subsidiary of the Chinese cutout has full free speech rights and the ability to give effectively unlimited contributions to campaigns.
What a backhanded way of telling him to shut up!

1) This is a tech-focused forum.

2) It was perfectly obvious that he was being clever.

3) The analogy was quite amusing.

4) The analogy does ring true... and even this research paper concedes the point that personal change is difficult and has proven elusive.

5) I imagine that if a wealth of actionable research results existed on this matter, that personal change and growth would have become more accessible already.
Like I said, that may not have been the exact link. I was just showing you the product. I was doing a quick price comparison and did not investigate who was offering it at that price back then. That link shows an even higher price than I remember seeing at the time.
Startup founder records album of songs found in garage sale
HN is kinda my goto place on the internet, so I thought I'd post this here as well (though I know, mea culpa, it isn't tech related): https://medium.com/@dylanbaskind/another-life-recording-an-album-of-songs-i-found-in-a-box-at-a-garage-sale-bc6daa298b5
What is it about “Cat Person”?
> just learn SQL

This is great advice in general for everyone in a role that even slightly touches on ops.

In my day-to-day work, I frequently observe that knowing some SQL (esp. joins, and aggregate functions like SUM/MAX with GROUP BY and HAVING) turns you into some sort of mighty wizard for most people. They're trying to debug a problem in their service and not making progress for hours, and you just walk straight into psql, take a look at the schema, do a few SELECTs, and zoom in on the problem.

Yet nobody seems to consider SQL a valuable skill. I guess it's not buzzwordy enough.
"Most quotes are misattributed. Seriously, look this one up." - Marilyn Monroe
Why do you wonder about that? Is there any indication that this is changing?
Just wear headphones (2015)
Things you can't say in Silicon Valley (non-political version)
Some people aren't connected to the city's water supply does that mean the city shouldn't have built out the water system? The same could be said for schools, libraries, public transportation, etc.
Community Up-Voted AI Resources
>Honestly I think people are overreacting because they have absolutely no idea of anything about everything that's inside bodies. Having used coagulators and seen hundreds of livers (pathologist) and the eventual macroscopical but benign scars they get because of ("naturally occurring") small infarctii or such, this has really no consequences whatsoever. I don't know how it worked in this case, but there's a reason doctors are disciplinally judged by their peers in some countries.

You must be Dr. Manhattan. It's a big deal to us uneducated ants but you're enlightened so you can see it for what it is, is that right?

Actually, you are simply too arrogant to see it.
Note that the system was fully private for a while (Railtrack PLC), until they went bankrupt. I think it's going to be expensive whether it's public or private, for complex reasons probably related to "legacy" hardware. If it was fully deregulated then the operators would immediately shut down all the tracks within 100 miles of London to build houses on them.

I believe all European countries are required to have separate track and train operators for railways with some structure for competition in rail. It's just that most of them manage it better than the UK.

The UK telecoms industry was privatised and has ended up with BT Openreach operating most of the wires, leased out with local loop unbundling (LLU) to a variety of broadband providers. It works OK although not brilliantly.
Thank you for the link and explanation, I've learned a lot today.
No

https://caniuse.com/#search=Crypto
This list is under progress. Didn't think about adding licensing information for the helpers, but that's an excellent idea!
> A query builder aids you at constructing queries

... that you understand and can be sure are sensible.

> while an ORM builds queries for you

... that you have to hope are sensible.

That's one of the biggest flaws of the ORM for me - you have limited visibility of what it's doing to your DB.
Already happening, thousands of Venezuelans are migrating to Brazil. Some towns near the borders are already having trouble to manage accommodating so many families.

https://www.washingtonpost.com/world/the_americas/hungry-ven...
Would your solution be better for most people on average? Probably.

Would anyone have unlimited gigabit internet access for $70 a month (like I do)? Probably not.

So yeah, I realize the hypocrisy of being willing to pay taxes to help the less fortunate but not being willing to give up my precious gigabit service to help the less connected.
TablePlus Relational Database GUI
I didn't even know this was a thing. But perhaps, like YouTube Red, it never made it to the UK.
How does it differ from wire.com in terms of privacy? Besides, wouldn't you have to transfer the chatroom name over another chat service since it changes all the time and users have no identity of their own?
> Pick a project that inspires you.

As an inspirational story, I built my first programming language at age 12. It was closer to Brainfuck than to C, but I built a compiler (in Visual Basic) that transpiled to 16-bit x86 assembler (I learned just enough from assembler tutorials on the internet) and ran that through NASM.

I remember that I worked an entire afternoon (possibly longer) on a program that was the equivalent of

if (getchar() == 't') {
puts("you typed 't'");
}

because the language was so ridiculously limited, but getting it to work (and an actual .exe file to show for it) was immensely gratifying.

Thinking about it, that language was actually the only one that I ever finished. As I learned more about language design etc., my designs grew much more grandiose than my freetime permitted.
Personally I prefer "the poop emoji" since basically everybody I know knows which one that is.
The language might have been snarky, but you can see this sort of thing around here all the time.

I just find it strange because I never saw a liberal-leaning post to be called ideological boilerplate before.
"They merely moved their business to other exchanges"

The price crashed from like $1200 to $200 and it took years for it to recover. All those Moms and Dads and Grandmas who bought $10,000 of Bitcoin after Thanksgiving dinner hoping it would turn into $100,000 within a month will certainly get hit if the price falls to $1600 and doesn't recover for 3 years. All it takes is a change in the media narrative that scares away a sizable chunk of the market (say, institutional investors or mom and pops, or Chinese people)
I implemented a protocol that uses MtE on a CFB mode cipher. And that's why I asked that question.

Now, it seems like I may did it horribly wrong, I'm going to fix it right now.

Thank you!

EDIT:

After I read an answer[0] on StackExchange, I realized I maybe did it right (Because of the CFB mode is different than CBC). Looks like I need to learn a whole lot more before start that fixing.

Next time I'll just use GCM and save all these troubles.

[0] https://crypto.stackexchange.com/questions/42369/is-this-sym...
Ok, I'll put my theory here.

We have seen weird spikes in the past that looked like a speculation bubble and it has taken us a few days or weeks to understand their cause. They usually crash a bit but stay at relatively high levels compared to where they started.

One was caused by Russians discovering they could evade sanctions that way. Another one was caused by people hiding money in Cyprus discovering that it could be seized by the government.

For the current rise, my money is on the anti-corruption operation happening in Saudi Arabia. Whatever you think about the crown prince's true goals, the move is not just theater. Hundreds of billions of dollars are changing hands.

I suspect that what we see is half of the royal family's wealth being shuffled around in a hope to escape being seized.
Strategy Pattern revisited
Yes, I've just played around with it, even if what I built was fairly complex and well tested. I assume you are running with a lot of extra servers - you need extra capacity for the operations you suggest (they move data around right) that might amount to a constant 20% over provisioning from normal use at the times these operations run, obviously also adding and removing servers adds overhead too. It's not like a normal database with provisioning at all.

I'd actually like a mode where Cassandra made itself artificially slower forcing you to over provision and then removed said slowness during operations that need the extra performance.
More socialist leaning countries privatize infrastructure. For example Ontario power generation.

Is there conclusive evidence that privatization is worse?

It seems like an age old question. That there are positives and negatives. It's also politically expedient as it raises money.
There's also a small but non-negligible chance that you could have understood the paper because you know (part of) the underlying theory under a different name, using different notation and concepts but leading to the same results.
Are there non-subsidized railways that break even, what's their quality?

The problem with rails is the same with roads.

Yes, AnCaps/Libertarians/Voluntarists/goldbugs think that "yeah, if the State weren't meddling in the market, people would form a corporation to build a [toll] road/rail", but of course, the same network effects would lead to very fine roads between major population centers and abso-fucking-lutely nothing else, because why would anyone connect a mining town in Wyoming anywhere? The mining company will use big all-terrain vehicles on dirt roads and that's it. Maybe they'll lay a track for the coal itself.

And I'd even argue, that yes, even if rail operates at a net loss according to GAAP, that doesn't mean socially it is a negative. The same applies to broadband.

However, maybe ... maaaybe not everyone should live so far from each other, so infrastructure TCO and commute times and energy use (and GHG emissions) would be lower.
>Only if the false story was actually representative of some underlying truth, despite the specific details being untrue. You keep presenting your original post as representing some underlying truth, despite the specifics being untrue.

Well, if the underlying truth is: "the US has a crazily invasive legal system and is too litigicious", then I think the (untrue) story conveys that well.
Connecting Roku with Harmony Remote: How Easy or Difficult Is It?
This raises a question that I'm still wondering about. Matrix operations are useful for high-performance computing because a lot of useful operations can be transformed (with varying effort) into matrix operations. Hence, with access to a relatively small library of high-performance implementations of these operations, one can obtain good computational performance. This is certainly practical.

However, is the matrix formulation the best one, if we have access to a programming language (like CUDA) where we have more flexibility in how we perform computation? For example, while we might be able to express k-means clustering as a matrix operation, we might express it more efficiently by programming it directly.
> As a theoretical abstraction above the data-store

I worked on a project with a home-grown ORM (in C; it was horrible) that abstracted over both MySQL and Postgres ... except the overarching application required Postgres-specific column types and functions.
Temporary confusion is better than repeating the same mistakes over and over again because you followed a wrong trail.
The curse of the strategy loop diagram
It seems to me that this form of "public spanking" would really earn the opposite of what you claim for: when you leave the judgement to the crowd, you are basically fomenting hatred and revenge (because for some psychological reason in such a case every one feels entitled to have a revenge, even when they are not involved in the case), which in turns leads to a punishment that cannot be controlled any more. This is why judgement should be left to professionals that (should) take the appropriate time to listen to both parties, review the legal basis and take a well-thought decision, trying to not put too much feeling in it. I'm not claiming this works perfectly, but it is definitely better that leaving the matter to the crowd. There are many cases of people whose guilty-appearing position was overexposed, for example by media, later proving innocent or less culpable that the initial situation might have suggested, but condemned forever to unjust public shaming.

On the act itself, I am in the number of those who think this should be taken extremely seriously and it is good ground for losing the license and criminal charges. Scarring someone's body (against their own will) has been for long (and until a few decades ago) a sign of property and slavery, and although I do not think this was what this surgeon intended, it still must be considered an extreme humiliation. Also, a surgeon's professional position usually entails an important amount of responsibilities and power, so violation of the public's trust in them are very important matter.
The article does read mostly like sour grapes. "T-T... They're never gonna get that money anyway!"

Some examples are plain false (calling "thin" volume when several exchanges see a billion dollars a day).

If the point was that banks will not let you transfer out of the exchange, the exchange will hose you, or your tethers will prove worthless, then the article should have just made that point. BTW the first two are false, obviously no experience actually dealing with big money crypto. WRT to tethers they look like a fraud but only represent one inferior exchange.
Truth from Zero?
Completely agree, but I was responding to the comment that suggested men don't become teachers because they are afraid of sexual harassment suits
A scenario where the government makes crypto currencies completely impossible is unlikely, as that would mean that you essentially controlled all communication. There are many ways they can make it difficult, cumbersome and risky however, even on an individual basis. That could lead to a short term dampening effect on the global price until people figure out effective ways to get around the regulation in question.
Pressure cookers are pretty great, but I don't get why Americans got hooked on the Instant Pot specifically. We just use a stove-top model.