vscode

https://code.visualstudio.com/

Free. Built on open source. Runs everywhere.

   1 # https://code.visualstudio.com/
   2 cd ~/Downloads
   3 wget https://go.microsoft.com/fwlink/?LinkID=760868
   4 mv index.html\?LinkID\=760868 vscode.deb
   5 sudo dpkg -i vscode.deb # 1.43.2
   6 code & # launch command
   7 # code 1.58
   8 sudo dpkg -i code_1.58.2-1626302803_amd64.deb

Install extension ms-dotnettools.csharp
Install extension Eclipse Keymap alphabotsec.vscode-eclipse-keybindings
Install extension c/c++ extension pack
Install extension extension pack for java
Install extension Python ms-python.python
Install extension PHP xdebug.php-pack

Python - install extension

Python ms-python.python

Slackware64 15.0

   1 cd ~/Downloads
   2 wget https://az764295.vo.msecnd.net/stable/f80445acd5a3dadef24aa209168452a3d97cc326/code-stable-x64-1644446282.tar.gz
   3 mv code-stable-x64-1644446282.tar.gz ~/
   4 cd ~
   5 mkdir vscode
   6 mv code-stable-x64-1644446282.tar.gz vscode/
   7 cd vscode/
   8 tar xvzf code-stable-x64-1644446282.tar.gz 
   9 mv VSCode-linux-x64/ ~/
  10 cd ~
  11 cd VSCode-linux-x64/
  12 ./code &
  13 # add path to PATH env in .bashrc
  14

Debian

   1 # https://code.visualstudio.com/docs/setup/linux
   2 sudo apt-get install wget gpg
   3 wget -qO- https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > packages.microsoft.gpg
   4 sudo install -o root -g root -m 644 packages.microsoft.gpg /etc/apt/trusted.gpg.d/
   5 sudo sh -c 'echo "deb [arch=amd64,arm64,armhf signed-by=/etc/apt/trusted.gpg.d/packages.microsoft.gpg] https://packages.microsoft.com/repos/code stable main" > /etc/apt/sources.list.d/vscode.list'
   6 rm -f packages.microsoft.gpg
   7 sudo apt install apt-transport-https
   8 sudo apt update
   9 sudo apt install code

VSCodium

Free/Libre Open Source Software Binaries of VS Code

   1 wget -qO - https://gitlab.com/paulcarroty/vscodium-deb-rpm-repo/raw/master/pub.gpg | gpg --dearmor | sudo dd of=/usr/share/keyrings/vscodium-archive-keyring.gpg
   2 echo 'deb [ signed-by=/usr/share/keyrings/vscodium-archive-keyring.gpg ] https://download.vscodium.com/debs vscodium main' | sudo tee /etc/apt/sources.list.d/vscodium.list
   3 sudo apt update 
   4 sudo apt install codium

settings.json

   1 {
   2     "workbench.colorTheme": "Default Dark+",
   3     "window.zoomLevel": 2,
   4     "python.linting.pylintEnabled": false,
   5     "telemetry.telemetryLevel": "off",
   6     "editor.codeLens": false,
   7     "editor.minimap.enabled": false,
   8     "editor.fontSize": 14
   9 }

Debug in Java

   1 java -Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=y,address="8000" -jar target/app.jar

.vscode/launch.json

   1 {
   2     "configurations": [
   3     {
   4         "type": "java",
   5         "name": "Attach to Remote Program",
   6         "request": "attach",
   7         "hostName": "localhost",
   8         "port": "8000"
   9     }
  10     ]
  11 }

In VSCode, menu Run, start debugging. Run and debug, attach to remote program.

.editorconfig file

VSCode EditorConfig extension.

MSSQL extension

Name: SQL Server (mssql), identifier: ms-mssql.mssql

After the installation we will see a SQL server icon and we may click on Add connection.

sqlcmd commands

   1 /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P ********
   2 
   3 use CSET
   4 go
   5 select PrimaryEmail from USERS;
   6 go
   7 
   8 select name from sys.databases
   9 go
  10 use CSET
  11 go
  12 SELECT name FROM sys.tables;
  13 GO
  14 select * from USERS
  15 go
  16 EXEC sp_help 'USERS';
  17 GO
  18 select PrimaryEmail, UserId, Password, IsSuperUser from 'USERS';
  19 go 
  20 select PrimaryEmail, Password, IsSuperUser from USERS where Password is not null
  21 go
  22 SELECT name FROM sys.objects WHERE type = 'V';
  23 GO
  24 SELECT name FROM sys.objects WHERE type = 'P';
  25 GO
  26 SELECT name FROM sys.objects WHERE type = 'TR';
  27 GO

Navigation