Visual Studio Code

Visual Studio Code: Grep

This is a quick post about a feature I discovered by accident in that I really like:

I was working in a Linux machine and ran a grep in the integrated terminal to find a particular piece of code. The terminal gave me the results in the usual way, with the file names highlighted, the line in the code, and a bit of the code around what I searched for. Then I happened to scroll over the file name in the results and it showed me a tooltip offering that I could open the file by holding Ctrl and clicking on the path.

Continue Reading Visual Studio Code: Grep

MySQL Workbench

You know what desktop app made the largest improvement to my workflows when I discovered it? Not Visual Studio Code, as much as my writing sometimes hypes it up as my preferred text editor. There were already good text editors.

No, the desktop tool that made the biggest improvement to my workflows was MySQL Workbench. If you work with databases at all, this will make your life so much easier than navigating those databases in a command line.

Continue Reading MySQL Workbench

My (Freelance) Web Development Workflow

When I work on a website, especially once I need to deploy some custom code, I have several tools at my disposal I want to set up. Here’s what those tools and that setup process looks like. For the purpose of this post, I’m assuming I already have the SFTP and SSH credentials from the website host.

SSH keys

The one-time need is to prepare my SSH keys. This requires three files which can be created with PuTTYgen, part of the package that comes with PuTTY.

Continue Reading My (Freelance) Web Development Workflow

Visual Studio Code: Remote SSH Development

One of the greatest improvements to my website development workflow came the day I discovered I could directly code on a web server in . Before this realization I was opening files with FileZilla, which worked but took a few clicks for each change:

  1. Browse to file in FileZilla
  2. Double-click to prompt opening in Code
  3. Switch over to Code, make changes, and save the file
  4. Switch back to FileZilla
  5. Say yes on the prompt to upload the change
  6. Test in browser to see if it did what I wanted it to do
  7. Repeat 3-6 if necessary for next change
Continue Reading Visual Studio Code: Remote SSH Development

Visual Studio Code: Using GitHub

Working in but need that connected to your repository? No problem. Getting connected to GitHub from Visual Studio Code is straightforward. It’s also possible to connect to other Git servers, but the authentication process is a bit more complicated, so I’ll stick to GitHub which is now my primary code repository. I’m also sticking with Windows, but the general idea is the same for other platforms with Code.

Continue Reading Visual Studio Code: Using GitHub