Overview

YugabyteDB is a distributed SQL database that provides high availability, scalability, and performance based on PostgreSQL. It is designed to handle large volumes of data and is widely used in enterprise applications. YugabyteDB combines the best aspects of traditional RDBMS systems with cloud-native architecture:

  • PostgreSQL compatibility: Use familiar SQL syntax and tools
  • Distributed architecture: Built for cloud-native, high-availability deployments
  • Linear scalability: Easily scale horizontally by adding nodes
  • Strong consistency: ACID compliant transactions across distributed nodes

Connecting

To connect to YugabyteDB with DBCode, you’ll need:

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon.
  3. Complete connection form: Select YugabyteDB as the database type and enter:
    • Host address (default port: 5433)
    • Authentication details (username/password)
    • Database name (default: yugabyte)
  4. Connect: Click save to connect to your YugabyteDB database.
  5. Start Managing Your Databases: Once connected, you can start exploring your tables and data.

For detailed instructions on connecting to YugabyteDB, refer to the Connect article.

Features in DBCode

With YugabyteDB in DBCode, you can:

  • Run SQL queries across your cluster
  • View and manage your distributed tables and indexes
  • Visualize query results in a user-friendly format
  • Use the built-in SQL editor with syntax highlighting and auto-completion

By using YugabyteDB with DBCode, you can leverage the power of distributed SQL while enjoying the productivity benefits of working within Visual Studio Code.

For more information about YugabyteDB, check out YugabyteDB.