skysight-inc/HackerNews huggingface dataset:
Ask HN: BI Developers, how do you manage your queries/scripts
Hi experts,

I'm wondering how do you manage and organize your queries, in case you work as a BI/DWH Developer who writes a lot of queries (but no DBA type of work).

On my side, I'm using Datagrip and my workflow looks like this:

- A main folder for the product (say a game)

- Two Level I folders, one for dashboards and one for reports

- Many Level II folders, each for one project (say, a feature of the game that product team needs a dashboard or several reports)

And then i put all of my SQL/Bash/Python scripts and Excel/Tableau workbooks under Level II folders, and occasionally create Level III folders if it's a big project that spans more than 4 sprints (2 months).

However so far I find there is a major flaw of this method:

- Difficult to locate frequently-used queries. These are NOT boiler-plate ones (I use Datagrip templates for these), but usually difficult and hacky ones that can be used in multiple projects, or multiple times in one project.

I'm wondering how do you organize your files/folders? There must be a better way to do this.
I've been using Uvicorn for a couple of years on a whole bunch of projects and it's not caused me any trouble at all.
Honestly it doesn’t matter at all if it actually happened, that they could is unacceptable.

EDIT: To be clear, it's not the certificate revocation that's bad, it's that the certificate is required to distribute code and can only be acquired from a single organization.
Good point. I never plan to skip the difficult parts, and one of the things that I have learned, is to not ship too early, even if it means a delay.

In fact, I am dealing with that right now, on a low-level Bluetooth SDK[0] I’m developing. It works great on iOS (and I even have a shipped app, based on it[1]), but I can’t consider it “shippable,” until I have test harnesses written for the other three systems (I’m just finishing up the Mac one, now).

[0] https://github.com/RiftValleySoftware/RVS_BlueThoth

[1] https://apps.apple.com/us/app/blue-van-clef/id1511428132
Epic Systems – Employees raise safety concerns with return to work plans
Yeah, I have seen firsthand how paranoid big US companies are about doing anything with personal data specially media which is a good thing for users. This really slows down even simple analysis where you were looking at even a Yes/No output and makes some features impossible/hard.

But they are competing with companies now which don't have the same ideological issues.
Isis Attack on Afghan Prison Leaves at Least 29 Dead
I actually wrote a half baked version of this to replace the headline with a machine learning generated summary of the article. Headlines wound up being sort of long and clunky but I did like them a lot more than the sort of headlines being discussed here (the reason I wrote it in the first place). Maybe I should finish that.
That runs counter to the Trump administration looking into banning it.
The problem for microsoft, it's not a simply "fixing the auto formatting", but "changing how auto formatting behave". Nowadays the buggy auto formatting may be expected by some people and changing (fixing) it may distrupt their workflow (xkcd reference).

Moreover I don't think there are "best" specification for those auto formatter, even a "better" one.
Researchers explore repurposing drugs to treat Covid-19
While I use Redux, and I like the simplicity of the single application state and the reducer function. I don't see it as a good example of FP or even JavaScript.

The problem with Redux is that it takes many patterns that make sense in languages like Haskell or Elm but are not idiomatic in JS. For example, action types and the usual reducer switch statement is easier to write and extend in Haskell.

And is not idiomatic JavaScript either. It always baffles me that an action dispatch is a way of doing a method dispatch (and yes I know that unlike a method dispatch an action can be persisted, and broadcasted). But if you compare the boilerplate and concepts introduced by a simple action dispatch (action creator, action type, payload, thunk, middleware) with a simple method call, and you look at the benefits (late binding with the state, persistence)... I wonder why solutions like Zustand didn't come up before.

(note, I wrote state management code similar to Zustand for my personal projects, but one of the reasons to continue using Redux is that getting the Context updates right is hard... a problem solved by React-Redux with addition of nice tooling and collaboration from core React devs. As soon React adds fine-grained context state updates the reasons to continue using Redux for me are low).
Surely by moving the goalposts you can make everything look like a monopoly. In the end both mobile platforms have practically the same popular apps.
The Django Admin is Django's "killer app." If a significant portion of your application is a back-office CRUD admin interface, Django is perhaps the most productive way to build something like that without writing a bunch of forms or using something even more out-of-the-box {like a Drupal). If you become proficient with Django you can build custom CRUD admins very quickly.

For other use cases, there are better frameworks out there.
I think it is more or less the same in all EU:

https://eur-lex.europa.eu/legal-content/EN/ALL/?uri=CELEX%3A...

Here (Italy) you have the first check/inspection after 4 years (for a new car) and from then on every 2 years.
> What he names it is really none of Apple's business

In any AppStore app, everything is literally Apple's business, considering they get a cut of any money that changes hands and can reject your app for "looking at them wrong".

That's why the whole model is (rightly) controversial.
The article didn't have many details about the "For You Page feed algorithm". Any guesses as to how it analyzes a video, and which properties it looks at?
The Hacker Way: How I taught my nephew to program
Windows 10: HOSTS file blocking telemetry is now flagged as a risk
Are You Asleep?
Answer to What books should entrepreneurs read? by James Altucher
"The Winter Fortress" is a fantastic book about the Norwegian sabotage of the heavy water plant... really highly recommended.
These two sentences, I think, best summarize the article's position on the topic:

> Instead of taking the summer to hone arguments against returning to the classroom, administrators and teachers should be thinking about how they can best support children and their families through a turbulent time. Schools are essential to the functioning of our society, and that makes teachers essential workers.

Yes, and many teachers think that the best way to support children and their families is to not put them in a position where they might die. Part of their "essential" function here is in advocating for the safest and most effective learning environment possible. Right now that seems to be attending lessons remotely until it's safe to go back to schools.

That the author thinks it's the duty of teachers to unnecessarily put children in harm's way as if there is no alternative is nothing short of bizarre and I'm disappointed to see it published by the Atlantic.
The way I was taught was that back in the olden days, "group" always referred to groups of permutations (and the operation was always composition), and it was Cayley that introduced the much more general and abstract notion of groups that we use now. He could do that because it's relatively trivial to prove that the the two definitions are basically the same: every group is isomorphic to some group of permutations according to Cayley's theorem: https://en.wikipedia.org/wiki/Cayley%27s_theorem
I'd recommend joining new graduate programs that let you rotate in different fields so you get a flavour of what different business functions do. I'd also recommend joining a large consultancy where you can get a breadth of various work across different industries. Consultancies are terrible for work/life balance but you get exposure to all kinds of problems across all kinds of industries.

It may take you a while to find what you love but keep at it. You're still early and your career can take many directions at any time so don't feel like you have to choose what you want to do and stick with it. I started out in computer science, did software engineering, went into consulting, then analytics then worked in business focused on strategy, which then allowed me to become an executive leading ML teams.
I'm still searching for a platform in this space, where I as a learner can pick and choose classes from various hosts.
Ask HN: What is “Launch HN” only for YC companies/founders?
"Which server OS do you prefer?", should be:
- GNU/Linux: 55.5%
- Windows: 39.6%
- Mac OS: 3.8%
> Because the Chinese cyber threat is incredibly real.

Comment like this lumps tiktok, a privately owned company with the Chinese government with no evidence. It's never about national security but really about US politicians seeing a social network with real reach in the US that for the first time does NOT need to pay to lobby in the US, nor to be responsive to congressional inquiry (as they have been able to do recently with US tech platforms, accusing platforms of suppressing conservative/liberal views, again without evidence).

If you know anything about bytedance's founder you would know that he's been an outspoken globalist, criticizing the government's approach to free flow of information on multiple accounts. Uninformed comments like this is truly tragic for many globalist people in China who grew up hoping for a global stage with open, fair competition and who often do not agree with the government's perspective.
>* apple actually did communicate to them, but it went to the developer's spam box.

Isn't "check your spam box" the same thing you're going to do if you're looking for an email that you're expecting?

>* apple actually did communicate to them, but sent it to an old email address that the developer never updated.

plausible, but seems unlikely that'd be the case, considering that this is a semi-important account that you won't use a throwaway account for. Also, isn't your itunes connect (app store) login based on your apple id, which is based on your email?

>* apple actually did communicate to them, but it was via a developer dashboard that the developer rarely checks.

His tweet said that his account was suspended, so he probably found that out while trying to log in, or got an email.
Great survey but why on earth does there need to be a book about lambdas in C++???
Also, historically C# ran terribly on Linux, or had a bunch of gotchas when it came to interfacing with the rest of the MS ecosystem.

I don’t know if that is still true today.
My vision is for this to be handled by things like remoteStorage, Solid, or (if you must) Google Drive. I find having control over your data and delegating access to various apps to be a nice flow when implemented well (see for example https://app.diagrams.net/).

It's not a silver bullet. For larger data you can't afford to download it every time. That tends to balance itself out though, because you don't really want to store huge data on your laptop anyway, so you're going to have to find a different solution for that anyway (such as using Jupyter). You can accomplish quite a bit with streaming + sampling, which is the crux of how all our apps work in iobio.
Don't forget people with raised pickups that now have their headlights above the height of your eyes. I've had to point my rear-view mirror at the ceiling with those behind me.
Amazon has historically lost money yearly while investing in their business. A lot of Cloudflare's various new inroads offer a lot of areas they can charge money. My guess is they could turn on the profit faucet whenever they want to.

Of course, for that reason it may also be uncomfortable to jump on some Cloudflare products: Presumably some prices are going to go up sooner or later.
In other words: you can’t depend on signed mac apps for anything important as a user even if they keep everything local to your computer. The developer could do something completely unrelated and your app will suddenly stop working with no warning.
Here you can find comparison of Omotype and Open Dyslexic:https://www.omoguru.com/dyslexia-lab/

There is a whitepaper about two research for ones who want to go deeper.

I've talked to many dyslexics who use it and they say it works really well for them, much better than anything they could find.

[disclaimer] I work with the team behind both the Omotype and Omoguru. Would be happy to provide any further info on both.
We Don’t Need SMS 2FA – Replacement Included
That is seriously wrongheaded thinking. This is just plain not a war, it is a plague. We do need to make sacrifices, but the ideals expoused in this article, needlessly throwing people into danger out of some misguided ideal of lionizing sacrifice is just going to get more people sick.
I was eight years in to professional videogame dev. When I decided to debug matrices used to generate racing track surfaces by drawing the columns in the game world when I realised they were X/Y/Z axis. I felt so stupid. I jokingly told the other coders around me how stupid I was... turns out we were all stupid.

One old timer laughed in the background and told us how he discovered this on the Amiga a few years before.
Paleontologists Predict What Future Animals Might Look Like
Gunicorn with the Uvicorn worker class is the recommended production solution
> honestly looking at the world in sober fashion I think most people are probably not scared enough.

I see your comment as the perfect irony. First, you presume that your outlook is sober, but have you considered that the way you perceive the world is just that, the product of your biased (by all the gloom) state of mind? Do you think the world is getting worse? It's been "getting worse" forever.

As for fixing problems, how many problems can you realistically fix from what you're watching? The world has real problems and you could just pick one if you want and focus on it. There's really no need to dwell on negativity days on end. Doom and gloom is just a distraction and contrary to what you may believe, not productive.

My personal advice though, would be to try to retreat for a while and observe that nothing much would have changed when you resurface. It'll be like skipping two seasons of a bad soap opera and picking it up later, without missing a beat and without having wasted hours following circuitous story lines.
Say a student misses a "live session" -- it's probably simple enough for them to go back and watch it? I mostly wonder about the videos, can I keep them and export them for archival purposes later? Can they be shared freely once a course is no longer offered, for example? Thanks it looks very nice and the interface is slick. The only rough edges I can detect are the "add your own image" headers and they are only a smidge away from full clean. I would like more imagery to explain what part of navigation I am currently in, but once I've read the titles it is clear where things sit.
Interesting article! I agree that mnemonics don't help you much with long-term retention, that's why it makes sense to combine it with a spaced-repetition strategy such as rote learning. However, mnemonics help you translate information into a form that's easier to process for the brain. Even if you don't actively use mnemonic techniques when memorizing meaningless information, you will likely end up applying such techniques intuitively.
Offering royalty-free Lottie animations is fantastic!
That's a misunderstanding of how companies at this phase of growth work. They are only "loosing" money because they invest so much in growth. If they slowed down growth, they could be profitable (they have 78% gross margins), but over time, it creates more value to keep investing at this phase of things and become profitable later, when they're more mature and the land-grab phase is over.
How does async/await solve this? I would have thought it has exactly the same problem?
Knotch | https://knotch.com/company/careers | Full-time | Remote in EST or CST (US timezones)

Knotch is a content intelligence leader committed to increasing transparency in content marketing data. We help Fortune 500 brands such as HP, Walmart, Calvin Klein, and AT&T become better storytellers by understanding their audiences, and allowing them and their audiences to own their voice online. We just hired a QA Manager and a Senior Product Manager, and we're now looking for:

Our first Application Architect. They'll partner with our VP of Engineering to execute scalable application architecture alongside our team leads.

A Lead Back-end Engineer. They'll lead and scale a team of four talented Ruby on Rails API Engineers through empathetic mentoring and implementing best practices with them daily.

Our stack at Knotch is modern: Rails, Ruby, Python, React/Redux, along with Javascript integrations and AWS technologies to power the back end. Every day we're facing unique challenges in testing and with data from architecture to visualization. We need the right team to solve them. We're at Series-B, and we have no plans to raise more VC just to inflate our value. We take so much pride in our culture, you should check out our best place to work awards two years running by Inc and three years running by BuiltInNYC!

Apply here for:
Application Architect: https://grnh.se/707d22f21us
Lead Back-end Engineer: https://grnh.se/c96593881us
Do teachers takes oaths? Do nurses? I was under the impression the medical profession was held to a much higher standard on ethics, assistance, and duty?
Commodore Amiga Public Domain Games in Order of Greatness
The MAX is also known as the 737-8200. Now that the product recognition is working against it, I think we will see the forgettable name a lot more.

At least in the US you can typically cancel a flight for free within the first 24 hours if it is booked more than seven days out, if that helps.

You are right that the airline can change the type of plane like that but it is uncommon. A much more common way to end up on a different type of plane than was booked is weather cancellation. (Personally, I don't like most of the regional jets, but by the end of the day of waiting for a 1 hour flight, I'll take anything.)
All those many factors equally affect both groups, that's the point of running a randomized trial. I am not sure how they are relevant to the claims that worms cause poor outcomes or that deworming children make them less poor adults. Could you please explain?
Beside all the political issues, what is Microsoft actually supposedly buying here? The data centre, data and access to it? Because it does not seem to me that they are buying any of the developers, am I right? At least there is no talk about that. How well can you run a platform by buying its software without any of the people that run it, at least from my developer point of view that seems a very strange idea. Basically, they will have to understand and rewrite the entire thing within a few months with whatever own developers they can provide. Without any major hickups, or users will leave the platform in seconds, its not like there are no competitors or the underlying technology is complicated. Its just that everyone is used to the platforms but if that changes ...

Anyways, an insteresting case study for platform theory ...
The necessary balance between KPIs and CPIs
No. qPCR is, well, quantitative, so it gives more information. Additionally, it requires less pipetting, and the data is easier to report. All of these things make it more desirable for diagnostics.
The person I was replying to used the words "critical" and "core".

As to best (admittedly subjective) if they are so good I'd think that one of the 100s of devs I know depend on them.

The only close one was Remote - which other editors do too - When I showed that remote drops code to the far end machine we determined that to be too risky - and went back to sshfs.

Also, if those extension are so "best" why hasn't a replica been created? Or why didn't any other editor have them? It might be those extension are not so compelling.

Also, my previous favorite editor (jEdit) had remote features back in like 2003 - maybe earlier.
Advantages and disadvantages. It is a bit like a kindergarten for software. At some point you might want to break out of there.

There are severe disadvantages though:

https://medium.com/vchaincodenotary/developers-unite-against...

Additionally, the most predatory kind of app milks your wallet and these come in signed and unsigned forms.

Also, quite a few companies with long time certs have leaked them pretty quickly. Primarily, it is a lock in mechanism with questionable security benefits. Predatory apps can be signed which would have been classified as malware 15 years ago.
People are normally skeptical of the US media and of government claims. Yet when it comes to China-related topics, people eat it all up, with minimal critical thinking, and even amplify them. China is not without problems, but people react so strongly to China-related issues that the subject is the perfect distraction, the perfect propaganda tool.
> Interesting that this should come out of China and not the west. Maybe we are seeing the effect of monopolies stifling innovation.

I doubt that is the case here, since one could easily make the case that China has more monopolies and government control than the West. More likely, this has more to do with what makes things go viral. TikTok's rise was very much a viral sensation.
A neat comment on the accepted answer:

> From OP's point of view this could be viewed as glass half-full rather than glass half-empty. Their dissertation results hold unequivocally on the sphere and might hold on the torus, though it is an open problem if they do. It is certainly legitimate to study what follows from a given conjecture being true. It could even be spun as a feature rather than a bug of the dissertation. If the results in fact fail on the torus then you know that the conjecture must be false. Potentially, it could open up a fruitful avenue of attack.

Kind of reminds me of Terence Tao's post on what solving big problems looks like: https://terrytao.wordpress.com/career-advice/be-sceptical-of...
You're very welcome! Excellent job with the video too :)
> I'm sorry, did you just allude to America being more corrupt than China?

I'm saying that America is relatively in my opinion more corrupt than the America of the past.

I'm not comparing it to China, China has a different set of systems. Both systems might work.
Yes. I just wanted to know if this was a ubiquitous feature in Europe or just a new tech that hasn't yet left the luxury market. The article title implies that the US is significantly behind the times here and I wanted more info to gauge how true that is.
REMOTE/USA (NYC Headquarters)
Olo.com - online food ordering
C#/F#/AWS tech stack

https://www.olo.com/careers#jobs

Good place to work, growing company.
Yeah, though it's worth noting they were talking about paracetamol and ibuprofen, not diamorphine...
Sergey: The little static site generator
>> It was plausible that Germany had a nuclear program as big as the American one.

Plausible only for those without knowledge of the extent of the US program. Even among those involved, few had perspective on exactly how much of the US economy was being funnelled into the nuclear program. The Manhattan Project famously at some points used roughly 10% of the electricity available in the united states, a country with an infrastructure relatively untouched by war. There is absolutely no way that WWII Germany could have sustained anything close to a similar effort. They had to brains to understand the physics, but not the raw industrial power necessary to turn that into a practical weapon.
Doctors diagnose advanced cancer–in a dinosaur
He should release a mini ebook for free. To capture the irrational value we place on free stuff, of course.
https://github.com/fonsp/Pluto.jl
A julia notebook using observablehq underneath.
Reactive with a git compatible file format, looks very promising.