CSE 462/562: Database Systems (Fall 2024)
Important rules and suggestions:
- Use VSCode or any other IDE over SSH connection at your own risk. We do not recommend using VSCode or other IDE that as they consume too many server resources. As we do impose a memory limit on your container, you may experience data loss if VSCode (or other IDE of your choice) goes over the memory limit. Also if you hog the machine with VSCode's server side processes, we will stop your dev container, which may also lead to unexpected data loss.
- If you do use VSCode or other IDE, we recommend disabling intellisense (or auto-completion in other IDE). (Search on google for how-to).
- If you insist on enabling intellisense or auto-completion, please retain the default settings we provide you.
- Use of generative AI is violation of the Academic Integrity policy. That means, you may not install or use CoPilot in VSCode.
- Discovery of use of generative AI in your course project will result in an F grade, with no exceptions. Please make sure Copilot is disabled or uninstalled in the extensions tab of VSCode.
This guide will show you how to use Visual Studio Code (or vscode in short - a popular code editor) to build, test and debug the project code you will be writing.
If you don't have vscode already installed, you may download and install it from here
Now please install the following extensions: Remote SSH and C++ extension pack
Step 1: On the bottom left of the screen you should see a green connection icon. Click it.
Step 2: Now select "Connect to Host…" and select "Add New SSH Host…"
Step 3: Enter -p PORT-NUMBER your-user-name@minsky.cse.buffalo.edu
Step 4: The editor might ask you for the path where it has to create the config file - it should be similar to this : - C:\Users\user-name\.ssh\config. Just hit enter. Make sure the path exists, otherwise the setup might stop abruptly.
Step 5: Now you should see the "Host added" success message. Click connect. A new window will open that will remote into our server. Select linux->yes->and enter your password. A successful setup will show this screen
Step 6: Click open folder and navigate to the root directory of your code setup.
Step 7: Go to the extension tab on the sidebar and install the above mentioned extensions in the remote server as well:
Step 8: Once installed, if the editor asks for the compiler select the following:
Building and running tests. After installing the extensions, the bottom bar should appear like this. You can click the following icons to build, run tests and debug your tests:
Debugging your code: Once you setup a breakpoint in any of your source files and click the debug button, the corresponding testcase runs and the breakpoint is hit!
At this point you should be in a pretty good shape to work on your project