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

help-circle




  • abies_exarchia@lemm.eetoScience Memes>:)>
    link
    fedilink
    English
    arrow-up
    33
    ·
    2 months ago

    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




  • abies_exarchia@lemm.eetoMicroblog Memes@lemmy.worldPeace and quiet.
    link
    fedilink
    English
    arrow-up
    12
    arrow-down
    1
    ·
    3 months ago

    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!