How do I add a data source?
Dashibase currently supports adding any PostgreSQL database as a data source.
To connect a database:
Note: Certain database providers (e.g. AWS, Azure, Google Cloud) block incoming connections by default. If you're using one of these providers, you'll need to whitelist our IP address: 188.8.131.52/32
Please refer to the following articles for instructions on the whitelisting process:
Where can I find my database credentials?
Note: User corresponds to Username.
postgres://[Username]:[Password]@[Host]:[Port]/[Database Name]. For example, the connection string above corresponds to:
Note: If it is not your first time opening the dashboard, the connection string will not display the password. If you forgot the associated password, you can either create a new user or reset the password.
Where can I find my Supabase Anon Key and URL?
You can find it by heading to your Supabase Project Page > Settings > API.
See below for an example of the Supabase API Settings screen.
How do I create a user column that is a foreign key to the id column of auth.users?
First, add a new column named "user" and then click on "Add foreign key relation" and select the auth.users table and its id attribute.
See video below for details.
When I try signing up to my dashboard, the signup email redirects me to http://localhost:3000.
Check that you have added your dashboard URL (https://XXX.app.dashibase.com) to the list of additional redirect URLs.
You can find the setting by navigating to Supabase > Authentication > Settings.
See below for an example of the Supabase Authentication Settings screen.
When I try to add a new item in my dashboard, I get an error that says "new row violates row-level security policy".
This is likely because you enabled Row-Level Security (RLS) for your Supabase table, but you did not set the policies explicitly.
Check out the Supabase tutorial on setting RLS policies here.
You can also set your policies by navigating to Supabase > Authentication > Policies.
My question isn't answered here.
Drop me a note at email@example.com! I'd love to be able to help you out.