skysight-inc/HackerNews huggingface dataset:
And as specifically noted in that linked article you reference, it talks about how functional dependencies are a feature of SQL-99.

This aspect of the original article is really talking about how MySQL decided to implement a more up-to-date version of the spec that many competitors when they finally addresses their deficiency (as well they should, finally being SQL-92 compliant in the 2010's wouldn't really be anything to boast about).
> As a result, every mainstream concurrency framework I know of simply gives up. If an error occurs in a background task, and you don't handle it manually, then the runtime just... drops it on the floor and crosses its fingers that it wasn't too important.

You ought to look into Erlang and Elixir on the BEAM vm/runtime. It's arguably the best example of this kind of concurrency (greenthreading, async) done properly with regards to error handling.

I don't write Elixir or Erlang, but I believe this process is managed by the supervisor. You can select various behaviours for when a process crashes or errors out[1]. For instance, you can have a process simply restart after it crashes. Combined with a fail-fast mentality, this produces remarkably fault tolerant and long lived applications.

[1]: http://erlang.org/doc/design_principles/sup_princ.html
Seen this before, but it's very cool. The sector in the UK seems a lot better than Australia - here you need a minimum of $50 million in Tier 1 capital (share capital and retained income) to even start the process to become an Authorised Deposit-taking Institution.

Sure, banking is a serious business, but I think it'd be beneficial to have a special category for small startup banks only requiring $5 to $10 million or so, with adequate supervision etc.

The problem we have though is that the culture of our banks is rotten to the core, and dominated by four main players. The regulators (ASIC and APRA) are underfunded and mainly turn a blind eye to a lot of what goes on (mainly going after smaller financial services companies who can't afford the same kind of lawyers as the banks). We're only finally having a proper enquiry now after investigative journalists having uncovered a lot of this years and years ago, and most people are pretty shocked at what's going on.

I think the sector could benefit from smaller players coming in (hopefully with better morals), but the regulatory requirements are helping to protect the big banks' strangleholds.
That's all true And he was not licensed to distribute Microsoft Software.
Sure, my email is in my profile. Send me a message with what you would like to know and I will get back to you.
Would you rather the market or the government make that choice for you?
Not algo trading but working and learning to automate things as automation, speed and more sophisticated interfaces can help me a big deal. I made a six figures trading last year manually last year. I won't really put a light into the markets I trade and the strategies I use. But there is lots of money for small fish in this market.
this is so sad to see, +1 on the fu Microsoft
what worked for me:

Compassion - getting out of bed was a win some days. That's OK. This shit is serious, and you can die from it. Have some compassion for yourself.

CBT (Cognitive Behaviour Therapy) - finding my values and starting to live by them was the key take-away from this.

Meditation - mainly learning that my thoughts aren't "me" and that I can ignore them with no consequences. Especially the ones that replay every bad thing I've ever done.

Exercise - Some days I did no more than put my running gear on and get to the front door before heading back to bed. That's OK. I ran a 12km "fun run" (it wasn't) within six months of starting running. I still run regularly.

Finding something larger than myself to contribute to - giving with no expectation of reward is amazingly good for depression. Finding a community and a way of contributing to it was a life-saver. Literally.

Therapy/Counselling - ultimately, acknowledging that I was not coping, facing up to my demons, and working through my shit in therapy has got me out of it all and back to a place of mental health. I still talk to my therapist about my emotions once a week, and it still helps. I don't know why.

What didn't work for me:

Diet - I lived on 2 litre ice cream tubs. One a day, eaten with a spoon straight from the tub. Meh, I didn't commit suicide, so winning. I have just about managed to shed the weight I put on (seven years later).

Anti-depressants - I was on these for about six months, and they just dulled everything and gave me no way out. I think I'd still be depressed if I'd stayed on them.

I don't expect that what worked for me will work for you. You're going to have to walk your own path on this.

But... seven years later, my life is totally different, completely amazing, and I'm a much better person for having gone through it. It can be a positive experience. I look back and consider how many times I came close to suicide, and I'm so grateful that I managed to avoid that. I'm genuinely happy and enjoying my life now, and that seemed impossible back then. Just keep breathing, and things will change.

Best of luck.
Interesting that many states have laws mandating this for auto care.

I'm hoping we reach consensus soon that healthcare isn't somehow "special". It's just an industry, with incumbent interests, fighting to earn as much profit as possible, just like any other industry.
Private insurance still exists in countries that have universal health care. In the UK, for example, a little over 10% of the population has private insurance.

In the US today, about 50% of the population has free or extremely low cost health care provided by the Government. The majority of poor people in the US now receive 100% free care via State-administered medicaid.

So what exactly does universal health care in the US look like? Medicaid/medicare for everyone? Based on the UK experience, we'd expect 20% of the US to still pay out of pocket for private insurance. Private insurance companies would also likely be free to discriminate on prior conditions because, after all, everyone has universal insurance as a backstop.

You risk creating a two-tier system of public-private insurance where healthy, wealthy people have access to concierge preventative care and very fast specialist referrals, while the chronically sick (uninsurable) and non-wealthy are stuck in a publicly run system with less preventative care and worse referral and wait times.

I'm not saying I have the answer - just raising some issues that are often lost in the debate over how to reform this market. Personally, since the medicaid expansion, I don't think insurance coverage is the problem any more. Now it's about quality and cost of care. And transparency and competition certainly seem like two reasonable ways to tackle cost.
A bad actor could have commit and publish access, and is looking to make the library more popular before committing and publishing some kind of attack.
It wasn't thrown out, the judge ignored it.

Another commentor dug up more detailed information, which intimated that the defendant wouldn't have made $80,000 worth of discs that had no value.
I've worked in medical finance as a consultant, and a huge problem that I've seen is that although private insurance was originally intended to encourage competition, it has made prices much more complicated and opaque for the end consumer (patient).

Generally speaking, each hospital/practice/clinical lab has to negotiate with individual insurance companies to get reimbursed at a given rate minus "contractual adjustments" - this negotiation process is highly inefficient, given that each payer may do things differently (a contract with BCBS of NC may be different than one with Florida Blue), and smaller providers simply don't have the bandwidth or resources to have any leverage in this process.

The complexity of this ecosystem only hurts consumers and providers (and helps the payers, of course), and although many insurance entities call themselves "non-profit", I seriously question their motives.

It's almost reminiscent of the era leading up to the financial crisis of 2008, where complex derivatives, mortgage-backed securities, and other overly sophisticated financial instruments made those that worked in the industry fantastically wealthy, while the common people were left holding the bag when the stock market finally plummeted.

I hope we can find ways to simplify this system - the single payer system, for all of its flaws, seems like a step forward in the right direction.
I like to say that when you're feeling crappy, think of the one thing you feel least like doing and then do it. When I'm feeling down the last thing I want to do is exercise but, honestly, it's the best remedy for me. I find that diet has a lot to do with it as well. I avoid heavy foods and big meals in general as the lethargy felt afterwards definitely contributes to feeling down.
"do" expressions have been proposed as well: https://github.com/tc39/proposal-do-expressions

Babel supports it if you want to live on the bleeding edge: https://babeljs.io/docs/plugins/transform-do-expressions/

It would be kind of neat if JSX implicitly used "do" expressions in children expressions, though the ternary operator is already very useful in JSX, and more concise [1]

1. https://prettier.io/playground/#N4Igxg9gdgLgprEAuc0DOMAEBhCB...
The built in thread pools must have a limit.

Also, this isn't just a matter of keeping thread resources down, it's supporting scenarios like developing web and UI software.

For example, if I have "OnButtonClick" and it does async work, I'd like to also call other functions that may also touch UI components. WPF has support for binding async actions to UI events, and it eliminates the need to ever wonder what thread you are on.

In short, you can't "join" a thread on the UI thread. Proper async/await with a task scheduler is invaluable.

Also, C# has thread pools. Most people don't create a raw thread using "new Thread()". They would normally use "Task.Factory" or "Task.Run". If it is a long running thread, you can specify to Task.Factory that is it long running and it will remove your thread from the thread pool and put another one in it's place.
It's really a great book, but as a warning that got me if you're more of a paperback fan: it's GIGANTIC. I bought it planning to read it on the train to work. It never even occurred to me that the thumbnail might be hiding its true size ;)
Tsinghua Uni is big in everything, not only tech as "the official no. 1 university in the country by decree" must be. Not to say that it is also freaking wealthy, as much alike Yale Uni is in USA (through Tsinghua University Group Holding.)

No denial from me that that they do pump out high profile publications in amount enough to bruteforce themselves into ratings.

Think of them as a Moscow State Uni back in USSR times.

The few universities Chinese tech scene gives cred, are virtually unknown in the West, you will not find them on any rating list, but that does not preclude their students be "booked" years in advance by the industry.
Do such hospitals actually accept non-resident patients from outside the EU for elective stuff? I'm not sure about the UK setup, but in Ireland, private hospitals are able to save costs on the basis that if something goes badly wrong, they can just shunt the patient over to the larger and generally better equipped public hospital, which is often literally next door, at which point the patient become's the state system's problem. For instance, many of them don't have an ICU.

This works okay if the patient is resident or is an EU citizen, and so is entitled to be treated by the public system (though it's arguably an effective subsidy of the private system by the public system), but I wouldn't have thought it'd be feasible for non-resident foreign citizens.
Ask HN: What are some SoC programs in 2018?
A lot of organizations that do not get accepted into GSoC open up their own programs.
I noticed that too and PostgreSQL does have them. They're just named slightly differently: `json_object_agg()` and `json_agg()`.
People can die in the ER waiting room, without ever being treated?
I went to the test doc at: http://altoonabustest.psu.edu/buses/reports/480.pdf?15190591...

The relevant quote there is:

The interior of the bus is configured with seating for 39 passengers including the
driver. Eight seats fold away for 2 wheelchair positions. The manufacturer passenger
placard indicates that the test bus can accommodate 42 standing passengers. At 150
lbs per person, this load results in a measured gross vehicle weight of 43,540 lbs which
exceeds the gross vehicle weight rating of 42,000 lbs by 1,540 lbs or approximately 10
people. At this load, the front gross axle weight rating is also exceeded. All testing
performed under this partial test was performed at a seated load weight of 37,230 lbs.

My read from that is total weight, and only about loading to highest placarded passenger count, which using the govt. weight would overload the axle.

I didn't see anything that would change based on weight location or CG.

As with every EV vehicle it's about weight reduction while maintaining structure and safety margins.
AFAIK pattern-matching is not a historical Lisp feature, it's usually been limited to simple destructuring.

In the modern acception of tree patterns (as opposed to text patterns aka regular expressions), I guess it comes from ML (and possibly prolog but prolog's unification goes even further?): it doesn't look like ISWIM had tree patterns and I can't find older references.
Ubuntu even provide an entire OS supported with security updates free of charge for five years. Granted, they have considerably more developers and commercial support from Canonical, but most of these languages have some kind of sponsorship deal in the background.

Definitely Oracle being Oracle.
Not X1 Carbon but on new T480. Runs flawlessly.
> use inflated billing from paying patients

It's not even that. "Sticker price" is simply the opening of negotations, sam as with any big-ticket purchase like real estate and vehicles and school tuition, and to a lesser extent airfare and hotel rates.

As with any high-overhead business with room for high-marginal-profit on units, they simply seek to maximize total revenue or at least cover costs. They don't care which customers pay how much.
At a recent interview I could have swore I heard someone stifle a laugh when I asked when the last time they had an uninterrupted 4 hour stretch.
Absolutely!

The text of GDPR expressly allows companies to make you prove you are entitled to any rights you claim, though.
Wow, CCXT looks really nice, I'll have to dig more into that. Thanks for sharing.

To be fair, I didn't look very hard for a good platform. I was aware of a couple that I had heard about either through friends or tangentially through HN comments on other stories but when I looked into them they either looked super shady and untrustworthy (yeah, I know, judging the book by it's cover) or forced you to implement your strategy in their language of choice (one was Python, one was a proprietary script-y language) and I wasn't interested in that.

Surprisingly it wasn't as much work as you'd think. It started as a hobby on the side so I wasn't worried about building a full-fledged trading platform that supported every exchange and every imaginable strategy type so I was free to keep it simple and focus on the one exchange I had an account at (GDAX) and the two or three strategies I had in mind at the time.
You're right, I get those mixed up.
Waiting time depends on the type of emergency you have, its not a single number for everyone.
Obviously they aren't taking money from people who can't pay. They take money from people who can pay.
Meet the Father of Digital Life (2014)
They made that decision because it is cheaper, everyone else is doing it, and companies like Facebook "biggest open office plan ever" do it as well.
Mortal Kombat New Tab
Some have found success with Transcranial Magnetic Stimulation when traditional methods (meds, CBT, exercise) don't work.

https://www.mayoclinic.org/tests-procedures/transcranial-mag...
Do not ask here, go to the doctor. Depression is a symptom which can have different causes (I had a depression from social anxiety at a point in my life).

A good psychiatrist will treat the cause (for example, by recommending some therapy, like CBT), not just symptoms. And will not just prescribe medications, which do work quite well though.
That article is light on how they tackle the thermal aspects of NOX exhaust.

The key challenge to diesel engines is that the combustion is essentially a chemical reaction in vastly different thermal conditions depending on the outside temperature. Every engine has a "sweetspot" thermal range where they are really efficient in burning diesel fuel and washing out NOX from the exhaust fumes. Once you're outside that sweetspot, there is little you can do.
Ask HN: Why is everyone updating Privacy Policy and Terms now?
I have received many emails in the past week from companies updating their Privacy Policy and Terms of Service, far more than normal. Why?
You mean are there any other languages trying to quickly catch up to C++'s complexity?
Given the name difference it's possible that the semantics are slightly different.
It's unfortunate that union actions against hospitals often try to scare the public -- the patient base -- into staying away. Such actions have been known to backfire. Where I live an electricians' union tried this, and it generated ill will towards the union and good will towards the hospital.
I'd argue that the desire to appear infallible in debate is a facade to shroud the overriding desire to pay less in taxes no matter the human cost, coupled with a lack of empathy.
Considering that the OP wants to abstract the details away from the connection between the sensor and the Fill_In_The_Blank module the single most comprehensive resource that I have been using to teach myself embedded linux are the books by Derek Molloy.Look them up on Amazon.they are cheap and get you going in no time. His companion book sites are treasure trove of information too. He has a book on RPi and Beaglebone black.
Apple knows this, because they still sell it. https://www.apple.com/macbook-pro/specs-2015/
Did you just look at print? Talk radio has been hammering this since the late eighties. Hell you can probably draw a line straight from the "Moral Majority" shit in the seventies, to where we find ourselves now. I suspect this has always been a big part of American culture, but it's being magnified now either by new tech or malicious actors or both.
I don't see email in your profile.
Better than being good at any singular game, you want to be good at the meta-game, ie, across the set of all games. Because then it doesn't matter what gets thrown at you, you have a way of looking at it and dealing with it. This could be thought of as specializing in being a generalist.
Elixir's multiple function heads are just syntax sugar for a case statement.
Why? They still sell that model: https://www.apple.com/macbook-pro/specs-2015/
I'm unable to see that in your profile (looks blank to me). Do you mind updating it?
Oh. Apparently I don't know SQL nearly as well as I thought.
I'm 43 years old and I've struggled with chronic depression since I was about 14 or 15. It's been a long tough journey but I'm doing quite well these days. I will share what worked for me.

1. Go see your primary care doctor. Depression can be a symptom of hypothyroid and sleep disorders such as OSA. I have both and am in treatment. Rule those out!

2. Exercise! It makes a huge difference in your general sense of well being. It also increases your energy. I never liked working out, nor was I particularly good at weightlifting. I work out twice a week with a personal trainer. It's expensive but it's work the money. Having him there with me makes it more fun and keeps me motivated.

3. See a psychologist or psychiatrist. You might need medication depending upon how bad your symptoms are and how long it's been going on. But don't just go to someone who write you a prescription and doesn't do therapy sessions. Therapy helps a lot. I have found group therapy works really well for me. When it was first suggested to me I thought "no way! Why the hell would I want to talk to a group of strangers about my problems!" However, I've found it to be much more effective that one on one therapy.

4. Eat a good diet.

5. Take care of your microbiome. There is a link between the microbes in your gut and your mood. I use probiotic supplements like Align and Culturelle.

6. Find a hobby (and no, drinking and partying are not hobbies)

7. Don't try to "self-help" your way though it. If you broke your leg would you buy a self help book and try to treat yourself? Get the help you need from a qualified medical professional.

8. Get a dog. They provide you with unconditional love and endless amounts of joy.
Just an FYI, Apple still sells the older 2015 model: https://www.apple.com/macbook-pro/specs-2015/
You mean because insurance quotes your copays as % amounts, not $ amounts?
If your machine is within range of your enemy, then they could simply destroy or disable it before publishing (a single point of failure).
at least in the 80's a private hospital only had to bring a person to a certain degree of health. I had a gash and was taken to a private hospital where they cleaned and bandaged the wound but then told me to go to Bellevue for more work as I was not insured. Just came back from Thailand where I had a mountain bike accident where I spent 2 hours getting stitches in emergency room with next day followup and bunch of meds and total cost was US$400.00. That would have been more like US$4,000.00 in the U.S.
ThinkPads are a bit pricier but generally run Linux flawlessly.
GDPR being rolled out in Europe, taking effect next month. Good news for consumers, bad news for your inbox, I'm afraid.

https://en.wikipedia.org/wiki/General_Data_Protection_Regula...
Exactly. And it's pretty much standard practice for providers to expect you to just throw yourself at their (or your insurer's) mercy and only learn the price later. They don't even upper-bound the amount you might need to pay by default.

I don't know how a patient can be expected to make a decision in that situation -- either legally or economically.
I'm ok with saying that this guy violated Microsoft's copyright by redistributing Windows binaries, but the punishment seems egregious. 15 months in jail and a $50,000 fine? At most he should have been fined the $3,400 and given a suspended sentence.
The article from autoblog is far better:

https://www.autoblog.com/2018/04/25/bosch-diesel-emissions-b...

Everything in this article is pure marketing nonsense.

>Bosch says its technology uses a combination of advanced fuel injection, a newly developed airflow management system to recirculate exhaust gases, and intelligent temperature management, and it requires no additional new components. It says the technology drops nitrogen oxide emissions to one-tenth of the amount set under the stricter 2020 limits for Europe, even in real-world driving conditions. Bosch says the results hold consistent regardless of driving conditions, weather or how aggressively the vehicle is driven.
Synchronized Swimming of Sea Monkeys
Latency Numbers Every Programmer Should Know (2012)
Why hospital even need to negotiate with insurance company? Can't they just set the price they deem reasonable and then let the patient and insurance to work out the payment within themselves .
That one liner has a lot going on. The first one is easier to read.
wouldnt you rather do something to earn money?
> The problem isn't the court, it's the law.

>The judge said he disregarded Weadock’s testimony. “I don’t think anybody in that courtroom understood what a restore disk was,” Lundgren said.

Oh, I think there was a problem with the court.