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.

For more information about MariaDB, check out MariaDB.