FEAT: SQL Database (MariaDB, MySQL) - Database Label

[datgausaigon]

Hi, I use MariaDB to many project with many "Database(s)" (100-200) per Database Server (DbGate "Connection").

For security our Database Server administrators name Database Schema Names that are long and difficult to read. For example:
yourdomaincom_YWExYzdmYTFhZDcyY2_dbname

Can you add an additional feature to label the Database Schema Name?

• Labeled databases will have a different color than unlabeled databases (add a red square in front, for example)
• Click to view details to see the real name of the Database, or click on the icon showing that this Database has a Label to display information, Database Label, Database Real Name, Edit/Delete Database Label
• SQL and other features similar to the Database must still use the physical name of the Database. Label is only used for viewing and management.
• We will have convenience in management and safety in Database management
  Database Real Name: yourdomaincom_YWExYzdmYTFhZDcyY2_dbname
  Database Label: Your Domain Database

I found your Connections configuration in /Users/{username}/.dbgate --> File connections.jsonl
Can we develop further from this configuration?

Label is just an instance definition to view and manage Database using DbGate. Very helpful.

Thanks ❤️

[datgausaigon]

Hi, I got the "Set Database Color" feature of you. I think this feature can develop from this.

[ProjectInfinity]

I'm trying to wrap my head around this. Why would having database names be so complicated increase security in any way? I think personally whoever designed this has worked you into a corner and it's quite the edge case.

Could perhaps another solution for you be to create separate connections for databases you use and label them accordingly using "display name"? That way you just set the "default database" field to whatever complicated name you wish to use.

It's not ideal but neither is your setup.