skysight-inc/HackerNews huggingface dataset:
You can say that again! I started a DB review team at my company. Not only queries, but Postgres allows for tables to be commented on, you can place a comment on table, columns, constraints, domain, triggers, view, pretty much anything.

Initially a few folks rolled their eyes at that, but now everyone loves it. When you have thousands of tables, comments help, likewise when you have massive amount of queries. I'm also in the camp of let the DB do the work if it can do it faster, and likewise have 100-400 line queries that will turn into 5x LOC programs which take 20x time to execute. Writing tons of comments is important. Usually the query is right and when it works, no one remembers it for a year or two till business rules change.

My approach to commenting such queries after modification is to delete every single comment and start afresh. From memory, when I'm done. If I can't then I have no idea what the query was doing which is very bad. Sometimes folks modify query and get a happy result. If I can document it without reference to old one, great! After that, I look at the old one to make sure that I'm not missing anything.
I like this! Had never thought of it that way, but you are correct I believe.
hello,

does it enable HATEOAS?

tks
Can you explain a little how the banks are doing this? By making it too easy for people to make poor financial choices? Or something more nefarious?
Amd64 Technology Speculative Store Bypass Disable [pdf]
That’s the point. You should never use string interpolation with strings defined at runtime for SQL.

Always build your queries out of strings defined at compile time and use them as prepared statements with parameters.
Nice and elegant. Boss is a hardware dude with a compatible rule of thumb: Don't use a micro until it has to do more than three things.
Why "just" ? It's incredibly more costly than having the injections being prevented at compile-time.
Median home price does not necessarily mean that houses are appreciating. People could be building larger, more expensive houses. Building codes may also add cost to a house. Homes didn't used to have to have smoke detectors all linked together, be grounded properly, have waterproofing, etc.
I am an engineer by day, then I run a few projects at night.

App isnt cryptocurrency, but the concept is to make ETFs spendable on a debit cards and peer to peer. App is a react-native javascript full stack with redux, php laravel and mysql.

We also run a charity, Kids In Kitchens and I run Efficiency is Everything.

Drugs? I cycle caffeine and weed every 3-4 months to maximize productivity. Been doing this for about 3 years and I can pull off a 70-80 hour work week. I sew clothes for recreation/withdrawal periods.

I'd give my lifestyle a 9/10 or 10/10. My programming skills automated lots of my day job and I really like my SO.
Still no SVB support for Plaid, which most tech companies use :-(
Facebook management moves around but people don’t leave
I recently asked a similar question of a co-worker who works with our AR/VR initiatives. He recommended

https://uploadvr.com/

There also appear to be some pretty active subreddits in this area:

https://www.reddit.com/r/augmentedreality/

https://www.reddit.com/r/virtualreality/
This is especially common in data warehouses, as the dimension tables need to be populated with all of the attributes that a user will be searching/drilling on (including dates). I don't think I've ever come across a transactional system with a dedicated date table -- you usually have access to a good suite of date-manipulation operations in SQL -- but maybe there's a case for it.
How I choose software
At the end of the day, researchers need some way to decide which papers they should read and which they shouldn't. There are too many papers coming out for anyone to read them all. The fact that prestigious journals have a vested interest in not printing crap papers is a helpful filter when deciding what to read.

I still think there should be some reform in this area but the journals do provide some value at the moment.
Trained humans can maintain a speed of ~20kph for hours (as in plural). Peak speed for a few seconds (which is what would be required to escape these animals if reaction time is not the problem) is ~50 kph for humans (but only for 10 meters or so).

Apples to apples, humans are far superior to these speeds. The best animals for these measurements do crush these figures (by a factor of ~3), but I would expect that the best dinosaurs wouldn't.

> Very large animals are effectively warm blooded by default due to volume to surface ratios cooling is a much larger problem than staying warm.

True, but being "very large" does not really help with either top speed or explosive power. The fastest animals are small (though not tiny, a decent-not-huge dog in size but much lighter) brittle little things. They chase, rapidly inflict a mortal wound, and run away, waiting until it is abandoned to eat. Fast animals, from cheetahs to rabbits are much lighter than their appearance would suggest. The animals with greatest endurance are larger, but humans are, perhaps surprisingly, pretty good at endurance. Clearly we, at one point, hunted like dogs do : not by outsprinting an animal in an intense fast chase, but by wearing it down for hours, slowly closing in for the kill. Most animals should not be able to escape humans using that strategy. Human hunters would make an animal sprint for it's life 10 times, letting it "escape" 9 times.
It works by only allowing statically defined strings to be used for SQL /statements/, it still works for dynamic input.

https://en.wikipedia.org/wiki/Prepared_statement

The ? is a placeholder for dynamic values, the user input is bound to it.
He may have been a bit profane, but he's not wrong. Rich and upper-middle class liberals, particularly in places like the Bay area, need to take a serious look inward.
Yes but we're talking about mentorship in business. For what it's worth I only know one person with a 'mentor' in that sense and it's just one of his rich dad's friends.
As is mentioned in the comments of the article itself, this initial analysis ignores the fact that the median square footage has also increased dramatically during the same time period.
Very interesting. This would only apply to the largest of dinosaurs though, wouldn't it ? The kind that's just not ever going to chase anything.
But you can't just take the positive effects and call it a day. The fact that many people would not do that, and find it tacky, manipulative etc. when they notice, is just as valid as the fact it "works" on some as long as they do not notice.
When I was at the university, the ISO was freshly baked, what mattered was SWI and SICStus compatibility.

Pascal's issues regarding industrial use and poliferation of dialects were mostly fixed with ISO Extended Pascal, other than GNU, everyone else ignored it and focused on Turbo Pascal/Object Pascal compatibility instead.

Ruby and Eiffel happen to have ISO standards, but I bet even developers on those communities don't know it.

For a long time whatever ISO SQL was had not so much to do with what RDMS were actually providing.

ISO only matters if it is something vendors actually care about.
> Raptor is the only company selling Power in a workstation form factor, and of course they've got the lowest entry price.

Not sure if the AmigaOne X5000 board counts, but it might be worth looking here: http://amigakit.amiga.store/catalog/product_info.php?cPath=3... - the motherboard is also available alone.
Usually, when pad material adheres to the rotor, people call that "warped rotors" because it feels like the rotor is warped when braking. It's not usually uniform, I think.

As for expense, brakes are simple and the parts generally cheap, at least for mass-market cars. You can get a full set of pads and rotors for less than $100 from Autozone.
>> Furthermore, as a bona fide, credentialed expert in computer science

That's alright. I'm a credentialed expert in computer science myself and I'm also always right about everything, including entire scientific fields I know next to nothing about.

If you understand how computers work, you understand how everything that uses computers works!
Just do something really technically awesome in Rust that becomes hugely popular and the language will speak for itself. I've not seen that yet. But I do hear a lot of fanaticism. That's normally a bad sign.

Docker is written in Go. It works great and is changing how corporations compute. Where is Rust's Docker? It needs that sort of thing to stand on its own.

C++ has nothing left to prove. Yes, it has warts, but those have been and are being fixed (C++11, 14 and 17). Go is 75% there, as far as proving itself technically, and is approaching C++ in the, "what more is there to prove" department. Rust is more like D. Lots of hype and talk but only a few very notable, wildly popular things have been built with it. It has a long way to go.
That one strikes me as hindsight advice. As in, something happened to work well for me, so I'm listing it as advice for others, even though it's likely not really actionable. Not quite "win the lottery", but for every ten people who seek a mentor, I'm going to guess that nine of them either can't find one or find one who doesn't contribute to their success.
It's easy to resolve this discrepancy when you realize these people are not actually liberal or progressive.
For AMD, in context of virtualization — you would need to also expose a new CPUID flag: 'virt-ssdb', which all hypervisor vendors will expose to guests on AMD hosts. More from the libvirt patch[1]:

Some AMD processors only support a non-architectural means of enabling
Speculative Store Bypass Disable. To allow simplified handling in
virtual environments, hypervisors will expose an architectural
definition through CPUID bit 0x80000008_EBX[25]. This needs to be
exposed to guest OS running on AMD x86 hosts to allow them to protect
against CVE-2018-3639.

Note that since this CPUID bit won't be present in the host CPUID
results on physical hosts, it will not be enabled automatically
in guests configured with "host-model" CPU unless using QEMU
version >= 2.9.0. Thus for older versions of QEMU, this feature
must be manually enabled using policy=force. Guests using the
"host-passthrough" CPU mode do not need special handling.

[1] https://www.redhat.com/archives/libvir-list/2018-May/msg0156...
‘Open Casket’ and the Question of Empathy
Well, what is a policy engine?!
The "other shoe" is that your children (if any) will have to move away to buy homes in the future.
Microsoft Azure Features and Benefits
To push the point slightly further: Floats, while realish, still have a discrete representation under the hood... We're still doing math (or at least, calculations) on a finite subset of the reals.
> Why would it matter? Are you operating under the assumption that they would then pass those savings along to the government? That's not really how privatization works.

Well, it would be if you imagine a perfectly competitive market for prisoner placement. That's not even approximately the current private prison situation, though.
Regressive Left.
They charge a fee for using their modem.
> That’s an interesting view. Do you own a business where you had to implement GDPR or is this theoretical?

I'm obviously biased because I work for a company providing CRM software. That said, that gives me a decent amount of expertise in the matters too.

Basically we need to get all our own customer-data and systems GDPR-compliant. Which I won't deny has been a reasonably big effort on our part.

But instead of only doing this for ourselves, we've put all this effort into getting our own CRM-software GDPR-compliant instead, meaning in the process all our customers get to benefit from this at near zero cost.

Basically: By using a modern, maintained and competent CRM-solution, you should get GDPR-compliance in your core-databases almost "for free". I won't push my own company here, but it should be trivial to find should you be curious.

If your CRM-solution does not help you provide GDPR-compliance, you should consider how serious they are in these matters and if you want to continue using them.

And if you don't have a CRM-solution at all (really?) it's definitely time to consider getting one, because that's going to be the absolutely best tool you will get w.r.t. ensuring compliance.

> Oh, and did you know that GDPR also affects the work of teachers, solo entrepreneurs, doctors and the like?

It affects stored and processed privacy-sensitive information. Why should certain professions or business-categories be excluded?
I think the appeal of sql builder apis is that they make it much harder to shoot yourself in the foot. If your queries are strings you can use placeholder syntax to avoid injection but all there is nothing stopping you (or a junior dev) from writing something stupid like "and name ='" + username + "'". If queries are represented with a separate datatype then it is much harder to put unsanitized user input strings inside them.
Great post. I welcome any alternative to HTML+CSS+JS. It's time we moved on from these [in my opinion] garbages.
I can't recall a joke about a President looking for an economist with only one hand. In economic forecasting there are mental models of the type: On the one hand, ... On the other hand. Polya how to solve list many ways to develop useful math analogies, but it seems that end result is not very satisfactory. I think that to make an intelligent decision you have to feel deeply involved in the subject, then some kind of unconcious force do wonders, it seems you can benefit learning or focussing in certain patterns, but I think that deep is better than breast. Also there is the theory of the hedgehog versus the fox https://en.wikipedia.org/wiki/The_Hedgehog_and_the_Fox
FabriKube – A framework for building Hyperledger Fabric blockchain on Kubernetes
I don't get the current obsession with sexism in IT. Are you not at all concerned about other fields such as nursing, human resources, and teaching?
That is the theory, sadly it doesn't work everywhere on the SQL statement.

So we always end up with a mix of prepared statements and string manipulation.
> Granted, those companies don't deal with people's health

This sentence of yours called to mind a counter-example:

Two companies traditionally in the "business consulting" trade, Atos and Capita, were tasked by the British Department of Work and Pensions with investigating the "fitness for work" of millions of British welfare recipients. Driven by expectations and probably bonuses for producing the desired outcome, they erred overwhelmingly on the side of "fit." A few of their "fit for work" examinees were undergoing intensive care in a hospital, at least one died on the day following the assessment. Apparently the assessment crew didn't even have a single licensed physician on board.

So here we had two typical "bean counter" outfits acting in a way that tragically worsened quality of life for many infirm and/or poor people.
Are we going to discover that Lisp is really a Python?
They could charge a trillion dollars for their software. I am not poo-pooing that. I am just upset with their practices in extracting those payments.
I have not had to contact Comcast since I had my own router replaced with the combo. When I did have my own router, I was able to have a tech come to my office and identify the issue (which involved cutting my router out and testing) Even though it was my hardware that was at fault, they did not charge me - probably because I opted for the combo? (not sure)

The combo router is not cutting edge - however I don't need cutting edge router technology at my business - I need reliability. We have two people in the office so our needs (even though we work "on the web") are not that great.

Check with me in a couple years, when my combo modem/router is even older and I need/want an upgrade. I'm not sure of that process - anyone been through that?
Do note that Facebook, like any large company complying with new regulations , have been in contact with EU representatives on their implementation, so the idea that this is a “bold” move on their part or they are doing something obviously illegal just isn’t true.
All those which are pledged to take initiatives to ensure full conformity with General Data Protection Regulation (GDPR). If a person doesn't give his or her agreement for operating their personal data by 05/25/2018 each self-respecting service owner or company or even a gambling database like https://bettingcasinoslots.com/20-free-no-deposit-bonus/ should permanently delete all the users' data.
Well, the problem with life that doesn't look like ours is that we'd find it very hard to recognise it as life in the first place, even if oozed to our doorstep and rang the doorbell. So it makes sense to look for habitable planets that could harbour life like ours first- because we're much more likely to recognise them if we can find them.

And knowing that life like ours has already developed on a planet like ours, it makes sense that there will be others like it out there, so we might as well look for them first.

I'm not saying that ET life can't be very different to ours, or develop in conditions radically different to ours- but it makes sense to start searching at the most likely place for the most likely thing, no?
Alternatively, people tend to simply ignore the sub dollar parts of prices as largely meaningless information.
College tuition and student loans are following the same track of turning us into debt slaves:

https://hornor.space/2020/snippets/tuition.html
That is complete nonsense, and all recognized studies back up that there are no behavioral changes in kids due to that. I've done it for two of our kids, and many friends have done it for theirs, and there are no changes before or after. In fact, studies show the exact opposite. Kids who sleep in their own rooms get more sleep than kids who don't. It's a win-win for everyone.

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3146354/

https://www.verywellfamily.com/co-sleeping-with-a-toddler-41...
>I feel like I've read similar comments on HN about cars and guns over and over. Seems odd to be preoccupied with cars and guns when most people don't die of either.

Cars are the #1 killer for people less than middle-aged (where age-related diseases take over). 30,000 people a year die in the US alone from cars, and it's even worse in other countries.

>Pneumonia, heart disease, stroke, COPD, pneumonia and lung cancer each kill more than cars in the first world.

Only for old people. For young people, the ones who really matter more for the future of society and the economy, cars are easily the #1 killer.

Here's a source:
https://www.everydayhealth.com/kids-health/car-crashes-the-n...

Guns are probably the #2 killer of children.
> We can see from the second chart that a median family home has been getting less and less affordable for the ‘median family.’ Whereas the median family could earn enough to purchase a home in just 2.4 years of work in 1970 (assuming 100% of their income went towards the home), it took the same median family over 4.3 years to buy a home in 2016, nearly twice the time and work.

This struck me as a slightly strange way to frame it, since the median buyer probably still has a standard 30 year loan. The ratio going up doesn’t mean it’s taking longer to buy, it means that people are no longer using the 1/3rd rule of thumb - buy something that takes no more than 1/3rd of your paycheck to pay down.

We definitely might be over leveraged as they suggest, but could this also be a change in the buying habits with the remainer of the paycheck? I.e., the other 2/3rds or one half... maybe on average the median buyer is on average buying small things like iPads rather than bigger things like boats or college tuition? Maybe the average median buyer is just saving less for the future, but believes that putting the money into their house is a form of saving (which is often true)?
> Ask politely and they'll say yes.

Or you can take Warren Buffett's approach and keep on bugging your mentor, even be ready to work for free so that you get to work with your mentor.
Amazon Teams Up with Law Enforcement to Deploy Face Recognition Technology
Not enough mathematics. A substantial chunk of these are derived by analogy from analytical domains which are kind of on the fringe between pure math and applied math, like game theory and financial theory. There, the models and their primitives being described are part of a more coherent body of knowledge that lets you apply the concept precisely.

I'm going to get a reply that "oh but reading this Farnam Street stuff helps build intuition" and you might very well be right, but this knowledge is only developed to its fullest extent when it's precise and considered deductively. Taking a microecon course made it difficult for me to stop seeing microecon for at least a year. Freakonomics wouldn't have been technical enough.
This more evidence that a hard consent is legal (from a conversation we had a few weeks ago on HN): https://twitter.com/maxschrems/status/998681336427827201?s=2...
Well, specifically for YouTube (what we were discussing above), you already can't skip some ads, while others you can only skip after some seconds of reproduction. Some ads even cut into the middle of the content, just as in TV commercials. And as it is part of the content delivery mechanism, my browser adblocker can't deal with it.

For the moment, youtube-dl works, but it is not ux friendly if you want to browse unknown or related videos instead of downloading a specific one / list.

I agree with the fear that the ocurrence of sponsored content, "educational ads", in-video placement and all those sneakier versions of ads, that you sometimes don't even notice, will grow a lot in the near future.
Isn't that why they used frogs DNA? To finish incomplete sequences as a heuristic?

Also: life uh... uh finds a way.
Most people know exactly what kind of people are talking about a taboo, censorship etc while it's not nearly true - and even if one would say it exists, it would be well distributed. Unfortunately it consistently seem to be an exercise in futility to try to get through to people like yourself. That's why it's extra frustrating when the derailing begins.

"proof in several areas in Sweden"
This is so obviously alternative anti-immigration media - and that's being nice - rhetoric, as most of your posts reeks of.

There is no nuance like: "The police has identified certain areas where segregation and economic hardship have made these areas extra vulnerable to furthering their hardship to crime, gang formation etc. and thus needs a multi-agency approach to stop this happening". In your alt-media view this is turned into a cocksure "proof of no-go zones" and more falsehoods (I've read your comments you know).
So the ratio of median home prices to median family income has moved from about 3 to about 4.5 over the last 50 years.

This is because the many manufactured things have dropped in price over that period of time. This has meant that families have more money available to spend on things that are not manufactured. Land is the epitome of something that cannot be manufactured, so goes up in value.

Here's an article on Baumol's cost disease which explains this: https://www.vox.com/new-money/2017/5/4/15547364/baumol-cost-...