Use community extensions for MySQL hosting

Questi contenuti non sono ancora disponibili nella tua lingua.

⭐ Community Toolkit

The Aspire Community Toolkit MySQL hosting extensions package provides extra functionality to the Aspire.Hosting.MySql hosting package.

This package provides the following features:

Adminer management UI
DbGate management UI

Hosting integration

To get started with the Aspire Community Toolkit MySQL hosting extensions, install the CommunityToolkit.Aspire.Hosting.MySql.Extensions NuGet package in the AppHost project.

aspire add communitytoolkit-mysql-extensions

La CLI Aspire è interattiva; seleziona il risultato corretto quando richiesto:

Select an integration to add:

> communitytoolkit-mysql-extensions (CommunityToolkit.Aspire.Hosting.MySql.Extensions)
> Other results listed as selectable options...

#:package CommunityToolkit.Aspire.Hosting.MySql.Extensions@*

<PackageReference Include="CommunityToolkit.Aspire.Hosting.MySql.Extensions" Version="*" />

For TypeScript AppHosts, add the Community Toolkit MySQL extensions package to aspire.config.json:

{
  "packages": {
    "CommunityToolkit.Aspire.Hosting.MySql.Extensions": "*"
  }
}

Add management UI

DbGate management UI

To add the DbGate management UI to your MySQL resource, call the WithDbGate method on the MySqlServerResourceBuilder instance:

C#
TypeScript

var builder = DistributedApplication.CreateBuilder(args);

var mysql = builder.AddMySql("mysql")
    .WithDbGate();

builder.AddProject<Projects.ExampleProject>("api")
    .WithReference(mysql);

builder.Build().Run();

import { createBuilder } from "./.aspire/modules/aspire.mjs";

const builder = await createBuilder();

const mysql = await builder.addMySql("mysql");
await mysql.withDbGate();

const api = await builder.addProject("api", "../Api/Api.csproj");
await api.withReference(mysql);

await builder.build().run();

This adds a new DbGate resource to the AppHost which is available from the Aspire dashboard. DbGate is a comprehensive database management tool that provides a web-based interface for managing your MySQL databases.

Adminer management UI

To add the Adminer management UI to your MySQL resource, call the WithAdminer method on the MySqlServerResourceBuilder instance:

C#
TypeScript

var builder = DistributedApplication.CreateBuilder(args);

var mysql = builder.AddMySql("mysql")
    .WithAdminer();

builder.AddProject<Projects.ExampleProject>("api")
    .WithReference(mysql);

builder.Build().Run();

import { createBuilder } from "./.aspire/modules/aspire.mjs";

const builder = await createBuilder();

const mysql = await builder.addMySql("mysql");
await mysql.withAdminer();

const api = await builder.addProject("api", "../Api/Api.csproj");
await api.withReference(mysql);

await builder.build().run();

This adds a new Adminer resource to the AppHost which is available from the Aspire dashboard. Adminer is a lightweight database management tool that provides a simple web interface for database operations.

Using both management UIs

You can use both management UIs together on the same MySQL resource:

C#
TypeScript

var builder = DistributedApplication.CreateBuilder(args);

var mysql = builder.AddMySql("mysql")
    .WithDbGate()
    .WithAdminer();

builder.AddProject<Projects.ExampleProject>("api")
    .WithReference(mysql);

builder.Build().Run();

import { createBuilder } from "./.aspire/modules/aspire.mjs";

const builder = await createBuilder();

const mysql = await builder.addMySql("mysql");
await mysql.withDbGate();
await mysql.withAdminer();

const api = await builder.addProject("api", "../Api/Api.csproj");
await api.withReference(mysql);

await builder.build().run();