Shortcut to open the project's database

[bilogic]

What

The extension https://github.com/damms005/devdb-vscode has quite an interesting feature: it reads the .env for database credentials and offers a direct shortcut to open the specific database that the project is interested in

Why (problem/use case)

If there are multiple connections and/or a long list of tables/databases, having a direct shortcut to the database allows us to skip through a bunch of searching every time

Additional Context

Add any other context, screenshots, or examples about the feature request here.

[mikeburgh]

Already a feature: https://dbcode.io/docs/connections/zero-config

[bilogic]

I use a multi root VSCode project and there is a Laravel .env in the first folder.
Contents as follows, and it could not be discovered

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=xxxxxx
DB_USERNAME=xxxxxx
DB_PASSWORD=xxxxxx

[mikeburgh]

Ahh, it was only matching connection strings, I just released version 1.18.2 which has a more robust support for those individual keys, and updated the docs, with more specifics about what it matches/looks for

[bilogic]

Hi, still not discovering on 1.19.1

[mikeburgh]

When you say in the first folder ? do you mean in a sub folder, root folder, workspace folder ?

Also if the connection already exists, it wont be added twice.. it matches on type, host, port.. I just tested your example in a root .env file and it picked it up fine.

[bilogic]

When you say in the first folder ? do you mean in a sub folder, root folder, workspace folder ? Also if the connection already exists, it wont be added twice.. it matches on type, host, port.. I just tested your example in a root .env file and it picked it up fine.

I use a multi root project, i.e. multiple workspace folders and have .env in the root of the first workspace folder

Prior to self discovery, I have created connections to all my servers and databases which includes the database specified in my .env, does that mean it won't show in discovered because it won't be added twice? This is hidden behavior to a user.

This has become a subset of #840, let me explain further there thanks!