why datagrip supports single database in one connection?

my service use multiple databases in mysql. i need auto complete about another database's table reference and 'dbforge' supports that. And dbforge shows every databases on 'Database Explorer' tab. why datagrip supports single database in one connection?

11 comments
Comment actions Permalink

I agree. This is probably the main reason why I'm not going to buy DataGrip yet and why I can't suggest it to my team. I've got 75 databases which I manage on a single server and needing to setup a connection to each one would be a nighmare.

1
Comment actions Permalink

Hello,
Please enable Resolve unqualified references check-box in Schemas tab for needed databases and schemas to have auto-completion work without needing to prefix table with the schema/database. This will help.

0
Comment actions Permalink

Do you also use MySQL? Does mentioned suggestion help?

0
Comment actions Permalink

It does not help me.  I have a postgres application with multiple databases.  When I edit a sql file, I don't have an option to specify which database I want to use to run it.

1
Comment actions Permalink

Agreed. Datagrip looks like something my organization would LOVE but because we have hundreds of databases, we can't even try it.

0
Comment actions Permalink

Still waiting for this feature.

0
Comment actions Permalink

I use postgres with multiple databases. DataGrip makes me open a separate connection for each database, even though they are really the same connection. This is not how Postgres is organized. I want this nested structure:

Connection 1

  • Db1
  • Db2

Connection 2

  • Db1
  • Db2

Currently I must do this:

Connection 1 with unique name

  • Db1

Connection 1 with different name

  • Db2

Connection 2 with unique name

  • Db1

Connection 2 with different name

  • Db2

 

0
Comment actions Permalink

Hi,

Multiple database support will be available in DataGrip 2017.2 and also in DataGrip 2017.2 EAP.

Thank you

0
Comment actions Permalink

@Menashehyperomsik Hi,

Did you install DataGrip 2017.2?

Here is a screenshot with an example:

Thank you.

0
Comment actions Permalink

Thanks Vasily ,

I can use multiple databases now with DataGrip

0

Please sign in to leave a comment.