MariaDB Database Management in VS Code

DBCode is a MariaDB extension for VS Code: connect, browse schemas and data, write queries with schema-aware autocomplete, and edit rows visually without switching tools. Install DBCode to get started, or see how it compares to standalone database tools.

Overview

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system. It stands out with these distinctive advantages:

• Enhanced performance: Optimized storage engines and query optimizer
• Greater storage engine support: Including Aria, ColumnStore, Spider, and MyRocks
• Advanced features: Window functions, common table expressions, and temporal data tables
• Stronger security: Default encryption for tables, data, logs, and communications
• Open development model: Community-driven with transparent governance

MariaDB ensures MySQL compatibility while providing additional features, making it an excellent choice for organizations seeking a powerful, open-source database solution.

Connecting

To connect to MariaDB in DBCode:

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 MariaDB as the database type and enter:
   • Host address (default port: 3306)
   • Authentication credentials (username/password)
   • Database name (optional)
   • SSL/TLS settings (if required)
4. Connect: Click save to connect to your MariaDB database.
5. Start Managing Your Databases: Once connected, explore tables, views, and run queries.

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

Connect Multiple Databases

A number of cloud providers offer MariaDB as a service, including AWS RDS, Azure Database for MariaDB, and Google Cloud SQL. To connect to a cloud provider and access multiple databases:

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. Select Your Provider: Choose the cloud provider from the list on the right.
4. Authenticate: Follow the authentication process specific to the provider.
5. Start Managing Your Databases: Once connected, you can manage multiple MariaDB instances.

For detailed instructions on connecting to cloud providers, refer to the Connect a Cloud Provider article.

DBCode Features for MariaDB

With DBCode, you can perform these essential tasks when working with MariaDB:

• Data Browsing & Editing: View and edit table data with an intuitive grid-based interface
• Schema Management: Create, alter, and drop tables, views, and other database objects
• Procedure & Function Editor: Create and edit stored procedures with syntax highlighting
• Data Import/Export: Import data from CSV/JSON files and export query results
• Relationship Visualization: View table relationships with interactive ER diagrams
• Query History: Access and reuse your previously executed queries

By using MariaDB with DBCode, you can leverage these powerful features within the familiar VS Code environment, streamlining your database development workflow.

Advanced Connection Settings

The Advanced section of the connection editor exposes pool tuning options alongside the existing Editor Connection Idle Timeout setting.

Max Connections

The maximum number of concurrent connections DBCode opens per database for this connection. The default is 10.

Lower this value when the server enforces a per-user connection limit (MariaDB max_user_connections). A lower ceiling serializes concurrent queries rather than returning an error when the limit is reached.

Pool Idle Timeout

How long an idle pooled connection is kept open before it is closed, in seconds. The default is 300 seconds.

Lower this value to release connections sooner on servers with a tight connection limit.

For more information about MariaDB, check out MariaDB.