Supabase allows large datasets and can perform very fast lookup via their built-in API tools. Step 1: Set up your Supabase project Step 2: Upload your CSV Step 3: Find the API details and request URL Sample Request URL:https://<your_project_id>.supabase.co/rest/v1/<table_name>?<table_column>=eq.{zip} Headers: Short video of setting it up: How to setup autocomplete lookup to your Supabase database […]
Articles Tagged: database query
How to use Google Sheet as a lookup table
Zipcode Lookup This method returns all row values associated with the zip code or any other data. It is useful for lookups when you need to retrieve the corresponding values. Step 1: Sign in to your Google account and access this google sheet link. https://docs.google.com/spreadsheets/d/1e8hYcRYIsu0bHY-445NKVB58nFxhS0mB2C9LRriJ_ik/edit?usp=sharing Step 2: Make a copy of the google sheet file […]
