Being able to think about data at scale will change how you approach your work and being able to work at scale will increase your efficiency and impact. The hard part? You have to pull yourself away from spreadsheets for a while-go slow to go fast (and big).

Now is a great time to upskill and become more effective in almost any career take advantage of the demand.The tools have caught up and basically, anybody with spreadsheet skills can set up a data stack that works at scale.There are plenty of resources to learn SQL but the path to using it in the вЂњreal worldвЂќ isnвЂ™t very clear.There arenвЂ™t enough people with the skills to work with data at scale.The scale and application of data still growing ( duh).I didnвЂ™t expect to be called to account for it.ДЄs it turns out, the post was pretty popular and I think I know why. I boldly claimed that вЂњA spreadsheet is just data in single-player mode.вЂќ And while I stand by that claim. вЂњA spreadsheet is just data in single-player modeвЂќ If you have Dash installed, you can use the command 'Look Up In Dash' in the context menu or press Ctrl-H to look up the current word (or selection) in Dash.JFrom Spreadsheets to SQL: Step One towards the Minimum Viable Data Stack Use the command 'Shift Left' in the 'Edit' menu or pressВ в‡§в‡Ґ orВ вЊ[ to shift the selected line(s) to the left (decrease indentation). Use the command 'Shift Right' in the 'Edit' menu or pressВ в‡Ґ orВ вЊ] to shift the selected line(s) to the right (increase indentation). Multiple selected lines can be indented at once. Multiple matches of the same suggestion will be grouped by type, use the left and right arrow keys to expand and collapse grouped suggestions. In the autocompletion window, use the arrow keys to select a completion, then hit the return key to confirm. You can also trigger autocomplete using the command 'Show Completions' in the 'Edit' menu. you are trying to 'complete' a whitespace character). This mode can even be used if there is no word (e.g. Press Ctrl-Space or ESC, and Postico shows a list of all possible completions in a popup window, including additional matches related to the word you have typed. We tried to make the behaviour similar to tab completion in command-line tools like psql and bash.

Press Tab again to display a list of possible completions in a popup window. When multiple completions are possible, you hear a beep. Tab Completion: Press Tab, and Postico automatically tries to complete the word you are typing.There are two autocomplete modes available in the SQL query view. To clear the result area, use the command 'Clear Results' in the 'Connection' menu or press вЊK. Use the command 'Execute All Queries' in the 'Connection' menu orВ вЊҐвЊв†©пёЋ to execute all statements at once. You can switch between results using a popup menu button at the bottom left. When you execute multiple statements, Postico will display the first result. They will be executed in an implicit transaction, so if one of the statements fails, all changes to the database will be rolled back. You can execute multiple statements at once by selecting them. The corresponding results are displayed below the text view. Use the command 'Execute Query' in the 'Connection' menu or pressВ вЊв†©пёЋ to execute the current statement (or the current selection, if any).

The query view highlights the current statement in light grey. There's also a keyboard shortcut (в‡§вЊT) to navigate to the query view. You can get to the SQL Query View by clicking on 'SQL Query' in the sidebar. You are looking at the documentation for Postico v1.5.19 - would you like to go to the latest version instead? Using the SQL Query ViewД¬ustom database queries can be executed from the SQL Query view in Postico.

Postico run sql files