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

Add function to index observation text from existing observations saved in SQLite db #102

Open
JWCook opened this issue Nov 19, 2022 · 1 comment
Labels
db SQLite taxonomy + observation database

Comments

@JWCook
Copy link
Member

JWCook commented Nov 19, 2022

Currently this is done by calling index_observation_text() with Observation objects.

For cases where observations are already stored in SQLite, it would be faster to have an option to do this directly with SQL.

@JWCook JWCook added the db SQLite taxonomy + observation database label Nov 19, 2022
@JWCook JWCook modified the milestone: 0.6 Nov 19, 2022
@JWCook
Copy link
Member Author

JWCook commented Nov 19, 2022

Update: It seems that the current table format would require using the json_each() function to accomplish this, which requires SQLite 3.38+. So options for this would be:

  1. Use separate tables instead of denormalized JSON fields for observation identifications, comments, OFVs, annotations, and tags.
  2. Require manually installing SQLite (or for naturtag, package SQLite binaries with it)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
db SQLite taxonomy + observation database
Projects
None yet
Development

No branches or pull requests

1 participant