• 2 Posts
  • 72 Comments
Joined 1 year ago
cake
Cake day: June 26th, 2023

help-circle








  • BitSound@lemmy.worldtoLinux@lemmy.mlSell Me on Linux
    link
    fedilink
    arrow-up
    2
    ·
    edit-2
    8 months ago

    VLC is the sort of software where if it can’t play it, I don’t know what else could. I guess I’d also try the ffmpeg command line tool to see if it can figure out what the video file even is, and maybe it could convert it to a regular format.

    Also TBH such a video file would be interesting enough that you could probably post it here (if possible, or any metadata you can extract from it) and see if anyone knows how to play it.


  • BitSound@lemmy.worldtoLinux@lemmy.mlSell Me on Linux
    link
    fedilink
    arrow-up
    9
    ·
    edit-2
    8 months ago

    Since Word documents are one of your bigger concerns, you can download LibreOffice on one of your current machines and try them out. That’s the same program you’d be using on Linux.

    It’d have to be a pretty unusual video format to have issues. Similar to above, you can try VLC on Windows and see if there’s any issues.

    Based on your description, I’d be surprised if you encountered any major issues. I’d recommend trying either Pop! OS if you’re OK with a slightly different UI from Windows, or Mint if you want something more comfortable. Note that you can create a LiveUSB stick of either of those, or any other distro. You can then boot your computer from it and take it for a spin to see if there’s any obvious issues.









  • Dunno what permissions issues you’re hitting, but I organize everything with beets on my desktop and then sync everything using syncthing to the main Music folder on my phone and it all works nicely. I use an old app that I think isn’t even available on the app store anymore named MortPlayer that uses the synced folder structure to organize things.

    I don’t use m3u files, but I imagine you could just sync them to the main Music directory next to the music files and have it work out, I guess depending on which app you use




  • I’m too lazy to convert that by hand, but here’s what chatgpt converted that to for SQL, for the sake of discussion:

    SELECT 
        a.id,
        a.artist_name -- or whatever the name column is in the 'artists' table
    FROM artists a
    JOIN albums al ON a.id = al.artist_id
    JOIN nominations n ON al.id = n.album_id -- assuming nominations are for albums
    WHERE al.release_date BETWEEN '1990-01-01' AND '1999-12-31'
    AND n.award = 'MTV' -- assuming there's a column that specifies the award name
    AND n.won = FALSE
    GROUP BY a.id, a.artist_name -- or whatever the name column is in the 'artists' table
    ORDER BY COUNT(DISTINCT n.id) DESC, a.artist_name -- ordering by the number of nominations, then by artist name
    LIMIT 10;
    

    I like Django’s ORM just fine, but that SQL isn’t too bad (it’s also slightly different than your version though, but works fine as an example). I also like PyPika sometimes for building queries when I’m not using Django or SQLAlchemy, and here’s that version:

    q = (
        Query
        .from_(artists)
        .join(albums).on(artists.id == albums.artist_id)
        .join(nominations).on(albums.id == nominations.album_id)
        .select(artists.id, artists.artist_name)  # assuming the column is named artist_name
        .where(albums.release_date.between('1990-01-01', '1999-12-31'))
        .where(nominations.award == 'MTV')
        .where(nominations.won == False)
        .groupby(artists.id, artists.artist_name)
        .orderby(fn.Count(nominations.id).desc(), artists.artist_name)
        .limit(10)
    )
    

    I think PyPika answers your concerns about

    What if one method wants the result of that but only wants the artists’ names, but another one wanted additional or other fields?

    It’s just regular Python code, same as the Django ORM.