One of the improvements to the new version that has been on the 'wanted' list since the very early days of DataGrip is the ability to group data sources within the Database Tree View. DataGrip is a combination of an intelligent SQL editor and collection of database tools packed together and running on top of the IntelliJ platform. The latest update has improved navigation and connectivity. Hotkeyes are similar to shortcuts like CTRL+Z (undo) or CTRL+PgUp/PgDn (switch tabs), except that they work from anywhere and do whatever you tell them to.There's a new version of DataGrip, JetBrain's IDE for databases and SQL. Here are some practical examples (using AutoHotkey format): hotstrings expand 'btw' to 'By the way' as you type ::btw::By the way expand 'jtel' to Jenny's telephone number ::j tel::867-5309 correct 'teh' to 'the' :: teh::the expand '!!SG' to select from table and group by template :: !!SG:: SELECT col_1, COUNT(*) cnt FROM table `nwhere true `ngroup by 1 `norder by 1 descĪ hotkey is a combination of keyboard (or mouse) keys that, when pressed together, run a pre-defined command. Hotstrings are used to type out long strings of text using just a few keystrokes. But how does one put hotkeys and hotstrings to use?Ī hotstring is a string of characters that tools like AutoHotkey or other text expanders are pre-programmed to expand into something else. Tools like AutoHotkey (free, opensource) for PC or Mac’s built-in Keyboard settings and Automator can help you make the most of this functionality and configure it to your exact needs. Text expanders output pre-programmed strings of text when called via “hotkey” or “hotstring.” Just about anyone can benefit from using a text expander but database developers and data analysts, who frequently type out the same patterns of text throughout the day, stand to gain the most. Still, the features mentioned so far easily merit a thirty-minute time-saving in any given workday - to say nothing of the peace of mind that comes from not having to type out exact column names or look up definitions across multiple screens.Įxample use of DBeaver 2. We’re only starting to scratch the surface of what a dedicated IDE can do. These tools can bidirectionally load data to and from a file and even allow you to update table records directly from query results, thus saving you from having to write the DML by hand. The ability to hyperlink to a table or view definition directly from the editor is also very convenient. You can (auto)save SQL scripts for later reference, work on multiple active scripts across multiple tabs, and even across multiple databases, all from a single screen. You can even transform a SELECT * into a fully qualified list of columns with a single keystroke. ![]() Vendor-specific interfaces will vary in their look and feel and the features they provide (some of which may even be exclusive.) However, if wiring SQL is your bread and butter, a dedicated IDE like DBeaver (free) or DataGrip (paid) will outshine any standard console.ĭBeaver and DataGrip offer very similar sets of features, starting with a customizable and theme-able UI, which includes syntax highlighting (helping you parse SQL quickly and avoid eye strain.)īoth of these tools excel at context-aware autocomplete - helping you find the exact column, table, or function, as you type (even with a partial match.) Formatting features like bulk indentation, auto-format, and case conversion help keep scripts neat and legible. Whether cloud-based or on-premise, database vendors provide some interface to write and execute SQL. So, with that in mind, let’s attempt to reclaim an entire workday from the clutches of inefficiency! 1. That means on average, the time benefit of the hack will depend on the likelihood of being used on any given day. Some yield small daily dividends while others pay off big on infrequent tasks. Some of these tips yield instant rewards while others pay off in the long term. Finding practical tips specifically geared towards developers, specifically BI developers, can be difficult.Īnother difficulty lies in the estimation of the time savings. When left unchecked, inefficiency will eat up chunks of your day and frustrate you through tedious and unrewarding work.Īlthough there are volumes of books and articles written specifically on productivity and getting things done (GTD), they tend to orient toward a general audience. “Unseen degrees” is the poetic way of saying that bad habits have knock-on effects that often go unattributed, though certainly not unnoticed. ![]() Ill habits gather by unseen degrees, as brooks make rivers, rivers run to seas.
0 Comments
Leave a Reply. |