skysight-inc/HackerNews huggingface dataset:
Awesome! I have seen PlanetScale hype up this release for weeks, and glad to finally be reading about it.

My initial thoughts after reading the blog post, just to poke holes in their new product:

1. Costs. This can save time on read, but it is also introducing additional writes to the database, that can be pretty expensive. PlanetScale can scale horizontally, but have to watch out how much it is going to be paying for the extra machines. (Albeit- machines are usually always cheaper than developers)

2. Consistency. It was not clear if it is going to make committing transactions slower to keep all the views up to date, or if the materialized view is running slightly behind real-time.

2a. And how does the materialized view handle large/slow transactions? Is there going to be any kind of serialization locks? Are the views correct inside of the transaction?

3. Predictability. Query planning is a necessary hell, and different queries might have different patterns that might introduce slightly different materialized views, that could have been maybe served under the same view. Increasing the cost.

3a. SQL Server took a slightly different route lately for performance, in which queries will have different plans depended on the table statistics. I wonder how such a feature would play with Boost, and if slightly different query plans might generate different materialized views.
Russian Missiles Land In Poland, Killing Two
The Twilight of Nietzsche
Unfortunately, I have data only from October 2021, that's why the longest time filter is 12 months.
On a somewhat related vein, I've had issues with pages timing out on Safari within iOS 16... You might just be onto something there too.
Ah, that is a better name! I'll have to add that to my mental list of git UX improvements (I'm also a big proponent of `git switch`)
> The business of a normal exchange is normally risk free (just matching buyers to sellers)

tell that to RobinHood
This is interesting, particularly for implementing Intl in JS engines without the mega-heavy ICU. But I wonder how portable it really is.

Sometimes I have to dig very deep to find that what folks call "portable C" is actually POSIX-dependent.

It doesn't appear to be the case after going through the code for a bit, so that's promising.
Despite the greytexting of this comment, I'm still really interested in the discussion around it -- and I'm really curious to hear from people that have the opposite experience.

Moving from SVN to git felt like liberation because there were suddenly idiomatic ways of expressing states that were sort of smushed together by SVN -- stuff like, "I have some changes in my branch I want to line up for commit" which, became the handy one-word concept, "staging".

The before-times were marked by a lack of these fine distinctions. While they existed in fact, they were obscured in-system.

Like a map, any tool should 'resemble' the sphere of human activity it potentiates, and git resembles our diverse workflows better because it has so many asinine distinctions.

This was always its strength, and indeed, likely the reason the platform is called 'git' in the first place, as 'smarmy git' (English idiom for 'smartass') implies an insufferable drawer-of-distinctions.

And like a smarmy git, it's easier to complain about git than it is to replace it.
Not sure which sources she crawled ... Many of the German job boards require companies to purchase job ads which expire after 30 days.
That's why I pirate; no reason to pay for these streaming companies, and have my personal info collected to be sold and receive ads. Just frak these companies, I'm tired of this.

Remember that old meme (I was not even called a meme at the time!) about the steps required to watch a genuine DVD compared with the ones required for a pirate file? We need an updated version.
unflag post please.
In a world where the geostrategic situation can be largely broken down into "the west vs. the rest", Russia is basically China's only ally (in the sense that "the enemy of my enemy is my friend") of any consequence. While it's likely that a conflict between Russia and the West (NATO) would greatly weaken the West, it's also possible that the West could "win" such a conflict without taking serious damage (i.e. via regime change instead of war).

There is no worse outcome for China than the replacement of a neutral/friendly regime in Russia with a pro-western one.
A device with a keyboard was much much better for me than paper in college (netbook at the time, but same idea as a iPad), and would have also made high school better. I can type faster than I can write (including most math needed in engineering, pure math I never quite got there and still used paper); the notes were searchable, more legible, and sharable; and I could bring up class presentations closer to my face and annotate them directly, among other advantages.

Folks can do what works for them, including pen and paper, but there are definitely advantages to the more tech route beyond just "fitting in", and compared to the cost of even a single semester at some schools the iPad cost is easy to justify. Sure, I can just browse the internet instead of doing work, but I can also do that on my phone and doodle in a paper notebook if I'm set on not paying attention, and people have been able to daydream forever.

Edited for spelling and such
Well, for these particular challenges, we're all on a Discord server (https://discord.gg/createwithclint), and these are semi-regular community challenges. There are also smaller weekly competitions, but these are the big community collabs:

Parallel Dimensions (11/2020) - https://www.youtube.com/watch?v=EdCvwmebWN0

Alternate Realities (06/2021) - https://www.youtube.com/watch?v=iKBs9l8jS6Q

Infinite Journeys (03/2022) - https://www.youtube.com/watch?v=JXrWPLNp9tw

Moving Mediations (09/2022) - https://www.youtube.com/watch?v=8b5k0M8wTBg
Russia is losing, but they aren't losing quickly. We'd likely see another 100,000 or more Ukrainian lives lost if we continue the current course.
Much appreciated, I will check you out for my next project. Right now I'm not able to migrate as I'm trying to get an MVP up and running and have spent a few days deeply integrating w/ Supabase.

What are your core value prop differences between your service and sb? Just curious how I should think about your offering compared to what I'm familiar with.
Gensler (SEC chair) prepared remarks, 2022[1]:

The Supreme Court’s 1946 Howey Test, which was about orange groves, says that an investment contract exists when there is the investment of money in a common enterprise with a reasonable expectation of profits to be derived from the efforts of others.

My predecessor Jay Clayton said it, and I will reiterate it: Without prejudging any one token, most crypto tokens are investment contracts under the Howey Test. Even before the Howey test, in the first several years of our federal securities laws, some entrepreneurs were notified that they had to register their offerings of chinchillas, whiskey warehouse receipts, oyster beds, and live silver foxes as securities offerings, as “the purported sale of the…property was merely camouflage and not the substance of the transaction.”

Today, many entrepreneurs are raising money from the public by selling crypto tokens, with the expectation that the managers will build an ecosystem where the token is useful and which will draw more users to the project.

Thus, it is important that we work to get crypto tokens that are securities to be registered with the SEC. Issuers of crypto tokens that are securities must register their offers and sales of these assets with the SEC and comply with our disclosure requirements, or meet an exemption. Issuers of all kinds across a variety of markets successfully register and provide disclosures every day. If there are, in fact, forms or disclosure with which crypto assets truly cannot comply, our staff is here to discuss and evaluate those concerns. Any token that is a security must play by the same market integrity rulebook as other securities under our laws.

That's pretty clear. If there's an issuer raising money with it, it's a security.
Note the line “the purported sale of the…property was merely camouflage and not the substance of the transaction.” That covers much of the NFT market.

[1] https://www.sec.gov/news/speech/gensler-remarks-crypto-marke...
The open sourcing schedule was completely unrelated to the layoffs.

The team working on Sapling has been planning this release for a very long time and will continue working on Sapling to support our internal engineering efforts.
I know who will be writing the next review paper now

(just give it a scientific sub-discipline and it gives a fairly readable wiki-style summary)
It's simply untrue that there is context. Let's just take one example:

> Alameda had accumulated a large “margin position” on FTX, essentially meaning it had borrowed funds from the exchange, Mr. Bankman-Fried said. “It was substantially larger than I had thought it was,” he said. “And in fact the downside risk was very significant.” He said the size of the position was in the billions of dollars but declined to provide further details.

We know the size of the positions! The Financial Times reported on Friday (as news) that FTX held $900M in assets against $9B in liabilities [1]. And that was before the balance sheet was released!

Why is it important to run this quote? Why allow him to spin the story like this? Why let him present it as a mistake? Why not include actual numbers? These are all choices the NYT is making that frame SBF in a positive light.

[1] https://www.ft.com/content/f05fe9f8-ca0a-48d5-8ef2-7a4d813af...
I'm not usually pro-union, but if there is any industry that needs to be unionized it's game development.
So daytime TV commercials?
Random Number Generator Hidden in Rust's Standard Library
Then good luck with that. I remember 2009 which was also a hard year but it wasn't impossible. Maybe start right after you are done.
I doubt that the FB people involved with the layoffs are the same FB people who decided to open source the Sapling project. Many FB engineering managers were not aware that the layoffs were being planned. Moreover, it takes up-front planning and design decisions (by more than just a few days) for a private company to open source their internal projects.
It's not that different.
Number seems to be 81 in fact.
https://www.mentalfloss.com/article/69175/answers-10-tricky-...
Looking at it again, I don't think the law idea I put forth makes sense. The pricing plan sounds more likely, especially given the ringing behaviour at multiples of 30/31 days.

I guess a large majority of those postings go unfilled.

Do you do any work to try to find if a position has been re-posted and recombine it with its previous posting for the purpose of this calculation?
Shall we see a scientific study "100% of People Who Invest in Bitcoin Inevitably Make Money" at the next all time high?
I can't help but wonder if the NYTimes article was intentionally designed to be 99% puff piece disguising the 1% of extremely damning information, just to get them direct access to the FTX team so they could get something juicy. Journalists can be sneaky like that sometimes.

The 1% of damning info was Caroline's reported admission that Alameda borrowed short-term to make long-term illiquid VC investments, and when those loans got called and Alameda couldn't pay, FTX commingled its customer funds with Alameda to pay them.

That was a new bit of info, that NYTimes just casually snuck into the middle of the puff piece without further commentary, but it's quite damning and kinda insane. While all the rubes are complaining about the article being too gentle, the financial crimes prosecutors are adding it to their case files.

https://twitter.com/WClementeIII/status/1592289824542949376
> the dude just perpetrated one of the largest financial frauds in the history of the world. Bernie Madoff level, and this is all the NYT has to say. Totally disgusting to defend the NYT here.

What charges have been filed?

What has he been convicted of?

Comparing him to Madoff is disingenuous. Prior to Madoff being charged, the media was the same... they're not going to print words like "perpetrated one of the largest financial frauds in the world" without charges. The only thing that screams is "defamation lawsuit". To be clear, I have no boat in this race. But calling the NYT out for not making statements that they do not (yet) have the ability to prove is entirely problematic.
such a great font
iPhone satellite SOS communicates to a constellation of 24 GlobalStar Gen 2 Low Earth Orbit satellites, orbiting somewhere between 800 and 1000mi[0]. This is the same satellite system that SPOT messengers talk to (which are also tiny devices)[1].

The user points the phone at the satellite (in reality, the UI tells the user where to put the phone in relation to it's measured antenna pattern to maximize the gain towards the nearest satellite), while the satellite has a huge, very very high gain antenna array to pick up the signal and pass it back down to a ground station. iPhones can output up to 2 watts of RF power, which is enough for a tiny <HELP! Here's my LAT/LON & status> message. It's using 5G NR band 53 [2][3]

I'm sure someone out there has already run a linkbudget and posted it to their blog, but I haven't found it yet.

[0] https://space.skyrocket.de/doc_sdat/globalstar-2.htm

[1] https://www.findmespot.com/en-us/products-services/spot-gen4

[2] https://gearjunkie.com/news/apple-iphone-satellite-messaging...

[3] https://itecspec.com/band/nr-band-n53/
As others have said, I suspect this was in error. However, there is still diplomatic work to be done even if this was an accident. Specifically, Russia must make a public statement confirming that this was in error, apologize unequivocally, and offer some form of meaningful compensation. The risk of no response is that it will make Poland and NATO look weak, and Russia is known for prodding and provoking to see what it can get away with. Better to nip this in the bud through diplomatic means to avoid any lingering doubts about Polish/NATO readiness to defend itself.
I saw those plots and I think there is a false comparison. No way the Lehman plot is at the same level of granularity as the FTX plot. My firm is mid-sized European insurer. We have a chart with low hundreds of entities. Most arise from compliance purposes. Many from acquisitions that have not been definitively integrated. Some follow from certain reinsurance deals. We have many funds in the market, some entities are related to ESG-activities, some are caretakers entities for certain customers. I get it though. In M&A of small firms I have seen ten people work in a firm with twenty entities and have raised questions. But it’s the story that counts. In larger companies you have notaries on retainer just to keep the legal structure follow the organizational reality.
You can also do `sl/hg log -Gr a21ccf+release_1.9`. The graph tells you the relation of selected commits. Last time I checked, git does not have the same --graph rendering yet - it only considers direct parents not ancestors.
I've suggested to orgs going through some sort of business or digital or whatever transformation to leverage excel/spreadsheets as prototypes for data input processes. For example, if there is a question about how to optimize some sort of process - where there might be a need to do some data input, etc.? Well, then start an experiment with a custom spreadsheet, then see how things work, get feedback from users, etc. If participants find that the spreadheet template never needs to change, AND there's value in turning it into something more robust, then you have data and empirical evidence to substantiate the building of a dedicated application for said process. If the experiment shows that too much needs to change, then a more comploex app could need to be built...or hey, guess what, just stick to the excel file. As a former developer, i myself occasionally get those feelings of snobbery about excel...but then i remind myself that the point is to get stuff done...and as long as the tech debt/whatever debt is acceptable by the business, then who cares if a clever excel file helps get the job done.
Yes, that was my experience too--that it does better at generating articles than answering questions. Prompting it for e.g. "Lit review on stellerators" resulted in a coherent text with actual working doi links relevant to the subject.
https://archive.ph/YZfvw
Yeah, there's a reason why AdSense dominates. If you are focused on optimizing your revenue, pretty sure Google dominates.

One other hack - AdSense may limit the number of ads per page, but you can also add in niche networks to increase your ads / page. This was 10 years ago, but I found the best option to be 2x AdSense per page, + 1 niche network. The niche network gave about 25% as much revenue as the 2 AdSense units combined - lower return but was still free money.
If I switch to a previous commit to amend it, then I would temporarily lose all the other changes I made, and means I can't easily run tests on that particular commit to validate nothing else broke.

It sounds like I would need to:

- switch
- amend the commit
- restack?
- switch back to the HEAD?

Fold based upon the documentation seems to move older commits into the current commit? vs the other way around? https://sapling-scm.com/docs/commands/fold

This doesn't seem analogous to git rebase --autosquash which merges the mixup into the old commit.
I've always said the site was in no way immune to be a future member of this list:

https://en.wikipedia.org/wiki/List_of_defunct_social_network...
Q: what is inside a black hole?

A: Sorry, your query didn't pass our content filters. Try again and keep in mind this is a scientific language model.

???
It's really just a matter of habit and getting used to no staging area takes short and has huge benefits.

We develop HighFlux[1] which also gets rid of the staging area. It simplifies your mental model of what's going on a lot.

Because everything you save is automatically committed, switching to a different task/branch is also always instant without needing stash.

Because what you're testing locally is what you're committing, I also never have CI failures anymore (with the staging area I frequently had unexpected interactions with unstaged changes and sometimes even accidentally forgotten added files).

1: https://highflux.io/
Had an interview a couple weeks ago which, unfortunately, didn't work out. Will do.
Hideously expensive?

I sent a decent chunk earlier for (allegedly) only $0.75. I agree with your timeframe argument, but the price of these transactions aren’t always that bad.
Important! If it is offline, please refer to this image until I get it back online: https://gcdnb.pbrd.co/images/ElMG6yee19KT.png?o=1
Hadoop isn't a database, they don't do anything close to the same thing. Nobody is cross-shopping PlanetScale vs Hadoop.

The cross-shop is PlanetScale vs Amazon RDS, Amazon Aurora, Google Cloud SQL, Firebase, Supabase, self-hosting Vitess or MySQL, etc.
Really love the concept, will definitely try it on my raspberry pi. I’ve been trying to keep notes on likes/dislikes of acquaintances and this is way more organized.

However I’m bit curious why it’s not deployed as a standalone desktop or mobile app? Is there a technical limitation?
Scene – the new Urbit desktop, by ~tirrel corp
Those 20 Million should revolt and blast Putin into the black sea.
https://archive.ph/DJfeE
The discussion has run for less than 24 hours; and of those (now) 37 editors, only three (3) have left a comment saying they are okay with the banners as they are.

Good URL trick. It helps to be a staffer. ;)

https://meta.wikimedia.org/wiki/User:DLynch_(WMF)
Great work! Super fast and smooth interface. Curious how you built it!

I also suggest adding WGBH Boston - 89.7 MHz https://www.wgbh.org/Radio
Offtopic: The Oregon sand dunes are amazing! I recommend hiking rather than taking the buggies.

https://www.google.com/maps/place//@43.5823425,-124.2545843,...
Others don't. Maybe it's just so weird to see body text on HN
Yeah, Rust is built from the ground up for programming at scale. One of the consequences is that it makes you think about thread safety from the start. (Imagine if you're on a large team and not everyone is aligned on whether some part of the code is thread-safe or not.) Some things are harder, but the benefit is that you can often make a program multithreaded, and many times faster on real workloads, with just a few minutes of work (an experience that's unmatched in all of programming).

One of the ways Rust is successful at scale is that the intraprocedural analysis is sophisticated, but the interprocedural analysis is deliberately quite basic. It's not quite in keeping with that to do things like selectively enforce bounds on global variables.

For use cases like the one you mentioned, the general strategy Rust wants you to use is to pass around a context with your data inside it (and the data could be in OnceCells if it's lazily fetched). This is also a more testable design. Global state is meant to be used sparingly.
Are you sure smartphones are even relevant anymore? They seemed to have devolved into doing everything mediocre and are much like a dildo/toothbrush hybrid without clear instructions. Dialtone 2.0 sounds like a winner already. The seperation of data and dialtone.

And with influencer marketing, its like celebs decades ago harping about the health benefits of eating a placenta... Are you eating placentas to maintain health? All those vitamins and minerals... Yummy :/

https://www.mayoclinic.org/healthy-lifestyle/labor-and-deliv...

Just because they invented it/said it, doesn't make it a good idea/product.

Product evolution is already well documented. The 1767 invention of carbonated water/soda water did not make large strides until 1886 and did not get HFCS until 1981-1984.

https://www.thoughtco.com/18th-century-timeline-1992474

https://thepopularlist.com/inventions-of-the-19th-century/

https://www.motherjones.com/food/2019/07/the-secret-history-...
I see the InReach as the system to use if you are an avid outdoors-person. This setup is well suited to the millions who took up hiking as a way to get out of the house during Covid and now maybe go out to the wilderness a couple times a summer but don't fully grasp the risks that can be out there.

Another use case: The there are two highways between my metro area and the Pacific coast. Both are pretty remote through the forest. One has decent coverage with only a couple of mile long dropouts along the way. The other road has essentially zero cell coverage for about 20 miles and spotty coverage for another 20 miles. Winter travelers have gone off the road and not been found for hours or even days. This device could certainly save a life in that case.
Funny. Our professor told us it was called that because a boiler plate is something you cook on, like a griddle or hot plate. You can't cook your food until that basic element is in place.
Agreed, also there were several high-profile reports of retaliation (Starbucks, et al) against union members. While they might have been settled out of court, it is not a good outlook for labor rights.
I don't know if one can draw the October conclusion. Would HR leave the posting up to expire on their own if they know they won't hire anyone?

I say that since they seem to remove them (presumably because they got enough applicants or actually hired someone) before the 30/31 day mark.
Now that folding-screen smartphones are a thing that actually exist on the market, it's not entirely impossible to imagine that the next Switch could be foldable like the SP. :P
> Is it really that confusing for Git?

Complete shit is what it is.

It's awkward, messy, inconsistent, and hard to compose.