Skip to content

Support for temporary virtual tables #1731

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Merged
merged 1 commit into from
Feb 23, 2025
Merged

Support for temporary virtual tables #1731

merged 1 commit into from
Feb 23, 2025

Conversation

groue
Copy link
Owner

@groue groue commented Feb 23, 2025 •
edited
Loading

This pull request fixes #1724 by allowing the creation of temporary virtual tables:

try database.create(virtualTable: "ft", options: .temporary, using: FTS5()) { t in
  ...
}

Note that temporary external-content FTS4 and FTS5 tables are not supported, and trigger a fatal error:

// fatal error: Temporary external content FTS5 tables are not supported.
try database.create(virtualTable: "documents_ft", options: .temporary, using: FTS5()) { t in
  t.synchronize(withTable: "documents")
  t.column("content")
}

This limitation comes from SQLite itself, which can't rebuild temporary indexes:

CREATE TABLE t(id INTEGER PRIMARY KEY, a, b, c);
CREATE VIRTUAL TABLE temp.ft USING fts4(content="t", b, c);
INSERT INTO ft(ft) VALUES('rebuild'); -- SQL logic error

@groue groue merged commit 9b09c53 into development Feb 23, 2025
8 checks passed
@groue groue deleted the dev/virtual-table-options branch February 23, 2025 12:59
@groue groue mentioned this pull request Feb 23, 2025
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
1 participant
@groue