-
-
Notifications
You must be signed in to change notification settings - Fork 303
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
FTS5 Options: Unindexed columns, prefix indexes, tokenizers & content #1277
Comments
hey Trevor. I'll start implementing this soon. Thanks |
PR is on its way #1279 |
@trevornagy please check |
@fnc12 Just tested with the unindexed PR commit on dev, getting the following errors:
|
@trevornagy |
Sorry! You're correct, I copied the incorrect commit id. It works as expected. |
Thank you very much for your quick work by the way! |
PR with |
@trevornagy please check new |
@fnc12 Looked at the API and it looks like you create the prefix inside a make_column? This seems strange to me as each prefix doesn't apply to a column but rather the whole table? https://www.sqlite.org/fts5.html#prefix_indexes The test in Note the Maybe I'm misinterpreting the example/test though? |
@trevornagy thanks for pointing out. This is my misunderstanding. I'll refactor it soon as a table constraint not column constraint |
PR is here #1284 |
@trevornagy prefix fix is merged |
Awesome, works as expected now. Thank you! |
@trevornagy this is good! Only |
Content was originally requested as well as tokenizer, but yes, amazing work. Really appreciated |
@trevornagy sorry I forgot to mention content. Just my negligence, of course content will be implemented within this issue ASAP |
@trevornagy I got a question: how are you going to use |
Sure, here's an example of tokenize: |
PR #1292 |
@trevornagy please check |
PR with |
@trevornagy please check |
@trevornagy do you also need |
Will test soon, sorry. As for the others, let me verify works with what we currently have and I'll get back to you! Thanks for all the work so far |
Hey @fnc12, my apologies for the delayed response. I think I'll need What I'm trying to accomplish is documented here: https://www.sqlite.org/fts5.html#external_content_tables The example in sqlite would look something like:
What's missing is being able to specify the external content Once again, sorry for the delayed response! |
@trevornagy table content is on its way #1304 |
hey @trevornagy . Please check out |
Perfect, thank you very much! That is all of the features! I really appreciate this! |
Opening this for visibility, feel free to close if you want this discussion in: #622
Does the implementation FTS5 support unindexed columns, prefix indexes and tokenizers? https://www.sqlite.org/fts5.html#the_unindexed_column_option
What about the content option? https://www.sqlite.org/fts5.html#external_content_and_contentless_tables These are all important features for me, can't see any examples or tests in the fts5 feature branch using them
Thanks!
The text was updated successfully, but these errors were encountered: