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

Store metadata title and description into the SQLite database #1318

Open
p4u opened this issue May 30, 2024 · 5 comments
Open

Store metadata title and description into the SQLite database #1318

p4u opened this issue May 30, 2024 · 5 comments
Assignees

Comments

@p4u
Copy link
Member

p4u commented May 30, 2024

When a process is created, once the JSON metadata is fetch by the offchaindatahandler, store title and description of the process into the SQL database.

Then provide two new queries to search by terms on description and process and return the processess.

@p4u
Copy link
Member Author

p4u commented May 30, 2024

@mvdan do you think this search is possible?

@mvdan
Copy link
Contributor

mvdan commented May 30, 2024

what do you mean by "search by terms"? we could either do substring searches or "full text search" as described in https://www.sqlite.org/fts5.html.

@p4u
Copy link
Member Author

p4u commented May 30, 2024

cc/ @elboletaire @marcvelmer

@p4u
Copy link
Member Author

p4u commented May 30, 2024

what do you mean by "search by terms"? we could either do substring searches or "full text search" as described in https://www.sqlite.org/fts5.html.

This might do the job, yes.

@elboletaire
Copy link
Member

I think vocdoni/interoperability#188 should be addressed first, since we may be storing information but won't be able to retrieve it since we don't have a way to properly filter and paginate results.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants