skysight-inc/HackerNews huggingface dataset:
I'm not English nor Irish (or from any anglo-saxon-adjacent place) to have Jonathan Swift as any important part of my cultural-literary canon, so excuse the ignorance but at the same time fuck you for telling me to "pick up a book" as if I should have known your cultural references :)

(And yes, the "fuck you" is in jest, I'm still astounded [and a bit ashamed] I didn't pick up the sarcasm at first...)

Sorry.
Ask HN: How would you build Stripe Sigma
Stripe provides https://stripe.com/sigma which allows users to write their own SQL.

If you had a multi-tenant Postgres DB, how would you build a system such as Stripe Sigma? Where each tenant can only query their own data obviously.

Thanks for any recommendations!

More notes that could be helpful:

* dozens of tables

* data latency should be minimized, but 5 minutes is fine.

* not "big data", <10 GB per tenant

* need a post-processing step (for example, add a column of current balance to each transaction in an accounting system)
> without losing performance

But isn't M2 ULTRA over 20x slower than this thing? ~30 TFlops vs 738.
You can say it is neccesary, but presenting achievements is performance, therefore performative. Powerpoint theatrics are not a bad thing, unless you spend most if your time on it.
The solution to X (Twitter) sucking is to stop using it. It will either: get fixed or go out of business and be replaced.

It seems we've become a society that rewards bad practices with attention which is all any company on the web is trying to get, your attention.
Thanks for the pointers...I'm not interested in defending American Jingoism by any means, and am very interested in learning more about the decision to drop the bomb.

That said, I do want to dispute this:

> The reason those cities were not targeted by atomic bombs had nothing to do with trying to limit deaths; they were not targeted because they had already been destroyed by firebombing in the months before the atomic bombs were ready, causing more deaths than the atomic bombs caused.

It's an exaggeration to say that they were "destroyed". Yes, ~100,000 died in the firebombings of Tokyo...but even by the end of the war the population was still well over 3 million, 10x the size of Hiroshima. Whatever the "true" motivation, the selection of Hiroshima and Nagasaki was entirely coherent with the claimed strategy that was focused on destroying the Japanese capability to make war, rather than to commit indiscriminate genocide as claimed.
What I learned from 50 years at the command line
People have been idly watching their neighbors since neighbors have existed.

The problem becomes when a corporation begins filming most neighborhoods and then handing it over to the cops w/o a warrant.

As for the smacking of mouths, I'm glad certain norms have changed.
non-JS/TS dev here but had done some TS dev in a previous company. I do not have Node installed just Deno. Purpose is doing my Udemy TS course with Deno. Is the purpose to have bun on feature parity with Node? When is this going to be achieved at least for hobby/learning?
Show HN: Free, Offline, Article Reader for iOS
That's very, very unlikely. What is more likely is that TSMC would find itself sabotaged to the point that the previous global chip shortage looked like a blip and that the West would look on while China occupied Taiwan and installed a puppet regime. This is also why you see all kinds of investments in alternate fabs.

The only reason the rest of the world is concerned about Taiwan is the strategic importance of Taiwan for chip manufacturing, other than that there isn't much. Of course everybody would wring their hands and make speeches but I highly doubt WWIII would start over Taiwan. But if Russia invades Poland or the Baltics (even by proxy) all bets are off, and this is one of the things that I consider still very high on the likelihood scale, that there will be a large provocation from Belarus towards NATO with Russia pretending it wasn't them.
He likely has a _right_ to, but it does make his whole ‘free speech’ thing look a little silly (of course, it’s not the first of his actions to do that, by a long shot). Observers have a right to make fun of him for doing so, too.
I love how there's all these arguments here that start with "surely they've carefully studied the productivity angle and wouldn't be calling back everyone to the office if it wasn't demonstrably better in the actual numbers".
Not applicable when dealing with people who have narcissistic personality disorder like musk. Would be naive to assume stupidity.
True, however since already the Visual Cafe, JBuilder and Visual Age days, Java IDEs have tried to provide a Smalltalk like experience, given where the community was coming from, so the concept of a virtual image mapped into the file system has always been present.

As such, code browsers always made this quite easy.

The fact that Eclipse provides a Smalltalk like code browser isn't an accident, rather its Visual Age roots.

It is only a problem when one makes the point to navigate through the source, outside Java tooling.
> GMT+12, which only covers two uninhabited American islands

New Zealand users are now mad at you :D
Been there, done that:

"pro-Sadam, pro-Iraqi, pro-Taliban, pro-Viet Cong", the list goes on.

Washington does love its wars and hence cherishes its foes.
I work with a system which extrapolates data in the frequency domain to reduce noise in medical images and then doubles the images resolution in the x and y direction (so 4x the pixels). It’s absolutely amazing.

It’ll be interesting to see if audio ever gets a similar treatment and in what areas it can be applied.
Very exciting. The "first-generation" Stable Diffusion frontends seem to have settled on a specific design philosophy, so it's interesting to see new tools (like this or ComfyUI) shake up the way people work with this tool. I hope that in a few years, we'll know which philosophy works best.
Can't speak for Linux, but got a few projects I've contributed to I've had to sign a CLA which negates that problem (but causes the one in this thread)
Less maintenance the fewer lines of code. While it shouldn't be unreadable, it should be succinct. Basically using abstractions sparingly, letting the data flow through the system and not wrapping things within each other are all great ideas. If you are instantiating a bunch of objects, you can simplify things.
Both your counterpoints are true, I didnt want to sprinkle the word “marginal cost” everywhere (marginal devops cost of buy vs self host). And ofc I agree, not all saas offerings are the same, EKS is fairly meh as far as setup and time savings.
Now that's agile.
That’s not that much money anymore for high stress low quality of life work. UPS driver and railroad worker wages are in the same range And people don’t really want those jobs either
Bullshit Jobs was a good read on this subject, covering all things work theater-related and more.
I'm not sure about this. The big SQL script is annoying but when broken down into 4 parts it's very easy to understand. This is precisely the strength of dbt. This would decompose to 4 dbt models, which could be deployed as views, tables, or ctes etc. Instead it seems that you've developed your own DSL for data transforms to take its place, in the form of special classes declared in yaml.

It might be better? But sql is so well understood and covers so much functionality I'd expect that it would be a long time before you ever hit parity with it.

It would be nice if dbt could interface with buckets etc but if they're wrapped in an external table or whatever then that problem goes away.

One thing I noticed is that it (the example) misses a killer feature of dbt, you're specifying your database targets right in the class config. The killer feature of dbt is that you just specify the transforms and then point it at different environments using a target flag and a profiles file, deploy to different envs with ease. I would definitely separate location/env/credential config from transform logic or make it variable.

Given that sql is a totally valid language for declaring transforms in spark, I would probably rather see spark as a materialization backend to dbt somehow rather than an entirely new thing.
SolidJS sounds exactly like what you want https://www.solidjs.com/
Mining is highly robotized. Here's a How It's Made video about mining uranium in Canada:

https://www.youtube.com/watch?v=9x7DozCqLxU

Other types of mines are less robotized, since they only have to worry about inhalation hazards, and not radioactivity. However, in most other types of mines, machines still do most of the drilling, lifting, detonation of explosives, and so on.

The biggest hazard in a modern mine is probably the accumulation of dust in enclosed spaces. I'd guess injuries during machine maintenance and repair come second, and cave-ins are a distant third. (I'm speculating though; I don't have data to back that up.)
Ask HN: What is the best way to remove personal data from white pages?
Is it even worthwhile?
No, not "just". Unless all you know comes "just" from the headlines.
Properties like Twitter are more than just some corporation, it's a user base, and a history of user activity built on user generated content. That was trusted to an organization that, effectively, no longer exists.

He's legally free to do this, but morally is a whole other thing.
Tolity
Hey everyone. Hope you guys are having a fantastic day. I'm a frontend developer currently working on
@tolityapp
. I just launched my project on PH - https://producthunt.com/posts/tolity

I'm still new to all of this so I'd really appreciate any feedback.
I am writing this from my own experience.

The worst mentor is someone who mentors others without being asked for it. The worst of the worst is someone who does that and thinks about himself as a mentor.

The best mentor is someone who doesn't know he is one. A person who is doing their own thing and is always there to help. When someone comes to them with a problem. This person solves the problem. Without playing a teacher or something what imposes teacher-pupil labels.

As a beginner I've meet the first type of mentor. Something that could be a 20 minutes long conversation, became 1,5h "I will give you riddles instead of telling you the answer and how I did it" play.
I have never wanted anything from this guy. I meet him again years later. Turns out there was nothing to learn from him in the first place.

I,ve meet people who were the second type of mentor. They would always help me. No playing, no teacher-pupil vibe. Always I would keep in touch eith them, I would work with them. I've learned from them a lot. They had the biggest influence on my skills.

I had to handle interns/juniors myself. I would give them straight answers. I would prepare some tools or docs for them. I would only check with them if everything works. I would encourage them to break things, take their time with work, ask me if anything, and I would just leave them alone.

That worked great for some, and we had a great time working together.

For some it didn't work at all, but they didn't want to work in the first place or ask me for help when they had problems. I would still give them the answer if they asked, tell them to ask me with anything, and leave. They were not worth my time, and I wasn't the owner of the company - not my circus, not my monkeys.
Have you tried plain simple warm-white led-filament stuff for retrofitting lightbulb sockets, or some whizzbang dimmable multicolor toys with remote control?
Shouldnt impact you much. _yet_
Most are due to the firefox tracking protection.
Others (with everything disabled) were for an airline company, some french governements website, and recently an SVG editor that just call to use chrome and doesn't works on firefox.
Very interesting, looking forward to reading the docs once they come out.

Why Java?
Semi related, I was suprised just how many bugs Safari has with animation timing while using Web Animation API. You can't possibly feature detect that, Motion one lib even disables GPU acceleration for them in Safari. In that case parsing user agent is the only option.

https://motion.dev/guides/waapi-improvements#webkit-bugfixes
I mean, I will go on record and say that Leopold II was a racist based on what he did in Congo. I'm comfortable doing that. And while we're at it, Roosevelt was racist for putting all Japanese-Americans into camps. Btw, did you know that Belgium and the US fought Hitler and Tojo, who were also racist? I know all very controversial stuff. Man, I'm enjoying calling people out for racism on the internet and I feel so good about myself right now.
What makes it performative is that this type of nap is taken in a conspicuous spot, so you will be seen to be napping at work as apposed to finding some out of the way place. This is what struck me initially, not that people were napping at work, but where they were doing it.
Oh i dont think you remember when Facebook launched React at their big conference. It absolutely does matter.
> Most people forget that Russia gave NATO an ultimatum[1] in December 2021

More people forget that Russia gave NATO an ultimatum in 2008 regarding giving MAPs to Georgia and Ukraine, and when NATO complied by not doing so, just as Russia demanded, Russia immediately invaded Georgia, and once that conflict went from active to mostly frozen, immediately invaded Ukraine as soon as they again didn’t have a Russia-compliant leader.

And the same people seem to forget that the ultimatum in 2021 was during the war of aggression launched in 2014, not before a conflict that started later.
If any Hashicorp people are reading, can you please tell your middle and senior management that this decision has deeply soured my entire DevOps cohort on continuing to use Terraform in the future.

We're already exploring alternatives. Future client projects may not use Terraform at all.

Languages and frameworks must remain open or they will wither and die.
Link is 404 now. Anyone fork it before it went 404?
> We're the good guys because our concentration camps are smaller?

Basically, yeah. The US are way less worse than China. 700 people is a rounding error compared to China's camps.

> In other words, if China had camps the size of US ones it would be ok?

It would be better, yes.

I wish China had camps the size of the US ones since that means between 1 and 3 millions people wouldn't have had (and still have) to live/suffer in them.

I wish neither US nor china had them though.
Just scrolled through your open job postings, and the Control Plane opening is jaw-droppingly interesting. Sounds like a marvelous mission you're on. I'm wishing you all the best and will make sure to check back in with Oxide's progress!
Reminds me of when filmmakers in the 90's rediscovered the Fisher-Price Pixelvision https://en.wikipedia.org/wiki/PXL2000
Just on system design alone this was enjoyable to read.

Clever architecture can help as much if not more than clever coding especially when keeping it simple but scalable is needed.
But the best and most successful do #1 well and use the results from it to exaggerate or emphasise their work. Spend the first 60-70% of your day on the latter and the rest+afterwork doing work.

I hate homework with passion and never understood that paradoxical word where work should be at work and not at home. But it's starting to make sense that using some of your "free" time on work is not optional in many jobs that don't pay by the hour.
Lisp, WebAssembly and MMORPGs from the 80s
The easy answer here would be either pure CPU at Hetzner (e.g. a 24 core i9 with 64GB RAM for €84/month) or GPU at lambdalabs (starting at $360/month). Or maybe vast.ai, if you find a trustworthy offering with good uptime.

Though GPU workloads are still a point where building your own server and running it from your basement or putting it in colo can be very attractive.
Derivative works with zero copyright protection due to the predominance of machine assists

No way to quantify though, for or against copy protection

But thats a convenient compromise for now
The Spectrum preset is cheating - it gave me several places where there's 3 or 4 colours in an 8x8 space (which, as any Spectroid knows, cannot happen.)
What's interesting to me isn't code itself, it's APIs and user interfaces. For any given API there's multiple ways to implement it. But they often perform the same.

If my goal was "Good code" I'd probably review and debate the value of each possibility. But I'd rather have any random trash behind a well designed API with unit tests, and then optimize it, instead of make a beautiful implementation with no real abstraction or tests or profiling.

I'd rather have average code in Dart or Nim or Rust than great code in C, unless the performance was too critical for that.

I'd rather have a python stdlib call than some excellent original code.

And if I think the actual purpose of the code is stupid, I'm probably not going to care about how it's written.

Reading code seems in theory like a worthwhile activity. But without hard science how can we be sure the time wouldn't be better spent reading actual literature and reminding ourselves that there's more to the world than code?

Programmers write code a lot, and read it too, it's part of the job... Do we really need to do even more of that?

If there's something particularly interesting I'll read it... but most code is not written like literature. It's written to implement something without anything surprising or innovative. Literature generally makes you feel something other then "Yep those are definitely words".
Looks amazing and incredibly smart. But I found the LOC and implementation time comparisons to Twitter and Threads very disingenuous. It makes me wonder what other wool will be pulled over our eyes with Rama in future (or important real world details missed / future footguns).

Still super impressive. Reminds me of when I discovered Elixir while building a social-ish music discovery app. Switching the backend from Rails to Elixir felt like putting on clothes that actually fit after wearing old sweats. Rama looks like a similar jump, but another layer up, encompassing system architecture.
If the extension is useful to the users of the site, maybe the site owners will want to promote it and help fund development?
There's certainly precedents in terms of black political poetry in music (The Last Poets, Gil Scott-Heron) and there was clearly a need for the disenfranchised to have a voice, but there's the other aspects such as graffiti, dancing and DJing that all came together over time.
Show HN: Project-metrics, Overview of projects and their health
“Are you kidding, carjacking?” – The problem with facial recognition in policing
What would you expect as a fix? How do they know about the timezone you are currently on? Not an easy fix in my opinion as they have to be aware of your timezone (or ask for it) anytime you post
Yeah, after seeing it first hand it triggered me so much that real talent was being hurt out purely on time submitted.

I'm not sure why or how this ever became a workplace norm but I think by every measure it's to the detriment of any kind of innovation or even real productivity.

In Ireland we were always trying to make our job easier with tools, scripts etc , this was almost taboo when brought on site for a client company in Japan.
I just love the programmer's analogy here.
Sorry I wasn't very clear, but I can't find the old version of the web-site by Zed Shaw. It was a free tutorial and it sounds like it was in the same format that the OP was looking for. I can find the current web-site for the paid course and book.
Is there significant widescale resistance to mobilization in Russia? (not a rhetorical question, I really don't understand what's actually happening inside the country)
I think most bugs are the result of someone's attempt to do just that. As is test-driven development I suppose.

Then again proving code works isn't everything either. There's a reason Knuth once stated "Beware of bugs in the above code; I have only proved it correct, not tried it."

Type checking is a nice intermediate, though not all languages allow all properties you care about to be encoded in types.
Are we completely ignoring the technical impact of using a SaaS that is likely in a whole other data centre to everything else?

It is very easy to destroy response latency by pinging loads of messages around when they should be colocated in one place.

This is one of the reasons AWS services are so sticky compared to everyone else.
"Rama is programmed entirely with a Java API".
Using the excess energy to produce hydrogen will depress the value of hydrogen until it's no longer profitable to produce hydrogen at those rates and then you have room for ball milling in the economics again.
I wrote a reply but then I found this and it’s a perfect explainer: https://www.totaltypescript.com/when-should-you-use-zod

Matt is awesome! If you have any more questions I’ll do my best to answer them.
NextJs is still react.
No.

Performative work means pretending to work so others can see. If your work involves an actual performance (even for a liberal definition that includes presenting something) it's not performative work, except maybe under some silly English language loophole.
Thanks for the feedback! I disagree, personally, and quite enjoy them, hence why I've included them.

I love them, myself and - this part is really going to bother you - I'm working on an open source project to help me generate them with even greater efficiency: github.com/zackproser/panthalia

But yeah: my content is definitely not for everyone!
I actually love the weaponization of OSS. It eats away at the technical gap between proprietary systems and their FOSS equivalents. See elasticsearch + openAI (although open models are still quite far behind)
What's interesting to me isn't code itself, it's APIs and user interfaces. For any given API there's multiple ways to implement it. But they often perform the same, and many of them are pretty OK.

If your implementation is bad sometimes it's because your API is bad. Or the whole project shouldn't be done at all. Or you're dealing with essential complexity and no matter how many hours you refactor, nobody but a mathematican will think it's easy to understand, and if you really want to improve at it, shouldn't you be studying math instead of reading code?

I'm not here to write amazing code, I want to make applications that can be maintained. If you pay attention to code all day, you're doing "pure" coding more than "applied" code.
Well I have run a few sizeable communities (albeit smaller than HN) in my day and it seems to me the correct approach is "no posting about Steve Jobs at all" rather than "only Steve Jobs worship is allowed".
"The bill was ultimately amended to remove e-bikes from the list of right-to-repair products" says the article. So they are excluding ALL repairs, not just battery repairs.
Interesting, I find Firefox's devs tools a lot easier to work with.

Firefox's design doesn't sit right with me, but there are themes and addons to fix that.
As a regular end-user of Terraform, what difference does BSL vs MPL make to me? From reading this article it seems not very much? Perhaps I'm misreading this.
What is that attempting to prove or replicate?

Here's a simpler test I think replicates what I am indicating in GP comment, with regards to cookie handling:

Not passing a cookie to the next stage; pure GET request:

$ time curl -s -A "Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Firefox/102.0" -e ";auto" -L https://t.co/4fs609qwWt > nocookie.html

real 0m4.916s
user 0m0.016s
sys 0m0.018s

Using `-b` to pass the cookies _(same command as above, just adding `-b`)_

$ time curl -s -b -A "Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Firefox/102.0" -e ";auto" -L https://t.co/4fs609qwWt > withcookie.html

real 0m1.995s
user 0m0.083s
sys 0m0.026s

Look at the differences in the resulting files for 'with' and 'no' cookie. One redirect works in a timely manner. The other takes the ~4-5 seconds to redirect.