Skip to content

[D1] Add changelog for exporting databases with virtual tables - #34586

Closed
ivoryibu wants to merge 1 commit into
productionfrom
d1-export-virtual-tables
Closed

ivoryibu wants to merge 1 commit into
productionfrom
d1-export-virtual-tables

Conversation

@ivoryibu

Copy link
Copy Markdown
Collaborator

Summary

Adds a D1 changelog entry for exporting databases that contain virtual tables (FTS5 full-text search tables, R*Tree spatial index tables). Databases containing virtual tables previously could not be exported at all.

  • Export uses the D1 export API with dump_options.compatibility set to sqlite3_cli_only, producing a dump compatible with the SQLite CLI.
  • The entry documents that this dump cannot be imported back into D1; the standard export remains for databases without virtual tables.
  • Dated 2026-10-28 so the entry publishes on that date, leaving time for last-minute changes before it goes live.

Follow-ups to complete before the publish date:

  • Add the exact flag name for wrangler d1 export. The option is not yet shipped in a published wrangler release, so the entry currently says the option is available on wrangler d1 export and in the Cloudflare CLI without naming the flag.
  • Confirm the "Cloudflare CLI" wording and its flag name.
  • The entry links to a new section of the import/export docs page (/d1/best-practices/import-export-data/#export-a-d1-database-with-virtual-tables) that is being added in a separate docs PR — the two should land together.

Documentation checklist

@github-actions github-actions Bot added product:d1 D1: https://developers.cloudflare.com/d1/ product:changelog labels Oct 24, 2026
@cloudflare-workers-and-pages

Copy link
Copy Markdown

🚀 Deploying Preview to Cloudflare 🚀

Preview URL: https://d1-export-virtual-tables.previews.developers.cloudflare.com (commit db2d49b)

This URL reflects your latest Preview deployment

Preview Deployments by commit

Status Deployment URL Commit Updated (UTC) See this deployment's details
  • Build: Success ✅
  • Deployment: Success ✅

View logs ↗
https://68597a27.previews.developers.cloudflare.com db2d49b 2026-10-24T01:40:24.958Z Visit the dashboard ↗

@cloudflare-docs-bot

Copy link
Copy Markdown
Contributor

@ivoryibu This draft pull request has had no activity for 3 days. It will close after 7 days of inactivity. Transition to ready for review if ready. A codeowner can comment /draft-never-stale to keep it open.

@cloudflare-docs-bot

Copy link
Copy Markdown
Contributor

@ivoryibu Closing this draft pull request after 7 days of inactivity. Re-open at a later date and transition to ready for review when you are ready if you seek review.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

product:changelog product:d1 D1: https://developers.cloudflare.com/d1/ size/s

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant