Sublime Text

Site: https://www.sublimetext.com/

This is a program that I had saw used by programmers at conferences and it took awhile to get a hang of using the tool. Memorizing a few key shortcuts really made this tool my go to for anything with a textual element. You can paste code into the editor purely for formatting, you can perform mass edits to multiple lines at once; multi-cursor selection. This program is really a text editor on steroids.

Recently, I have been referred to VSCode, which I have been actively testing. VSCode is a free alternative with similar functionality. It also appears to be more frequently maintained than Sublime Text.

Through the use of this program, I came across numerous packages that helped with performing various tasks. Below are some of the packages that I use frequently. Their descriptions can be viewed at https://packagecontrol.io/

  • Advanced PLSQL
  • Advanced CSV
  • AlignTab
  • All Autocomplete
  • ApacheConf
  • Auto Semi-Colon
  • AutoFileName
  • AutoSpell
  • BracketGuard
  • BracketHighlighter
  • Case Conversion
  • CodeCounter
  • ColorPicker
  • Compare Side-By-Side
  • Copy as HTML
  • Crontab
  • CSS Extended Completions
  • CSS Format
  • DeleteBlankLines
  • DocBlockr
  • Emmet
  • FileBinder
  • Foundation 6 Autocomplete
  • GenerateUUID
  • Git
  • GitGutter
  • Google Spell Check
  • Hasher
  • HTML Minifier
  • HTML-CSS-JS Prettify
  • HTML5
  • Increment Selection
  • InsertDate
  • jQuery
  • JSLint
  • Origami
  • Package Control
  • PackagesUI
  • Pretty JSON
  • rainbow_csv
  • RainbowBrackets
  • Random Everything
  • RandomCase
  • Show Character Code
  • Side-by-Side Settings
  • SideBarEnhancements
  • SqlBeautifier
  • Status Bar File Size
  • StringUtilities
  • StyleToken
  • SublimeCodeIntel
  • Swap Selections
  • tabr
  • TabsExtra
  • VBScript
  • XAML

JSFiddle

Site: https://jsfiddle.net/

This is a small sandbox for learning or testing different web technologies. You are able to have 3 panes for HTML, Javascript, and CSS; a fourth pane will then display the output, based on what you type in the other three panes. This website provides the ability to use numerous frameworks such as JQuery, Angular, React, etc.

Royal TS

Site: https://www.royalapps.com

This application has been a tremendous time saver. This application is able to handle all of your connections to servers, whether you use RDP, SSH, SFTP, VMWare, or VNC. This application also simplifies management of your connections by creating a credential object, which can then be assigned to your connections for quick accessibility. To differentiate production, test and qa environments, you also have the ability to color code folders, and child objects can inherit the color.

emEditor

Site: https://www.emeditor.com/

emEditor is a tool that I purchased for a specific need, and SublimeText was not able to handle it. I needed the ability to open an extremely large CSV file and manipulate the CSV data in bulk. Specifically, the CSV had sporadic use of quoted cells, commas where their shouldn’t have been, etc. emEditor was able to open the file and, in attempting to parse the CSV, it was able to pinpoint lines that had a mismatch in the number of columns for the CSV. This allowed me to correct those records manually. Another feature that I used at the end of the project was the ability to mass-quote each individual cell, for consistency. Although not quite to the point of excel and its formula language, emEditor allowed for tabular display of CSV data, which allowed for quick sorting of data.

I still do not use this editor on a consistent basis, but it has unique functionality that I have not been able to find anywhere.

DBeaver

Site (Free): https://dbeaver.io/
Site (Paid-Enterprise Edition): https://dbeaver.com/

This is a connection manager for databases. You can share common settings amongst connections, color code connections, and standardize your keyboard shortcuts across different SQL languages. Free edition should work for most users; paid edition includes advanced export functionality and more connection options.