skysight-inc/HackerNews huggingface dataset:
Nice UX!

I checked the code and noticed some things that you might want to address in the future (I've done major version upgrades via logical replication myself several times using a script similar to this).

The "default" way of bringing the target DB in sync with the source one (CREATE PUBLICATION on the source then CREATE SUBSCRIPTION on the target) only works for moderately sized databases. Even on ~50GB I noticed that it may take hours to catch up with the origin. There are a couple of solutions:

1. Drop all indices except for the primary keys before performing initial copy, and then restore the indices after all tables have been copied and replication stream started.

2. Instead of copying into a blank database, you could instead create a logical dump using pg_dump with snapshot isolation, restore it on the target DB using pg_restore, create a subscription in the disabled state, advance the logical replication slot to the LSN with which you created the logical dump, and then enable the subscriptions. This way your target database would only have to process the delta between the time you created a dump and the current time. I have a snippet illustrating how we did it: https://gist.github.com/take-five/1dab3a99c8636a93fc69f36ff9....

3. We found out that pg_dump + pg_restore is still very slow on larger databases (~1TB) and it's untenable to wait several hours. Remember that while you're waiting until the dump is being restored, the source database is accumulating WALs which it should later send to the target DB. If left unchecked for 12-18 hours, it could lead to running out of disk space. This was unacceptable for us, so instead of creating a target DB from a logical dump, we created a copy of the source database from AWS RDS snapshot, upgraded it using pg_upgrade and then set up logical replication (similar to how it's described in Percona blog: https://www.percona.com/blog/postgresql-logical-replication-...). Something like this can probably be achieved with ZFS snapshots.

--

Otherwise, it was very similar to how you programmed your library.

Recently, I saw an article here on HN on the same topic of migrating Postgres databases using logical replication. There was a very nice idea to set up _reverse_ logical replication after switchover so that it's possible to roll back quickly in case something breaks.

EDIT: formatting
Well, I'd say that the graph completely explains the problem.

(But there are no minutes loading screens. Some 10s happen, not minutes aren't happening.)
Midjurney is still so far ahead it's no competition. Did a lot of testing today and firefly generated so much errors with fingers and stuff, not seen that since the original stability release. Anyone know if the web firefly and the Photoshop version is the same model?
The explanation I got was my grandfather did the same. In his service records it seems he stops getting older for a few years at some point, probably because after WWII they were trying to get all the remaining enlisted men's records correct.
It's not pulling stats remotely every request, but probably hitting the database with a dozen queries. Caching and optimization is not often a priority in this space.

https://codeberg.org/thefederationinfo/the-federation.info
There's another tangent in here to be had.

I'm someone who loves running, always have, the weight gain happened in my 30's, either because I had a kid and suddenly my ability to just run when i had free time disappeared, or because my metabolism slowed down, or most likely both and more.

That said... Now I've started running again daily for the last year, one thing I've noticed. Beginning to exercise whilst overweight is SIGNIFICANTLY harder than it was when normal weight (or because i was 40, probably another "both" here too).

One of the things that made me realise how much harder it is, was some fitness YouTuber put on 20kg of weights and ran, he noticed a number of things were different. Once I saw that it gave me enough fuel to continue ignoring the hunger for another month or so.
I've read so many biographical sketches of various individuals that begin the description of their stint in the WWI or WWII military with statements like, "when he was 16/17 he signed up for the war, lying about his age…" It seems pretty commonplace.
Making Games
I thought Goldfish go to the top of tanks and 'gulp air' to get extra oxygen. Or so I assumed – does anyone know why they do it for sure?
The founders sold at a perfect time, getting that bag just before traffic dropped due to generative AI.
Turns out "regular" american Christianity didn't need an excuse to push for Christofacist nationalism. It's attempting to take hold literally right now.
Sorry, "best by" dates are the strongest indicator I have that I'm not going to get a migraine after eating pantry food. If any given food was equal, the more I push beyond the dates, the more severe they get.

They're not perfect, but to my body, also clearly not meaningless.

Consider that food producers are logically often already under ample pressure to set those dates in reasonable thresholds on both sides by their reputations and their own supply chain lags.
> The people that killed him got to write history

No they didn’t. The primary sources for Julius Caesar’s life are Julius Caesar writing about his own campaigns, Plutarch, Suetonius and Appian. None of the conspirators wrote any history that has survived.

They literally turned this man into a God after he died! By 42BC the Senate considered him a God. His successor adopted his name and called himself Gaius Julius Caesar because he wanted to be associated with the name. Many Roman emperors adopted the name Caesar. And German kaiser, Russian tsar and Turkish kaiser-i-Rum all refer to this one man.
Another fairly popular one is Dome Keeper: https://store.steampowered.com/app/1637320/Dome_Keeper/
I feel hungry basically all the time (30 minutes after a meal I am hungry again, an hour and I'm at peak hunger until the next meal). I am thin because I only eat at "normal" times; I don't snack / I don't eat whenever I'm hungry (which would be all the time).

You get used to it. People who claim to get "hangry" (like in those Snickers commercials[1]) need to get a grip. If hunger is all it takes to make you a shitty person then I think hunger isn't actually the primary issue.

[1] https://www.youtube.com/watch?v=shOiXy5b5Ro&themeRefresh=1
My father (and me) washed engine parts with gasoline. And occasionally degreased our hands (followed by dish soap and sugar). We practically bathed in the stuff.

Then my father discovered Goop.

My father also dumped engine oil into storm drains. Then into the ground when that was banned. Yes, he was an idiot. (Becoming a treehugger was probably an act of rebellion.)
Pixel density has diminishing returns, we've known forever its not linear. Its the same reason why phones aren't all 4k by now, nobody can tell the difference.
London is not in the EU anymore :)
Ah. Here's the genius part though, and the real business innovation of tech:

>Make a software platform everyone just agrees to click through EULA's for
>Someone realizes, wait, this is a contract. I'm supposed to be able to negotiate.
>Nigh impossible to get in contact with legal.
>If you do, they just ignore you.
>Get more people to do it.
>Business goes under rather than actually try to exist in a world where everyone doesn't just mindlessly accept terms.
Or
>To many small claims court cases, National Court system encourages private arbitration
>Still too expensive.

To be quite frank, and though I'm loathe to make encourage people to send business at lawyers... We live in a world that is entirely the result of our refusal to challenge terms. So many abusive businesses would disappear overnight if suddenly their legal bills went through the roof.

There's no good faith in the vast majority of contracts anymore because all of it is take it or leave it levels of abusive.
Damn, I guess I unwittingly revealed my phonecall preferences. :)

Edit: Isn't there some kind of wake-on-lan on arm chips that the Baseband OS could use?
Equatorial clouds are also much better it seems.
We actually did self-host the community edition for several months using the omnibus version (some features you still need a license for that is same price as hoested). After initial setup it worked okay and was mostly hands-off except for that the performance started to degrade slowly over time. After spending a few weeks digging into the internals and failing to solve the problem we felt that we were better off just switching to a hosted provider. In this case we switched to GitHub because the pricing was better for the features we needed.
> I am not so optimistic that they will die

In the end, the people that drink the Kool-Aid offered by the platform will stay, and the wise people migrate to better platforms. The mega platforms like FB are cults with the main userbase being stalwarts that won't leave.
.split("\n")

It looks like this has the same issue as the Tcl code, where the empty string after a terminal "" is treated as a line. I think that is an error in the Tcl.

You'll also need a .catch(err => console.log("dup:", err));

And the console.log(value, key) needs a tab separator.

And a loop over the argv input files.

All minor tweaks which don't detract from your conclusion.
Sure, but discord gives you no other option.

There is an api you can use to make a third party client, last I saw it's actually just the same as the bot api but you just identify as a "human" instead.

Users risk getting banned for "self botting" if you do this though. AFAIK there is no option to pay to do this either.
I did not do an extensive comparison to DDG but I would say it is definitely worth it. Been paying for awhile now and it blows away Google. And they are constantly adding new features and improving old ones (and finding new ways to improve their back end costs as well which makes it more sustainable).

I use search engines a TON though (especially for work) so 10$ a month is absolutely worth it for me. I am currently trying to convince my boss to buy it for our whole IT team
Probably because it's a publicly traded company that needs to please its shareholder.

I honestly believe that what we are seeing is the realisation that money and growth isn't infinite and companies need to return to actually turn a profit, not just grow revenue. That's why we're seeing Reddit, Imgur, Gitlab, Meta, Twitter and others implement changes in rapid succession. It not even that I completely disagree with their choices, I just wonder why a dumb ass like myself who knows nothing of business was able to see broken business models years in advance, while Wall Street and Silicon Valley couldn't... Or did they just not care?
I'd be moderately surprised if it was necessary: atomic clocks are only really king of time stability over longer time periods (days/months). If this just needs to stay in sync over the course of a few hours (after syncing outside with GPS, for example), then it's much more plausible to do it with a high-precision crystal or silicon MEMS oscillator (SiTime has already become a big player in the phone market because of their low power consumption for the precision they offer, and they have some really impressive higher-end offerings that wouldn't currently fit but perhaps could be made to).
I'm mostly criticizing the OS. When it sounds like I'm criticizing the hardware, I'm probably criticizing the company's inability to ship hardware with an OS that has drivers that work with that hardware (especially considering they control both the hardware and the OS.)

Why do I need to download a kext and monkey with defaults to make the charger work? This was the kind of thing Macs were supposed to free me from.
I was always of the impression that this is an extremely crowded space.

What does Render bring to the table that's new?
It's because they are ultimately beholden to "shareholders" and "shareholders" nowadays expect continual growth. Not maintaining the "growth" will cause the share price to plummet and will eventually get the CEO fired. Furthermore, the high interest rates we have now are squeezing the hell out of margins, requiring these CEOs to look for turnips from which they can squeeze some blood.

So tldr, the greed is a result of systemic forces, corporate structure, interest rates/inflation, and numbers on a spreadsheet.
Eugenics is still plenty popular to the American philosophy, just under the hood. Plenty of racism is rooted in bad ~breeding stock~ "culture"
I mean services. Decent public transport, good healthcare, day care for children, etc
> It's like the difference when somebody gets hurt. (...) The older kids tend to scatter and disappear as quickly as possible.

Definitely not my experience growing up. I'm sorry.
I still cannot figure out what Car People mean when they say Tesla is bad at making cars. What are you looking at that normal people don't see? The one thing I agree about is the yoke steering wheel, but that's on a high-end car nobody seems to actually buy.
One thing that has changed a lot since this article was written and everyone bought RVs during COVID: good luck just showing up and finding a camp spot. Pre-2020, we'd either just show up to a state park on a Friday night, or maybe reserve a spot a couple of days before. Not anymore; I booked all of the spots we might want, or at least could even find available, in March or so and even then we had to schedule around available spots, and not the weekends we necessarily wanted.

Now, maybe it's just WA state, but if we hit the road for an extended period I'd be reserving spots ahead of time even at places far less popular than, say, Yellowstone.
He gave you a recent event and you conceded the point then suggested he use something else.

And, DMCA is bad law but many companies make it worse in their overzealousness to "comply" with it.
Image search was already good and hugely improved - and the native reverse image search is also pretty cool!
I believe the issue you're concerned about is relatively insignificant compared to your perception of its magnitude. But if this is something you are very concerned about, there are many approaches you can adopt in a Go codebase to make errors richer, such as using the "errors" package and a structure logger, which are enforceable at CI time and will give you stack traces.
I don’t know what the Enneagram is.

Some things aren’t just taken out of thin air. Part of being a “social creature” is that you pick up on what other people think of you by observing how they talk about other people that you have something in common with. And that doesn’t have to be something wishy-washy like “being boring”; it could be very concrete, objective things, like being X or having Y. Then you go, huh, that’s me as well. And then you listen to them say that oh, people who are X, Y, and Z are A and B. And that’s you as well.

But no (someone says), they’re wrong: it’s just their opinion. It’s entirely subjective and partial.

... But don’t you see? That’s what being a social creature is—being at the whims of the opinion of others. How can you possibly claim that Humans Are Social Creatures, and then blame the person who is affected by What Others Think of Them?
Well the quarter of that article I could read seemed interesting.

The 80/20 rule made them furious. Academically I knew about it but I never had to experience it.
I think this experiment would have gone over much better if SO leadership wasn't so disconnected from the actual users of the site, and had been willing to say "here's an early prototype, please red-team it and show us where it breaks so we can hopefully get it to a state where it's actually useful in a way that makes your jobs easier"
It's a very nice project, especially that they provide both a fully sealed device and an open devkit - at good prices. The NRF52 microcontroller is the gold standard for battery powered BLE devices.
I am considering to use it as a dev/demo unit for Machine Learning inference using emlearn, especially for Human Activity Recognition an Gesture Detection using the accelerometer.
Also curious. I was looking locally for some sort of meetup/show where I could see people builds, ask about cost, etc. Sadly I just missed an expo the previous weekend.
>For advances in computing, "double the performance every 18 months" would seem like a good upper bound.

But not a realistic one past the mid '00s. Due to the end of Dennard scaling[1] that sort of exponential performance increase is no longer available. At this point a fundamental breakthrough (quantum computing for example) would be required to get a large and cheap increase in computing capability. That puts the hardware side in more or less the same situation as the algorithmic side. A fundamental breakthrough is required. That does not help with the uncertainty here. This stuff is more or less impossible to predict.

[1] https://www.extremetech.com/computing/116561-the-death-of-cp...
Bernie Sanders launches investigation into working conditions at Amazon
It's not the expectation.

It's not well understood by people on average (and those dieting) how to mitigate hunger when restricting calories or how to successfully diet, but they are correct that a deficit is required to lose weight. That's physics and biology. The problem is the knowledge gap leading to strong-willed efforts that can actually backfire.

For instance, there's body fat set point theory and metabolic adaptation. The more severe a caloric deficit, and more frequently a person diets, the worse your metabolic outcome. Your body will try to slingshot you back to your "original" weight (the one it's used to), with leptin as a regulator. But if you lose weight slowly, and leverage resistance training, it leads to a better outcome.

A prime issue is sustainability. Most people on a diet do succeed in losing weight; it's just that they gain it all back, and they can end up with a worse metabolic rate than they started with, making it that much harder to lose weight again. Metabolic rate can actually recover, but the length for this seems to depend on the severity. Assuming a slow rate of weight loss, it can take almost just as much time as the diet period to recover metabolic rate. For the "Biggest Loser" contestants, it took several years.

Leveraging the satiating and thermogenic effects of protein, fiber and resistant starch in diet also helps, for satiety.

All of which to say, it's possible to lose weight in a sustainable way without drugs - notwithstanding the failure rate. The people who succeed in doing so are not necessarily "more disciplined", or "less prone to hunger", but they tend to have certain behaviors in common. One of them is exercise (particularly resistance training).
Last time I looked into Gitlab CE I decided not to go with it because there is no pull mirroring outside of their Premium offering, I would consider this a limit.

https://docs.gitlab.com/ee/user/project/repository/mirror/pu...
For technical info like programming language references, I get much better results in Kagi after I spent a few minutes setting my blocks and pins. I just searched "run a test suite in go" in Google, DDG and Kagi, and blogspam results were higher in Google and DDG while GoDoc and Stack Overflow was higher for me in Kagi. Many of the DDG results were about running a single test out of a suite, rather than running a suite.
I do believe that we will talk about the AI era in a 'changing the industry' way and not in a 'hot garbage we should have just ignored'.

And we already see the effect and have not even reached any hill.

Its for me the same as with renewable energie and EVs: We have not yet invested that much money into batteries as we could and all the problems we are facing will be gone sooner than later because there is no ceiling currently visible. Just not enough VC for it.

Battery tech started to get much more funding 2022.

AI will defintily change a lot and the progress is astonishing.
Some web pages don't have a date.
Actually I used to run OpenBSD on a Thinkpad as a daily driver. Did that for work at a startup around 2010, but it was a miserable experience.
Working with mainframes seems like the ultimate balance of good pay and unsexy. Still need to know Cobol and not sure about being remote.
>If there's inadequate water or sun to grow crops that need lots of both, perhaps that location is not the best for those crops.

"omg lets just move the farms to where the water is"

like you're not talking about growing plants rooted in the literal ground, some that must be cultivated over multiple years to yield quality product.

like we're not all going to be chasing water on a hotter planet with a chaotic climate.
Coomscrollers? Reddit aggregates a lot of NSFW material.
It was delicious. I fried the hell out of it and used it for home-made Dan Dan Mian.
I don’t even want a “phone.” The number of actual phone calls I make is minuscule compared to internet usage, texting, videoconferencing, navigating, etc.
For small teams which were happy using the "free" tier, that's really the correct solution. Just self-host it and retain free-tier functionality.

That said, it looks like the premium features are $29/mo or $99/mo per user regardless if you self-host it or take advantage of their managed SaaS offering. It's somewhat bizarre - there's a lot of costs associated with managing this on-site but no discount for that. I presume they feel that extra overhead cost to the customer of self-hosting breaks even with the perceived or actual added security value of self-managed installations.

I might be reading it wrong, but that's how I see the pricing presented here and associated pages: https://about.gitlab.com/install/ce-or-ee/
This was purely due to familiarity. I knew murmur3 was considered a good, current hashing algorithm. I was able to find a good implementation of it in JS, so I didn't really look any further.

Thanks for exposing me to xxhash! I'll store that away as an alternative to murmur3 if I ever need one in future. :)
I migrated from Heroku to Render for a small Django project of mine: https://pinnacleclimb.com/

Some things I like about Render vs Heroku since switching:

- Building the container from the Dockerfile in my repo seems to be a lot faster because it keeps all of the image layers cached.
- I can control the external IPs that have access to my postgres database. I usually keep them all off and only let the webapp access it internally, and then whitelist an IP as needed.
- Env groups are nice - if I want to start another service I can have it use all the same environment variables vs trying to keep them in sync myself.

A couple of years ago they had some multi-hour outages but things have been pretty stable since, a couple of the multi-minute outages were on me as I was upgrading the database or messing around with some configs. https://status.pinnacleclimb.com/

One thing I'd love in the future is some sort of postgres upgrade button. They handle minor version updates but to do a major version I need to put the app in maintenance mode, dump, restore, and swap to the new DB. It would be amazing if that could be automated with something like pglogical.
And of course all of the above may be "peanuts" for professional studios, but I am not aware of any hardware/workflow/money/things you can throw at the problem to make the editing and production experience smooth. There are tons of inconveniences, practical barriers, bandwidth issues (and I'm not even talking about network/cloud bandwidth, that's a whole other thing-- even just disk IO, moving stuff around via USB-C, backing up stuff, etc... It's all super labour-intensive and annoying).
Army rolls out new Army Body Composition Program
The question is whether the fediverse is a community, or infrastructure. You wouldn’t argue that toxic people should be prevented from using the roads or the power grid.