Skip to content
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.

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

Combine lexicon id and version in schema #234

Open
goodmami opened this issue Mar 17, 2025 · 0 comments
Open

Combine lexicon id and version in schema #234

goodmami opened this issue Mar 17, 2025 · 0 comments
Labels
schema The database schema has problems or lacks features
Milestone

Comments

@goodmami
Copy link
Owner

In trying to reduce stateful entities (see #226), I find myself replacing a lot of rowid conditions in SQL queries with id || ":" || version (since lexicons have a unique id + version pair in the database, it serves as a unique identifier). It occurs to me that it would be more efficient to just have the concatenated id:version ("lexicon specifier") as a single, indexed column in the database. With SQL globs we can find lexicons only by their id (id:*) or version (*:version), so there shouldn't be any loss of functionality.

This change would require databases to be rebuilt.

@goodmami goodmami added the schema The database schema has problems or lacks features label Mar 17, 2025
@goodmami goodmami added this to the v1.0 milestone Mar 18, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
schema The database schema has problems or lacks features
Projects
None yet
Development

No branches or pull requests

1 participant