skysight-inc/HackerNews huggingface dataset:
The problem is that such a decline has intense inertia. When you have declining birth rates, average ages go up. Caring for elderly becomes a more significant chunk of the budget of a society. An only child for example has to care for 2 parents, potentially grandparents, themselves, and if they have a kid, half a kid. When you socialize this, people who have kids subsidize people who don't.

You can see how this would spiral. The society that makes it out of such a spiral is unfortunately the society that stops caring for it's elderly. The transition period would obviously be extremely unsavory and socially catastrophic. What winds up happening is people become incentivized to have kids so that they have someone to take care of them, and those who have more kids inherit the society a couple of generations down. That's what reversal of this trend looks like, it's not just about population numbers, median age is an even more consequential factor.
Hi! At the moment, we show a range of simple digestible graphs, with a relevant graphic customised to each question type so it makes the most sense (e.g. a heat map for the address input). We also do correlation analysis, showing which pairs of questions have a strong relationship in their responses; again, in a plain-English simple view. You can even see the regression graphs for the most correlated question pairs.

Analytics is a struggle due to the E2EE, but we've done some benchmarks (which we're hoping to formalise and publish soon) and it's surprisingly lag-free even with tens of thousands of responses! So we've got the basic groundwork, and we're hoping to add more analysis in the future (as long as it doesn't require a stats degree to understand!)

Hope that helps, and thanks for your interest!
I hope I am missing something in this logic?:

Broken indexes are intentionally left because indexing can be a long operation on a big db, so you may regret not just repairing them..

Let's delete and recreate indexes all the time, just in case because they might be left over..

Hope we don't encounter the reason they left broken indexes and wait a few hours for a rebuild?
Really? That is strange as for me lowercarbon had a posts and I have quite a few comments.
> The paper that definitionally is Raft doesn't tell you how to interact with durable storage.

That's being a bit pedantic. Yeah, I did mean that any respectable library implementing Raft would handle all of this correctly.

> without having to crawl some Btrees by hand.

This is not how I query an index. First, we don't even use Btrees, most of the times it's just hash-tables, and otherwise it's a simpler form of binary search trees. But in both cases, it's completely abstracted away in library I'm using. So if I'm trying to search for companies with a given name, in my code it looks like '(company-with-name "foobar")'. If I'm looking for users that belong to a specific company, it'll look like '(users-for-company company)'.

So I still think you're overestimating the benefits of a query engine.
I mean, this is exactly why I go out of my way to pay for subscriptions via the App Store whenever I have a choice. I don't want to go through some rinkydink "please don't cancel bro" cancelation process on somebody's website, I'd rather just open the App Store and cancel it in one tap. Not to mention the subscriptions and purchases are automatically shared with my wife.
Related:

Algorithmic price-fixing of rents is here

https://news.ycombinator.com/item?id=41212616
If it doesn't show for you in the README (it didn't for me at first), just click on demo.gif
Do you do any alerting for INVALID indexes? For example, by default PgHero will display them prominently and I believe PgAnalyze does as well. My thought is to put the energy into making INVALID indexes highly visible. Perhaps combined with a process step. 1. Any CREATE INDEX CONCURRENTLY migrations go out in their own deployment. 2. Any queries that depends on that index being present means a PR has a process step asking the author to verify that the index exists and is valid. That way you wouldn't have to lose if_not_exists.

That all said, still would be cool to make this the default in Active Record. Nice idea!
Car commuting is a carbon problem. So is buying a larger house, lower living density, and larger yards. I’m addressing solely the claim about this being lower carbon footprint. I’m not addressing any other issues or concerns.
Do you even understand how hard it is to become a citizen from an immigrant?
No branch yet, we're still in the early research and experimental stage.
He is saying what is very easy to see in certain contexts is not transferrable to the abstract. Go can be shockingly productive at certain tasks, but it also falls flat on its face at others. If you take your limited experience with Go (or whatever; this applies to all tools) where you found it to be highly productive and then conclude that it is always productive and therefore a tool you can use in all situations, you are bound to encounter negative productivity when you have a different problem to solve.

Need to write, say, a network service? Go can no doubt give just about anything else a productivity run for their money. Need to solve a machine learning problem? ... Good luck. It can be done, of course, but you're quite likely in for a whole lot of extra work not needed in other ecosystems, destroying any semblance of productivity.

In other words, the comment is a thinly veiled "use the right tool for the job".
Has the mystery of life's 'handedness' been cracked?
I enjoyed this article. As a bit of a contrast, I also recommend this article I came across yesterday, which criticizes the American idea of building a home as an isolated utopia:

"The Suburban Lifestyle Dream" https://www.ryanpuzycki.com/p/the-suburban-lifestyle-dream

> Even as the West has built some of the world’s most extraordinary cities, this Puritanical, anti-urban throughline runs across our culture. The desire to return to an Edenic state is a central theme in the story of how the “Suburban Lifestyle Dream” first entered our collective conscience. That dream has powered the unique pattern of suburbanization that typifies much of modern America—one marked by “stratified and segregated social geography” and “relatively low density.”
Any sort of audio/video control for sure, which is a substantial portion of patreon content. Also, if you want to support offline content, it's nearly impossible to do it in a browser.
It is patreon, creators will just ask people to use a browser to subscribe.
So we have turned an asset into a liability and are surprised when the change in incentive has predictable outcomes.
Nice! Many, many years ago, when Shelfie was shutting down, I was imagining we might want VR bookshelves one day, and I convinced Brewster to store Sheflie's spine and cover images over at the archive. Might be worth reaching out to see if they still have them. Spine images are a little hard to get; they're not part of the Amazon API, for instance.
Related:

No reasonable expectation of privacy in one's Google location data - https://news.ycombinator.com/item?id=40958458 - July 2024 (163 comments)
That said, SF's sky high rents are largely due to decades of anti-growth policies that have prevented building enough housing to meet demand.

Yes. This reminds me of the way so much emphasis is put on trying to prevent people from sparking wildfires with cigarettes or abandoned campfires and ignoring the work that needs to be done for good forestry and controlled burns for decades.

It's incredibly short-sighted and irresponsible behaviour when it's done by individuals but institutions somehow get a pass.
https://archive.is/PWnVH
Good q! Check my other comment here about spine images.
I dunno, it takes me about 15 minutes of actual work to change my oil, vs driving to and from the shop and waiting. It’s like a 10x time difference, and I’m still probably doing it with more care than Jiffy Lube.
I don't have any Apple devices, but as a Patreon customer, I'm going to be affected by this requirement that Apple is forcing upon Patreon.

The entire point of this article is that Apple is abusing their market power to force other companies to do things that affect people who are not even Apple customers.

But regardless, your argument is laughably wrong. We don't have "countless other brands". We have iOS and Android. They are not fungible. There are pros and cons to both platforms, and sometimes it's impossible to reconcile a showstopper negative on one platform with a different showstopper negative on the other. Or to reconcile a must-have feature on only one platform, even though that platform also has a showstopper negative.

Yes, it's nice that there are many Android manufacturers, but they are still largely very similar products, with the "differentiation" being annoying most of the time, not a benefit. The idea that we have "choice" is hilarious.

Anyway, any time someone suggests "don't have a smartphone at all" as an alternative, my respect for their opinion drops to zero.
A Systems-Minded Approach to Creating a Music Player Application
Ask HN: What are some AI utilities that can help with SQL development?
SQL is a more challenging problem compared to standard software development languages like C# or Python. Generally, it requires information on database schema. I've not found GitHub Copilot to help with my SQL development, doing worse than an IDE's built-in intellisense.

Are there any mature (preferably private/local) AI tools that help with SQL?

I've seen some things with DataGrip but doesn't feel quite there yet. (https://www.jetbrains.com/datagrip/whatsnew/2024-1/#:~:text=day%20trial%20available-,AI%20Assistant%3A%20option%20to%20attach%20schemas,-DataGrip%20only )
"CEO of company selling product does stealth advertising to suggest that their product will be so good that it will cause amusing problems."
> Walled gardens suck.

Let me fix that for you. uhuhm. Duopolies suck.
they're just sharing information. ie. protected speech.
Tenstorrent Is Continuing Its Contributions to the RISC-V Open Source Ecosystem
One should not forget how the FCC gifted the bottom of the 220 MHz band to UPS, who never used it.

https://en.wikipedia.org/wiki/1.25-meter_band#U.S._reallocat...

I have a better idea. Take the old UHF TV channels 70-83 that were re-allocated to AMPS cellular and re-allocate them again.
The lack of controllers make the Vision Pro poor for games; it can't handle even bog standard VR games like Beat Saber.

I'm pretty sure I remember Apple demonstrating hooking it up to an Xbox controller. I think the only thing more bog standard than that is an Atari 2600 joystick.
Dude just go look at the founders at ycombinator, huge percentage went to top schools. They only interview them for 10 minutes. Without some kind of proof of being able to run a startup (MVP and traction), capital is allocated based on education.
Whatever price you put, you will get it wrong the first time.

Make an educated guess (maybe informed by your competition), and test raising and lowering it over time. Make sure you have a tier of pricing that gives people the chance to pay you a lot of money in exchange for additional value you can provide.

Talk to your customers and understand who they are and have that inform the types of tests you do or tiers of pricing you can offer.
This is speculation: for younger people, apps are the web. I think there is some age/line where on one side, your first instinct is to open the browser on your phone and navigate to a website, and on the other side of the line, you open the app store and navigate to an app.

Personally, I agree. I want better/first class mobile websites over an app. I don't want apps for most things. That said, I didn't grow up in a mobile first/mobile only era.
Ha! When we were putting in the flooring in the kitchen, I kept interrupting him "optimizing" the layout and he snapped at me like one of his workers. He immediately apologized since I was paying him, but I told him that he was supposed to yell at me because he is the boss when it comes to building stuff. He knows what he's doing and I'm just trying to learn. We have a great relationship and I know when to back off and let the expert just do the right thing.
> this software we pay lots of money for says we could be charging more money? No no, let’s ignore this suggestion for the good of our tenants

But the software doesn’t make the number go up. Landlords’ privileged bargaining position does. Collusion requires some prohibition on undercutting; otherwise it’s just markets being markets.
Ask HN: What note taking app do you use and why?
I have been paying for evernote, and recently read BASB which has inspired me to take more notes. Before I commit to evernote, I'm taking a look at other note taking apps, such as Obsidian, Apple Notes, Roam. Curious which app you use to take notes and why?
We already had Flash, Silverlight, JavaFX and now Flutter (with Wasm). How is Pax better than them?
> What saved Intel? The Pentium-3.

The Pentium-pro which become the Pentium-2, then Pentium-3 then... Of course each change in name come with some interesting new features, but the Pentium-pro was where that linage started.
Your solution works in a geometric world, where light propagates in a perfect straight line of infinitesimally small width. That's not true in reality, where light propagates in an ever-expanding cone.

More concretely, you can have two cameras photographing along different but parallel planes that do see each other.
What was the loophole?
Having houses spread out and lowering population density is bad for environment. More roads need to be built, more infrastructure needs to be built, etc. We consume too much. America is not in danger of having too much population density. We are too spread out as it is.
A good handyman is an incredible asset. I've had periods where I had one available, but they are very hard to find, and like most professions, hard to keep as someone else will often outbid you (or offer full time employement in these cases). I could keep one busy for weeks right now, if not longer...

I too lean towards DIY but have had to learn to make the hard decision on projects. "Will I realistically get this done in O(days|weeks)?" "Do we actually have any weekends free in the next ~month?" This usually leaves enough low-pressure jobs for me to do on my own, while maintaining domestic harmony by paying someone to do the rest.
Isn't Patreon essentially just a website to pay creators? What added value does the iphone app even provide?
Daily sewage showers for equality. There is a good platform to run on. /s
A bit of a tangent, 3 days ago I opened a small issue with RiMusic, not only did the maintainer reply within a few hours, they implemented the feature I requested and it is already in the F-Droid build running on my device
If they work long nights, they will be dumb eventually. Permanent stupidity can be induced by a relatively a short period of sleep deprivation.
> required (or strongly pressured) landlords to adhere to their recommend pricing

How?
We need to expand ISM license-free zones to facilitate experimentation and development, not shrink them even more. 902-925 is not ISM in Europe and it sucks. Don't let them take it from you over in the US!
Fantastic!

Sadly it’s quite hard (and expensive!) to get a real SC-55 in the UK :/

The 8820 is the same architecture etc as the SC-55/88/88 Pro, so the simulation is basically swapping out the sample sets. I can’t tell the difference :)

My next target is a MT-32 :)
It takes me about 30mins - 45 minutes to do my oil change, it takes me 20 minutes to go the dealership, another 20 to go home and about an hour wait. So I often save about an hour of my time doing it. There's nothing mess about it, I have an overall I put on when working on cars, about $40 from amazon. I put on gloves, and pre lay paper wipes where the oil might drip. Once I'm done, I take the gloves off, clean up, toss in trash, done. The only extra is that I just have to collect the oil and once a year go dispose it when the city collects hazardous materials which costs me about an hour of work. About 10 oil changes a year and I'm saving 10 hrs. When I do physical work is the time that I take to step out of the computer and think about code.
Both have to happen. I live in a very friendly to develop location and rent/housing prices have skyrocketed up to CA prices. Not due to a lack of housing, there isn't an apartment complex in the area without vacancies. Yet everything has lock step raised their prices.
Yeah, there's nothing wrong with that. The weak point was that the software supposedly required some action to deviate from the suggested price and required some degree of adherence to the price. I don't have the software myself so I can't say how much of this is blown up and how much real, but that definitely seems like it makes things problematic.
> There are a bunch of square ASCII, like PETSCII

Note that e.g. PETSCII, while internally 8x8, would be displayed using non-square pixels[1] - also not resulting in square letters.

[1]: https://retrocomputing.stackexchange.com/a/13871
It could be that nobody cares outside tech and nerd spaces.
That's distinct from the existing per-creation billing in a few ways, with the most obvious being that the existing method is automated while consumable purchases require user input. Trying to create a SKU for every possible per-creation price is also just incredibly janky and hacky in a fundamental way that would never scale and would probably make accounting next to impossible.
I'm an active aider user, I spent ~$120 last month on a combo of Sonnet and Opus. It was much more expensive, as you probably know, with Opus. Now it's rather reasonably priced and more sustainable, IMO.
Actually the index can only fail because of a deadlock or a unique failure.
Deadlocks are rare and are probably an Application bug and for unique failure you need to fix your database anyway and you either need to drop and recreate it or reinfect it (new stuff will use the index for unique checks even in invalid state but not for queries)
> The beauty of capitalism is that we used to have horses and shoes only, then black cars became an option, and now you can buy any color you like.

I'm pretty sure it's at best wildly misleading to argue that the reason cars were invented is "capitalism".
It's written in headlinese [1].

[1] https://en.wikipedia.org/wiki/Headline#Headlinese
How about "hosted" in isolation using a server(s) which are guaranteed to be single occupants?

You retain control over the software and they have assurances the hardware is not shared
I'm not arguing that this never happens, I'm arguing at the magnitiude:

> 95%
Yeah probably. But no flourine, I'd guess.
As the saying goes, "Wherever you go, there you are."
Yeah, def, good call.

I have a job that runs nightly or weekly and performs a concurrent reindex on tables, which nicely covers cases like this.

Given that lock timeouts are very much "rescuable," I'm also thinking about addressing the problem right at the start (when adding migrations) by implementing retries. This approach at least would eliminate the need for any follow-up steps by developers and reduce additional cognitive load.

The ideal goal being "The system just works"™ :D
Apparently it's already so common, it's become a pedagogical task for learning to code with Llms :

https://aws.amazon.com/blogs/machine-learning/build-a-robust...
They are a very effective tool for finding burglars.

That's how many burglaries are solved in my area. If the exact time of the burglary is known (from alarm or security camera) a very specific warrant is given for all phone activity at or near that time at that location.

I'm hoping if the warrent is more specific (perhaps finding similar burglaries and requesting information only for matches between the two locations) they can still be used.
This is when the doctor leaves the ER examining room for a minute and you glance at the notes. "No abuse suspected at this time" is all you have time to make out before his swift return with the prescription for the antibiotics and instructions to keep the kid calm and quiet for the next 24 hours until the anaesthesia is completely out of their system.
Yes, very simple, except that when physicists say "tensor", they mean tensor fields, on smooth, curved manifolds, in at least four dimensions, often with a Lorentz metric. Things stop being simple quickly.
Time resolution is a funny thing. With enough detail, it can be said that your head exists in a slightly different time than the PC you are sitting at, or that one end of a RAM module has a slightly different time than the other end.

Fortunately we haven't yet reached situations where that would actually matter, and, with some luck, never will.
That's not really a choice. That's "either do what we say, or your business will be destroyed".
Apple creating an ecosystem of mobile apps is causing all this. Just go back to the Internet’s universal UI: the Web
We generally ban any IF NOT EXISTS in our team (we use MySQL) because it usually masks the real problem (why is the developer trying to create a table which already exists in the test environment? maybe there's a name conflict with another branch etc.)
>AI will allow people to select the stories and movie experience they want on demand.

Yeah there's a bunch of movies/show I'm not interested in watch but fascinated by aftershow content, i.e. all the game of thrones podcasts/recaps. It's interesting the variety you can get in a 5 minute recap, a 20 minute one, or a 2 hour one. There's alot of mid movies out there that I'm satisified with just the recap. Ditto with all the channels summarizing entire seasons of TV shows. I'm just waiting for a selectable X minute recap/summary/synopsis slider for content. Bonus choosing how recap is done, i.e. I really like game of throne wiki because it feels more like history book with drama stripped out / toned down.
My understanding is that Acceptance and Commitment Therapy (ACT) is considered a "fourth wave" psychotherapy, whereas Cognitive Behavior Therapy (CBT) is considered more "third wave". Many therapists still focus on CBT, so those that are interested in ACT will have to seek out practitioners of it.

The classic consumer-facing book about CBT is "Feeling Good", and a good consumer-facing book about ACT is "The Happiness Trap."

I share this because your comment may resonate with people, and I think it's important to understand that ACT is quite different than the more-common CBT.
What’s wrong with the native html <video> tag? Or <audio>? I use those for everything and i’ve never been unable to control media.
"In it, he argued that to restore the play-based childhood, we must first rebuild strong in-person local communities."
Churches! It is perfect, gives community, hope and a purpose. And the Christian way to live and be is a very good model.
Absurdle was a lot of fun! I was thinking the "share score" thing does show a score of "n/∞" which I guess is supposed to mean the game could keep going for an indefinite length... but someone smarter than me can likely prove what the upper bound is in the general case or in the case of your opening word, both of which are definitely going to be lower than ∞
Well of course you can't recall it, it's an antimeme.
Reindex starts fresh on a temp index and then does a swap in the end - https://www.postgresql.org/docs/current/sql-reindex.html
No it can't. That's GP's point. We can reason that one gymnastics skill is more technically difficult than other skill, with various degrees of certainty. We cannot reason and especially codify the same for poetry or its component parts.
What does the app do that <video> <img> and <audio> cannot?