skysight-inc/HackerNews huggingface dataset:
Errata: there's a shortage of skilled labour for these working conditions. Said budgeting is not set in stone, and as long nurses and whatever else professions can vote with their feet (by leaving the profession) no amount of politics-led finger-pointing can replace a real-world change in the healthcare policies.
Ask HN: Best way to generate product analytics SQL?
I've always used Amplitude / Mixpanel, but lately there's some queries that I just can't get out of it.

- Conversion funnels, grouped by user properties identified later in the funnel.
- Highly specific cohort retention
- Automating reporting into Google Sheets across weekly/monthly/quarterly.

Feels like I finally need to bite the bullet and learn SQL after pushing it off for a decade.

Anyone have links to services that generate SQL queries for common product analytics queries? I'm finding various blog posts, and a lot of enterprise-targeted BI tools.

Is there any tool that, given a schema, pops out queries? Like June.so for product analytics SQL queries.

Rakam looks similar to what I want, but it got bought, and seems to be EOL.
You've forgotten the ~$30 reimbursement for returning the broken part.

Honestly though... what did you expect? Apple said the parts were sold at the exact same prices as their AASPs and their own stores. When you already have the tools, that makes a ~$49 margin for the Store or AASP for a display replacement, a healthy reimbursement of labor and time. Did you expect to save hundreds?
"Recession" is a bit ambiguous. To identify winners and losers in any economic climate you need to consider the specific factors at play, and the winners of previous "recessions" may or may not be winners in the next.

In this case _my_ assessment is that we're facing a prolonged period of high inflation partially fueled by factors which can't be mitigated by Fed actions (COVID lockdowns in China, global transportation backlogs, European conflict, food shortages) and perpetuated by high household savings levels. I don't think we're going to face significant slowdown of consumer spending this year.

In that economic environment, consumer staples which do their own production and have the ability to quickly respond to inflation are favoured. I'm in a sector ETF for this.

I also believe profitable tech which is ad-funded is at an advantage - anything where prices are set by auction and ROI is demonstrable/visible is golden, as are industries like cloud computing which have natural deflationary economics. This implies Meta/Goog/MSFT (and in this I'm betting on specific tactics and am choosing specific companies).

Those are my bets, you should form your own hypothesis and extrapolate appropriately.

Also note that these are systemic factors, but will always be dominated by idiosyncratic realities. Individual stocks are only loosely correlated with sector movement, if you think you have a winner or asymmetric knowledge about a specific company don't let larger trends dissuade you (or vice versa).

Finally, a corollary to the above:
when you invest on macro/sector trends, do so through sector/strategy ETFs. If you're investing on asymmetric knowledge or insight, invest in specific equities. Combine the two strategies at your peril.
At a lot of schools, you can take CLEP tests to get out of (especially) 100 and 200 level courses. Take the test, pay a (somewhat lower) rate for the credit without taking the actual class, and it's done.

If you're capable of completing 5 semesters worth in 2 semesters, you're probably capable of passing several of those tests with only a little studying over a Summer.
To me, the thing that jumps out is the "our". That's not the normal way an HN comment would be written. If it's not a bot, it's someone speaking for a group - a publication or a company. (Of course, a GPT3 bot could have lots of that kind of writing in its training corpus.)
Loodio means "I hate it" in spanish, so I'd suggest a change of name.
I'm a bit similar. I always did poorly in school working at the pace that the teachers wanted me to go. I would do well on the tests, but always had awful grades because I didn't do all my homework.

When I discovered WGU 1.5 years ago, I did much better simply by being allowed to go at whatever pace I felt like, and taking time off when I felt like it, and I managed to get through school in a fairly short amount of time.

I'm doing online graduate school now, and fortunately my supervisors are somewhat amenable to this style; they simply give me a bunch of recordings of their lectures and all the assignments that I'm expected to do all at once. Some days I don't do anything, other days I'll spend six hours straight watching lectures and doing homework.
Not GP, but I think what they meant is having a MX record with a higher priority pointing to an unroutable IP

blackhole IN A 240.0.0.1

@ MX 10 blackhole.example.com
@ MX 20 mail.example.com
Birder here, who's somewhat plugged in to this. Essentially nobody of any repute that I've come across believes there's any merit to these claims (sadly).
Honest question: why do it this way instead of just hiring employees/contractors to do the stuff needed on your private property? Presumably Six Flags still has people picking up litter without needing to have the power to levy taxes, so why not Disney World?
You just put the problem into focus. Trump pushing the lab leak hypothesis and using the term "China virus" is indisputably a xenophobic dog whistle to a racist subset of his base. But that doesn't mean the lab leak hypothesis and any discussion of it is racist, and based on what's been uncovered since, it's certainly not a baseless accusation.

Trump has used this tactic effectively many times in the past: he says something that makes sense ("we need border security") in such a racist and distasteful way that causes the opposition to kneejerk react against whatever policy he's proposing, forcing them to take a position that's at odds with common sense ("border walls are racist!"). It's possible he may have had some classified information about the lab leak being a feasible story, but I also wouldn't be surprised if it was just one of the thousands of things he blabbers uncontrollably about and this particular one luckily happened to have some truth to it.
For a Datalog program and a specific database, there is always a finite set of facts the program can possibly derive (that is the “finite grounding” from above), obtained in the following way: for every predicate that appears in the “head” of a rule (i.e., any predicate for which facts are potentially derived by the program), instantiate it with all combinations of values that occur in the database or (as constants) in the program (the so-called “active domain”). In general, this will be exponentially many facts (with respect to the size of the program), and polynomially many facts (with respect to the size of the database).

Entailment in Datalog is monotonic in the sense that once a fact has been derived by the program, no further rule application can invalidate this fact (this is no longer true when adding negation, and is indeed what we recover by stratifying).

Taken together, this means that you can always compute all facts derived by a Datalog program on a database by computing the least fixed point under immediate consequences (roughly “apply all rules and add the derived facts”; this approach is called “naive evaluation” in the literature, in practice, more optimised evaluation strategies are useful), and you are guaranteed to obtain this after polynomially many (with respect to the database) or exponentially many (with respect to the program) steps – every step derives at least one fact; once you have reached a state where there are no more immediate consequences, you have derived every fact that you will ever derive and can stop.
> Almost all the makefiles that I have ever seen used in open source software projects are in my opinion horrible garbage

I mostly agree with your post, and I use Make for my own projects. But, I think there's a reasonable argument that if a tool is so hard to use that no one uses it correctly, it's not a very good tool.
Patients have always been entitled to make decisions about their bodies. You can decline procedures, and treatment, and you can get second, third, fourth, fifth opinions. Satisfaction surveys do nothing to increase that autonomy. The dystopian world you speak of is a straw man.

The problems stems from people believing they are consumers of healthcare, on equal footing with the practitioner they are seeing. They're not, objectively. A 45 minute Google search doesn't equal 4 years of college (usually in something like biochem but not always), 4 years of medical school, 3-7 years of residency training and potentially another 1-4 years of fellowship training. If you're seeing anyone above a family doctor/PCP, they 100% know more about your condition than you do, whether you've been living with it for a decade or not.

That doesn't mean you don't have autonomy, or that you shouldn't question your doctor's decisions and ask for explanations, but it does mean you should err on the side of thinking the person whose spent at least a decade, but probably closer to two, educating themselves to get where they are probably knows what they're talking about.
> A corporation being granted the permission of owning an entire chunk of the American public's land and taking over all local and state governance for itself is also rather unconstitutional.

Is it? What provision(s) of the constitution does it violate?
Maybe that's regional? In my area (Minneapolis/St. Paul metro), there are tons of independent dentists and few conglomerates (at least that I know of). In my little-ish suburb (25k people) there are no corporate ones but about 6 independent ones.

I go to an independent office (2 dentists) and I've never felt pressured by them and they've even said things like, "It looks like that may turn into a cavity, but we can wait and see what happens."

Obviously I'm not saying it doesn't happen, but like anything, it's not everywhere.
That's a very disingenuous way of putting it. There is a lot more at play here that just "special privileges". There is the increased tax burden on the surrounding counties that will now be responsible for upkeep/services/etc and the fact that this was very clearly backlash motivated by the company voicing support against the recently passed "Don't say gay" bill. Further more from what I can tell this was a mutually beneficial arrangement, it wasn't just "special privileges" for free.
I run my own mail personal mail server, and do my own spam filtering. Things that are likely spam get delivered into a spam folder for the occasional review, but things that are extremely likely get rejected entirely (with a "spam rejected" message).

I guess my feeling is: if I want to quarantine suspected spam without telling the sender, that's my prerogative -- why does the sender get any say in this?
I have a Shelly Plug S connected to my PC Speakers, which connects to my InfluxDB 2.0 via MQTT. The speakers use 11 Watt on average, even if turned off, which amounts to 96.10 kWh per year. In Germany, that would be 37.48 € (39 cent/kWh), or 31.51£ - only one device turned off.

Now, I still leave it on, because turning a power adapter on and off 365 times a year may also render it useless after a while. I was actually thining about this recently, and whether I should use the Shelly to turn it off automatically, but did not reach a conclusion so far.
Nurses leaving the field is only part of the larger problem.

Nursing educators aren't exactly a dime a dozen. The average age of a masters prepared nursing educator in the us ranges between 56-62. Doctorally prepared is higher. The country is facing a nursing shortage, and a nursing educator shortage.

Now my doctor has an interesting theory that some of the pain points for nurses is being created by the hospital systems and industry themselves as an excuse to say we dont have enough nurses and bring in nurses from other countries like the Philippines, as they'll be glad to come to the US and work for less, and will be so grateful for the opportunity that they'll go along with whatever the hospital says they need to do. (This was in the context of vaccines.)

The other thing that has nurses worked up is recently is this case:
https://www.cbsnews.com/news/radonda-vaught-nurse-guilty-dea...
"Guardian analysis of 100 top US companies percent change from the most recent reported quarterly profits to two years prior."

Wow. Incredibly misleading journalism. This is terrible. They are comparing today with April 2020. Seemingly arbitrarily. I wonder if anything was going on in April 2020 that may have depressed the net profits of companies like Chevron (on their list). Wasn't oil at -39 dollars per barrel in April 2020? Chevron doesn't even set or raise prices on the cost of a barrel of crude oil which contradicts their entire point anyway.

I know the Guardian has a certain bias but this is basically misinformation with data.
It's not surprising, it's just unconstitutional
Tried a lot of settings, but with enabled network I never got the standby power consumption down. It should also be expected that the TV uses the advertised amount of energy in standby mode with the default settings, which was really not the case for me.
And don’t get me started on this „might increase power consumption“ message. This might actually not be Sony‘s fault, but the EU‘s, but it really gets annoying when it pops up all the time.
>I had a friend who I suspected of having sleep apnea. She called her doctor and asked for a sleep study

It doesnt sound like the situation has improved. Without a friend like you, would she have received treatment?

I think the community has gotten better at addressing the undiagnosed sleep apnea epidemic. When I needed help, there were some discussions about it on forums that I could find with the right search terms. Now, it's become much more common knowledge on the internet that people can spot it in others. which is fantastic.

The Doctors still seem to suck at it. For starters, fatigue is possibly the single most common symptom of disease - and is not something proactively asked about by doctors (in my experience). Every doctor at every check in should be asking "How tired have you been?". The fact that you can notice apnea in your friend before trained professionals even suspect to ask about it is the problem.

And the bigger problem is that even if we address this for apnea, how are we to know how many other issues are going around waiting for the patients to bring it up themselves? I certainly no longer trust that proactive diagnostic due diligence is being done on anything other than blood test result levels.

Doctors rely on patient complaints to govern their behavior. full stop. Check-ins and physicals are way more superficial than most patients understand, imo. Still very helpful, but not nearly enough
GitLab team member here. Thanks for your feedback.

The blog post shares more details [0] on the logo iteration:

> The new logo places GitLab at the center of the DevOps infinity loop.

[0] https://about.gitlab.com/blog/2022/04/27/devops-is-at-the-ce...
With all the insiders on HN, I also haven't seen anyone saying "yes, we listen, here's how to verify, and here's where it's allowed in the TOS."
You're spot on. This pattern is emerging across many structures. Efficiency is inverse correlated with resiliency. JIT systems have spread over the globe but they don't handle shocks in the pipeline very well.
This is awesome! I've been wanting something like this for a long long time and am thrilled I didn't have to build it myself
I thought about going to WGU instead of a community college/transferring to a private/state school to earn my bachelors, but after starting to apply to WGU it literally seemed like a diploma mil to me. There would be WGU recruiters constantly calling me etc. and overall didn't seem legit to me. So, I decided to go to school for 4-6 years instead.

I wonder if places like RenTech would hire someone with a degree from rentech. I think that the DoD hires folks with degrees from UoP, so I'm not surprised they would. I saw a few folks on Linkedin work at Amazon with degrees from WGU and on their website they list that a few students got accepted to grad programs to Harvard etc. [1].

https://www.uopeople.edu/ WGU reminds me of the uopeople which is in the process of earning regional accreditation.

1. https://www.wgu.edu/alumni/career-support/education-and-prof...
> I strongly believe that only physicians should be running hospitals.

More than that - hands on healthcare should not be a for profit industry. The need to make profit is fundamentally opposed to providing the best care. As the push for profit increases, more people get sick and die. This goes for long term care as well, which is facing a similar staffing crisis for similar reasons.
> the prior distribution is a Bernoulli distribution

No, it isn't. The prior on the outcome of multiple tosses is a Bernoulli distribution, but the prior on the outcome of a single toss is a number. And for a fair coin, that number is 0.5 before you see the result, and it is either 0 or 1 after.

Note that "This coin will land/landed heads" is a different proposition than "this coin is a fair coin." The latter is much more problematic because it is hard to define what a "fair coin" is.

> your prior probability distribution was more complex

No. You are confusing my prior on a single proposition (a number) with the set of priors on all propositions which I have considered in my lifetime. The latter is obviously a set of numbers, one for each proposition.

> "the coin landed heads but I mistakenly observed tails"

Yes, that is two separate propositions:

1. The coin landed heads.

2. My senses are reliable.

All evidence must be assessed relative to some "background model", a set of propositions whose priors are very nearly 1. And it is also possible to model an infinite family of propositions about continuous properties, e.g. The length of that rod is between X and Y for any two real numbers X and Y. But none of this changes the fact that for any single proposition the prior is a number.

> it could not be represented by a single number

That depends on what you mean by "it". The probability that the coin landed heads certainly can be represented by a single number, as can the probability that the coin is magnetic. Two different propositions, hence two different priors.
I went to an undergraduate school with a fairly large nursing program, and interacted with a fair number of nursing students. One thing I noted was that a large proportion of nursing students were first-generation college students from lower-middle-class and working class backgrounds. I suspect that the meme of nursing being "well paid" stems from the fact that it is a step-up in that context.
It's a political stunt for DeSantis
I had all that setup from day one and still ended up in the GMail spam and banned by Microsoft/Outlook.com (which also includes anyone using Office 365 in their workplace for mail)

I assume that's because I had no reputation, although I did start on a DigitalOcean VPS before I learnt about their terrible ongoing reputation for ignore abuse reports. [1]

[1]: https://discourse.mailinabox.email/t/digital-ocean-ips-being...
Certainly, although I find subject-based subreddits are a lot less tolerant of a lot of that BS.
Some just leave to stay-at-home, some go back to school and a lot will take early retirement.
Even if one setups everything by the book (SPF, DKIM, DNS.) etc. No one at @outlook.com will receive email, based on my experience. Thus, it does not work well if email is important for business-to-business use.

Outlook and Gmail are basically having opaque rules who can receive email and there is no process to get “whitelisted” on these receivers.
0% as my house is mortgage free but probably 5% annually towards property tax.
Ask HN: Best way to learn about payments ecosystem
Hi,

I understand that the best way to learn about payments ecosystem is to work in it. However, I am trying to learn as much as I can by reading, googling, and networking about the payments industry.
Is there a course or certification that you would recommend to establish me as a valuable resource in the Payments Ecosystem?
As an example, a thousand channels of 16-bit samples at 48 kHz adds up to 768 Mbits/s, which is well within USB3 bandwidth many times over.

1000 channels is a rather small array, though. 5000 is still not too much.
Does this mean I can ewrite a web app, put the source on GitLab and have GitLab run the web app (ideally with very minimal hassle)?

If not, what does it mean? What is Gitlab letting me do now than (a) it didn't do before (b) Github doesn't do?
> a used up battery has near-zero value and probably less than it costs to ship it back in an individual box

That's if you look at it on an individual quantity. In volume quantity there may be other considerations at play.

> This is clearly a bad-faith effort to make stocking up on parts impossible and make the entire process more inconvenient than it needs to be.

Give me a break !

For a start, this isn't a "parts stocking" programme, it is a self-repair programe. You obtain relevant parts on a Just-In-Time basis. Jeez !

If you want to stock parts, go become an Apple Authorised Service Provider. You even get a credit account so you don't have to pony up the cash up-front.
> Purchasing decisions are made based on the monthly payment.

Yep, this made the decision for me. Do I pay 30% more rent to move into a basement? Or 50% more mortgage for a full, freehold house outside of the city?

I like living in this urban area, but a hybrid commute from a small town with the bare amenities is not bad either if it gets me a house.
It would be more interesting for sure but dedicated privacy tokens have too low of a marketcap, for now. Bitcoin is decent with Taproot+Schnorr and Lightning and bridges but you really need your own nodes and Tor. Ethereum with Tornado Cash is okay, you still need Tor OR your own locally hosted node there, as unlike Bitcoin, Ethereum nodes don't know which node saw a transaction first which means privacy. But if you send your transaction to a datacenter then lots of people in between know you did. The bridges let you access the Ethereum and EVM ecosystem.
You started self hosting before Gmail was a thing. It’s completely likely that Google has had you whitelisted since the inception of gmail when they were far more open. The “reputable IP” is the hardest part of delivering mail reliably; and your post says the equivalent of “just have your dad gift you a reputable IP from the 90s”
My wife (ER/Trauma RN) feels the same way. They will need to double the pay of non-travel nurses to get through this.
See also: California’s plan to eliminate algebra 2 and calculus from the highschool curriculum. It is being spearheaded by someone without a math degree, in the name of improving marketability of the kids for data science positions, or something.

See also (2): Monty Python’s bicycle repairman sketch.
If you live in the Netherlands (or Belgium/Luxemburg/Sweden) and have a smart meter it is fitted with a P1 port according to the DSMR (Dutch Smart Meter Requirements). If you connect it to a RS232 port (and pull some pin high depending on the version) it will dump a ASCII "telegram" every 1 or 10 seconds (depending on version) with all meter readings, current usage/delivery, gas meter readings and some other stats like frequency and phase voltage. It's very useful in determining your current power usage and "debugging" vampire drain. A good starting point is the HA DSMR component page[0].

I personally log the metrics to Prometheus so I can graph them over time with Grafana. For groups/devices that don't have a dedicated power meter attached I sometimes do a run where I switch off all the breakers and then turn them on one by one. The live power usage output is really useful to quickly determine how much easy group is using.

[0] https://www.home-assistant.io/integrations/dsmr/