skysight-inc/HackerNews huggingface dataset:
This is great news. I found myself wishing for these earlier today, for some tiny workloads. We've found the c/m/r6g instances to work as advertised: good or better performance for a significant discount. The downside is that you have to be sure your workload will run on ARM. In some cases that might take some changes to your build pipeline, but for certain use cases there might not need to be any changes at all. We've been able to move our PostgreSQL boxes configured with Ansible and operated with a whole lot of custom Python/Bash/Ruby scripting over to these instance types with no changes to our provisioning process beyond mirroring the arm64 postgres binaries to our private APT repo.
From their perspective, it would be rational to cut a deal with JPMC: they bring workforce back to offices, landlords get their money and give a % of that to a few execs at JPMC. And all the health related problems won't be a JPMC's problem. In some sense, JPMC's execs suggest to burn the workforce now, pocket the extra money, and depart to greener pastures (less contaminated with viruses) shortly before the fallout.
Until they get sued. Many of the people who made money of Madoff had to return the money they gained.
Not to mention that the author has apparently licensed this as GPL2, yet posts only the minified JS and claims it is "locked" to only localhost...
I haven’t seen the talk actually. I’m increasingly more interested in this problem space and it’s good to find like-minded people and ideas. Thanks for sharing. I’ll look into it!
When Is Dead Dead? (2019)
That's great, but if you need something like oh... a transaction or more than 5 RPS... nope.
Yup, Wireguard is what I use. I toyed around with both Traefik and Caddy as reverse proxies (not simultaneously, of course), but found it to be much more complicated to set up than a VPN. I wouldn't touch a reverse proxy for personal use again.
I offer myself as tribute!
This approach is the best and works really well if you don't need to do a join on a related table to look up information. If you need to use data outside of the current table for exclusions/check constraints, you have to write a trigger function (as far as I know).

I had to solve this recently, where the actual start/end times were stored on a related table. I'm no SQL wizard, but I'd love to share my solution in case it helps others (it might be terrible).

Note: I changed the actual tables/domain to be generic, this is a poor example and it made more sense for my usecase, but this shows general approach.

-- Let's pretend we have these tables (awful design, but for sake of example):
-- room <-> reservation <-> reservation_info
-- Where "reservation_info" has "start_time" and "end_time"
CREATE FUNCTION check_for_overlapping_reservations()
RETURNS trigger
LANGUAGE plpgsql AS
$$ BEGIN
IF (
-- Find the newly created reservation and join it with the info record to grab "start_time" and "end_time" for check below
with this_reservation as (
select * from reservation
inner join reservation_info on reservation_info.id = reservation.reservation_info_id
where reservation.id = NEW.id
), bookings_for_timerange as (
-- Select every other reservation, where the reservation is happening in the same room
select * from reservation as other_reservation, this_reservation
inner join reservation_info as other_reservation_info
on other_reservation_info.id = other_reservation.reservation_info_id
where other_reservation.room_id = this_reservation.room_id AND
-- And the timerange from start to end overlaps the newly created record
tstzrange(this_reservation.start_time, this_reservation.end_time) &&
tstzrange(other_reservation_info.start_time, other_reservation_info.end_time)
-- Get a count of all the records, it should only be 1. If it's greater than one, there's overlap.
select count(*) from bookings_for_timerange
) > 1
THEN
RAISE EXCEPTION 'Room is already reserved during this time period';
END IF;
RETURN NEW;
END;$$;
The converse is webassembly+webgl. There are different cases where i.e. SDL-based games are being ported to "Web" also Qt provides WebAssmebly support.
Weekly article: Gory detail of success and failure of growth launch today
You are replying to a point that the GP didn't make. This was the precursor for the might-as-well-go-for-letsencrypt statement:

"What if they can register a very similar / regional domain that you didn’t set up already?"

In other words, they register fakebook.com and then just go get a TLS cert for it. If you're not looking carefully, you might not notice the difference.

Whether the CA system, with fungible, interchangeable certificates that can be issued by dozens of CA's (pinning excepted), is worth sinking lots of trust into is an entirely different matter ;)
Killing those things might not be a negative...
Wouldn't that just be the same, just a different timescale? And then there's the energy expenditure of burying it.

maybe there's a way to have your cake and eat it too. reuse it for fuel:

https://en.wikipedia.org/wiki/Plasma_gasification
I want to bring up another question: How much of the work was synchronous vs asynchronous?

A company that is deeply in bed with meetings and face-to-face cooperation will suffer in a remote-first environment. The article, as others have noted, talks a lot about feelings of the upper management rather than any hard data.

Reading a linked article further down [0] says that JPMC, and other banks, were ramping up the return to the office for months, and it's now when they are making it mandatory.

Also, several weeks ago large New York landlords [1] were urging Wall Street banks to bring their staff back into work. Might be a coincidence, but the timing certainly warrants a look.

[0]: https://archive.is/qJYRo

[1]: https://archive.is/LSp9t
The comments mainly relate to the Mac OS implementation, which is clearly very early and not fit for production. As he points out the iOS version is more stable. The company I work for are already shipping a SwiftUI iOS app, and plan another one.

I've been using SwiftUI for design and prototyping since release on iOS, to the point where it's faster for me to prototype on SwiftUI rather than Figma or Sketch. Particularly with animations and overall experience.

The problem for new people is the error reporting is still pretty bad, and it gets flakey if your views are too big. The key is to keep views small and compose them. It's also hard moving to a declarative model for UIKit devs who haven't done React.
Start with the facts.

We have extensive evidence of incremental development of technology, throughout all of history and pre-history. Thus, suggesting that any sophisticated development, such as is seen in the stonework at GT, would follow less sophisticated work is no kind of "wild claim". The term smacks of name-calling and bad faith, so I leave you there.
I see it as good news.

If employees can be fully productive while working from home, they can be equally productive while working from Mumbai.

I'd rather be in NYC office.
Just use it with Emacs, equations will render in LaTeX
Or for those using journald, use Storage=volatile in /etc/systemd/journald.conf and then `systemctl force-reload systemd-journald`. Remove /var/log/journal to get rid of the old persisted logs.
That’s a bad idea: that pushes the burden of data validation entirely on your client or application code. Textual column lengths should be used to enforce sanity checks on data.

I’ve worked on more projects than I care for which had nvarchar(max) columns for storing the contents of a small 3-4 line HTML textarea: most users were expected to type in less than 100 words or copy-paste the output of another program.

One day, that other program had a bug that made it generate about a gigabyte of textual output. That program had a “Copy output” button so the user didn’t realise how much data they were copying. I don’t know how it didn’t timeout when it was inserted, but that user brought the system down for everyone because that gigabyte-sized text value was used in lots of places.
I've set up a small cluster at home via Docker Swarm. I use it to not only an environment to prototype more complex apps, but also keep my devops knowledge up, too.

I originally had a Cluster Hat (https://clusterhat.com/) which piggybacked four Pi-0's on a Pi 3. Even cut out a nice acrylic case, too (https://climbers.net/sbc/clusterhat-review-raspberry-pi-zero...). It worked fine, and I even had Hadoop running on it for a while. The biggest issue was the ARM7 of the host (pi3) vs the ARM6 of the Zero's. This caused a lot of problems with deployments, essentially eliminating the redundancy you get from orchestration systems.
So they aren't buying treasure data then?
This argument and arguments like it suck because it fails to recognize that people who can't control themselves have the potential cause harm to those who can. Stoicism would only work if everyone would instantly adopt it at once.

People who mal-consume social media contribute to cancel culture, spreading lies and propaganda, and providing the fuel for negative power-seeking behavior in political and business realms. These have very real consequences for those innocent parties that don't mal-consume social media.

Aligning with your libertarian pattern, you can say "Well it's up to the people who can control themselves to defend themselves from the people who can't", and then that's precisely why we would introduce laws/regulations limiting things.
Ireland was certainly producing plenty of other crops than potatoes but when I said they were lacking biodiversity I was specifically referencing the potato monoculture. The poor were overwhelmingly reliant on the potato and it was wiped out by a blight that could have been largely avoided with a broader diversity of potatoes being grown. Similarly there are plenty of banana varieties around the world, but the only one sold in grocery stores near me is being wiped out by blight. Imagine if something similar happened to corn or wheat. An aggressive blight on a main cultivar would be pretty devastating, even if there are still lots of heirloom varieties being grown in small quantities around the world.
Clicked on try it out on my phone, and allowed camera, but it did not seem to work. Just sitting here waving my hand at my phone and feeling a bit dumb :-)

Is there some step I’m missing. Or maybe does not work on mobile?
A new firmware selector for OpenWrt
They've rented out their reputation to further this scam. That reputation is now damaged.
Plasma Gasification
I vote for mass "social media" that raise rather than lower collective consciousness and individual quality of life.
I'm doing the same, my disks are much faster than what should be necessary. Exactly the same setup and observations.
Good call! NKLA is down 8% aftermarket
I love CLIM, too bad it's not used much. The whole idea of it is very interesting, an evolutionary dead end that in many ways seems far superior then what "modern" GUIs provide
There's no need for a new operator. The R metaoperator respects precedence, associativity, etc.

my Int $age;

42 R= $age;

say $age;
I speak as someone who's worked for 30+ years on data modelling. Every time I encounter some mongo or other non-relational DB where the company jewels (the data) are stored with no documentation, no data model etc and stuff is just shoved into these stores willy nilly it makes me weep.

Start off with relational, if perf is a problem then look at denormalising, after that then consider other alternatives for special cases. But to see run-of-the-mill apps with no near future scalability issues jumping right into mongo et al from day one makes me want to run away.
If it only costs you $100 to upgrade all your non-server devices from crappy to good, you have to tell me where you shop.
replacing real estate as an asset class can enable affordable housing

This is a great insight. Taking Germany as an example, policies to de-financialize housing lead to low and stable prices. China has been the opposite with the US in the middle.

Ultimately investment gains have to come from somewhere; real estate "investment" has mostly ended up stealing unsustainable amounts from the next generation. Even if you could replicate that with crypto it would probably only work for one generation (if that).

I guess government regulations created the housing market so you could imagine different government regulations (Sinagpore-style?) propping up some crypto instead, but that's not realistic today. Although... a system that almost every working person invests into then cashes out decades later sounds like US Social Security (except bigger and more harmful).

the biggest challenges are implementing illiquidity and regional market pricing

Why are these good?
Might seem a little off topic, but you are well positioned to read "Deep Work" by Cal Newport. It's been discussed on HN many times, and when I recently read it, it felt like someone finally "got it". Like "yes, this is what I've believed, but now someone else is saying it!".

Back on topic - I've been on both sides of this. I started working from home ~7 years ago when I took a job on the west coast, but opted to stay in Chicago.

Prior to this role, I had worked almost exclusively IN the office for ~10 years, with the very occasional WFH day (literally about 1-2 days/year, usually during the holidays, so definitely not a habitual thing).

When I started WFH, I loved it...for about 3 months. I relished the lack of commute. I enjoyed the additional focus / reduced distractions. But then I started to feel the downsides. The lack of connection with people, the higher effort required to collaborate on some kinds of things, etc.

Over the years though, I found a balance. I found new outlets. New habits. And about ~25% travel helped break things up a bit.

And then COVID hit.

And now I'm back to fully hating WFH. My new habits, outlets, and most importantly the work travel, were no longer viable.

On top of that, while I may have been comfortable with WFH by the time this all started, most of the people with work with were not. So they're going through the learning curve, and I'm empathizing every step of the way. Which is in turn reminding me about the things I dislike.

Anyway, this is a super long winded comment that I'll bring to a close by saying: WFH is not a cure-all. It's not a solution to every problem. Like everything in life, it needs to be applied prudently, and a balance must be found.

My advice to you and people struggling with similar challenges is this: quickly learn to set boundaries.

- Set "Do not Disturb" windows on all work apps/notifications.

- Set clear expectations with your management about when you'll start/stop your day

- Don't succumb to the temptation to just keep working...working...working at the end of the day

- If possible (this is hard or impossible for some), set up a dedicated work space

- Only check Slack once/hour if you can. Encourage your team to do the same.

- Invest in good noise cancelling headphones

- Oh, and read Deep Work :)
but that means the audio stream is at least passing through the video card, no? is it only passing through post mix?
We have to follow the same refactoring strategies we use for programming to refactor the way the world works
> Could I remedy all of these problems with extra effort? Sure, but it's far easier for me to simply go to the office.

This, exactly this. People adverse to self discipline are the ones that most want to go into the office, because its "the easy way". But people with discipline should have always, and should continue to be given the choice to work in the way that suits them the best, if you will, that is "easiest" for them. Don't try and make me come into the office too when the things that happen at the office

* open office distractions & lack of privacy
* trivial socialization
* commuting to and from work

are what makes it not "easier" for me to get my work done. Diversity folks, or if you will, different strokes for different folks.
The Internet Crisis: Why Isn’t Access Free Like Radio?
It's against cloudflare tos to be doing mostly video/images for free. It would be a great idea as it would solve the problem of IP exposure but if it gained any traction it'd have to be shut down.
Encapsulation in a Large Rails App with O Microservices or Rails Engines
If this is because of high PM2.5 concentration (due to wildfires or otherwise), I suggest building a DIY air filter, such as the one in the video here: https://www.youtube.com/watch?v=kH5APw_SLUU

When the Air Quality Index shot up to ~150 in my area (you want to keep it below 100, preferably below 50), I went to Home Depot and bought box fans and furnace filters and built my own.

You can check the air quality in your area on this site: https://aqicn.org
Have there been genocides before facebook?

That should answer your question.
Perhaps, but it's hard to imagine a typical GM customer giving a damn about this investment.
120 days in the US by law, unless I'm mistaken.
Wasn’t the earths atmosphere mostly co2 in its early years?
I don't agree that they serve the same purpose; shorting is not the same as buying a put and the two only behave similarly in a very narrow and limited sense that isn't particularly practical. Yes in some circumstances money is gained if the price of a stock decreases with both a short and a put, but the risk profile, timing and cost are quite distinct.

Furthermore it's absolutely possible and in many circumstances likely that the price of a put decreases even if the underlying stock's price decreases, for example if the volatility also decreases.

I don't think many informed individuals treat shorting stock the same way they treat buying puts nor do they attempt to accomplish the same purpose.
This is very on point to how large companies operate.
B-29 Cannon Questions
My question is about the 200cannon artillery B-29
Any ideas behind the nose art and history?And yes, the nose of the B-29 was copied for the mill. Falcon. Can you help?
Perhaps this is because the url has a .info gTLD coupled with a political domain name and is getting tripped up by some sort of spam filter. It sort of sounds like a shadow ban.
If I got my history right, one of the big motivations for physically modeled synthesis in video aka 3d graphics in games was cost. At least that's the argument The Digital Antiquarian makes[1]:

From the standpoint of the people making the games, 3D graphics had another massive advantage: they were also cheaper than the alternative. When DOOM first appeared in December of 1993, the industry was facing a budgetary catch-22 with no obvious solution. ... Even major publishers like Sierra were beginning to post ugly losses on their bottom lines despite their increasing gross revenues.

3D graphics had the potential to fix all that, practically at a stroke. A 3D world is, almost by definition, a collection of interchangeable parts. ... Small wonder that, when the established industry was done marveling at DOOM‘s achievements in terms of gameplay, the thing they kept coming back to over and over was its astronomical profit margins. 3D graphics provided a way to make games make money again.

Not sure if and how this translates to audio.

[1] https://www.filfre.net/2020/06/the-shareware-scene-part-5-na...
Sounds good, we will just hide the fact that the genocide ever happened and arrest anyone who says it did for Anti-Ethopian-ness.

As is the case in Turkey.
Reviewers possibly use org-mode to keep track of those things. Would be trivial if Emacs is their mail reader.

For those who are really taking advantage of org-agenda et al, I'd argue GitHub issue tracking UI is far more restrictive for tracking patches.

If I were in that position I'd be duplicating issues into org-mode anyway (or using an Emacs mode to interact with/sync them). Maybe that's the missing link?
My first thought was to go after the weakest link, or the cables/connection in this case.
Thank-you! That explains a lot!
We Couldn’t Control the Pandemic
If GM didn't know they rolled it down a hill then it sounds like people are going to jail.
I've considered that before. Also means it's possible to share with other trusted people unlike going the VPN route.
Not to minimize the struggles of suburban parents, but I do feel they might be divorced from what single urban life is like right now.

As a "younger" (30 year old) tech employee, in addition to living in a cramped space with 3 roommates in SF with no privacy, I have to work in a dining room because my bedroom has very thin walls. I also have to do cook and clean way more often, when I previously used to get 3 meals a day at work. I also have to haul groceries a couple times a week, which is super painful without a car, and then I have to compete for very limited fridge space.

I also haven't met friends and family in over 6 months, and my dating life's been obliterated. It's been mentally taxing in a way that living with your loved ones in a McMansion isn't. I can't even handle Zoom calls with friends anymore. It's the last thing I want to do after the 3 hours of back to back Zoom meetings I get roped into because I'm "senior".

Again, I don't mean to minimize the struggles of parents, college kids, the many people unemployed, our essential workers keeping things running, or our elderly who are at risk of dying. I'm in a very privileged position. But it's clear that all the lifestyle changes I've been forced to make have been a huge drain on my productivity.
I power a laptop drive with mine. One of those WD passport type things. Works fine for video playback.
Yeah when you dig you'll often find out "decrease in productivity" is in the noise of the data. CEOs and managers enjoy control and surveying their minor kingdoms. I think it's more about ego than efficiency. I know that I am dramatically more productive at home. I hate the distractions at work. The random drop bys, the "do you have a second", the "15 minute (oops 1 hour)" meetings that could be done over slack or email. It's ridiculous. I know it really depends on your work and personality but by and large managerials are type A with egos and they are starting to feel less important so everybody needs to get back to the office stat.
Because people keep lighting them and the media keeps telling us its climate change
Building both gcc and llvm from scratch (which somehow usually ends up happening) is probably more harmony than I need in my life.
I don’t think they are exporting more CO2 production than their GDP peers. For example, The USA has 3x the per capita CO2/GDP of France and the USA imports twice as much per capita from China. That is something I would like to learn more about tho if you have any resources.
Open Product Designer Roles
My company Onramp is helping Parachute Health find an amazing junior and senior Product Designer. If you're not familiar with their org, Parachute Health simplifies the process of prescribing medical equipment to care for at-home patients. For more information and to apply go to: https://bit.ly/onramp-product-designer
A few comments based on lots and lots of experience:

- Wide tables in columnar DBs can make some analytics queries easier to write and sometimes more performant.

- Wide tables can come at high storage cost and make other queries less performant (like SELECT *)

- How much of these things happen is extremely DB dependent. How does the DB's underlying storage mechanism work? How is the data partitioned and distributed? How sophisticated and storage-aware is the query planner? How large is your data? How fast is your data growing? How fast do you need a new data point to be reflected in your dashboard?

There's no free lunch when it comes to this stuff. A perfect solution doesn't exist, but the technology is getting better all the time. I've personally never used sql server as a data warehouse but plenty of folks do.

The stuff I use that I recommend very highly - Snowflake, TimescaleDB, vanilla Postgres. Also, use dbt.
This was using an sd card.
Tesla coils too!
VR-OS Demo
New Windows exploit lets you instantly become admin