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?
请先登录再写评论。
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.
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:
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.
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 ).
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.