Daily Shaarli

All links of one day in a single page.

May 7, 2024

Learn SQL for Analytics

Are you looking to enhance your data skills and become proficient in SQL? We just posted a comprehensive, 11-hour SQL course on the freeCodeCamp.org YouTube channel. It will teach you to handle complex database queries. (Vlad Gheorghe)

A giant course going over many of the 'functions' of SQL. Good but long, and you will need to consult additional sources to connect many of the concepts to the bigger picture.

GitHub - KrumpetPirate/AAXtoMP3: Convert Audible's .aax filetype to MP3, FLAC, M4A, or OPUS

Basically a wrapper around the ffmpeg conversion functionality.

Takes care of some things like entering metadata, can optionally receive an audible authcode, and provides some convenience. I would nevertheless suggest directly using ffmpeg itself and grabbing the authcode from one of your files directly.

GitHub - spion/adbfs-rootless: Mount Android phones on Linux with adb. No root required.

Perhaps the best way to mount your android phone storage into the PC.

I found it to be more stable and useful than similar projects such the various mtp fs implementations.

GitHub - typst/hayagriva: Rusty bibliography management.

A 'simplified' bibliography reference format like bibtex or biblatex.

Uses yaml under the hood and is super simple to understand:

Doan2020:
    type: Article
    title: Kinetics and luminescence of the excitations of a nonequilibrium polariton condensate
    author: ["Doan, T. D.", "Tran Thoai, D. B.", "Haug, Hartmut"]
    doi: "10.1103/PhysRevB.102.165126"
    page-range: 165126-165139
    date: 2020-10-14
    parent:
        type: Periodical
        title: Physical Review B
        volume: 102
        issue: 16
        publisher: American Physical Society

One interesting fact is that it uses one (or multiple) 'parent' keys to signify where something is from which in turn use the same simple keys (type, title, ...) as the original document to describe themselves.
So, instead of a million individual keys to describe an entry we use a more recursive format with each having the same couple keys.
This could be really interesting for a closer papis integration with its standard yaml format for example.

Format readme here.

I am not sure how 'mature' the format is, however.
It has been created for the typst typesetting language afaik, and that is still pretty new/fluctuating as of now as well.