Dev Plugin

Reference for MariaDB information functions, covering session and server metadata such as LAST_INSERT_ID, ROW_COUNT, FOUND_ROWS, USER, and VERSION, with usage guidance for writing SQL that reads auto-increment IDs, row counts, and connection details.

Explains MariaDB Connector/Node.js specifics: Promise vs Callback API, placeholders, BigInt handling, batch inserts, query streams, pooling, transactions, and prepared statements, for writing or reviewing Node.js code that uses the `mariadb` package.

Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.

Explains MariaDB Connector/Python's DB API 2.0 behavior, including qmark placeholders, autocommit, prepared statements, buffered cursors, connection pooling, and error handling, for writing and reviewing Python code that uses the mariadb module.

Reference for MariaDB control-flow functions and operators, including IF(), IFNULL(), NULLIF(), COALESCE(), CASE, NVL2(), and DECODE_ORACLE, with guidance on correct usage and common pitfalls.

Adds the MariaDB Connector/R2DBC reactive driver to a Maven or Gradle build and configures connection factories, pooling, and TLS, including the R2DBC-specific URL scheme and parameter names.

Best practices for MariaDB system-versioned (temporal) tables, covering creation, querying historical data, managing history growth, and handling ALTER TABLE operations.

Installs and configures the MariaDB Connector/Node.js npm package, covering API entry points, TLS, and pooling.

Installs and configures MariaDB Connector/Python, covering the 1.1 and 2.0 lines, build prerequisites, and connection settings.

Scaffold a MariaDB Schema Management (MSM) project and author the initial schema in the development folder, creating the project with msm.create_project and writing the first version's tables, objects, and grants into the MSM sections of <schema>_next.sql.

Deploys a MariaDB Schema Management (MSM) schema version onto a live server using msm.deploy_schema, creating a fresh schema or upgrading an existing one, with optional backup.

Develop the next version of a MariaDB Schema Management (MSM) schema by editing the development script and splitting large sections into SOURCE-included files.

Prepare a MariaDB Schema Management (MSM) version release by snapshotting the development script, filling the generated update script with the actual migration, and then generating the deployment script.

Configure authentication and authorization for a MariaDB REST Service: create REST auth apps, link them to services, add REST users, and manage REST roles and privileges.

Modify existing MariaDB REST Service endpoints using ALTER and DROP REST statements, including renaming request paths, enabling/disabling, publishing, and merging JSON options.