Josh Campbell

@thingengineer

Profoundly curious, lifelong learner making the type of products I would want to use.

Joined September 2024

About

Passionate about leveraging geospatial technologies to build innovative solutions. Skilled in PostGIS, SQL, JavaScript, Supabase, Vercel, Linux, and DevOps. Available for consulting projects related to GIS, spatial data, and web development.

Available for

Consultation

Josh Campbell's blogs

thingengineerthingengineer.hashnode.dev5 posts

Articles Comments

Recently published

JCJosh Campbellthingengineer.hashnode.devNov 26, 2024 · 3 min read

How to Securely Access User Data with Supabase Edge Functions

Prerequisites Assuming you have your local Supabase CLI setup and linked to your remote project. Make sure Supabase is running with: supabase start Creating a New Edge Function Run this to create a new edge function named 'admin-list-all-users': sup...

0

JCJosh Campbellthingengineer.hashnode.devOct 21, 2024 · 2 min read

Intro to Svelte 5: The Compiler-Free Frontend Framework

Svelte has carved a unique niche in the frontend framework landscape. Known for its blazing-fast performance and developer-friendly approach, Svelte recently released its highly anticipated version 5. This update boasts exciting new features and impr...

0

JCJosh Campbellthingengineer.hashnode.devOct 4, 2024 · 7 min read

How VOLATILE, IMMUTABLE, and STABLE Attributes Affect Functions in Supabase

In Supabase, which is built on PostgreSQL, when you create functions using PL/pgSQL (Procedural Language/PostgreSQL), you have the option to specify the volatility category of each function: VOLATILE, STABLE, or IMMUTABLE. These categories describe h...

0

JCJosh Campbellthingengineer.hashnode.devOct 2, 2024 · 3 min read

The Great Data Debate: Is It 'Data Is' or 'Data Are'?

Hey folks! Ever stumbled over whether to say "data is" or "data are"? You're not alone. This little conundrum has tripped up many, including me! So, let's dig into why both usages exist and how you can confidently choose the right one for your contex...

0

JCJosh Campbellthingengineer.hashnode.devSep 29, 2024 · 5 min read

Boost PL/pgSQL Performance: Find and Fix Common Slowdowns

Hey everyone! If you’ve ever dealt with slow database performance in PostgreSQL, especially with PL/pgSQL functions, you know how frustrating it can be. But don’t worry, I’ve been there too and have gathered some valuable insights along the way. Toda...

0

Josh Campbell

About

Available for

Josh Campbell's blogs

Recently published

How to Securely Access User Data with Supabase Edge Functions

Intro to Svelte 5: The Compiler-Free Frontend Framework

How VOLATILE, IMMUTABLE, and STABLE Attributes Affect Functions in Supabase

The Great Data Debate: Is It 'Data Is' or 'Data Are'?

Boost PL/pgSQL Performance: Find and Fix Common Slowdowns

Search Hashnode

Josh Campbell

About

Available for

Josh Campbell's blogs

Recently published

How to Securely Access User Data with Supabase Edge Functions

Intro to Svelte 5: The Compiler-Free Frontend Framework

How VOLATILE, IMMUTABLE, and STABLE Attributes Affect Functions in Supabase

The Great Data Debate: Is It 'Data Is' or 'Data Are'?

Boost PL/pgSQL Performance: Find and Fix Common Slowdowns