@thingengineer

How to Securely Access User Data with Supabase Edge Functions

Nov 26, 2024 · 3 min read · 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...

Intro to Svelte 5: The Compiler-Free Frontend Framework

Oct 21, 2024 · 2 min read · 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...

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

Oct 4, 2024 · 7 min read · 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...

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

Oct 2, 2024 · 3 min read · 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...

Boost PL/pgSQL Performance: Find and Fix Common Slowdowns

Sep 29, 2024 · 5 min read · 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...