masamune_model_tidb 3.2.0

Masamune plugin package that includes a model adapter to retrieve data from TiDB.

Masamune Model TiDB

---

[GitHub] | [YouTube] | [Packages] | [X] | [LinkedIn] | [mathru.net]

---

Plug-in packages that add functionality to the Masamune Framework.

For more information about Masamune Framework, please click here.

https://pub.dev/packages/masamune

Usage

Use TidbModelAdapter with @mathrunet/masamune_cloudflare_tidb Workers.

final adapter = TidbModelAdapter();

Model paths use the same layout as Turso.

database/<database>/<table>/<document_id>

The adapter sends all reads and writes to the Workers CRUD endpoint. It does not open direct MySQL/TiDB TCP connections from Flutter clients.

Katana CLI

Enable TiDB in katana.yaml and run katana apply.

cloudflare:
  tidb:
    enable: true
    connection_url: mysql://user:[e-mail]:4000/app_db

Katana CLI stores the TiDB connection URL in Cloudflare Workers secrets with wrangler secret put.

TiDB Cloud Starter and Essential clusters require a username prefix. For example, if the TiDB Cloud connection dialog shows 4M9hEa4vE3S7jAF.root, the prefix is 4M9hEa4vE3S7jAF. Use the prefixed username in connection_url:

mysql://4M9hEa4vE3S7jAF.root:<PASSWORD>@gateway01.ap-northeast-1.prod.aws.tidbcloud.com:4000/app_db

The root password in connection_url is used only by the Workers backend and is not returned to the Flutter client.

TiDB databases are not created automatically. Create the database in TiDB Cloud before using it. Tables and missing columns are created automatically on save.

GitHub Sponsors

Sponsors are always welcome. Thank you for your support!

https://github.com/sponsors/mathrunet