skysight-inc/HackerNews huggingface dataset:
I thought this was a nice retrospective on how history rhymes. I think there’s no question in the long run, San Francisco will be just fine. It has too many inherent strengths for it to ever become a wasteland.

I do think the city has some pressing challenges in the near and medium term. On a recent visit, for example, I was wandering through the financial district and I was kinda shocked at just how much obsolete office space there is. To the extent that those properties were highly utilized five years ago and still a substantial component of the city’s tax rolls, that’s a problem. There’s going to be a period of painful adjustment as commercial real estate values are adjusted, and the cost of housing is only going to delay the completion of that reckoning.

It also seems like the city has a disproportionately large exposure to the homeless and untreated mental health issues that currently affect American society generally right now. I have no idea what the solution is here, and I feel pretty confident saying that San Francisco city leaders don’t either, but I’m not sure anyone else does for that matter. So I don’t really hold that against San Francisco or think that it’ll be the demise of the city.

There will be some years of muddling through, but I’d wager a decade from now the storyline today will seem as foreign as predicting NYC’s imminent demise in 1977 or 1989 or 2001.
That seems super interesting. Do you have any book/article recommendations that dive into this mindset?
yes this. green messages imply the person has poor internet reception e.g. when out of town or during heavy storms
I've frequently had drives in a RAID fail in rapid succession. If you buy a bunch of identical drives at the same time and put them in a RAID, then you can end up with:

* They were manufactured in the same batch, maybe even one right after another on the same line.

* As they were transported from manufacturer to OEM to you they were exposed the the same environmental conditions, right down to vibrations, humidity, and ambient EM environment.

* As you use them, they continue to be exposed to the same environmental conditions, including power supply fluctuations and power inductively coupled into places it doesn't belong.

* They see the same usage patterns. Depending on the RAID specifics, that might be right down to seeing the same disk locations seeing the same read and write volume.

Its then not surprising if they fail at about the same time.

The last machine I put together that I wanted to have high availability, I intentionally bought two different brand drives to put in the mirror to maximize the likelihood that they fail at very different times.

Many years ago (c. 2003) the group I was working in inherited a massive 6U storage server with an insane number of 10k SCSI (it was before SAS was a thing) drives. We named it "hurricane" for the sound it made. After a few weeks of using it, the first drive failed. It rebuilt to a hot spare and we ordered and eventually installed a replacement. A few weeks later, another drive failed, and this time before it could finish rebuilding, two more drives in the RAID failed and its contents lost (but we had a good backup). We never used it again. For a while I used it as a coffee table, but then someone convinced me that was too tacky, and it got ewasted.
The specific truth here being the virulence and mortality of C19. Not the origin story.

It should not be surprising the chinese government, notoriously shy of public data, put this stuff under an interdict. It also should not be a surprise that somebody somwehere in officialdom was compiling the stats, because there are two kinds of lies, both bad:

The first kind is the one you tell everyone else. The consequences here go to things between you, or in them. They certainly caused every other economy harm by not sharing data.

The second kind is the lies you tell yourself. A government which doesn't have the real figures cannot govern effectively. Its massively counter productive to understate mortality in the field, in the crisis, inside your planning engine. Somebody needed to know. Maybe it went to the Chinese Academy of sciences and got whited out of the report, but the data went "inside" the system. At the point you tell hospitals to stop publishing mortality statistics, if you also tell them to stop reporting them, you've really lost control of the situation.

And in any event, given time, it comes out. The surplus deaths figures, and future population demographics are really hard to hide.
That's true, but the only way to cover everything is to be mediocre at all of it. Or corrupt.

So they can have a few people who are expert in broad areas, like Walt Mosberg. No ukuleles, no toasters.
Unless you're specifically trained for that, it's very hard to fake body language and facial expression. That's the whole point to it.

And it doesn't apply to emoji.
Can you talk about how you integrate gpt API at work and why not just use chatgpt 4?
I run 70B very cheaply using serverless GPUs. I've had the best experience with Runpod, but there are a few other options out there for it as well.
I think this is just copied from original PG docs: https://www.postgresql.org/docs/7.2/locking-tables.html
D. Just ship Python with Excel
The economics of creation are meaningless if distribution lacks physical scarcity. That is the entire problem with copyright in the digital age -- it is physically impossible to control (i.e. prevent) consumption once the consumer has the data, and for IP like music this is impossible to control. Sure, we can attach DRM and technological controls to our work, we can form massive databases of royalties distribution, we can falsely moralize until our faces turn blue, we can even try to craft laws and legislation to get what we ant. But all these things are meaningless in the digital land of infinite plenty to a determined enough adversary, and some music fans are adamant (yet also kind enough to share with others)

If copyright (and DRM) was enforced the way some wanted, we wouldn't have a rich history of remixes, recontextualizations, or bootlegs that allow a work to live on far past its shelf-life. Memes would be a shallow husk of what they are today. We wouldn't have many, many genres of music, and things like the Amen break wouldn't exist and we'd all be worse off for it.

For that reason copyright needs to be abolished. There are other ways of monetizing intellectual property. Once a given work is released to the public, its creators have literally zero control over it, despite the technological artifices we construct otherwise.
This is an alternative model for quality reviews that's lasted about 60 odd years so far.

www.choice.com.au/about-us
Your story is amazing and very inspiring.

> I was 90k in credit card debt and planning on foreclosing the company and declaring personal bankruptcy the same month we got acquired. At one point I recall having a major fight with my roommate at the time over him rounding down 30 cents on a bill we split.

I smiled and almost shed a tear reading this ^
shitshow by Canada and Australia.
I can't believe it. I can't believe it. Wow. Alright, now we're getting somewhere.
I've always felt the Pebble was superior to the Apple Watch for controlling music playback, because you could control the playback with tactile buttons you can operate without looking at. With the Apple Watch you don't really have any choice but to raise your wrist (to make the screen turn on), look at the screen to know where to tap, and tap precisely on the right spot on the screen. With the Pebble you can just feel for the upper button and push on it. One of the ways in which my "upgrade" to an Apple Watch was actually a downgrade :\
> A charitable reading of your post

I don't need you to perform any reading of my post, charitable or otherwise. It says what it says; nothing more.
I usually start with Looria, which I discovered here on HN. It does a decent job of summarizing the Reddit consensus picks, which was how I used to start my search before discovering the site.
External links in Excel are copied and cached though.
Is this resource up to date? ALTER TABLE ADD FOREIGN KEY NOT VALID (PARENT) shows a stronger lock than ALTER TABLE ADD FOREIGN KEY (PARENT) while the PG docs says that the locks should be the same.
We've run experiments on datasets ranging from 5K - 100K examples, which gave fantastic results [1].

Some examples
- https://huggingface.co/datasets/b-mc2/sql-create-context
- https://huggingface.co/datasets/GEM/viggo

On the other hand, 8K examples was not enough to learn to solve grade school math problems [2], so it is very problem dependent.

[1] https://www.anyscale.com/blog/fine-tuning-llama-2-a-comprehe...

[2] https://huggingface.co/datasets/gsm8k
Sam Bankman-Fried (1992 –)
Wrong Sinclair: the quote was Upton Sinclair (who, according to Wikipedia, is “not to be confused with his contemporary, Sinclair Lewis”).
I can assure you some of us have worked in hellscapes where it does change every month ^_^
It's not unreasonable to believe that if you pick two identical products off the same shelf at the same time (as one would logically do when purchasing 2 of a single item), that the two products were manufactured at similar times and in similar conditions.

Your model isn't exactly bad, but there is an assumption being made that you haven't accounted for. Which to be fair, is frequently not stated. The assumption is that the drives defects are independent of one another. This is a poor assumption when manufactured back to back.
You say 'ah yes' as if there's no value in these steps. Compare with more common steps:

1. Don't try to understand the problem, just stare at the given information blankly.

2. Instead of devising a plan or thinking real hard, try to "guess the teacher's password" and parrot any relevant sounding words for this ... or any related thing - https://www.lesswrong.com/posts/NMoLJuDJEms7Ku9XS/guessing-t... and the linked https://www.lesswrong.com/posts/48WeP7oTec3kBEada/two-more-t... - as if the universe will accept the words (map) as the solution (territory).

3. Carry out incantations handed down from above, regardless of whether they could be applicable to this problem; they are not understood which leaves room for them being potentially powerful and relevant.

4. Give up. If the incantations of power didn't help, what else is there to do? Don't look back.

Are these steps from How To Solve It in 1945 so different from Eric Raymond's "how to ask smart questions" from the 1990s(?) or from Eric Lippert's "How to debug small programs" from 2014 ( https://ericlippert.com/2014/03/05/how-to-debug-small-progra... )? His example "I wrote this program for my assignment and it doesn’t work." is still a common approach to "problem solving" nearly a decade later, not just for student coders either.

People seem to be missing:

- the belief that problems are solvable. (Instead apparently believing that some people know the answer or that the problem cannot be solved; not understanding that someone can start unknowing, work to solve, and then know).

- that solving something involves a mental model of how a thing works, in some context. (Instead apparently believing that solving is random or guesswork or luck or flash of inspiration, but not solved by any kind of knowable process).

- that solving something involves a feedback loop of gathering information, testing hypotheses, learning from the result, looking back (Instead trying one thing and stopping, not seeing if anything could be learned from the result, not trying to expand a mental model from what was known).

Even that this is a pet frustration of mine with some of my coworkers and internet programming askers, I still resist writing down the problem or thinking real hard (as far as I can do such a thing).
> Using a type of AI known as ‘machine learning’, computers are now able to uncover hidden information about the whole body from these images alone.

So now computers use AI to do something, interesting...

I always liked how it's always "AI did X" or "AI discovered Y", but never a "crane built a building".
According to Ahrefs, Wirecutter is on page 1 (Google) for 756k keywords, and position 1 for 95k keywords, so it's probably just not appearing for what you search for.
While the quality has declined, the latest update from detailed.com suggests Wirecutter is making up to $38M/qtr (revenue not profit) for NYT, not a bad return for the $30M they paid for the business 7 years ago.
Why are you sure of this? If it were so readily apparent just by looking what difference would the sirens make?
It’s not an anecdote, it’s the idea that there are no anecdotes.

That is a much more risky idea in the first place, and your link provides quite a few such anecdotes.
> This means that the process is eternally tied to the cloud now.

Not only the cloud, also the subscription. If you cancel the subscription (note that the announcement mentioned it might be a paid module), don't have the subscription (because you got the Excel from a supplier), etc. you already have a problem using this Excel sheet.
How iceberg won the lettuce wars
The atomic trick was very satisfying, especially extrapolating the swizzle instruction from the PowerVR heritage. I don't know but wouldn't be surprised if the Apple engineers are learning from this or at least they would appreciate the sheer cleverness. It reminds me when back in the day, the Sega Genesis video hardware was reverse engineered at Accolade and our engineers used the public Texas Instruments TMS9918 VDP documentation as a starting point to extrapolate the evolved 9918 derived VDP in the Genesis (Mega Drive).
WSL2-Linux-Kernel: Source for the Linux Kernel Used in WSL2
> Conway and Tao are widely considered outside the "roadkill" category of mathematicians.

Ah, but they didn't really /need/ Polya's book.
How large is pretty big? And who said it must be installed by default?

Hyper-V is enabled by default on supported hardware.
>If one guy reads the Tao of Pooh and it helps him 'be' — that is the point. Laozi would likely agree: don't overthink it.

That's still a Western way to see it.

For Laozi that wouldn't "be the point". The point of his teaching was not to help people "be" in any which way, but to be in a particular way, within a certain philosophy of the world and our duties in it.
Your intellectual inconsistency is amusing. You believe in intellectual property but not stochastic terrorisim, even though both are just created concepts to explain things that people believe exist.
SustainOSS Episode 195: FOSSY 2023 with Denver Gingerich [audio]
>On the other hand I'm sitting here typing on a Mac with nothing but USB-C ports that is connected to half a dozen peripherals and a big ol' monitor over those standard ports using standard protocols.

cool, now try two monitors https://www.kensington.com/en-au/news-index---blogs--press-c...
Critical periods for language
But right now I have zero knowledge of your reputation. I have zero interest in finding out the reputation of "user norir"... I am evaluating your statements one at a time, without interest in your historical activity.

I would expect the same of readers of my posts... I highly doubt anyone is digging through my old posts. Who has the time? For what purpose?

The exception is maybe a big claim you make. Perhaps a controversial claim which is hard to verify, and people may then look at your past comments. But if you're not making any big bold claims, or leaking juicy gossip, or dropping any unbelievable truth bombs....

I think your account churn is motivated by something else. It's your business, it's all good, but your HN account reputation wouldn't be used against you. Every day is a new day, and people gravitate towards good faith discussion, don't they? Your spicy post from the other day is forgiven! (to be clear, I am not aware of any spicy posts you wrote). Good luck.
More shitty engineering from Apple, what a surprise.
How do you keep the cost down?
original https://postgres-locks.husseinnasser.com/
I don’t think you understand how this works. At some point, you will surpass the sales tax threshold[1] for most states. Then you’ll be reporting and filing taxes in that state anyway. Adding an employee in a state is not complicated by that point.

So sure, if you’re a company doing only local sales. Or a company doing less than 3-400k of revenue a year, this is probably complicated. Once you hit ~1m in revenue, there is probably AT LEAST one other state you are paying taxes to. Adding states should already be a defined process (or being defined) and an employee moving there is only a one or two lines different.

1: https://salestax247.com/sales-tax-thresholds-by-state
I'm a non software engineer so maybe I do have a chip on my shoulder, personally I don't really have a beef with what people call themselves, however I will say the distinguishing factor in my opinion between software and the broader engineering world is liability and the culture that exists around that. I am professionally held liable for any work I perform while calling myself an engineer. There can be potentially very serious consequences if I am found to have been negligent or to have not followed best practices.

In most parts of the software world I don't think there exists similar circumstances. I'm not sure if there are agreed industry best practices or certification requirements for most types of software development.
How to Solve it (202?)

Ask GPT7 to think for you
The sticky history of baklava
>The only real use-case for crypto was doing crime.

It was never any good at that, either. Cryptocurrency is somewhat hard to censor but easy to track. And in practice, people go through centralized exchanges because blockchains work so badly.
What I like about Project Farm is he often doesn’t make an absolute recommendation. The way he tests is really useful in identifying the products NOT to buy based on specific use cases.
Or the myth ZFS without ECC is more dangerous than anything else without ECC.
Is there a current open source Flash editor? There's an open source player now, Ruffle, and it's in Rust, so the security problems are much less.

Application: a 2D UI for games and don't want to haul in a whole web browser.
A few years ago we had capacitor plague. Are we living now the storage plague? It's getting ridiculous that all storage is getting worse and worse. WD is making HDDs crappy with SMR, manufacturers says that 3 years operating time is already too much for SSDs and HDDs, and they don't joke. I just had a Kingston SSD (okay, that was like 8 years old) and a portable WD HDD (~2 years old) die just this year.

The internet is full of problems lately about data loss and longevity issues.

I remember 20 years ago HDDs were not meant for eternity either, but they definitely outlived the usefulness of the computer that they were bought with...
I second the Hillel Wayne article, and the whole series he wrote on the subject. It's a really good exploration of what engineering looks like in different disciples, what software engineering can learn from other engineering disciplines, and what other discipline can learn from us.

I think people hear engineering and jump immediately to a handful of big professions like aerospace, or civil engineering, and build their view of engineering entirely based on that: very controlled, very life-or-death, everything needs to be done correctly, etc. But that's kind of like assuming that what Google is doing is representative of all software engineering. And while it's true that software engineering is probably one of the less mature branches of engineering, there are things that we do a lot better than other disciplines, like change management (i.e. git), or automated testing.
Yes, but the HTML50-output options leave a lot to be desired - it's not as simple as taking an existing multi-megabyte *.fla file from 2004, opening it in Animate CC and going File > Export - there's a whole bunch of incompatibility and breaking-changes involved, some are listed here: https://helpx.adobe.com/animate/using/creating-publishing-ht...

What's kinda interesting to me is that Macromedia also had a Java-applet-based SWF player, which got me wondering why a Java-based version of Flash, instead of the native-code Flash, never took-off as a more secure alternative.
I'm trying to negotiate my rent now. Thaaaaannnnkkkk you, sfgate.com. That's exactly the kind of article I like to see.

In all seriousness, SF has felt more alive than ever. Perhaps people are leaving, but after the pandemic, it feels great here.
Is your code subject to code review? If so have you done anything to improve that bottleneck, or was it never an issue at previous productivity?
Of course but I’m not going to just trust a podcaster for closing to have a PhD
I don't use AdNauseam but I have been thinking about it more lately, not out of malice but because I wonder if it's simply a more efficient way of preventing trackers from learning about me than by standard blocking. I am concerned no amount of blocking is going to cut it, and there will always be little leaks of my data. If I stop trying to hide from them and instead jam their systems with as much noise as possible, maybe they will have less useful information about me than if I continue to hide while dropping inevitable, accidental breadcrumbs.
> Connection centric: SQL's session-based transaction model is maladapted to modern cloud computing abstractions such as serverless, and is difficult to manage at scale.

There's nothing connection-centric at all to the language.

> Inflexibility of result structure: SQL is particularly inflexible in terms of control over response: A query result is always a set of tuples. A query is incapable of returning a rich structure [...]

Many modern SQL-based RDBMSes provide JSON support for this. Some support row/record values, which is -in SQL- more natural than JSON.

> Complicated, irregular syntax:

Well, few like the SQL syntax -- there is that. I wouldn't say it's complicated syntax though.

> [...] and allows only limited forms of composition.

CTEs and subqueries are the main methods of composition in SQL.

> Opaque, unpredictable performance:

Yes, well, yes, of course, because SQL is declarative. That the programmer gets little control over the query planner is part of the point of SQL. The query language really needs to be like this. What could and should be done however is to have a) ways of addressing parts of the query, b) ways of specifying out of band (i.e., not in the query) hints or requirements for parts of the query's planning.

I really would like to be able to:

- specify indexing for CTEs
- be able to pass in hints from outside
a query, like what table source to
make the "first" in a query plan,
what indices to use for specific
table sources, where constraints, etc.

> Rigid tabular data model: Despite the theoretical adaptability of the relational model to many domains, the flat, uniform structure the traditional SQL database imposes on records is especially rigid, forcing a significant amount of upfront design.

I don't agree that this is a problem. You have to design your schema? The horrors.

> Introducing new query patterns and schema evolution is fraught with a significant amount of operational risk. Combined, these hinder iterative application development and risk locking in bad data model design decisions.

This is not exactly not true of alternatives to SQL-based RDBMSes...

TFA makes very strained arguments.

There are good arguments for a new language, but there's no need to make strained arguments along the way -- it detracts from TFA.
Designing Data-Intensive Application, aka “The Boar Book” (kabanchik)
Solid job! I thought that the link provided was a clever way to introduce you to the product.
> What killed the Wirecutter for me was the standing desk referral code scandal, full stop

They responded and pointed out that Nextdesk was wrong, but if you've ever worked for any journal or know someone who has, they will all tell you that the reputable ones, like NYT, have a complete separation between income and reporting. Literally the only common link between them is the CEO.