← 一覧へ

Export D1 databases with virtual tables

changelog / Storage / D1 / 2026/11/12 09:00 JST

要約

仮想テーブル (FTS5の全文検索やR*Treeの空間インデックスなど) を含むD1データベースをエクスポート可能に。エクスポートAPIで dump_options.compatibility に sqlite3_cli_only を指定する。

You can now export a D1 database that contains virtual tables, such as full-text search tables using SQLite’s FTS5 module ↗︎ or spatial index tables using the R*Tree module. Previously, export failed for any database containing virtual tables. To include virtual tables in the dump, set dump_options.compatibility to sqlite3_cli_only on the D1 export API . The same option is available as the —compatibility flag on wrangler d1 export . Import is not supported This dump targets the SQLite CLI only. You cannot import it back into D1. Use the standard export for databases without virtual tables. cu

出典: 公式ページ