I moved over to actualbudget! It’s way more intuitive to me and the the simplefin integration my bank transactions are automatically imported
This is what Sinclair Lewis’ It Can’t Happen Here is about. A book about the rise of fascism in the US written in 1935.
Actually surprised chatgpt is less than average
That was a good read, thanks!
Hey just following up on this, I took your advice and got it working! For anyone seeing this in the future I took the old navidrome.db and called it navidrome_fav_artist_backup.db
and then I loaded into the new database (after making a backup of it) with sqlite3 navidrome.db
and then I ran this
-- Attach the backup database as "backup"
ATTACH 'navidrome_fav_artist_backup.db' AS backup;
-- Update annotations for favorited artists by matching on artist name
UPDATE annotation
SET starred = 1,
starred_at = CURRENT_TIMESTAMP
WHERE item_type = 'artist'
AND item_id IN (
SELECT newArtist.id
FROM artist AS newArtist
JOIN backup.artist AS oldArtist ON newArtist.name = oldArtist.name
JOIN backup.annotation AS oldAnnot ON oldArtist.id = oldAnnot.item_id
WHERE oldAnnot.item_type = 'artist'
AND oldAnnot.starred = 1
);
-- Detach the backup database
DETACH backup;
.quit
Breaking Changes
- Artist favourites and artist ratings will be lost after the upgrade.
I spent a lot of time carefully favoriting artists. Is there any way to re-import or maintain these favorites after updating?
Hmm where can i learn more about this
Over the years i have settled on zotero with th webdav backup to a self-hosted nextcloud server. Works great. Recently i started using the bookmark manager Hoarder and save articles i find there until i read them. My workflow is
Kinda complicated but it’s been working!
Probably not helpful to be this divisive with your anti trump allies. Whether in your eyes the abstention voters made a mistake or not, we’re going to need all the solidarity we can get to oppose/survive this administration
I see bucky, i upvote
2 years out and still working on this in therapy
Not sure why you’re getting downvoted, this seems pretty irrefutable and apolitical haha
A joke i’ve heard among systematists is that there are lumpers, splitters, and then paleoanthropologists
Does anyone else just shuffle them around every few months to a new place, just to feel productive? I had them in a bookmarks folder for a while, then saved in a desktop folder, and just last week i consolidated them in a LinkWarden repo
The democratic party establishment failed us in this last election and the wound is raw. OP’s post demonstrates further actions of the democrat leaders that are maligned with a just and livable world, and it feels like rubbing dirt in that wound. I think it’s pretty expected to see these ‘fuck democrat’ comments in response to this
This is a really interesting part of the Red Mars Trilogy by Kim Stanley Robinson
I definitely think this is backwards. its the humans that are less likely to overhunt the animals that they evolved alongside. If the animals are part of your culture/religion/ecosystem you’re not going to wantonly destroy them. But as humans spread, the animals may not have meant as much to them culturally, or they didn’t know how to not overexploit them. Like the first people in north america were likely a key factor in the loss of megafauna, but then became stewards of many existing megafauna/ecosystems as their culture adapted and they became more grounded in place
Doubleplusungood, even