abies_exarchia

u/abies_exarchia@lemm.ee
5 posts · 58 comments

Recent posts

Recent comments

on >:)> · c/science_memes · 32 pts · 1y

Not necessarily, with “genetic drift” random phenotypic changes can happen that have a neutral effect on fitness. So if they don’t need side-facing eyes, then this can just happen randomly. Especially if the sideways eyes are in some way “costly” to maintain

on *Permanently Deleted* · c/science · 6 pts · 1y

Unless your parents are members of the ruling class, they had very little to do with your immiseration!

on Peace and quiet. · c/microblogmemes · 11 pts · 1y

Also the whole industrialization, privatization, and rise of capitalism thing in Europe that led to successive waves of emigrants leaving or being coerced from their homelands. I think in general people don’t leave their communities and families without some kind of direct or indirect violence.

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

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

  • get google scholar alerts sent to RSS feed (locally hosted freshrss)
  • save articles in Hoarder that i intend to read
  • when i have time, read articles in Hoarder, add the citation to zotero, take notes in Obsidian on the article and link it to the zotero item using the Zotero plugin, and then also move the article to a ‘already read’ list in Hoarder.

Kinda complicated but it’s been working!