VS Code Can Do That - Workshop
Main
Main
  • VS Code Can Do That Workshop
  • Essential Keyboard Shortcuts
  • Exercise 1 - Customizing The Editor
    • Customizing The Editor
    • Switch themes
    • Install a new icon theme
    • Switch fonts
    • Editor tweaks
    • Change default Settings view
    • Easily identify editor instances
  • Exercise 2 - Productivity Tricks
    • Productivity Tricks
    • Essential navigation shortcuts
    • Creating HTML with Emmet
    • Styling with Emmet
    • Update image sizes
  • Exercise 3 - Navigation And Refactoring
    • Navigation And Refactoring
    • Moving, Duplicating and Deleting
    • Folding sections
    • Multiple cursors
    • Rename refactor
    • Finding things
    • Extract refactor
  • Exercise 4 - Debugging
    • Debugging
    • Simple debugging
    • Simple launch config
    • Auto attach
    • Debugging browser apps
    • Compound debug configurations
  • Exercise 5 - Docker
    • Docker
    • Dockerizing an application
    • Running and inspecting images
    • Docker compose
    • Debugging Docker containers
  • Exercise 6 - Remote Development
    • Remote Development
    • Create a remote container
    • Create a new function in the container
    • Handling extensions
  • Exercise 7 - Working With Data
    • Working with data
    • Working with MongoDB
    • Working with SQLite
    • Working with MySQL
  • Exercise 8 - Git and Source Control
    • Git and source control
    • Cloning repos with VS Code
    • Common Git workflows
    • Branching and merge conflicts
Powered by GitBook
On this page

Was this helpful?

  1. Exercise 7 - Working With Data

Working with data

PreviousHandling extensionsNextWorking with MongoDB

Last updated 5 years ago

Was this helpful?

Apps have data. At least most of them do. Even if you're strictly a frontend developer, the time is going to come sooner or later when you have to work with a database of some sort. Traditionally, databases are a black box that you interface with via a network protocol or command line tool. In some instances, there are third party GUI's that you can install. With VS Code, you can bring most database providers right into your editor.

In this section, you'll learn how to connect to various data providers, visually interact with your data stores and run queries right from the same place you run your code.

Open the "exercise-7-working-with-data/start" folder.

This section does not have a "solution" folder. All work will be done in the start folder.

cd exercise-7-working-with-data/start
code .

This project uses Remote Containers to deliver Mongo DB and MySQL as databases without you having to install anything. It's like magic.

After VS Code opens...

  • Open the Command Palette (Cmd/Ctrl + Shift + P)

  • Select "Remote-Containers: Reopen Folder in Container"

  • This may take just a moment as VS Code has to pull down images and build the containers the project runs in