Datagrip Simple tips for Database Users - Part 1 - Hands On Easy Demos! скачать в хорошем качестве

Datagrip Simple tips for Database Users - Part 1 - Hands On Easy Demos!

Using DataGrip Verson 2019.1, I show you many basic tips to get you using Datagrip effectively. I am not paid anything for this promotion. I just think it is a pretty good multi-database product. (   / greg-c-coopman-b07b54103   ) 00:00 Introduction 6:54 Open a query window -new console 7:20 Multi-database usability 8:25 Copy code for connection to send; but won't capture password. 10:56 Tip of the day 11:40 Get all databases/schemas to show up 15:40 Commenting code 18:00 Highlight * and get drop down to see all column names 19:05 Alt key-drag cursor for vertical editing 19:35 Export data as updates, inserts, json, csv etc. 22:40 Shift-esc close database console 25:17 Pinning result tabs 26:34 Transpose toggle - looks like record format instead of tabular 27:28 Dragging columns and multi column sorting in result pane 30:07 Hover over column header after shmushing 32:10 Tab name identification - just save them with name you want 34:40 Query history 36:45 Compare syntax 39:04 Saves open windows on exit/restart ------ Note: Below, I have posted an email message I received from JetBrains-DataGrip, giving feedback on this video) ---- email from Max Sobolevskiy Product Marketing Manager of DataGrip JetBrains ----- Hi, Greg! My name is Max and I am the Product Marketing Manager of DataGrip. I've just found your video about tips in DataGrip.    • Datagrip   Simple tips for Database Users ...   I have to say that I really appreciate you making it. Please let me leave a couple of comments to your video. Some things can just be done in more efficient ways and also you've found a couple of problems I wish to comment. I will use youtube timestamps.    • Datagrip   Simple tips for Database Users ...   Here, when you choose schemas to be shown, you don't always need to use the context menu. Just click on digits '1 of 13' near the data source name and chose schemas!    • Datagrip   Simple tips for Database Users ...   Here, once you've chosen schemas they should be displayed and hidden automatically. The fact you тууув to press Sync is a bug, we will look into it. BTW what are your issues with Sync button? Are there problems?    • Datagrip   Simple tips for Database Users ...   When you clicked on the data source name, it was in "always on top" mode that's why there was no context menu. I agree this is not intuitive.    • Datagrip   Simple tips for Database Users ...   To see all coulmns you don't need always to use the lightbulb. In DataGrip we have super-important shortcut, just remember it: Alt+Enter. Being pressed on any part of SQL it offers you to improve the code or do any kind of action with it. Just press Alt+Enter on the asterisk and choose "expand wildcard".    • Datagrip   Simple tips for Database Users ...   First, to qualify all the columns you don't need multiple cursors. Just select all columns, press Alt+Enter and choose "qualify". See how it works:https://www.jetbrains.com/datagrip/wh... Also, when you notice that some objects in your SQL are yellow - that it is not normal. It means that DataGrip doesn't understand what objects they are. We call these objects unresolved In your case xyz is yellow and it should warn you. In fact, it happens because your alias was [as xyz] and DataGrip warns you about that misconnection. In later versions, we mark unresolved objects red.    • Datagrip   Simple tips for Database Users ...   When you have much code and you want to see it better, use Hide All Windows action by Ctrl+Shift+F12    • Datagrip   Simple tips for Database Users ...   Usually, you type SELECT * FROM several times a day. DataGrip knows it and offers you code snippets :) Just try typing 'sel' and press Tab! Forget about repetitive typing. More information is here: https://www.jetbrains.com/help/datagr...    • Datagrip   Simple tips for Database Users ...   Don't select queries before running them! You can just put the caret on the query and Run it! Also, you can not use the Execute button, just use the shortcut Ctrl+Enter.    • Datagrip   Simple tips for Database Users ...   In DataGrip 2019.2 we've introduced the ability to change page size settings just from the data editor. https://www.jetbrains.com/datagrip/wh...    • Datagrip   Simple tips for Database Users ...   Again, the same thing with unresolved objects. In your new file there is no session attached that's why DataGrip 'doesn't know about that objects'.    • Datagrip   Simple tips for Database Users ...   DataGrip actually can script several objects. Select the schema Ctrl+Alt+G and this will cal SQL Generator. The problem is that now you cannot select only the needed tables or only the tables node in the database explorer. I think we should add this possibility. Also, I would advise you to see our features page which will help you to know the tool better: https://www.jetbrains.com/datagrip/fe... If this letter was useful for you, I can do the same with the second part of your tutorial. Thanks! -- Max Sobolevskiy Product Marketing Manager of DataGrip JetBrains