• 5 Posts
  • 56 Comments
Joined 2 years ago
cake
Cake day: August 2nd, 2023

help-circle







  • 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!










  • 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