skysight-inc/HackerNews huggingface dataset:
Hard read but resonated with me. Late 20, living in rural area and introvert. It is very hard to make new friends/find love. Tech is no solution in my experience, getting out is somewhat harder since covid (get social anxiety much more easily). You end up just going through days mechanically.
Isn't this literally in the article? I think so.
There are less bitcoins than there are millionaires in the world, and the dollar is only going to continue to depreciate.
YouTube's error-prone Content ID system. Despite being in the public domain now, YouTube may still take it down.
My guess is that next to zero actual thought goes into the design and production of most items these days. Companies are getting cheaply designed cad files and whacking them onto an assembly line and shitting them out into a shipping container bound for a nameless Amazon sellers page.
I try to keep my chocolate bars at 95% cocoa... less than that and I plow through them.
Vibecession. People are convinced there's a recession because everyone else says so.
Lowering the value of commercial real estate would also be helpful. I know of two stores that had to shut because the landlord raised the rent significantly. The landlord did that because the value of the real estate is proportional to the rent rates. The stores stood empty for a considerable time. Nobody won.
The owner can also make money on appreciation still, even if they don’t ever pay down any principal.
A new-year message from the CEO
The PR[0] which has a lot of background on the Rust porting plan.

[0] https://github.com/fish-shell/fish-shell/pull/9512
What story? Or would that count as the spoiler?
I had heard that Edison‘s batteries were subpar compared to other contemporaries. Which makes me wonder if things would’ve been different if Ford and Edison weren’t friends.

But gasoline is so energy dense and at the time was so incredibly cheap I think it would’ve been a fight even if the batteries were better.
Machine Sympathy vs. Human Constraint
What did you see in the light? Don't full a Fermat's Last Theorem on us please...
I just re-read the entire reasoning, and I got it all wrong I think.
N%2 will only ever yield one of two inputs.
In short, I shouldn't try to brain before the morning coffee ;D
I can't find the original post now, but there's a good suggestion that booleans should usually be timestamps:

UPDATE orders SET deletion_timestamp = CURRENT_TIMESTAMP() WHERE deletion_timestamp IS NULL
Because there’s more to the average persons life than overall GDP growth.
I did a bunch of PRs last year on c2nim, which can parse and translate most C code now. The hardest was handling C function pointers that take function pointers. The C for those is hard to parse and easy to second guess, but Nim makes it a breeze.
I don't think it would have been popular. Oil is very cheap $/potential energy and not range-limited in the same way EVs are. And even if you dumped trillions of $s in battery tech 100 years ago it's not clear it would be enough to really improve the situation.
Yes this is extremely strange and has nothing to do with SQL.

This is a bizarre client implementation.

I use blank lines to separate sections of long queries all the time for readability and have never had a problem with any tool ever.
Also, open source, legally, does concern the relationship between the user of the code and its author, and it is not required to be public at all.

Open source works more than fine with defence stuff, actually would be a requirement...
I just got very nostalgic reading/watching this and i usually dont. Great „content“ seems to be getting rarer as companies grow bigger. Last decade was especially bad in this regard.
>The extra benefit is I have no gimmicky touch screen or never used 2in1 hinges to deal with as well.

Its insane that Microsoft, who also produces the XBox, just couldn't be bothered to produce a quality HTPC interface for Windows, when they already had all the elements for such as early as their fantastic Zune interface. To this day, there is no proper UI for hooking my PC to a TV and using it as a strict entertainment center. You gotta download Playnite/Emby , etc
Yeah, like unemployment, inflation, wages and so on, all of which are pretty good in Jan 2024.
> What happens when they are not refinanced? They are owned by the bank just the same.

A fiend in CRE explained that defaulting on these debts is a calculated risk built in to the office owners' business models.

They secure financing with the hope that the investment will pay off, but if it goes under then they let that specific building's isolated business fail. The bank takes ownership of the property and must sell it off at a discount.

The same people who owned the building originally might then go back and bid on the same building again at the new, lower rate.

Both the banks and the CRE operators understand that his is how the game is played, so it's priced in to the cost of financing (in theory). Letting the bank repossess a property is just a business decision.
That’s nominal GDP, real GDP only increased about 2%. Inflation is starting to get under control but the ~3% average this year is still over the Fed’s target. We’re no longer in dire straits but “As good as it has ever been” is definitely a stretch. The dangerous part will be the effects of coming back from a zero interest regime. Foreclosure rates for example started rising last year for the first time since the GFC and in 2023 they increased roughly 18% YoY
I don’t know why the decided for a default like that. In Editor > Editor SQL > SQL Processing

There is a setting called 'Blank line is a statement delimiter' which is on by default for some reason
The bank judges loan viability based on the rental income of the property. Lowering rent in that case might cause the loan to become underwater (acknowledging lower income), and they are better off not renting at all than lowering the rent (not acknowledging lower income even if that means no income).
> This is the rumor at my work about management’s push for RTO. Some amount of tax incentives were provided because the office would drive additional downtown spending.

I guess I can sort of see that if the company is locked into a lease. But I can't see that playing out in the long term - It's hard for me to believe that the city is ponying up more than the cost of corporate rent in tax incentives.
We're working on porting unl0kr from postmarketOS to Fedora to allow for LUKS on the Steam Deck without an external keyboard, that should also work well for a tablet use case once it's done.
Yes, I think it's even less than 0.1%. Assembly should mostly be written as a target for a compiler backend or to inline a hotspot only when it is proven that the compiler can't do it for you. Very few are in either of these two situations outside of artificial environments like a class.
FC Barcelona between 2008-12:

- had Pep Guardiola as coach

- players like Messi, Xavi, Iniesta

But sure, the only super star during that period was Messi...

The 2017/18 team had, in addition to Messi, Iniesta, Suarez and Alba

But again, of course it was only Messi who carried them. Sure.

But even if he did, which he did not, there are only two players like this in his generation, Ronaldo and Messi. That means the vast majority of "rockstar" emoloyees by definition cannot be in that league.
Sure, the current market is down right now due a but due to interest rates hike and the economy being shit, but check the period from 2010 to 2022 please. It went up up up despite a stagnant population.
And turn this off in Chrome: chrome://settings/adPrivacy

https://www.washingtonpost.com/technology/2023/09/11/chrome-...
CS Lewis’ last novel was inspired by an ancient myth, and it wasn’t a quick rehash. It was reworked and retold with a new voice. Perhaps Steamboat Willie will be the same!
Interesting, I’ve never heard about that pattern, only is_deleted everywhere
I would invert the title a bit:

The quality of your life strongly depends on how many bad people you manage to avoid.

People are mostly OK and reasonable to deal with. Some super duper partner will not increase quality of your life 10 times. There is still work, kids and so on.

But bad partner or friend can easily make your life 10x worse, or even put you in jail.

> there are Diminishers and there are Illuminators.

Self-help bs. Normal people are too busy with their lives and paying bills , and will not do some monkey dance to "illuminate" your path.
Understanding a diff usually requires knowing and remembering the codebase well, having a very clear code, the diff being reasonably short and atomic and time.

Commit messages, if good, are extremely helpful to check what changed e.g. in an open-source application you're using. Of course the commit messages can lie, so you should also check the diffs, but it's much easier to confirm what a diff does than deducing it.

Not to mention that for many changes you can only make a guess at what the intention was; if you have a message saying what was meant to be done, you can check that it really was done correctly.
Could probably be done with a DB statment-level trigger. It's sometimes useful to flush tables for testing or work tables. TRUNCATE is even a special case command for such purposes.
A land value tax (Georgism) would alleviate that problem.
For others that also don't know what a rectifier is:

> A rectifier is an electrical device that converts alternating current (AC), which periodically reverses direction, to direct current (DC), which flows in only one direction. The reverse operation (converting DC to AC) is performed by an inverter.

https://en.wikipedia.org/wiki/Rectifier
But you aren't, because there's really only a few stores, not thousands, so people congregate at the same ones, and if there's nobody in those aisles continuously, they stop getting stocked (people create less content if nobody consumes it).

The problem is almost never that there's nobody in your aisle, it's about finding the right way to connect with them. There are numerous ways to do this. Even just leaving a comment on a video asking a question or responding to someone else's comment. That's about as low effort as you can get, but actually works.
The fact the Tesla isn't a start-up anymore makes it even worse.

And yes, BMW having those issues is embarrasing as well.
Given how central gasoline was to developments leading up to and during the Pacific War (like the role of the Dutch East Indies), history would change in all sorts of difficult-to-imagine ways.
commercial real estate tumbles. Followed by municipal bonds tumbling. Cities file for bankruptcy. Growth stagnates permanently since the income from taxes does not fully sustain most cities today. This is largely due to highly inefficient city planning and infrastructure planning (suburban sprawl, highways, and continued dependency on car centric travel generate significant amounts of long term debt that accrue at all levels).
I don't know anything about Manybooks' history, sorry.

At SE we focus exclusively on US public domain titles; that's one of the major philosophical points of the project. The other major point is a high quality standard, so it's in our best interest to keep pursuing that. SE became known due to its quality standard, not because it's more free ebooks. Therefore if we strayed from those points then we'd be just another free ebook site, of which there are no shortage.

Quality is also why we reject self-published books that have been dedicated to the public domain, as those are typically low-quality content to begin with. (Though I wouldn't call every single book we host "high quality content" in the sense that each one is up there with Shakespeare. But books that have survived a hundred years tend to have survived because they're not slush.)
Only for some tables. Depends on the usage.
Not that it's relevant to the issue at hand, but I'm curious about what kind of setup leads to "corrupt orders in the DB" and in what kind of business the correct response to such a situation is to simply delete the offending rows. Surely those orders are there for a reason?
I have been burned by this DBeaver behavior before. Nothing so destructive, but yeah not great. For "more serious" commands, I try to force myself to highlight the command, but should really investigate if there is a way to enable more strict command selection.
Educational youtube is modern age what Discovery Channel documentaries used to be

And they are better, way better
Odroids were amazing. At some point I had 16 of them spread out in various homes plugged behind routers scraping Amazon. They all reverse tunnelled their ssh ports to a public beacon for access. This went on for years until I didn't need them anymore. I still remember zeroing the sd card of odroid14 remotely because the owner had to move out and forgot about it. Sad times.
Right, but as I had no way to understand which orders should be ‘hidden’ and which don’t, from the systems side it was the same as if I hard deleted everything.
So, I know I am a little late to the party here but I think party of the problem is not the smartphone screens. As a society we are doing dismal job of making reality an interesting place to live.

As an example education (at least for me, I'm 54yo) we are told to study something interesting, follow dreams, get good at something academic. Then access to every tool and resource taken away and we are told to go make a living. No fancy tools or studios, the time and environment to do something interesting is taken away. It is replaced with drudgery and cheap entertainment. Think Disney, Hollywood movies, pro sports/gambling, other prepackaged activities, and cellphones.

Government, large/medium corporations, startups have zero incentive to help. Enough people get through the education system to fill what jobs are needed and the rest can [modern equivalent to flipping burgers] and look at their phones.

Excuse my writing. The education system did not work out for me and my family works with our hands. I enjoy working with my hands. I am one of the lucky ones. I tried mainstream and it is miserable. I am glad for the tech industry and the internet and the like. We need to do better for those that are not working for management in what is essentially the company town. It will be a better more enjoyable world if we can.

Makespaces?
More funding and expanded mandates for public libraries.
Extending what education means and how long people can be involved.
I don't know what.
Calibre: Unlock the Data in Your Breath
It's possible the universe is "running" as a black hole computer, here's why
Because of this, it's also customary to use a LIMIT just in case.

For something like this, LIMIT 3 if you assume the query is correct (e.g. in production), or LIMIT 4 if you're running it manually -- so that if it reports 4 rows changed instead of 3, you know you messed up somewhere, but at least you only have up to 4 rows to fix by hand, rather than an entire table.
If copy pasting is that important to you, I don't think you're a good developer.
Are such tools built into RDBMS's?
Apple in its early days nearly failed at every stage of its development. See "Return To The Little Kingdom" by Moritz.

Jobs was a very quick learner, though. For example, he soon realized he needed outside management help.

> We could all be Jobs level if we had the sandboxes he was gifted in the 1980s

Jobs saw opportunity where everybody else did not (including Woz). I worked at a company in the 70s that was far better positioned to develop an Apple-like computer, but utterly failed to see the opportunity. This was hardly unique.
Isn't this just trickle down housing?

If the goal is to lower rents down the chain, why not just build more units at every price point? That way everyone, not just the wealthiest, will get new units and not be subjected to old stock in potentially older / worse neighborhoods.
A decent database has transactions, so you can rollback your fat-fingered queries.
https://www.conservation.ca.gov/index/Pages/CA-big-quakes.as...

Big quake in Japan, rank very high in this list of California quakes
If you've ever done voice prompt recordings for a phone system, voice cloning would be super helpful for doing one off tweaks, especially if you have to record a bunch. Instead of rerecording 20 messages, which can sometimes take hours, you can use a clone of your own voice to make the necessary modifications. My friend does a lot of recordings as part of his job and when I showed him the Adobe voice editing preview he got really excited. It has the potential to make tweaks a lot easier, less time consuming, and reduce voice strain.
Ok, let's change the URL to that from https://github.com/webui-dev/zig-webui above. Thanks!
If I saw this behavior in a tool I use I would honestly report it as a serious correctness bug. All sorts of things can produce spurious newlines and I’m like 90% sure the SQL standard does not permit them to be interpreted as delimiters.
If battery tech was easy and it only failed to progress faster due to lack of a well-funded use case, then submarine warfare should have brought us to Tesla-grade batteries in no time.
If your process requires trashing the commit messages it's not surprising you don't find them useful.
Found this recommended by Alan Couzens, currently testing it. https://twitter.com/Alan_Couzens/status/1741831602932498518
Naval Power in the Pacific: China vs. the United States
Laziness/simplicity, I guess.

You can't safely use semicolons as delimeters unless you parse/tokenize the entire statement (to exclude quoted semicolons). The exact handling of quoted string literals can vary depending on the SQL dialect, or even the configuration, and getting it wrong could cause even more unpredictable behavior.

For instance, on MySQL I don't think it's possible to reliably identify statement boundaries without knowing the server-side value of the NO_BACKSLASH_ESCAPES setting.
That's a frequent request but it would also require having our catalog in a database, which we don't have right now. I do think the time is soon for doing that for several reasons, but there's no spare time in my day at the moment.
This makes more and more sense the more I think about it
The changing economics of open-source software
The usual reason: users flagged it. This is in the FAQ: https://news.ycombinator.com/newsfaq.html.
> does anyone DELETE things now a days?

Yes. OLTPs work best when cold data is hard deleted from the hot instances. Backups and OLAP can keep things for longer, as needed. GDPR, right to be forgotten, and similar regulations may require deleting even scrubbed copies. (IANAL)
Exactly. I guess I didn't add enough context for people to understand what I meant lol
Do you have any thoughts on providing manually pre-formatted PDF files? Em-dashes, curly quotes, etc. are all nice, it's a step in the right direction, but in the end the EPUB file needs to be interpreted by the ebook reader on the fly and in terms of typesetting quality the outcome is far from what physical books provide, since you still get orphans, weird hyphenations, ugly/misaligned chapter titles. For me, nothing beats reading a print-ready PDF file.
Two pieces of advice I took to heart that have resulted in massive improvements to my life:

1) Do not associate with dishonest people, even if they're only dishonest about small things

2) Associate with people you admire, because you will slowly become them over a long enough period of time

Nearly every interpersonal problem that doesn't involve family (can't choose your family) comes down to one or both parties being dishonest or choosing to hang out with people they look down on in some way. In the past six years, almost every bit of "drama" that came my way was from someone I associated with before applying these principles.
I watched a small company building great tech hire experienced managers from big professional firms to put the proper process in place. We didn't have the sales yet, nor the headcount to warrant such efforts.

That was fatal. They didn't need the process and couldn't afford the overhead.

It's worth giving serious thought to whether your company is successful enough to survive this new strategy. It may be time to look for the exit.
Youtube makes it pretty easy for me. The algorithm recommends videos nd channels, and I say 'not interested' to the garbage, the result: a high quality subscription tab.
And yet poor people constantly vote for tax cuts for rich people.
I don't expect min/max to make a substantial difference to the overall runtime of the program. I've added them to the challenge to have a bit of assurance that contenders process the entire data set, rather than doing some kind of sampling (which should be apparent from looking at the code, but then, you never know...).
The texture suuuuucks though, or at least it did the first (and last) time I tried it.
The answer is actually a bit complex. I simplified in the article, the orders are in fact internal ‘missons’, that our operations team needed to execute (I work at an Agtech company, and each such mission is a drone flight above a field).

Due to some bug, there were duplicate missions created, and it messed up the systems and confusing the operations team.
I first saw Tom Scott on Computerphile. He’s so good at explaining topics with excitement and enthusiasm. It’s amazing he’s been so consistent with a video every week for the last 10 years. Not only “a video”, but videos that go above and beyond the norm in quality. He’s an inspiration.
Just to be independent from those grotesquely and absurdely massive and complex compilers(gcc|clang/llvm), justify the additional amount of work for myself.

Not to mention that from the perspective of the life cycle of tons of system software components out there, the actual coding is not that much.
To continue with the transit/urbanism channels...

* Not Just Bikes

* City Beautiful

* Alan Fisher

* donoteat01 (not really uploading anymore since he has a podcast that takes all his time)

* Eco Gecko (also doesn't really upload anymore)

* Adam Something

And also others...

* Folding Ideas (popular topics video essays)

* hbomberguy (popular topics video essays)

* Epoch Philosophy (drier more academic video essays)

* BobbyBroccoli (intersection of science and politics, very well animated)

* Jacob Geller (media analysis)

* Explosions&Fire (aussie backyard chemistry, like NileRed, more of a vlog style)

* Mustard (engineering, similar format to Real Engineering)
There was a study funded by NASA on the topic which made the rounds back in the day. Here is the Scientific American take: [1], here is PBS Space Time YouTube: [2]

The topic pops up now and again, most recently called the The Silurian Hypothesis. There are many articles in respectable sources on the subject, it goes beyond science fiction into literal science.

For example, you might wonder how long it would take for some large portion of the surface of the earth to subduct. I believe the answer to that question is in the paper discussed in that article.

1. https://www.scientificamerican.com/article/could-an-industri...

2. https://www.youtube.com/watch?v=vyEWLhOfLgQ&ab_channel=PBSSp...
And this discussion from November has an update on the progress: https://github.com/fish-shell/fish-shell/discussions/10123
The reason ICE cars won, is that electro motors got good enough to serve as starter motors for ICEs. Which is kind of ironic.