Create admin panels for Postgres in 3 short steps

felipefreitag

Felipe Freitag Vargas

Posted on November 19, 2024

Create admin panels for Postgres in 3 short steps

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!
Sign in to Flashboard

  • Complete your (very short) profile

Complete profile

2. Connect a database

  • Choose "connect my real database"

If you want to look around first, go with "play with a demo".
Connect database

  • Find your connection string and paste it.

If needed, check out this helpful guide to connection URLs.
Paste your connection URL

  • 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.
Namespace

  • 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.

Create panel

You're connected and ready to build!
Empty panel

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".
Create tab

Almost there. Let's choose some fields!
Empty tab

You can choose what fields to list, reorder the columns with drag-and-drop, pick a default column to order records by.
Edit tab

Filled edit tab

Looking good! We already have a read-only list of coupons, complete with search, filters and pagination.
Coupon list

Let's add some CRUD operations to it. Click on "Build" to see the options.

Build menu

  • 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!

💖 💪 🙅 🚩
felipefreitag
Felipe Freitag Vargas

Posted on November 19, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related