Connect to Database Using Oracle NoSQL Visual Studio Code Extension

This section describes how you can connect to KVLite in a container using Oracle Database Visual Studio Code Extension.

Oracle NoSQL Database Visual Studio (VS) Code extension provides multiple ways to connect to an Oracle NoSQL Database. You can connect to Oracle NoSQL Database cloud service, cloud simulation, or an on-premise installation. For more details, see About Oracle NoSQL Database Visual Studio Code Extension. In the below case, we will connect to the KVLite instance that we are running inside a container by creating an on-premise connection.

1. Open the Oracle NoSQL DB extension from the left panel in Visual Studio Code.

   
   

   Description of the illustration nosql-db-vs-extension.png

2. Choose Show Connection Settings page from the Command Palette.

   
   

   Description of the illustration add-connection-vs.png

3. Choose Onprem. Choose Add New Connection. Provide a Connection Name and provide the Endpoint as http://localhost:8080 (if you are using an external host - provide the name of the host machine). Choose Add.

   
   

   Description of the illustration view-connection-vs.png

4. You will now be able to view the connection in the left panel. Choose the Plus icon or right-click on the database connection name and choose Create Table.

   
   

   Description of the illustration create-table-vs.png

   For more details on creating and managing tables, see Managing Tables Using Visual Studio Code Extension