search

vocdoni / vocdoni-node

A set of libraries and tools for the Vocdoni decentralized backend infrastructure, the main ground of our universally verifiable, privacy-centric and scalable digital voting protocol
GNU Affero General Public License v3.0
82 stars 16 forks source link

Store metadata title and description into the SQLite database #1318

Open p4u opened 4 weeks ago

p4u commented 4 weeks ago

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 commented 4 weeks ago

@mvdan do you think this search is possible?

mvdan commented 4 weeks ago

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 commented 4 weeks ago

cc/ @elboletaire @marcvelmer

p4u commented 4 weeks ago

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 commented 4 weeks ago

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.