JoeCode

August 2021

• PostgreSQL Full Text Search
• You Are Not Lazy
• Svelte.js - Compiled Javascript
• GitFinder - MacOS Finder Extension for Git
• Mattermost - Open Source Slack Alternative
• Force Sync From Azure AD Connect to O365
• BRU - Bloatware Removal Utility
• absurd illustrations that make sense
• SPF, DKIM, and DMARC

Fun With SQLite

• static.wiki - Using SQLite HttpVFS To Host a Read Only Database on GitHub
• static.wiki Source Code
• 43GB SQLite Database
• SQLite HttpVFS

Parse and Process Word (.docx) Files

• Mammoth.js Library
• Mammoth.js WordPress Plugin

All The Buttons

• Peter’s Stream Deck Setup
• Stream Deck XL

Remember?

• Want to Remember Everything You’ll Ever Learn?
• Anki - Open Source Flash Card Tool
• Anki - Github

WordPress and Microsoft Teams Fun

• Sign Sign-on with Azure Active Directory
• Adding a WordPress tab to Microsoft Teams and use Single Sign-on
• WordPress + Microsoft Office 365 / Azure AD

WordPress Secure Downloads

• Secure Downloads
• Force Login

SharePoint Online PowerShell

• Install PowerShell
• Lazy Admin
• Fix “Unable to find repository” errors

Usage Notes:

Install module: Install-Module SharePointPnPPowerShellOnline

Use web login to connect: Connect-PnpOnline -Url https://contoso.sharepoint.com -UseWebLogin

Restore files deleted by a specific user: Get-PnPRecycleBinItem -FirstStage | ? DeletedByEmail -eq 'user@contoso.com' | Restore-PnpRecycleBinItem -Force

July 2021

• Apache Superset - Business Intelligence Tool
• How To - Restore Individual PostgreSQL Table
• How To - Join CSV and JSON Data With SQLite
• Does CrossFit Have a Future?
• Blackjack Probabilities

Javascript

• Apache ECharts - Open Source Javascript Chart Library
• Understanding Styled Components in React
• Understanding State in React
• Explore Javascript Learning Course

Markov Chains

• Using Markov Chains to Generate Seed Data
• Gem - Marky Markov
• Gem - Ruby Markovify
• Python - Markovify

Datalist HTML Element

• Mozilla

<datalist id="ice-cream-flavors">
    <option value="Chocolate">
    <option value="Coconut">
    <option value="Mint">
    <option value="Strawberry">
    <option value="Vanilla">
</datalist>

Alex Krupp - software architecture essay

Software architecture for consumer apps

• Predictability
• Readability
• Simplicity
• Upgradability
• Easy

June 2021

• Bob Ross Art Gallery
• BarraOne Service WSDL
• Parsing Big XML files with Nokogiri
• 2020 Seattle Seahawks Analysis
• Tufte CSS Jekyll Theme
• Echolocation For Humans
• Cryptographic License Key Generation
• HTTP Status Dogs
• Kopia - Open Source Backup
• Calculating Variance
• Tooljet - Open Source Low Code Framework
• Alpine.js - Super Lightweight Javascript Framework
• Demo Driven Development
• Comic Mono
• WinAuth - Open Source Windows Desktop TOTP Application
• Hide Photo Album - MacOS
• Flutter - Cross Platform Natively Complied Applicaiton Framework
• TreeSheets - Free Form Data Organizer
• Newsstand - Mac OS 9 RSS Reader
• MapLibre - Drop-in Mapbox Replacement
• Microsoft Attack Surface Analyzer
• CSS Only Charts

Perfect IP Lookup Tool

• ICanHazIP
• Cloudflare Purchase of ICanHazIP - $8.03

TCL Development

• WAPP - Web Application Framework
• NaviServer - (AOL Server Fork)

Load Testing

• Kalvad Locust Tutorial
• Locust.io - Open Source Load Testing Tool

Workout Data

• Exercise JSON Database
• Traindown - Markdown Inspired Data Format

WordPress Markdown

• WP-Markdown Plugin
• Jetpack Markdown Block
• WP Githuber MD

TIL: Ping hyperlink auditing attribute

Browser should send a request to the resource defined by the attribute.

• HTML Spec
• W3 Schools
• Can I Use?

May 2021

• Hacking detergent DRM
• List of free-tier services
• Grafana - open source analytics platform
• ClearURLs - remove tracking elements from URLs
• Get Into Python - tutorial from jobtensor
• Codewell - HTML & CSS design challenges
• Data exfiltration with Apple AirTags
• PapaParse - javascript library for parsing CSV data
• Staff Engineer Book
• GeoCode SQLite
• SQLite and Write-ahead Logging (WAL)
• Invoke - python Rake-like CLI framework
• Remake - webapp building framework

Apple Design Resources

• Design Resources
• Marketing Guidelines

Mac OS Virtualization

• Lukes Empire VMS guide
• Foxlet MacOS KVM

Joseph Campbell

• The Hero’s Journey
• follow your bliss

Chess

• Lichess
• Free
• GitHub Source (Scala)

April 2021

• Learning COBOL
• The Hitchhiker’s Guide to the Galaxy
• fly.io - Ruby application hosting
• This - Javascript
• Retro Terminal
• WebAMP - WinAMP in the browser
• List of self-hosted applications
• NextCloud - self-hosted file sharing app
• Apache + Puma setup
• System 7 on an iPad
• Just give me interesting work
• Mac Chimes of Death
• Unusual Whales - Monitor unusual market activity
• Semiotic Standard - Alien Icons
• Google Documentation Style Guide - Wordlist
• Signal vs. Cellebrite
• Pop OS
• AVIF Images
• Excel Lambda Function
• OPNsense - network protection
• Protomaps
• Opensource Geocoder
• Markdown and Reveal.js Slideshow
• Video call checklist
• Linux on iPhone
• Shell on iPhone

PDF from HTML

• Paged.js
• Example (pdf.math.dev)
• GitLab

Ruby Crontab Fun

• Stack Overflow
• Daniel Szmulewicz

Mr Robot

• Kali Linux
• Who is Mr Robot?
• USA Network

Filestash

• Filestash
• GitHub

Opensource Discus Alternative

• Cusdis
• Vercel Docs
• GitHub Source

Coeur d’Alene Realestate

• WSJ Lakeside Idaho City
• WSJ Emerging Housing Market Index

SQLite Noise

• Eliminate Database Server for $0.03/month
• Litestream
• SQLite (when to use)

Sinatra Noise

• Sinatra ActiveRecord Gem
• Setting up Sinatra with Active Record
• There Is No Magic in Ruby (BCrypt)
• Sinatra Authentication
• Sinatra Authentication GitHub

64,069th place finish

SQLite3 Noise

• Work with CSV files as a virtual table
• SQLite is not a toy
• Data publishing tool
• SQLite graph database, simple-graph

21point2 snoridgecrossfit