ThingEngineer

Keybase proof

I hereby claim:

• I am thingengineer on github.
• I am joshcampbell (https://keybase.io/joshcampbell) on keybase.
• I have a public key ASBGn17Q6cYHyA0N5tAK1OOVfN5SmHZVUCmeHBI33g7rhwo

To claim this, I am signing this object:

ThingEngineer

Receive GOES-16 and GOES-17 Images with a Raspberry Pi and RTL-SDR dongle

Also see the original Pieter Noordhuis's guide

Hardware

You need:

1. Raspberry Pi Model B (or B+) with a MicroSD Card $35-40
2. An RTL-SDR dongle:

ThingEngineer

SvelteKit PWA Install Prompt Browser Test/Demo

How to use

Add this to your root +layout.svelte in your already working PWA

<script>
let deferredPrompt;
	let installButtonVisible = false;
	let output = '';

	onMount(() => {

ThingEngineer

SvelteKit Minimal PWA Install Button and Service Worker Auto Update Prompt

How to use

Add this to your root +layout.svelte in your already working PWA

<script>
	import { beforeNavigate } from '$app/navigation';
	import { updated } from '$app/stores';
	import { onMount } from 'svelte';

ThingEngineer

Virtual Environments (bash) A virtual environment is an isolated Python environment that allows you to install packages without affecting other Python projects or your system's Python installation. It also ensures you are working in a clean slate environment and enables reproducibility through dependency tracking.

Create:

• mdir my_project
• python3 -m venv my_project

Use:

• source my_project/bin/activate

ThingEngineer

-- Role-Based Access Control (RBAC)
-- With live propagation of roles to JWT token in a multi-tenant application using Supabase refreshSession and custom_access_token_hook
-- A method of restricting table and route access to authorized users based on their role or permission level.



-- This SQL implements a dynamic, multi-tenant role-based access control (RBAC) system with route authorization. It includes:

-- A custom access token hook that enriches JWT claims with role and company data.
-- Functions to authorize actions, check route access, and retrieve authorized routes based on user roles.

ThingEngineer

CREATE OR REPLACE FUNCTION v_knight(
    piece_id VARCHAR,          -- ID of the piece being moved
    target_pos VARCHAR,        -- Target position in chess notation
    board_state JSONB          -- JSON containing all pieces and their positions
)
RETURNS TABLE (
    is_valid BOOLEAN,
    message VARCHAR
) AS $$

ThingEngineer

#!/bin/bash

# gpkg2mbtiles.sh - Convert GeoPackage to MBTiles with specified zoom levels
#
# Usage: ./gpkg2mbtiles.sh -Z <min_zoom> -z <max_zoom> <input_file>
# Example: ./gpkg2mbtiles.sh -Z 14 -z 17 wa-parcels
# 
# Created by: Josh Campbell - ThingEngineer
# Date: 2025-05-01

ThingEngineer

Setup Multiple Local Supabase Projects

Project 1 (Current - my-project) default settings:

• API: 54321, DB: 54322, DB.POOLER: 54329, Studio: 54323, Inbucket: 54324, Analytics: 54327, Edge Inspector: 8382

Project 2 (New - my-project-2):

• API: 54331, DB: 54332, DB.POOLER: 54339, Studio: 54333, Inbucket: 54334, Analytics: 54337, Edge Inspector: 8383

Steps: