Supabase

🧭 Situation I’m setting a Metabase dashboard to view the status of my data stored in Supabase. Options for Secure Connection to Metabase Option 1. IP Allowlist via EC2 Security Group Allow inbound access only from your home or office IP. Effect: Only you can reach the login page. Tradeoff: You’ll need to update the rule if you travel or use a new network. Option 2. Put Metabase Behind Reverse Proxy + Basic Auth Run an Nginx reverse proxy on the same EC2 instance. ...

Here’s how I added search to my KBooks site. All my book data was already flowing into Supabase from the National Library of Korea API through a dbt pipeline, so the challenge was: How do I make this table searchable efficiently without adding another service at this stage? This is how I got database-level search ready, step by step, and why each decision made sense. 1. Start from a clean source: silver_books My raw data lands as JSON in raw_nl_books. From there, I built a silver_books table using dbt. Each row represents one unique book identified by its ISBN-13, and only valid ISBNs are kept. ...