#Datagrip sql full
#Datagrip sql code

Introspection is killing performance of DG. This is important not just for getting insight writing assistance, but it determines when introspection happens. Do I set up a single datasource for all databases? Or is it better to set up a datasource for each database? If I do the latter, will I lose cross-database introspection when writing a queries in the editor that's connected to a datasource? What is the best practice for setting up projects, especially database connections? I work w/multiple databases on a server, often querying across databases. Now I want to run query B into a new results tab.ġ2. Is there a way to execute results into a new tab? Scenario is I run query A, results appear. And I don't have a desire to name every console I open.ġ1. Can console names default to server or database name? When attaching to a console, it's hard to know what is what. Not sure it has the info I'm looking for.ġ0. The scrollbar area has lots of colors, but that's bird's eye view.

#Datagrip sql code

Are there colors for the editor gutter to indicate code which has changed since load or changed and saved since load? See SSMS or many other IDEs. What is the equivalent function for 'Change Connection' in SQL Server Management Studio?ĩ. Is Control-Space supposed to show possible joins? And it should work between tables without FK defined by columns names in common. Why are joins not suggested? I know DG is supposed to suggest joins, but it's never worked for me. Is there a way to invoke by keyboard the hint which appears for function and procedure calls? Sometimes the hint appears for the first parameter after typing opening parenthesis and then will disappear. Bonus if you can add a 'Initial caps each word' option.Ħ. (The other casing options won't work.) Ex: 'select * from salesorder' should format to 'select * from SaleOrder' if SalesOrder is the table's name. In formatting options, can there be 'As in database' or 'As in metadata' option? The 'No Change' option seems to not touch text as I typed, which is not preferable. Is there a way code completion for table names put an 'as' between table name and alias? DG puts the alias. Is there a way to move the results of an execution to the footer of the editor, close to the source?Ĥ. A nice feature of SQL Complete is aggregation in results view. DG offers no writing assistance when querying through a linked server.Ģ. Does introspection support cross server queries? We have servers lined and write queries which pull data between them. Here my observations and questions using w/SQL Server (in no particular order):ġ. Thanks JB for the 30 day eval, because 30 days is what's needed.

#Datagrip sql full

'You get what you pay for' - The paid tools are worth the cost if you can use it to full extent.I'm evaluating moving from SQL Complete to DataGrip. dBeaver - SSMS, Azure Data Studio, Oracle development studio - Snowflake UI, GBQ Builtin UI The tools native to the system are more than enough. VSCode - Pycharm + DataGripįree tools should not be ignored as they get the job done well. This means, the development environment should cater to general needs and/or scripting.

I'll summarize some of the response:įor general DE needs, a scripted approach seems to be consensus. Toad, data grip, dbeaver etc.Īny recommendations / opinions on IDE & why?Įdit: Thanks for the feedback.

I have been using sublime and atom as text editors with syntax highlighting but I have been looking into full fledged IDEs e.g. Just curious about the IDE's that other people use.