iTerm2 vs Sequel Pro
When comparing iTerm2 vs Sequel Pro, the Slant community recommends iTerm2 for most people. In the question“What are the best power user tools for macOS?” iTerm2 is ranked 1st while Sequel Pro is ranked 22nd. The most important reason people chose iTerm2 is:
Other than being able to customize the various shortcuts, iTerm2 also lets you customize the colorscheme, font, transparency, etc.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Extremely customizable
Other than being able to customize the various shortcuts, iTerm2 also lets you customize the colorscheme, font, transparency, etc.
Pro Autocomplete is built-in
iTerm has autocomplete features built in. It remembers your past commands and when you are writing something on the terminal, simply pressing Control-;
it will show you a drop down menu of suggestions from which to choose.
Pro Complete out of the box
Unlike most terminal emulators, iTerm2 comes with a pretty complete set of features. It has built-in search, autocompletion, tabbed navigation, Growl support and even a built-in clipboard manager for various API keys and such.
Pro Fine tuning for fonts
It's possible to choose a font and adjust vertical and horizontal spacing.
Pro Can immediately open files inside a text editor
You can Ctrl+Click on a file path to open said file in a text editor.
Pro Supports mouse actions
Has support for mouse actions like clicking, dragging, selecting, etc.
Pro Active maintainers
Issues resolved fast by quality contributors.
Pro Works well with powerline fonts
Pro Completely free and open source
iTerm2 is completely free and open source. It's released under the GPLv2 license.
Pro Split panes
Easy to split panes to either horizontal or vertical sections. Makes it easy to observe multiple console windows.
Pro Supported by many applications as a terminal app selection
If an application has terminal integration, there is high probability it allows iTerm2 to be selected.
Pro Intuitive
Pro Cmd+Shift+I to Input all
Wanna SSH your server from multiple tabs, here you go.
Pro You only need to type in commands once
iTerm2 can store up to 4M of history of commands you already used. This, coupled with the built-in search features makes it possible to type a command only once and then search for it through the history for subsequent uses.
Pro Works perfect with Oh My Zsh
It's a perfect base to add Oh My Zsh on top of it and enjoy a lot of themes and a really pleasant look and feel.
Pro Works well with tmux
The great mouse and clipboard support that are built-in go really well with tmux.
Pro Any key can be mapped to any function
Using the Preferences Menu you can set up hotkeys to map virtually any action you can think of to a single key or a combination of them. This is extremely helpful as it allows you to use shortcuts to edit commands you are typing in the terminal and while most terminal emulators have shortcuts for this sort of thing, few of them let you define your own.
Pro GPU-rendered, blazing fast and super smooth
Many people say they use Kitty or Alacritty because they are GPU-rendered. That was true a long time ago. But iTerm2 has been GPU rendered for years now. It's so fast and smooth that you soon forget you are in a terminal.
Pro Beautiful, minimalistic and elegant UI
It's super-clean and during use it gets completely out of the way, it's a beautiful canvas for your terminal work, a pure joy that never gets old.
Pro Can be configured as a drop-down terminal
Can be configured to work as a drop down terminal like Quake.
Pro Cmd+D to split plane vertically
Very handy to use multi-tab.
Pro Great UI
Clean, easy to use, highly polished interface.
Pro Native OS X from the start
Unlike other solutions, Sequel Pro was built specifically for OS X and for MySQL from the beginning and as such the design takes better advantage of OS X features and is optimized for MySQL.
Pro Free and open source
Licensed under MIT.
Pro Multiple connection methods
Sequel Pro can choose between standard and SSH connection methods.
Pro Multiple import/export options
Sequel Pro can export to SQL, CSV and XML files and import SQL and CSV files.
Pro Command line access
Sequel Pro can also access and manage everything from the command line.
Pro Excellent user management
Has easy user privilege management.
Pro Highly flexible filters
Sequel Pro has highly flexible and customizable filters.
Cons
Con Keycodes are not passed through following Linux standards
If you come from a Linux terminal emulator (Gnome Terminal, Konsole...) and you rely on key-combos that are widely supported in those, porting the same functionality to iTerm is possible but will require a lot of research and configuration on your part, so account for a long painful adoption period.
Con Not quite as fast as Alacritty or Kitty
Comparing these 3 terminals on the same machine/config, iTerm stands out as the slowest of the bunch. The difference may not be noticeable to all users.
Con Way too many menu items and settings
Finding the right one is like searching for a needle in a haystack.
Con Doesn't support Snow Leopard 10.6.8
Some people still use Snow Leopard or other 32-bit systems.
Con Doesn't support RTL
Con Crashes constantly
Crashes when working with mysql 8.0.12 for macos 10.13. Unable to do anything.
Con Not maintained
The app crashes when you close a tab.
Con No MySQL 8 support
Con Not adapted for MacOS Catalina
Con No multiple query tabs
Sequel Pro does not support multiple query tabs in its editor. This is incredibly frustrating for a power user.
Con Text in the query lost on connection failure & crashes
Con OS X only, no Linux or Windows versions
Power users have to manage in many different environments. A consistent admin interface is hugely beneficial.
Con Query editing capabilities much poorer than MySql Workbench, Querious, and others
Con No visual query editor
Con Unable to import from binary SQL files
I frequently import binary multipolygon data from another source, and it won’t open.