skysight-inc/HackerNews huggingface dataset:
PopSQL (YC S19) | Head of Engineering, Product Engineers | San Francisco or Remote | https://popsql.com

PopSQL is a collaborative SQL editor for teams. It's like Figma, but for data teams. We just raised a $14m Series A[1] and it's time to scale engineering like crazy from 3 to 15+ We need a Head of Engineering[2] to help us with that, and we need product engineers[3] that want to build delightful products like Slack/Asana/Notion.

Lots of info on our /about page, but some quick facts:

* Strong product market fit with customers like Peloton, Udacity, Redfin, and Target

* Backed by Tiger Global, Y Combinator, Gradient (Google's AI fund), and angel investors from from Segment, Instacart, Asana

* Remote team of 15. Me and a few others are in SF

* We plan on having retreats 2-3 times per year, check out our latest one in Mexico[4]

About our stack:

Frontend: React, TypeScript, GraphQL, Apollo

Backend: node.js, Rails, PostgreSQL, AWS, Terraform

We have lots of other roles available for support engineers, designers, customer success, sales, marketing, recruiting, etc[5]. Thank you!

[1] https://techcrunch.com/2022/02/09/popsql-aims-to-be-a-modern...

[2] https://jobs.ashbyhq.com/popsql/38860235-c49b-49c1-ad31-cab4...

[3] https://jobs.ashbyhq.com/popsql/9b30c9ba-183d-462d-aab5-e2fb...

[4] https://www.linkedin.com/posts/rahilsondhi_remotework-wfhlif...

[5] https://popsql.com/jobs
Referring to hbomberguy right? I love his videos.

And yes, I agree -- even if BB isn't your first (could be a good first for some people, but it wasn't for me), it more than any other From game affects your play style for the better. Starting as a knight in DS3, using the shield and hiding behind it, was pivotal in allowing me to start to understand and appreciate these games, but my enjoyment and skill skyrocketed when I took a page out of BB's book and ditched the shield.
This is antidotal but when I was in elementary school my 4th grade teacher was fired when she came out. She told us on her last day she was moving to a different state b/c she was black listed from the school district.
> It's because HTML+CSS (without even any JavaScript) is still the fastest, most effective way to build a compelling and coherent UX/UI for any platform right now.

I would agree if you mean cross-platform, but other than for the web specifically, basically every platform has a much better way to create an app for it. The web is seriously so lacking on several trivial fronts that it is laughable, layouting being one example, but just creating a slightly modified version of a native widget like calendar require the recreation of the whole thing with quite bad primitives while goddamn WinForms could deal with it through inheritence.
If you survive a nuclear attack you will wish you were dead. Any "nuclear attack survivability guide" is probably counterproductive because it reinforces the illusion that there is any such thing as a world the day after a nuclear attack. It's all over.
An event driven, local-first, UI that automatically reacts to changes in the underlying database is a pretty old idea.

https://docs.microsoft.com/en-us/dotnet/api/system.data.data...
https://doc.qt.io/qt-5/qsqltablemodel.html

Am I missing something novel in the article? I really feel like I'm missing something.
If you like this there's actually a lot of work on this kind of topic in media studies! I particularly liked Nonhuman Photography[1] by Joanna Zylinska.

[1] https://mitpress.mit.edu/books/nonhuman-photography
Food waste ending up in the landfill is bad, produces large amounts of methane. I imagine there will always be streams of food waste that need to be diverted out of the landfill. In CA you're no longer allowed to throw food waste in the trash bin, it must be composted. I don't think that option is available everywhere. Having a variety of options should help divert food from ending up in a landfill.
Hmm, I realize I was the upload image works backwards from how I expected – I think you are actually intending me to upload a screenshot of a design to then swap out palettes. That is super cool, but on first guess I thought you were extracting from mine to make a palette. Might need a little helper text, but cool feature!
> There are ways to act that maximises the chance of surviving a nuclear attack,

This reads like a monty python skit
Five dead as Romanian MIG disappears, and helicopter sent to find it crashes
Or "Threads", an even bleaker and realistic look at what a nuclear exchange looks like.
Seattle had one. Covid killed it (for now?).
https://www.meetup.com/HackerNewsSeattleMeetup/
Mandates?

"Since last June, Google has approved nearly 14,000 employees globally to transfer to a new location or go fully remote, Casey said. About 15% of applications have been denied, he added."

"Employees not prepared to return April 4 also can seek a remote-work extension, Google said."
> Inability to run the site in multiple tabs. State is entirely local so state gets broken easily.

I have seen this more for sites where a TON of state is stored in the backend, the site expects the user to have 1 tab that is kept in sync with what the server thinks that user session is doing.

Heck I have seen sites that throw up errors asking me not to open multiple tabs.

I have also seen sites where if I have Tab 1 on Page A, and I open Tab 2 to Page B, then go back to Tab 1 and navigate to Page C, if I go to tab 2 and try to navigate anywhere, it just goes to Page C.

Fun times when the server has too much state.
West Elm Caleb and the rise of the TikTok tabloid
...had.

With each day, Putin is scrambling to find all the help there is.

The only people fighting for him now are psychopaths and conscripts. The latter don't want to be there, and Russia is running out of the former.
Exactly! We only need sources cited for things we don't like.
But at this point you need to ask, what for? Surviving a conventional attack is completely different - you move somewhere else and live on, possibly coping with PTSD. Surviving a nuclear war means only prolonged suffering with no purpose, that's all.
Tank Man is not a good example here, as it is not just one image. People might remember [1], but never seen [2] or not even be aware that there is a full video of the event [3] as well. And of course depending on where you viewed it, it might have been cropped, photoshopped or taken from the video.

[1] https://img.timeinc.net/time/images/covers/asia/2001/2001011...

[2] https://miro.medium.com/max/1024/1*yMZA-hOHadTkNrGrSKriBw.jp...

[3] https://www.youtube.com/watch?v=qq8zFLIftGk
Could you please elaborate what script is injected, that reason and why it is that out of your control? Thank you
Ask HN: Whatever Became of Freedows 98?
Freedows was supposed to be an open source alternative to Windows 98. It was in development a long time and then vanished. Any idea what happened to it?
It will fix it eventually when those new colleges build up a reputation.

It'll take time but it will fix itself.
You better watch Threads for a more accurate take.
Very cool.

A few months ago I tried building a configuration manager for robusta.dev using streamlit.

Basically I wanted to autogenerate a frontend for arbitrary Pydantic models (in my case configurations of Kubernetes automations). The tooling was still lacking so I abandoned the project, but it was really cool just how far I could get with writing almost no code. A way better experience than all the no code tools IMO
Check out this graphic:

https://www.reddit.com/r/dataisbeautiful/comments/t4hyik/oc_...

Russians had about as many warheads in the 60s as they do now. In the 50s they had twice as many as China does now.
Java's demise on Windows was sealed in 1997 when Sun sued Microsoft. Java remained cross-platform in a technical sense, but couldn't achieve much success on the desktop afterwards.
Syrian enemies did not have nearly the level of anti-aircraft (and more incoming from NATO countries) that Ukrainians have. I think they are just trying to keep irreplaceable fighters and bombers intact at the cost of ground forces. Russia know that in a war of attrition they can outlast Ukraine although it will cost them more than they thought now. I think they gambled based on what happened in Crimea and the "contested" regions of Ukraine.
Pretty sure if most organizations doubled their security budget, it would end up being spent on checklist crap. All employees would have voice, thumb, and face checks to login in to their laptop, but their AWS bucket will remain wide open.

I guess the context here is zero trust, so s/laptop/HR vacation request site/.
> However, for an application with a persistent UI, I fail to see how constant page loads and navigation just because "the browser can do this" make any sense at all.

in the same way how re-rendering the screen in a 3D game for every frame does it. Or how you buy a new pair of jeans instead of meticulously learning how to patch the old ones. It solves a lot of problems even if it sounds suboptimal. It was the standard practice when computers and networks were much much much slower, therefore it cannot be that bad.

I think SPA and their entire ecosystem give some sense of optimality to purists which is probably shortsighted and wrong.
> And now that car dealer ads have to specify the exact car they're referring to (by VIN or stock number), that one car will often be the only one the amazing deal applies to and once it's gone, so is the deal.

Sure, if its just one they have to identify it and say something like “1 at this price” but that also tells you up front what the deal is.
Qobuz is not associated with 7digital.
If this all ends well then it could be a case study in promoting economic investment / economic warfare with adversaries.

The idea is that they get dependent on that foreign investment and the threat of it being taken away and are much more amenable than an adversary that is completely disconnected economically and has nothing to lose.
Why would they invest in such great infrastructure for amazon.com if they're just going to sell that infrastructure to competitors?
Managed Hosting or PaaS for Bootstrapped and Mid-Sized Teams
Congratulations to the Streamlit team!

Personally as a machine learning practitioner, Streamlit was a god send tool to quickly setup demos without having to fiddle with front end code. I hope they continue to support the open source ecosystem even after the acquisition.
There's 3800 active warheads and 10'000 cities. Many of the cities would need multiple nukes to be wiped out. Many nukes would get disarmed by iron domes, anti-ballistic missiles, etc.

Nucular fallout is thing that I'm not sure about. Technically more efficient bombs are cleaner, but I didn't go too deep into this and I'm not even sure there's conclusive data.

Overall I don't think it's anywhere enough to completely wipe out humanity. Not even majority of people would be killed. But definitely it would effect everyone. Even current events already effecting everyone.
He's a psychopath. When he is cornered he will do whatever works for him. Because that is all he can do.

The thing that might temper this is, I think, is that he does have children. Psychopaths aren't capable of true emotional love, but they do look after their things.

It is said (albeit largely in tabloids) that the outcome he fears the most is dying like Gaddafi. He was quite preoccupied by Gaddafi's death at the time:

https://www.reuters.com/article/libya-gaddafi-putin-idUSR4E7...

Maybe he'll commit suicide. Psychopaths do commit suicide. Harold Shipman did, Fred West did, Jeffrey Epstein did (sorry everyone; suicide is the logical explanation).

But they also commit murder-suicide.

This is a guy who has had people pushed out of windows, poisoned, a guy who almost certainly ordered the faking of apartment block bombings as a pretext to invade Chechnya. He's comfortable with cruelty; he has no conscience.

I think it is interesting he is becoming more emotional. He is very narcissistic, but he's always had control over it, appearing showy but gentlemanly and urbane. Perhaps he is losing that control.

Personally I think it's going to be bad. As soon as he believes there is no chance he'll avoid a traitor's death.

I don't know how bad, but I still think there's a good chance he will find a tactical way to demonstrate his willingness to use nuclear weapons.
By "cleaning" I mean opening it up, unscrewing things, and cleaning the internal mechanisms of the machine to remove any leftover ice cream before it goes bad.
Amazon used to do a lot in that space, they had a big focus on customers creating and sharing lists of products. Your list was almost a blog post where you could write descriptions of each item and why they were there, order them, etc. I remember in the mid-2000s these lists were some of the best ways to find good books and products--there were always great "here's a roundup of the best technical books for programming language X/Y/Z" lists that I would seek out for example.

It looks like there's much less focus on Amazon lists these days. Maybe they got rid of it entirely--it's hard to tell, all I can find are wish lists and such now.
Commute sucks. Anything above 30min for one way is unbearable.
Prepare for a blog post titled Our Amazing Journey.
And? He has his own propaganda he's trying to push and probably wouldn't be against outright lying either if it wouldn't be publicly traced back to him.
there is even a similar DIY, only using microwave generated flash, on producing a [very small] artificial diamond from graphite by what basically is CVD method https://www.instructables.com/How-to-Make-a-Synthetic-Diamon... which most probably would work for any source of carbon (the people who don't like the low tech look of it may google for respected scientific labs doing similar :)
This is basically the perfect use case for IPFS.
> For example, saying "shoot here" then having a tank round go through the wall 5 seconds later wouldn't benefit from encryption

Of course it would. Otherwise:

* the enemy could analyse your strategy and tactics and predict your approach; and worse:

* the enemy can impersonate command, say "approach through there" and have the tank go through an anti-tank ditch

There's no excuse for unencrypted military communications. One would think the Russians would have learned their lesson from freaking Tannenberg a century ago, but it seems not.
I looked into what to do:

If a bomb goes off, don't look at the blast, go to an area in your house without windows and little air access, close the doors and wait there for 24 hours.

Ideally, it's a closed basement surrounded by ground and concrete. If not, maybe a bathroom wine cellar, etc. the idea is to isolate yourself from the surrounding radiation in the air.

Hopefully, you have a shortwave radio with fresh batteries or one you can hand crank. Because cellphones and access to information will be limited, the shortwave radio is important because ideally, city officials will be broadcasting where to avoid going outside and safety instructions.

Don't go outside within the first 24 hours, as small radiation particles will fall on you and cause serious health issues.

If you do go outside get rid of all your clothes and take a shower, don't use conditioner which binds radioactive material to your body.

They say that after 24 hours, radiation levels should drop off significantly, since the winds will hopefully blow them away. But that's why a shortwave radio is important to have, so you know which directions of the city are getting the radiation.
“Great salary allowing them to live close to the office” is an interesting way of phrasing “requiring you to unnecessarily live in ludicrously expensive areas”.

Honestly in my experience the work environment itself is not great - google has cubicle pens with half height walls, it super frustrating to work when people are continually going back and forth around you.
Pico-8: CPU
Outside of Silicon Valley, it is possible to live close to the office without a FAANG level salary. Beverages and snacks also are not that rare.
It'd be reasonable to structure the development company as a non-profit, to prevent an outcome like Bandcamp's.

I think it may be possible to build the marketplace in a purely FOSS-y way, but it would be illegal to operate it with the wrong configuration values. I'm thinking in particular about the accounting functions, such as earmarking x% of each sale for royalties, and ensuring they go to/from the correct bank accounts.

In other words, one could plausibly release the code as FOSS, but the interface would depend on a set of corporate entities that are configured a particular way, so it would be of limited value to the median person.

It would definitely lower the barrier to entry for people to fork the business, though, which is probably a good thing for the median person.

---

I'd also be down to contribute as an engineer, if such a project already exists with momentum or if somebody wants to start it!
You can figure out "natural" focal length by taking a printed photograph, holding it at a comfortable viewing distance, and measuring that distance. Now, scale all of those distances down until the photo is the size of your imaging surface (24x36mm for 135 film, better known these days as "full-frame").

Normally, for a 4x5" photo, you'll naturally hold it about 6" from your face, which is pretty close to 150mm. Ergo, the "normal" lens for 4x5 cameras was 150mm. If you scale that down to the "35mm" 24x36 frame, though, you'll discover that that's closer to 40mm. This is not a mistake; IIRC, one of the early 135 camera makers found it easier to make a 50mm lens than a 40mm lens, and it's stuck ever since.

It so happens that a normal lens has a FOV of about 1 radian, so the normal focal length is approximately the diagonal of the image surface. A proof of that is left as an exercise for the reader.
"Then fight for it. Unseat Putin and his gang of scumbags that pilfered billions"

Some people who are Russian citizens, weren't even born in Russia or left as children, precisely because their families were being prosecuted.

I recently saw a picture of 12 Russian opposition leaders, lawyers and journalists from 2000's - the one thing all of them have in common, is that they are dead.

It's clear the current leadership won't leave peacefully, protesting with posters and slogans does nothing. And unlike America, you have no right to bear arms in Russia, so good luck attacking armed men with a kitchen knife.

I don't know what an average man can do against current regime that isn't either suicidal self-sacrafice, or is basically terrorism against the state. Maybe you think that's what required, but unless you have that kind of experience, it's not fair to critize random Joe
Thanks - my company is pushing a lot of ZTN stuff, and I wasn't totally sure where the principles are coming from. Having a root that I can anchor my debates in (which, as you can probably tell, is currently lacking) should be really helpful.
I fully support NameCheap and they will continue to have my business. Most of us commenting here are doing so from the comfort of their safe office. Ukrainians are dying, defending themselves from a war which they did not provoke.

I empathize with simple Russian people who are impacted by this but the world needs to send a message to Russia. There will be casualties.

You can move your domains or hosting infrastructure. People cannot be replaced.
I wonder if this is why I've never found much joy in browsing at chain bookstores (Indigo, in Canada). It's all just bestsellers, and half the products aren't even books, they're like kitchy home-decor items, candles, blankets, cozy "reading" pajamas and whatnot. I guess it's lures intended to stimulate impulse purchases out of people who already know they're not going to read anything they buy anyway.

Whereas you go to the indie store and there's an entire shelf in the back dedicated to heraldry, seemingly for no other reason than that it's an area of acute personal interest for the proprietor.
Well, they own WeChat: https://en.wikipedia.org/wiki/WeChat#Controversies
The books thesis is that nuclear war is far more survivable than the public has been led to believe. It's an eye-opening perspective for sure.

But this is not the kind of book you're going to be able to use in a crisis. The appendixes contain how-tos for:

1. building a fallout shelter

2. building a ventilation device for the shelter

3. building a dosimeter

The problem is that these instructions are mixed with commentary. Lots of it. There are half a dozen or so types of shelter you can build. Which one do you build? Go figure. What should be simple recipes are ordeals in concentration. I can only imagine the kinds of heated conversations that would take place should this guide be pulled out and used in anger as the hand crank radio crackles with terrifying reports of unthinkable events.

What the book has going for it is field testing. The methods described were tried out on regular folk who were paid to participate and paid bonuses for certain milestones. The author claims good results.

Apparently this was all done as part of a federally-sponsored program that no politician wanted to see become public policy.

One of the most useful parts of the book is a prediction of fallout zones across the US. The author notes that even at the time of publication, this was 10 years old. Imagine a map of the US with greyscale clouds running left/right. Darker means more potential for fallout. Really hard to do given uncertainties, but maybe valuable for big-picture planning. I'm not aware of a more modern map.
> Did they really launch this invasion on the assumption that the people of Ukraine would just roll over and accept foreign rule?

I don't think it's that simple.

Sure, conscripts were told to expect a welcome in streets lined with natives waving Russian flags. Maybe some in high command even thought that was a possibility. But they have backup plans; we've seen only the first click of the ratchet. Escalate, pause; escalate, pause. This happened in Chechnya too.

Putin didn't invent this approach. And Putin didn't invent the idea that Ukraine is not a separate state, but a part of Russia.

He's written history books, I gather; I might be interested in reading one, but I suspect they're hard to get hold of just now.
I should have been more clear. I'm basically agreeing with you. It feels like the article is constantly about to say something like "Here's an example where I used a 50mm and you can see how much more closely it matches the painting and my recollection" or something like that before then going on to talk about how perspective in photography is essentially a tradeoff with field-of-view. But it... just doesn't do that and so ends up with this awkward feeling mismatch with reader expectation (for me, at least).

I don't necessarily begrudge the article for it but I do share your frustration.
Anything you hit with those is pure luck.

Source: experience.

Edit: I was thinking of what we had in the Army, which was definitely not guided.
Yeah, even with the buses into Mountain View.
Ah, sucks. I really liked the 4-star store.
Yup, as sole buyer China are going to set the price of Russia's oil and gas.
You must be young. I was very young when "The Day After" came out, and that friggin' movie gave me nightmares for many, many years. Into my twenties. Every time I heard a jet, I was convinced it was an inbound ICBM. My case may be extreme, but the Cuban Missile crisis was by that time well understood, the immorality of the USG was apparent thanks to Vietnam and Nixon, and classic movies like Wargames and James Bond used the threat of nuclear war constantly. Getting nuked by Russia was a real threat for 40 years. But you realize it's out of your hands, and deal with the stuff in front of you.

(The real question is: what is the path away from nukes, entirely? It seems to me that a world in which any individual can launch nukes is a world with a very short lifetime. This gets worse the fewer human barriers there are to launch. Even if we get past this conflict, we have this fundamental problem which affects democracies and autocracies both.)