JamesonNetworks (u/JamesonNetworks)

JamesonNetworks commented on A faster way to copy SQLite databases between computers alexwlchan.net/2025/copyi... · Posted by u/ingve

zeroq · 4 months ago

How to copy databases between computers? Just send a circle and forget about the rest of the owl.

As others have mentioned an incremental rsync would be much faster, but what bothers me the most is that he claims that sending SQL statements is faster than sending database and COMPLETELY omiting the fact that you have to execute these statements. And then run /optimize/. And then run /vacuum/.

Currently I have scenario in which I have to "incrementally rebuild *" a database from CSV files. While in my particular case recreating the database from scratch is more optimal - despite heavy optimization it still takes half an hour just to run batch inserts on an empty database in memory, creating indexes, etc.

JamesonNetworks · 4 months ago

30 minutes seems long. Is there a lot of data? I’ve been working on bootstrapping sqlite dbs off of lots of json data and by holding a list of values and then inserting 10k at a time with inserts, Ive found a good perf sweet spot where I can insert plenty of rows (millions) in minutes. I had to use some tricks with bloom filters and LRU caching, but can build a 6 gig db in like 20ish minutes now

JamesonNetworks commented on Apple needs a Snow Sequoia reviews.ofb.biz/safari/ar... · Posted by u/trbutler

hkpack · 5 months ago

But it doesn't in practice.

I develop and distribute few free apps for macOS, and building / notarising is never a problem.

JamesonNetworks · 5 months ago

In contrast to this point, as long as I use Xcode and do the same thing I've always done allowing it to manage provisioning and everything else, I don't have a problem. However, I want to use CI/CD. Have you seen what kind of access you have to give fastlane? It's pretty wild. And even after giving it the keys to the kingdom, it still didn't work. Integrating apple code signing with CI/CD is really hard, full of very strange error messages and incantations to make it "work".

JamesonNetworks commented on The Frontend Treadmill polotek.net/posts/the-fro... · Posted by u/Kerrick

lo_fye · 6 months ago

I once read an article that promoted putting all of your business logic in the database, in the form of stored procedures, functions, etc. I thought the author was completely insane, until I kept reading. "You can change frontends any time you want, or you can run multiple frontends simultaneously. Everything important, including validation, is handled by the database." Have I done it? No... but that opened my mind to a new way of thinking.

JamesonNetworks · 6 months ago

My experience with this at one company is the DB became a wild west of cowboyed sprocs that were in source control but a lot of times the sproc in the db didnt match the stored code. It became a way to skirt code reviews and push changes fast. Now, the environment was toxic to begin with, and maybe that wouldnt happen on a project with better technical leadership, but there is a lot of wiggle room for hanky panky at the db level

JamesonNetworks commented on The Frontend Treadmill polotek.net/posts/the-fro... · Posted by u/Kerrick

mattlondon · 6 months ago

standalone for us was piecemeal - just do it one by one line of code here or there when you are already in the component making other changes.

Likewise signals it was trivial to just change @Input() to input (ok slight simplification but not by much - I think there are automated scripts to do it anyway if you want to do it in one fell swoop?) when already in a component making changes.

But you didn't have to, which is nice. You could take your time doing it but by bit if you wanted, no rush etc. I don't think the old ways are even fully gone yet anyway?

JamesonNetworks · 6 months ago

You may not have to today, but you will one day. They will remove zone.js and there will be a whole host of deprecated libraries and outdated blog posts about how to do things the “angular” way. If the vite dev server didnt feel so much snappier, I would lament it, however, I think overall its a nice change. And sure, just change components while you are in there, but this is for my blog libraries I work on in my spare time. A lot of the standalone stuff just feels like change for change sake and the scripts did not run against a library project. I tried to dig into the @angular/cli repo to try and figure out what was going on, but after reading a few classes noped out and just converted by hand. Only takes a couple of hours or a day to test, but thats 0 productivity time. Change detection is different now and leveraging ngOnChanges is def broken now, zone js removal is experimental, and all of it so Angular becomes more like React as far as I can tell. My new projects are Django with templates and post backs. Its a breath of fresh air.

JamesonNetworks commented on The Frontend Treadmill polotek.net/posts/the-fro... · Posted by u/Kerrick

mattlondon · 6 months ago

Just use Angular and stop worrying. Batteries included, it works and works well.

Yes there was a big change from v1 to v2, but we are at v19 now I think and upgrades are pretty painless IME (I generally don't even really notice them happening, and there is even a tool to help know what changed: https://angular.dev/update-guide) I've been using it at BigCos now for years and it's really just totally fine, and importantly zero drama.

They key thing is you only need angular so you don't need a whole fleet of dependencies that you also need to migrate at the same time.

JamesonNetworks · 6 months ago

Upgrading to standalone components and the new signal API right now, not sure I’d say this avoids the frontend treadmill

JamesonNetworks commented on Apple starts pushing AirPods owners into Transparency mode, with no easy opt out keydiscussions.com/2025/0... · Posted by u/spenvo

st3fan · 8 months ago

Nobody is asking the most interesting question: why.

Why is the option to use the AirPods in “normal” mode being removed? Is Apple hit with some lawsuit or something?

JamesonNetworks · 8 months ago

Off hand guess: reduce apparent battery life in order to nudge people to upgrading, thinking their batteries are going

JamesonNetworks commented on Ask HN: Who's building on Python NoGIL? · Posted by u/grandimam

SOLAR_FIELDS · 8 months ago

You are right, it was distutils. Good call out. Not sure why I thought of setuptools.

JamesonNetworks · 8 months ago

This comment thread is a microcosm of the problems with python packaging :D I appreciate the work the ecosystem does on it and everyone is doing their best, but its still a hard problem that doesn't feel solved

JamesonNetworks commented on Running an open source app: Usage, costs and community donations spliit.app/blog/spliit-by... · Posted by u/scastiel

mherrmann · a year ago

Re your question on saving costs: If you run it on a single Linux VPS, then I suspect you can get the costs down to 5-10$ per month.

One thing I find interesting is the growth chart: It's linear. But given that the app clearly has some traction, and is viral in nature, how come it isn't exponential?

JamesonNetworks · a year ago

Best I’ve been able to do is around $22 a month on DO, would love to hear alternatives that are cheaper

JamesonNetworks commented on Running an open source app: Usage, costs and community donations spliit.app/blog/spliit-by... · Posted by u/scastiel

hahahacorn · a year ago

The inefficiency is bonkers but understandable. I could host this app for like ~$60/year, generously, with little to no devops work. It's painful to see the creator paying out of pocket for such a great project because the Vercel marketing introduced such massive inefficiencies to the ecosystem.

Even less when I pay for a dedicated machine running all of my hobby projects. Gratuitous Kamal 2 plug. Run your personal projects all on one machine.

JamesonNetworks · a year ago

Where would you host this for $60 a year?

JamesonNetworks commented on Does your startup need complex cloud infrastructure? hadijaveed.me/2024/09/08/... · Posted by u/hjaveed

ghomem · a year ago

I went through sweat and tears with this on different projects. People wanting to be cool because they use hype-train-tech ending up doing things of unbelievably bad quality because "hey, we are not that many in the team" but "hey, we need infinite scalability". Teams immature to the point of not understanding what LTS means have decided that they needed Kubernetes because yes. I could go on.

I currently have distilled, compact Puppet code to create a hardened VM of any size on any provider that can run one more more Docker services or run directly a python backend, or serve static files. With this I create a service on a Hetzner VM in 5 minutes whether the VM has 2 cores or 48 cores and control the configuration in source controlled manifests while monitoring configuration compliance with a custom Naemon plugin. A perfectly reproducible process. The startups kids are meanwhile doing snowflakes in the cloud spending many KEUR per month to have something that is worse than what devops pioneers were able to do in 2017. And the stakeholders are paying for this ship.

I wrote a more structured opinion piece about this, called The Emperor's New clouds:

https://logical.li/blog/emperors-new-clouds/

JamesonNetworks · a year ago

I’ve just recently gotten into ansible and find myself building the same thing. I wrote a script to interact with virsh and build vms locally so I can spin up my infra at home to test and deploy to the cloud if and when I want to spend actual money.

I’m still very much an ansible noob, but if you have a repo with playbooks I’d love to poke around and learn some things! If not, no worries, I appreciate your time reading this comment!