Integrated Database Console

The latest PhpStorm EAP (build 94.430) contains a good number changes in Database-related functionality. Namely:

  • A dedicated Database Console tool-window
  • Сonsole-like UI keeps input and output in one place and retains the highlighting for execution history
  • Configurable keyboard shortcuts for all Console actions (in IDE Settings)
  • Per-result Page Up, Page Down and Refresh actions
  • Complete support for In-Memory Databases (try running some DDL in Console then click Refresh Tables and all the tables will be loaded in the Data Sources tree)
  • Quick Table Contents Lookup using the standard Quick Documentation Lookup action. Try Ctrl+Q on a table name anywhere in the IDE!

Try all this in the latest EAP and let us know what you think.

This blog is permanently closed.

For up-to-date information please follow to corresponding WebStorm blog or PhpStorm blog.

 
This entry was posted in Cool Feature, PhpStorm and tagged , . Bookmark the permalink.

8 Responses to Integrated Database Console

  1. Dmitriy says:

    I set up Data Source. I have autocomplete for tables names in database console tab. How I can get autocomplete at least for tables names in .sql files?

  2. raveren says:

    How do you set it up? The add connection dialog is not self-explanatory nor could I find any info on it. It asks me for a java.sql.driver file, I’m really lost.

  3. gregsh says:

    You need a JDBC driver for your database in order to communicate with it. You can try google it yourself otherwise you can use the “Find JDBC Driver on the Web” button in the panel toolbar.

  4. gregsh says:

    Completion works in *.sql files just as it works in console. If you have troubles with it please visit our forum at http://www.jetbrains.net/devnet/community/idea and ask this question there. Don’t forget to provide more information concerning the problem such as SQL dialect, statement text, place of completion.

  5. Zyava says:

    @gregsh I asked my question here: http://www.jetbrains.net/devnet/message/5259027 . Hope somebody has answer.

  6. Bob says:

    a good update for console

  7. Thank you for your information!

  8. Christian Hünniger says:

    Thanks,

    very cool feature, i like it :-)

    Regards,
    Christian

Comments are closed.