Understanding workflow

I just downloaded 0xDBE, and I'm having a hard time understanding the workflow.

In a competing product, I can save my queries and execute them as though each saved query is in a separate database console, each with its own result set.

When I save queries to files in 0xDBE and execute them, I can see the database output (e.g. "Executed in 185 ms"), but not the resulting rows. To see the set of resulting rows, I have to manually copy a query from the file tab and paste it into the database console tab. This is inefficient. And because I can only open a single database console tab, I can only see one set of rows at a time, which is a step backwards from my current solution, one I'm eagerly looking to replace due to its own shortcomings.

Is this the intended workflow in 0xDBE, or am I overlooking something?

3 comments
Comment actions Permalink

Hello.

Thank you for the feedback. One reason we publish EAP builds is to collect such opinions and improve the product. So the answer is - yes, the workflow is not perfect, but will be improved.

Multiple consoles for the same data source is currently under development. Should be ready very soon: in the next EAP or in the following one, like that.

Executing a single statement in a file is a known feature request. No fix estimation at the moment, though. Welcome to vote and comment: https://youtrack.jetbrains.com/issue/DBE-297
Update: sorry, it's rather this one: https://youtrack.jetbrains.com/issue/DBE-176 Actually this is a set of issues to put all these commands in order.

The output for executing the entire file is not shown on purpose, since the whole file can be huge and generate a lot of output results. "Execute file" is rather a batch task. But executing a single statement in a file is quite reasonable request, so the issue above is open.

Regards,
Alexander.

0
Comment actions Permalink

Have you guys looked at SQL Server Data Tools plugin (aka SSDT) for Visual Studio 2013? It has many workflow options for SQL Server, but I need something that also targets open source databases like MySQL and PostgreSQL.

My dev workflow for projects under development consists mostly of the following steps in no particular order:

  • Create DDL table/procedure/function files by hand or with the designer.
  • Write scripts or procedures to insert initial data.
  • Commit the SQL project and all of its files into a git or other repo.
  • Use a Schema Comparison to update my local developer database.

As I develop my app, I might make changes directly on the server (outside of the project) for instance - I have SQL scripts that generate new objects based on existing objects. So at that point I might use a Schema Comparison to pull changes from my DB back into the project. This has the
effect of altering my DDL scripts for tables/procedures/etc. Otherwise, I might use a Data Comparison to generate a new set of INSERT INTO statements for my static data scripts by comparing my working DB to a new empty copy of the DB.

Will 0xDBE provide a comparative workflow? UPDATE: I just got my 0xDBE download email and I tried it out - it seems like 0xDBE will initially be more of a SQL console like SSMS, not a DDL scripts project IDE like SSDT since it does not seem to let the user store a project in a git repo. Is that correct?

Right now I am trying out IntelliJ IDEA for it's database tools and it seems that none of this functionality is available there. So, I'm hoping that 0xDBE can fill the need.

(Sorry for hijacking the thread, my question basically has the same title. Please let me know if I should start a new one.)
0
Comment actions Permalink

Hello Wayne,

Currently 0xDBE can not pull the entier remote DB shema for storing, versionning and comparing it with the remote schema. Such support is planned for sure.

We would really appreciate if you would share your expectations of the support you would like to have ( you can file a request at https://youtrack.jetbrains.com/issues/DBE ).

Right now I am trying out IntelliJ IDEA for it's database tools and it seems that none of this functionality is available there. So, I'm hoping that 0xDBE can fill the need.


Basically IntelliJ IDEA (with Database Support plugin) has the same features 0xDBE has. The difference is in a bit different project creation and management workflow.

0

Please sign in to leave a comment.