microblogging – Saul's Blog

August 13, 2025

Spotify & music tools

Spotify-specific Make Spotify Better SpotX-bash – Mac and Linux adblocker for the Spotify desktop client, in Bash Spicetify – Powerful CLI tool to take control…

Saul Tools

August 8, 2025

Waveshare Raspberry Pi 4g Hat and tutorials

microblogging, technology

waveshare product page – Core electronics video and post tutorial – archive.is backup BONUS – ESP32 integrated 4g-gps module, compatible with meshtastic – main link, archive…

Saul Tools

collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => 
    [inExcludeYear] => exclude
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 1
    [showYearCount] => 1
    [expandCurrentYear] => 
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 1
    [showPostDate] => 
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 0
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 0
    [blockId] => block-20
    [widgetTitle] => Archives
    [style] => noArrows
    [showPosts] => 1
    [customExpand] => 
    [taxonomy] => category
    [number] => block-20
)
POST QUERY:
 SELECT wp_terms.slug, wp_posts.ID,
    wp_posts.post_name, wp_posts.post_title, wp_posts.post_author,
    wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
    MONTH(wp_posts.post_date) AS 'month' ,
    wp_posts.post_type
    FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
    wp_term_relationships.object_id
		LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
																			wp_term_relationships.term_taxonomy_id
		LEFT JOIN wp_terms ON wp_terms.term_id =
		                          wp_term_taxonomy.term_id
  WHERE post_status='publish' AND wp_posts.post_type='post'  
  GROUP BY wp_posts.ID
  ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => tech-notes
            [ID] => 769
            [post_name] => managing-read-only-mount-volumes-in-linux
            [post_title] => Managing read-only mount volumes (in Linux)
            [post_author] => 2
            [post_date] => 2025-09-03 11:21:35
            [year] => 2025
            [month] => 9
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => tech-notes
            [ID] => 590
            [post_name] => saul-list-of-local-linux-tools-programs
            [post_title] => List of Linux tools & programs
            [post_author] => 2
            [post_date] => 2025-08-14 15:08:11
            [year] => 2025
            [month] => 8
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => tech-notes
            [ID] => 591
            [post_name] => saul-list-of-online-software-tools
            [post_title] => List of online software tools
            [post_author] => 2
            [post_date] => 2025-08-14 15:08:07
            [year] => 2025
            [month] => 8
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => tech-notes
            [ID] => 564
            [post_name] => saul-list-of-homelab-tools
            [post_title] => List of homelab tools
            [post_author] => 2
            [post_date] => 2025-08-14 15:07:54
            [year] => 2025
            [month] => 8
            [post_type] => post
        )

    [4] => stdClass Object
        (
            [slug] => tech-notes
            [ID] => 670
            [post_name] => spotify-tools-2
            [post_title] => Spotify & music tools
            [post_author] => 2
            [post_date] => 2025-08-13 16:37:28
            [year] => 2025
            [month] => 8
            [post_type] => post
        )

    [5] => stdClass Object
        (
            [slug] => tech-notes
            [ID] => 596
            [post_name] => waveshare-raspberry-pi-4g-hat-and-tutorials
            [post_title] => Waveshare Raspberry Pi 4g Hat and tutorials
            [post_author] => 2
            [post_date] => 2025-08-08 14:54:22
            [year] => 2025
            [month] => 8
            [post_type] => post
        )

)