Josh Campbell 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:

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 $$

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

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';

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(() => {

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:

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

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:

	#!/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

	-- 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.