JoeCode

January 2022

• Deep Learning Interviews book
• vim -y prank
• Financial Modeling & Valuation Analyst (FMVA) certificate
• How to install PGAdmin (server mode)
• Roy’s NFT Emporium
• Dirty Little SQL
• Dirty Little SQL (github)
• DBeaver - universal database tool
• Datasette - an open source tool for exploring data
• Tips for a healthier PostgreSQL database
• Grafana University
• CSS only fingerprinting
• Compress PDF online
• Oracle Truffleruby
• Find a domain’s authoritative nameservers
• Use HSL or HCL to make gradients
• Write shitty code
• Database-less torrent website
• CommonCrawl and Internet Archive CDX tools
• Playwright - browser automation and testing tool
• Kimura Framework - Ruby web scrapping headless chromium/firefox library
• Simple CSS - clasless CSS framework
• nodep Simple CSS Zola theme
• Render - hosted PostgreSQL databases

Use descriptive_statistics gem safely

# GEMFILE
# gem 'descriptive_statistics', require: false

# Usage Example
require 'descriptive_statistics/safe'
data = []
data.extend(DescriptiveStatistics)
data.sum

SQLite Fun

• SQLite is not a toy database
• Consider SQLite
• vsv: CSV files as virtual tables in SQLite
• Variably Separated Values (VSV) plugin
• How to create one millions records

WordPress Fun

• Adding Input Fields To Comment Form
• StackExchange - Add Comment Field
• StackExchange - Custom Comment Field

GeoIP Fun

• StackExchange - how to block range
• CPAN - IP country database builder module
• MaxMind GeoIP2 database
• Country IP Blocks - ACL builder

Drag and Drop Form Building

• Formeo - vanilla javascript form building module
• Formeo source code
• FormBuilder - jQuery form builder
• FormBuilder source code
• FormBuilder development docs

December 2021

• Space Shooter
• Make your own Ruby Gem
• Apache reverse proxy tutorial
• Clever uses of Pass (Unix password manager)
• Microsoft identity platform and OAuth 2.0 authorization code flow
• Writing classes in Ruby

Flask Security

• How to secure Python Flask Web APIs with Azure AD
• Flask OpenID documentation
• Secure your application by using OpenID Connect and Azure AD
• Flask-OIDC

Ruby and SharePoint

• SharePoint Ruby Gem

host = 'contoso.sharepoint.com'
relatvie_url = ''
prefix = 'crmsandbox'
site = Sharepoint::Site.new host, relative_url, prefix: prefix
site.session.authenticate username, password

November 2021

• Async Ruby
• How not to sort by average rating
• I’m a puts debuggerer
• CSS layout patterns

Charts

• QuickChart - Static, image based charts
• QuickChart.io donut/gauge example
• Chart.js Gauge Chart

Motor Admin - Self Hosted BI Tool

• Motor Admin
• Motor Admin Source Code

October 2021

• Static Map API link builder
• USGS Hydro Network-Linked Data Index NLDI
• USGS Washington State streamflow data
• USGS North Fork Snoqualmie River hydro data
• Amazon - Textract, OCR and text extraction API
• Textract table usage example
• Hive.ai - AI as a service
• Content moderation with Hive.ai
• Trading Economics calendar
• 20 Things - Software engineering advice
• SSH tunneling explained
• HTML checkbox animations
• Series 65 - license for investment advisors
• Learn all about the Golden Age of whaling
• Use your weirdness points wisely
• Coursera - Google IT Automation with Python
• Meow Hash - fast hashing algorithm
• WiFi Pineapple
• PWA Builder - convert progressive web apps to iOS apps

Applescript and Messages

• Applescript primer
• Apple developer docs
• Ruby iMessage Class
• Stack Overflow - Applescript send to group chat
• Stack Overflow - Applescript send to imessage service
• SQLite - How to read chat.db file

September 2021

• MJML - Email markup language
• Web2Img - Embed web files in an image
• Searx - Private meta search engine
• FreshTomato - GPL Broadcom router software
• Eleventy - Javascript static site generator
• NIST Cybersecurity framework
• Build a search engine with Ruby
• Health Icons
• Turbo 7 - minimal javascript framework
• Majestic Monolith
• Zero Terminal V3 - DIY Rasberry Pi project
• Ruby Packer - package ruby apps as single binary
• Brad Woods 7GUIs implementation
• Ruby for ebook publishing
• Use two keyboards for RSI

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
• Google’s C++ Style Guide

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