skysight-inc/HackerNews huggingface dataset:
The deep relations (7-table join) example in the link is something I wouldn't do (including the repeated 'user' entities) with an RDBMS, given that I expect some elements of some tables to appear multiple times, that's a waste of I/O and hard to cache.

> Users have friends, friends have posts, posts have comments and likes, each comment has one commenter and each like has one liker.

I would likely gather all the instances of User id in each context (user, friend, commenter, and liker) and query it separately from the JOIN query. Depends on your data which way works out better on average/worst-cases.
Seems like a Python only tool.

AWS CodeGuru is Java only, AFAIK.

Anyone knows good JavaScript/TypeScript tools?
This is why we end up working on our assigned "tasks" outside of work hours. It's one reason I like work from home, less work place distraction.
How to get your first ten customers? (YouTube)
Yes, but Gamestops was above 150% of float short. So that scenario doesn't matter and fraudulent stuff is going on. Shares were literally created from thin air.
I mean, `List.map` is often used in a partially applied manner and, used in conjunction with the pipe operator, results in, imho, readable code:

[1;2;3;4]
|> List.map ((*) 2)
|> List.reduce (+)
Using the latest pip is the will of the PyPA, and they let you know this on every invocation that touches the network:

You are using pip version 8.1.1, however version 21.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.

There are also packages and workflows which break on the older pips, and this has been justified on the basis that everyone can always just use the latest.
The Best-Case Outcomes Are Statistical Outliers
I prefer to plan my own routes. But I sometimes use maps before I set out because:

1. Map apps give duration information about different routes - this is interesting as it calibrates my own mental model of potential routes. However I also often optimise my routes for things apart from time.

2. I am in a hurry, and map apps are better at avoiding roadworks and traffic jams than my own mental model. I ignored a route suggestion the other day because I thought I knew better, which delayed me by 15 minutes because a flyover I wanted to use was temporarily closed.

3. Map Apps are great when I am travelling across town on a route I would rarely drive, so I am unfamiliar with the possible routes (e.g. I often go to A, and I often go to B, but I rarely go from A to B).

4. Edit: and map apps are fantastically safer in cities or towns you have no familiarity with. You can pay attention to your driving and not be distracted looking for street names or other route waypoints.

> It's dangerous and unnecessary. Pay attention to the damn road.

Opinion or fact? My opinion is that voice directions makes it possible to pay attention to the traffic, and I am not stressed, and I don’t have to have uncertainty about road choices (which is safer). It certainly makes looking for unknown street numbers or businesses safer - scanning for street numbers or business frontages is very distracting.

Use your tools sensibly and safely - don’t use them like a fool.
Why would anyone enter rehab if the government is providing free, high-quality drugs?
Would love to learn more about this. Any resources/links on this subject?
Webaverse | Building the metaverse | Remote | Full-stack Software Engineer

Webaverse (https://webaverse.com/) brings virtual worlds together with fun digital objects (NFTs) on Ethereum. We have raised a seed round and are looking for gamedev-minded web hackers.

We are 3 hackers, looking for full-time engineers who:
- Have strong web engineering (JS, profiling, optimization)
- Have experience/interest in Ethereum/Web3
- Understand WebGL/WebGPU shaders + rendering pipelines
- Can grok networked objects
- Like video games and memes

Technologies we use: Ethereum, IPFS, Three.js, AWS, Node.js, React, Next.js, WebRTC

You'll be working with the founders on the hardest and most valuable interoperability problems in game development. https://webaverse.com/hiring
There's weird cases. In my DnD group only one person has not switched to Signal and they refuse to. Their answer is that "I can't fight them so why switch?" Which weirds me out since this is exactly how you fight tracking. Btw, this is someone who has a PhD in computer science so it isn't like they are tech illiterate. But I've seen several people like this and honestly I don't understand.

I think at this point a lot of people are now apathetic and have given up. And we know people like to double down on good or bad positions when faced with adversaries. Doing things like "switching to Signal" (when you already have most of your friends there) and "using an adblocker" seem like very simple things that easily respond to "what can I do about it?"
GameStop and the Truth Wars
> Or take functional programming as another example. Arguably, about 80% of it is incredibly useful and makes for much better code. Taken to its ultimate conclusion in purely functional languages, things like doing I/O get a lot more difficult compared to strict languages.

The author seems to be quite confused about functional programming.
Apple is openly trying to sell ‘premium’ privacy services at consumer costs, be as skeptical you want but this is an obvious business decision and in many ways they actually are looking out for people...at a price
If you prefer yaml > Python or if you prefer installing one k8s app instead of managing all of the airflow dependencies (scheduler, webserver, workers, etc)
I think what lucian1900 may be thinking is that instead of

create table purchase_order (
id int primary key,
ordered_on timestamptz not null,
customer_id int not null references customer,
canceled_on timestamptz
);

you could have

create table purchase_order (
id int primary key,
ordered_on timestamptz not null,
customer_id int not null references customer
);

create table order_cancelation (
order_id int primary key references purchase_order,
canceled_on timestamptz not null
);

This is indeed a better normalised schema and it allows you to index order_cancelation.canceled_on without worrying about nulls.
Reverie Labs (YC W18) | Cambridge/Boston, MA | Backend and Full-Stack Roles | Onsite (Temporarily Remote) | https://www.reverielabs.com
At Reverie Labs, we’re rethinking drug discovery by building a biotech company that looks and feels like a tech company. We are actively working on several cancer therapeutics programs and building an internal platform to accelerate discovery. We’re looking for engineers across the tech stack, including data scientists, front-end engineers, and full-stack devs to expand the computational systems that generate the next era of life-saving treatments for millions of patients.
If you think you might enjoy any of these types of projects, we’d love to hear from you!

* Architecting a Django REST-driven internal application development ecosystem that supports multiple drug development programs.

* Building performant software for billion-scale molecular analyses alongside machine learning engineers.

* Designing and implementing front-end interfaces that enable our in-house chemistry team to interface with software.

* Using Pandas/R/Plotly/Dash or any other of your favorite analysis tools to extract meaningful insights from datasets.

* Combining a set of 25+ in-house experimental assays and 50+ external data streams into a universally accessible data platform.

* Using a modern cloud-first development stack, giving you access to effectively infinite computing power.

* Owning the full development cycle of a product from ideation to implementation to deployment (of course in collaboration with a team!)

We were in the W18 batch of YC and are now based in the biotech hub in Cambridge, MA. We offer competitive salary and above-market equity. Benefits include full medical, dental, and vision coverage, flexible vacation policy, and gym membership.

If you have any questions or want to apply, please reach out to me at ankit@reverielabs.com (I’m one of the founders), or apply at our website here: https://reverielabs.com/careers.
This is why I found it odd. I wondered why they didn't use FBLearner Flow and figured that not all teams were using it even though they did machine learning.

We like these conversations where people share problems they may be having in order to get a bigger picture. We built our ML platform to solve our own problems that we faced over the years, but it's always nice to be exposed with problems we have not seen before to solve a slightly more general problem.
SQL databases don't support easy schema evolution, sharding and so on.
Cool. Actually I should know more about this since I took a lecture series with Krishnaswami on this topic. He combines the two type systems in a way that makes sense and can produce a programming language.

But yes, for the linearity control you'd need to model variables within the type system and indirect to a function handling h's resource relationship instead of using it directly.

Formally I would like to compare linear types and dependent types and their ability to encode or not each other. I don't know what the tools for that are.
The destruction of RH's reputation is irrelevant. Thanks to the increased collateral requirements, They were facing liquidity issues and had to restrict buying of GME. There was no way around that.

The problem is that they continued to allow customers to sell GME and lied about their rationale to their customers who could no longer buy it.

If a large broker exclusively allows a stock to be sold, not bought, the trajectory of that stock's value will be pushed downward. It's in RH's interest to see GME go down (or at least go up slower). Lower prices mean less of a liquidity problem for them. It also really helps out their biggest market maker partner.

It would not have been a conflict of interest if RH prevented customers from trading GME outright while they got their liquidity issue patched up. It would piss off potential sellers and, if the stock price went down, would result in objective losses for them which, IMO, RH should be liable for. That is a tough choice to make, but it would eliminate the conflict of interest.

A stockbroker's value is in enabling customers to easily trade their stocks. If they cannot do that, they deserve damage to their reputation. If they cannot do that without engaging in conflicts of interest, they deserve to be investigated. Last week they failed on both fronts.
How does this work at 160% of shares shorted?
From the conversation in CH:
Elon Musk: OK, you had to restrict buying. Why didn’t you also restrict selling?
Vlad Tenev: The fact of the matter is, people get really pissed off if they’re holding stock and they want to sell it and they can’t. So I think that’s that’s categorically worse.

Read full transcript: https://www.mrhack.io/blog/elon-musk-vlad-tenev-robinhood-ce...
Someone else on HN (I cannot recall who), stated something along the lines of (paraphrasing):

"Centralized power can be abused in the hands of the government or the private sector [via monopolies]"

Whether or not you agree, I thought this was an elegant way of phrasing it. The cure, IMO, is to ensure that both ultimately answer to the people, although I have no idea how that is practically enforced.
SFOX | Full time Front-end Developer | Remote | sfox.com

Want to join the crypto space? Our platform allows traders to leverage their trades across multiple exchanges. In one simple sentence the software we build replaces the need for expensive in-house trading solutions and gives customers access to deep global liquidity (for large 100BTC+ trades).

Tech stack: EmberJS, Typescript, Node

Apply here: https://www.sfox.com/jobs/ or reach out to me directly!
Show HN: Archivy – Extensible Self Hosted Knowledge Base – v1 Release
Aside from my enjoyment of the subtle humor expressed in the above comment, I find it interesting that there was no way to express either approval or disapproval of it without that action being subject to misinterpretation. I sat frozen for two minutes, mouse poised above the up and down triangles, unable to act. An appreciative reply seemed to be the only way out. Bravo.
Good. This has worked well in other countries, particularly Portugal:

https://transformdrugs.org/drug-decriminalisation-in-portuga...
If it was irrelevant, Facebook wouldn't be worried.
I don't buy that. For example - I bought a rowing machine on Amazon. It was the first piece of home gym equipment I'd ever purchased. For months after, other rowing machines were suggested to me. I already bought one, why would I buy another, especially if I hadn't returned the first one?

Ads like this are very common for me - a purchase that I would consider to be a one-off thing (at least, for several years, whatever the standard lifetime of that product is) just leads to more ads for different models of that same thing. Occasionally, accessories that only go to a different model or brand of that thing.

I don't see how this is any better than the random shotgun approach - these ads that are 100% irrelevant and not going to lead to a purchase are taking up space that ads that are possibly < 100% irrelevant (even if completely random) could be occupying.

It seems like this would be a solvable problem for Amazon - aggregate the data of everyone who has purchased X model of rowing machine and see how many of them purchased a second rowing machine, which brand it was, and how long after purchasing #1 they bought #2. Don't show ads for rowing machines to people who have purchased X until time is >= avgTimeBetween1And2, with some fancy statistics in there somewhere.

Clearly I'm missing something in my logic, because plenty of people a lot smarter than me work on this adtech stuff.
This stands in stark contrast to Germany's reputation and perception that it is a leader in renewable energy.

Their energy policy as a whole should be looked at because they are held up as an example for adopting solar and wind. But looking at German's electricity production and ignoring natural gas for things other than electricity gives a skewed picture.

Would Germany need natural gas if they committed to nuclear power and shifted to electrical heating?

>Gas covered around a quarter of Germany's primary energy use in 2019,

>Currently, most of the gas is used in the industrial sector (e.g. for power and heat supply, or in chemical processes), followed by private households (mostly heating), public power and heating supply, manufacturing and trade.

https://www.cleanenergywire.org/factsheets/germanys-dependen....
wow what a weak mindset your friend has
Yes, but it makes you look like a fool if your argument against theirs is that they must be a newbie, when in fact they are a seasoned developer.

Instead take action to support your statements or opinions and put up some convincing argument.
JingOS is an Ubuntu-based Linux distro designed for tablets
If your concern for the legalization of drugs is businesses exploiting people, maybe the focus should be on preventing businesses from exploiting people and not limiting people's autonomy to make decisions about their own lives?
12 is the max parallelization, so you could define more but some of them might queue.

All databases that run locally (mongo included) are supported, here's the doc page for that: https://layerci.com/docs/advanced-workflows/layerfiles-can-s...

We have a secrets dashboard, they are stored encrypted in our database (though many users have something like hashicorp vault with a central repository, with only the access key stored in our database). The secrets are only viewable by admins of your organization.

Most of our users build their docker images within LayerCI, then push to ECS by adding a write-only access key as a secret. Deployment is often done with something like Terraform or ArgoCD.

Thanks for mentioning the typo!
Me too :). I think it hits the sweet spot for me between being as readable, expressive, and low ceremony as Ruby/Python but also type safe.
Show HN: Mysite.gg – Free websites for creators and influencers
mysite.gg is a website builder designed specifically for creators and influencers to own, grow, engage, and monetize their audiences.Please check it out! and give me your feedback, thanks a lot!
Weights and Biases raises $45M for its machine learning tools
Thank you for the tip. I think I did briefly look at that, but the "experimental" banner on the web api documentation page scared me off. Looking at the browser compatibility chart, it does seem to be pretty widely implemented at least.
Edit window expired on the above comment. Robinhood is solving for capitalization with an equity raise [1] [2].

[1] https://blog.robinhood.com/news/2021/2/1/robinhood-raises-34... (Robinhood Raises $3.4 Billion to Fuel Record Customer Growth)

[2] https://news.ycombinator.com/item?id=25990453 (HN: Robinhood raises another $2.4B from shareholders)
The US should stop interfering in foreign countries sovereignty. Germany doesn't tell the US if they should build keystone 2 or not.
>scratch a relatives itch

I count myself extremely lucky to have found an 'ideas guy' (and people person, and bookkeeper, money raiser, etc etc...) who came out of the world of the 90s and 2000's where he'd fly around the world implementing copies of high touch software.

From day 1 his vision was clear, we had an in-house subject matter expert, and the customers were there when our SaaS was ready.
> extra natural gas

But who says it's about extra natural gas? It's actually more about more reliable, easier and cheaper natural gas supply. Germany has been depending on Russian gas since probably well before I was born...
> No one is denying these drugs are harmful

Everything is harmful when used incorrectly, but useful when used correctly. I for one think these drugs are not inherently harmful, everything has a use. Why should doctors get to be a gatekeeper of my health if I choose to self medicate?
I am a Cdn on a TN. There is very much an expectation that you will reside in the same location of the office. Its not as hard+fast rule (like the h1b1) but considering a random border guard could have a bad day and deny your TN based on whatever they feel like, I would strong caution against anyone living far away from their assigned office.

Also, if you're living in another state getting a US drivers license might be impossible (how do you prove residency if your work visa is for a different state?) . Some states don't require residency for a drivers license, (Oregon and CA don't) but you can get a RealID on your DL if you can prove residency. RealIDs are strongly suggested because you can use them to fly in the States, instead of your Cndpassport + work visa. Again, TSA agents have the legal ability to detain anyone on a work visa, so having a RealID lowers the chance of complications.
You think people enter rehab because they can't get drugs? What?
A catalogue of biochemically diverse CRISPR-Cas9 orthologs
We'll snapshot the state of the database after you set it up once, and then re-load that snapshot every following time you need the database to exist.
> Oregon is basically saying "go ahead, it's fine, use these drugs".

Not at all. Oregon is saying they are going to stop using police resources to punish people for self-destructive behavior. Most drug users are struggling to begin with. Adding prison time for something which is not hurting others is cruel.

> The next obvious step is to legalize all drugs, and let these lobbies profit off the back of addicts and their families and their ruined lives.

As opposed to ruining people's lives for a behavior which isn't inherently harmful to others.
PostgreSQL Database Security: Authentication
All statistics in postgres are considered best effort guidance. Even if the statistics are wrong it can never impact the correctness of the results.
Most relational databases have some level of json support nowadays. So I'm not sure how much it simplifies in that case.
Screening, Within and Without
So I guess you should click "Allow" in the first facebook-designed prompt, to trigger the second Apple iOS level system prompt, and click "Don't allow" there, to actually register the do-not-track request to be enforced on the OS/API level?

If you just click "Don't allow" on the first FB screen, it doesn't look like iOS will know about the do-not-track preference at all?
> By that logic, the advertising industry would not really need individual targeting at all

You're right, they don't. But the point is not to argue that ad relevancy itself is bad. In a vacuum, improved ad relevancy is good! However, the improved relevancy of individually-targeted advertisements is not offset by the social detriment of user tracking.

To use an example, on a Facebook group for gamers, it would be fine and dandy for Facebook to establish a market where PC hardware and video game companies bid to show ads to users browsing the group page. Note that this doesn't have to involve advertisers receiving any identifiable data about who the ad was shown to, and nor does it have to involve Facebook tracking your behavior online in order to show ads based on other sites you've visited, e.g. gaming communities on Reddit. The targeting is as simple as "show the game ads to the people in the game group"; it's extremely coarse demographic-based targeting that doesn't require any sort of persistent user profiling. It's no more of a privacy issue than back in the old-timey days when a company would buy an ad in an enthusiast magazine.
> old and has lots of warts

It was still the worst programming language ever created even when it was new and wart free.
CompilerWorks | Remote (we are global) | Full-time, remote (or local) developer/architect | $95k-$250k driven by what you bring to the company.

If you love solving tough programming challenges and avoiding organizational politics this might be the place for you.

CompilerWorks is a bespoke compiler company, with our core technology centered around compiling one dialect of SQL to another - e.g. would you like to run Oracle PL/SQL on a PostgreSQL database? You can with CompilerWorks.

We are driven to solve interesting engineering problems, for this reason we take on challenges where compilers are useful. Our current product focus IS disruptive to the database market. We are profitable and growing rapidly.

We are looking for EXPERIENCED developers. Our core development language is Java. We are currently a team of 20 in 18 regions of the world.

https://www.compilerworks.com/about/#Careers
> I think it all boils down to this: which side supports censorship and which side condemns it? There you will find your answer on who is more adversely affected by censorship.

I don't think that's a valid metric at all. This doesn't reflect the quality of censored expressions, their factual validity (mere facts are not opinions) or evolutionary adaptations to the discourse, like deflection ("No u!"). You assume a zero sum game.

See how diversity initiatives and co are confronted with "this is racism against white people!". Does this reflect an increase in discrimination against "white" people, or an decrease in discrimination for "non-white" people?

Then, people getting kicked off a Platform for being mean and abusive, doesn't mean they got censored for their political views, even if they claim that's the case.

All, I am saying is, your metric is problematic.
at most cases it could also be 1.) how the user writes the code, and 2.) how the db api / library was coded
Keepass is made with .NET. It’s native for Windows. It works with other OS using Mono, but it’s not as native, I guess.

KeepassXC written with C++ and crossplatform GUI, so it’s better fit with Linux and macOS. Also, AFAIK, KeepassXC has more features.

I’m using Keepass because I trust C# more than I trust C++ when it comes to security. But it’s nice to have options.
“No one actually needs a car either. Or to eat industrially produced food. Or etc. etc.“

This is a false equivalence.

Facebook is nowhere near at that level of need yet.