Felipe Freitag Vargas
Posted on November 19, 2024
With Flashboard, you can create admin panels for your Postgres Databases in an instant.
- Modern look
- Great UX
- No need to build the UI
- Light and dark mode (it follows your OS settings 😉)
Let's go from scratch:
1. Create an account
- Enter your email and choose a strong password.
The password will encrypt your DB connection strings, so make sure you'll remember it!
- Complete your (very short) profile
2. Connect a database
- Choose "connect my real database"
If you want to look around first, go with "play with a demo".
- Find your connection string and paste it.
If needed, check out this helpful guide to connection URLs.
- Optional: select namespace.
Most of the times, it will be "public". If there's only one namespace, you'll go directly to the next step.
- Choose a panel name and slug.
You need to confirm the same password you used to sign in. It will encrypt the connection URL. Only you have access to your DB data.
You're connected and ready to build!
3. Build your first tab
Let's create our tab. All your relations are already available, pick one from the selector.
For this example, let's go with "coupons".
Almost there. Let's choose some fields!
You can choose what fields to list, reorder the columns with drag-and-drop, pick a default column to order records by.
Looking good! We already have a read-only list of coupons, complete with search, filters and pagination.
Let's add some CRUD operations to it. Click on "Build" to see the options.
Table settings: what appears on the list. We already configured it when creating the tab, but you can change it when needed.
Detail settings: enable it if you want users to see the details of a row. Details can show data from columns and relations.
New item settings: enable it if users should be able to create new records. You can choose what fields to show on the form.
Edit item settings: enable it if users should be able to edit records. You can choose what fields to show on the form.
Allow deleting: toggle it if users should be able to delete records.
You don't need to configure everything at once. Each feature is disabled by default to prevent mistakes like "wooops, I forgot to disable XYZ".
From here on, you can use it as-is, create more tabs, or share panels with team members.
That's all you need to have an up-and-running Postgres admin panel.
Please let me know what you think!
Posted on November 19, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.