skysight-inc/HackerNews huggingface dataset:
Apple powers iCloud Core Data with SQLite. This way it uses the same DB engine locally on your Mac and iPhone, and the server backend in their data centers.

I don't know if they've swapped the backend, or just use it as-is. SQLite can scale vastly if you use it for file IO and do sharding/replication on top of it as a separate concern. I've done ad-hoc (extremely crude) versions of that in some apps.
i think you should question the validity of your statement, “I lost a great job..”

what was so great about this job? since you likely departed from a big tech company I assume the compensation was most or all of the reasons you thought it was great. you probably wouldn’t get burnt out doing something at a great job imo.
How's Atlas on power? It's a 180 pound robot. How long between charges if it's doing actual construction work?
> Someone who has worked alongside their parents for the approximate decade

Not sure if this is a culture difference here or something but most people where I'm from (Canada) don't work alongside their parents doing anything valuable as a pre-teen, and it's illegal to employ people younger than 16. Even if they do, it's very unlikely anyone would seriously consider it valuable work experience and pay substantially more than minimum wage.

For most people being a teenager is absolutely the first job they will have and it will be minimum wage or near it.

Working as a teen was absolutely not my most valuable earning years. That money went towards my university degree to offset my student loans, not into savings accounts to maximize the time-based value of my money.

N=1 but I would wager my experience is more common here than what you describe.
Depending on your runway and goals you have a few options.

1. Take whatever you can get that’s closest to where you want to be. I worked as a sysadmin in a large financial firm as they were close to Linux distributed systems during the Great Recession. I’d advise sticking to something with a swe title, but taking a job as MLE for a year - or SWE - instead of a research position isn’t a bad strategy.

2. If you have lots of runway, start your own business! If it pans out, then you’ll be better off than your dream job. If it isn’t successful, you will have something to talk about in a year.

3. Stick to academia/research for a year. If you can hold off your graduation for a year, the market may be more favorable. Bear markets tend to be short.

4. Hike the AT/PCT/other bucket list activity. It can burn up the better part of a year, and will explain a resume gap well. Be mindful that employers will be concerned if they see an unexplained resume gap/and may not care about your fitness.
Xcode does this but only for the last 10 or so queries. I wonder if that is somehow configurable in an undocumented user default…
Loads gemini://cosmic.voyage/ships/ and other pages for me fine. (iPad Pro M1 16.2)
There's also the hot standby leader configuration that the higher Heroku Postgres tiers do. The standby leader receives writes asynchronously, so during failover you can actually suffer a little permanent data loss. Really should have a bigger warning label.

I only ever do single leader, multi follower like you describe.
The SQLite team are good at listening to the people who use the software.

People who use SQLite want to be able to scale it to handle higher concurrent write loads, including from multiple processes.
Comanche Terrain Rendering [video]
So it looks like animal charities are out then. A local shelter was my chosen charity. Saying that, I only generated $70 of donations with 300 orders so it wasn't much, but every little helps.

The fact that they're axing this at a time of mass layoffs makes me think they're not telling the truth.
Oops, yes thank you for the correction!
It was a problem with my gitlab-ci config but I wasted a lot of time wondering if the problem was the scripting portion.
This feels to me a little bit similar to MyISAM v.s. InnoDB in MySQL - two different "backends" that are low level details about how the data is actually stored and accessed.
Microsoft too, since Bitwarden uses Azure. I think its find.
Oof, really? Then I actually feel bad that some of the smaller blogs I follow that published legit reviews didn't get credit for my sales. (I use the Always Smile browser extension.)
I would ask myself: do I personally like these people enough to be courteous? Or, is it professionally useful to me to be courteous?

Probably no, so, I'd be out. Also a good opportunity to highlight how it's weird to be fired while leading a meeting.
I guess I meant what do you do to prevent that from happening.
> I can think of at least 10 things people might freak out about me

Wow! I'm a total weirdo and I can only think of like 4-5.
My main comment was about Bonuses, btw. which, as I stated aren't guaranteed and are typically paid when companies are doing well.

Options and even RSUs only have value if they go up above initial grant or strike price.
How do you enforce that they are only read upfront?

Why not just make them parameters if you are going to put them upfront and turn them into ENVs?

How do you deal with a commit that needs to be rerun? What if the flags have changed in between?
I would expect they'd at least want the holster!
+1 on a comparison. Binwalk has served me faithfully for years but you never know what you don’t know until the day it fails
Lol all the talk about how dieting isn't "fair" is hilarious. Some good points though. Although her attitude is weird: people should just accept the "set range of weight" they're in because that's the most healthy? That might've been true in the 70s, but has she heard of the obesity epidemic?!
> How much of it is still SQLite at that point?

I'm guessing just the interface. If there are any well-understood quirks of the regular implementation, maybe they'd want to replicate them too, idk.
Litestream didn’t exist until late 2020, meanwhile postgres has existed for decades.

Moreover, SQLite requires the place you run your application to have durable storage, which is a huge departure from the status quo.

It’s definitely neat, but the stack as a whole doesn’t strike me as mature enough to replace Postgres just yet.
Why not host on their own Gitlab of Forgejo/Gitea server? Has all to do with trust and ownership. Now it feels like a mere dump...
Facebook Container Extension
I feel the title is missing something, like "people", or "grenades", or "cream pie".
> Or are all my friends/family just ugly?

No. They're all probably pretty good looking. The problem with the apps is the selection bias exhibited by males and females. If you look at the selection stats for men, you'll see they swipe right for about 80% of women. If you look at the selection stats for women, you'll see they swipe right for about 0.5% of men.

I've no idea why this is the case, but the results have held out over a number releases both private and public.
Seriously? Good riddance to the "developers" that couldn't adapt. The job market is littered with garbage developers, and it's exactly the type of developer that can't adapt to a new language or style of programming that are the ones that aren't really meant to be a developer. Hopefully they found their niche in the economy. - Ex-VB6 programmer turned VBA programmer turned VB.NET programmer turned C# programmer turned Python programmer turned Javascript Programmer (and all the non-pro projects and gigs inbetween, C++, Go, Elixir, Java, Kotlin, etc).
I don't think this is true, I run an affiliate site that directs people to Smile, and my commissions have been the same whether I direct to Smile or not. I have heard that your conversions typically go down when you use Smile. However I think that might be because many customers have never signed up for Smile and are scared away. I decided to stick with Smile links because I thought that in the long term it would motivate people to continue using my site and I figured at worst I'd help charities a lot more than the income I'd lose so I'm a bit sad to learn about this.
New Age Wind Hawkers (2021)
PyCharm has a built in learning module which works great for middle school-high school ages.

Edit: Also for visually showing concepts, you can’t beat https://pythontutor.com/visualize.html
> On the other side of the equation, the company paying you a pittance used your capitulation to drive down wages elsewhere, including in its home country. There's a reason why maybe women as a group in this day and age continue to earn only 82 cents on the $ that men make [1].

How much do you think wages are in Nigeria to the US? A quick googling gives approximately 3 cents to the dollar. That's a 33x difference. You would rather not improve the wages of someone making $0.03 / dollar. Because it _might_ hurt someone making $0.82 / dollar. Yeah equal pay for equal work is about protecting the relatively high US wages. And I don't think it's at all clear that exporting these jobs specifically hurts women workers and not male workers.

> Sure, you got your quadruple pay, while some woman here went without money for medicine and died before her time.

The average life expectancy in Nigeria is TWENTY FIVE years lower than in the US. Quadrupling the pay of someone in Nigeria has a far greater impact to their health than it does to someone in a first world country where there is significantly more access to medicine and other resources. If you are trying to help someone, wouldn't you want to focus on the population that is dying 25 years before everyone else?

> Now the (actual or philosophical) descendants of those Europeans play off the impoverished Nigerians against the local Women to exploit both groups.

How are Nigerians being exploited here? If it had been a local Nigerian company offering them a wage of $2 an hour (which is over their minimum wage) would it be exploitation? Or is it simply because the company operates multi-nationally does it become exploitative.

> Equal pay for equal work is not a hard concept to understand - it is basic fairness.

What is your proposed change here? The minimum wage where I am is $18.50 an hour. Therefore under equal-pay-for-equal-work, if a company based where I am living wants to offer a job outside my area must pay $18.50? Which means, the jobs would never get exported to Nigeria. Sure that is a win for people living in the US, but not for the people living in deep poverty on the other side of the world.
No one smart is expecting critical work from a new grad. If you move once every 1-2 years then you are fine. Once per year will raise flags after 3-4 jobs due to fear that you are being terminated on every job for some reason.
Learn the historical significance of the One China policy. Then the answer will be obvious.
Isn't each cloud CoreData store just for a single user, so high concurrency isn't needed?
Sounds like a similar situation I had where the relationship dynamic that was created at the start was the main cause for the issues later.

I recently went through a purging of many of these one sided relationships. People I thought were friends, the kind who I would show up for and never ask for anything, but when it came time for me to need someone to lean on it was crickets. They are not bad people, I wouldnt have wasted time on them if they were, but now we are no longer compatible since my standards changed. (for both my approach and theirs)

It took some time to realize how un-healthly keeping that dynamic around had been, and that I am better off mostly alone doing my life while meeting new people (though it is difficult to make new friends).

There was one, even with their own limitations at the time, that tried to be supportive without making jokes or other weird behaviour I got from others. The surprising part was I had known them for a long time but they are at a distance and the relationship was mostly just sending jokes and random comments to each other from time to time. They are still in my life and the relationship changed to the supportive kind (still w/jokes) that I thought I had built w/others. My take is that the relationship wasn't built on a dynamic where they came to see me as an unshakable pillar so it wasn't confusing or awkward for them.
I’m not sure of your point. So a job I got 13 years ago largely through a contact isn’t how things work today? As in my most recent example.
If documentation is how you get your data and code correct, than sure, it is important. But that's a methodology, a mean to an end. There are other methodologies that are not based on documentation, most notably, Agile.

But let's imagine. You use your documentation-centric methodology, and produce software, with good data structures, algorithms, and documentation. Problem is, your server room is on fire and so are all your backups, you can still recover some data but it may fail at any time, what will you try to recover first? I don't know about you, but for me, it definitely won't be the documentation (unless they are legal documents, maybe). If I lose the data and code, I will be left with nothing workable, I will have to do everything all over again, not from scratch because of the good documentation, but in the meantime nothing. If I lose only the documentation, future teams will have a hard time reverse engineering the code and all that, but in the meantime, they will still have a working product, and will still be able to do minor evolutions and bug fixes without too much trouble.

That's what I mean when I am saying that documentation is the least important. It means the least important as a product, it does not mean it is the least important to your methodology, or that you should not write it first, especially if you use it as a working document to make sure you get the other parts right.
Most SQLite writes can be measured in microseconds. If your app is doing less than 1,000 writes a second you probably won't even notice that SQLite is serializing your writes rather than applying them concurrently.
Now I have to log into Wikipedia just like reddit in order to get the non-atrocity user interface experience. How nice.
Failure isn't a strategy but it's a very likely outcome that you have to plan for. A startup fails to raise each successive round something like 67% of the time. [1] Of course you have to work on something you care about, but I think 'something you care about' can be a meaningful business that creates value to customers. Once you have traction you'll start to love it - or you won't.

You only fail when you stop trying.

[1] https://medium.com/journal-of-empirical-entrepreneurship/dis...
Is what's worse is SharePoint has also introduced the term "library", which is really just a root level directory.
I always assumed having to type the smile domain was more about making sure they didn't have to make both an affiliate payment and a smile payment on the same order.

Seemed like an easy way to cut off affiliates while appearing to be generous. Maybe I'm just too cynical.
I have a husky and so I often have to go for multi mile hour long walks frequently throughout the day. During that time I use voice dictation to text to work on new projects, articles, etc. by virtue of the fact that I am dictating them in an ad hoc manner they're frequently haphazardly written, disorganized and rife with grammar and spelling issues.

With the zero shot learning of chat GPT, when I get home I'm able to drop them in and it'll spit out a polished version of them. It has been saving me hours of time.
Means, in future, will there be a browser?
I've managed to successfully boycott Amazon for about 3 years at this point, with very sparing business expenses that I'd do through AmazonSmile to "offset" my use of Amazon. It's good to know that that option will no longer be available to me, meaning that I will no longer have any excuse to do business with Amazon!
Yeah, that's what I was thinking. If you're already using SQlite, here's a faster version of it.
Why does Microsoft keep publishing job positions on LinkedIn just a few hours ago?
Context: https://www.theguardian.com/australia-news/2022/jul/25/clubs...

My "favorite" part, for lack of a better adjective, is how ClubsNSW (the slot machine organization) successfully got a federal court order telling the whistleblower to stop "intimidating, harassing" the poor, innocent ClubsNSW, while at the same time the home of the guy who interviewed the whistleblower gets firebombed, twice!
Maybe I'm using SQLite wrong, but I have a website scraper. It's written in python and so uses processes for concurrency to avoid GIL issues.

On my laptop, 16 processes accessing the same SQLite db file can do something like 5,000 write transactions/second. That seems like plenty for many purposes?

A caveat: it's in WAL mode, with synchronous mode set to NORMAL. This means that it's not fsyncing the WAL on each individual transaction commit. Instead, they get synced in batches roughly every 200ms. If you pull the power plug on the server, it may lose some amount of writes that happened in that time. Terminating the process is fine.

Yeah, yeah, we're giving up some amount of durability. In practice, not very much (200ms of transactions) and only very rarely (when the server dies). That seems like a fine trade-off for many backend processes and many web apps. You could tune this, as well: for the transactions that you _really_ want durability on, run a checkpoint before rendering your response to the user.
This is horrendous and is going to take away huge amounts of money from charities that rely on it.

Charities that customers care about, not Amazon executives.

The charity I support is the ASPCA, which gets significant funding from Smile and it’s going to translate directly into fewer animals getting care.

Shitty.
wow. are you looking for a gig? i have some public facing pages that i need rewritten. you sound perfect! ;-)
I like that fully a third of their "charitable" targets are seeking ways to create a better environment for Amazon itself. Funding affordable housing in Seattle and training more software engineers both.
I'm sorry i didnt realize you were just quoting the page
I too am from Canada. While there are some exceptions carved into law that do allow children to work at any age, I agree it's not common. I am saying that we would be better off if it were. Historically it was the norm. This aversion to it now is quite recent, rather strange, and seemingly of negative benefit as it divides families and removes access to education.
Pretty good list, but definitely led with the weakest. Lots of people marry an ideal instead of an actual person, or marry someone who changes (perhaps quite drastically) later. The divorce rate wouldn't be so high otherwise. Then there are (formally or informally) arranged marriages, and other confounders. This rule will spew both false negatives and false positives all over the place. The others are all much stronger.
I think that the no-heroism-gene group might've been what really sensitized me to this.

After seeing a particular incident as an adult, when I saw people not help even when it was begged for, and it was even their job... I started having a strong teary-eyed emotional reaction whenever I did see heroism specifically. After a few times of that reaction, I realized it wasn't due to a powerful moment in a movie or children's cartoon that prompted it -- it had started happening coincidentally after having been gravely disappointed by the no-heroism-gene group. Exactly why, I don't know, but we seem to have some strong wiring related to giving and expecting help.
To be fair, the book example isn't really a 1:1 comparison because white space on a page translates to wasted $$.
We give to the Southern Poverty Law Center, who according to the app have received $315k up to Nov 2022.

Sad to see this program go.
What existing market did Airbnb destroy?
Let's be clear: you made a bold claim without evidence. I responded with an explanation of why your claim is incorrect, based on the actual text of the law which defines the terms. I also provided specific examples of the differences, which are in the post you just responded to.

At no point have you provided any actual evidence, other than an unsourced offhand anecdote (which I addressed), to support your bold initial claim.

I've taken the time to provide much more in the way of both evidence and explication than you have presented. If you'd like more, then perhaps first you can provide some concrete evidence to support the scope of your original, claim, and also address the specific examples that I revealed which refute the premise of your claim.
Inspiring thank you!
I know people working for banks in France and they basically have bugs sometimes where their customers are debited or credited twice. It’s a bunch of legacy xml protocols used for settlements and they sometimes have to pull a bunch of people to manually go through the books and fix mistakes. It’s insane to me that not more has blew up so far. I guess in a way banks truly are decentralized and so one bank fucking up doesn’t necessarily affect other banks.
Well generally they use RPC or GRPC
Do they have investors freaking out?
FlexVision – Eyeglasses that adjust to your eyesight, not the other way around
This honestly might be a net good if everyone complaining buys less plastic junk on Amazon as a result. To me the program always felt like a lot of recycling: a way to make people feel better about unsustainable overconsumption.
Cool, thanks!

edit: wow from the looks of their capabilities that site seems like a mini NASA.
Even with a beefy PC, the chrome 'youre offline' Easter egg dinosaur game still drops frames.

It's code is pretty much the simplest web game you can make. The bug is not in the game. Rendering should tax no machine. And yet it drops frames.

To me, that says something about the readiness of the web platform.
Amazon smile is what made me start using amazon excessively. I'm going to wind down that excess now.
If you buy stuff in person you'll save money and will have more to donate to your favorite causes.
Variants of that are played worldwide, even today especially in Central Asia.

https://en.wikipedia.org/wiki/Knucklebones
soooo, are they going to change their logo?
I think he’s saying to shard writes by tenant, or something else that makes sense for your app - so you can route reads to an individual shard. Same as you’d do to shard any other database, if a little more DIY.

Speaking of Wordpress though, that’s a pretty great example of a web app that typically handles almost exclusively reads. I’ll bet almost any Wordpress instance would work great on SQLite.
It's like competing against the Japanese for best sushi knife.
Typescript is a Microsoft invention, to say nothing of Emacs's complete
lack of financial incentivation.
Agreed so much with this. The "mobile version" should be triggered by the viewport size, not by the subdomain. I was hoping this site redesign would have unified the mobile and desktop sites.
The metric vs imperial discussion reminds me of Android vs iPhone discussions: Android users tend to care a lot more that their text message bubbles are green than the iPhone users do.
And we no longer have solar radiation variability?
I asked ChatGPT to translate your paragraph back to positive sounding corporate speak:

> We are committed to being strategic and efficient with our charitable giving by focusing on a select number of organizations that align with our values and support our business objectives. This approach allows us to make a meaningful impact and gain positive visibility through high-impact initiatives and partnerships. Additionally, it maximizes the benefits of our charitable investments, including cost savings and tax advantages.