Click the button below to set up your database automatically, or copy the SQL and run it manually in Supabase → SQL Editor.
DROP TABLE IF EXISTS visits;
CREATE TABLE visits (
id text PRIMARY KEY,
address text,
lat float8,
lng float8,
visited_at timestamptz DEFAULT now(),
note text DEFAULT '',
geom jsonb
);
ALTER TABLE visits ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON visits
FOR ALL USING (true) WITH CHECK (true);
ALTER PUBLICATION supabase_realtime ADD TABLE visits;
🌍 Public Sharing
Your credentials are saved on this device. To make the map
automatically load your data on any device (phone, friend's browser, etc.)
without them needing to enter anything — embed the credentials directly in the HTML file:
Replace these two lines near the top of the <script>:
⚠️ Only share the file with people you trust, as it contains your database key.
The anon key only allows reading/writing the visits table — it cannot access other Supabase data.