search

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.ophir.dev
MIT License
883 stars 64 forks source link

search component #331

Closed amrutadotorg closed 1 month ago

amrutadotorg commented 1 month ago

Hi,

I would like to build a page with a lot of text, and I was wondering how to implement a search engine. Is it possible?

Thank you.

lovasoa commented 1 month ago

Hello ! A search engine is definitely possible ! You can then use the form component (https://sql.ophir.dev/documentation.sql?component=form#component) to display the search input field. Then, you should store your full-text documents in your database, and use your database's full-text search capabilities: Sure! Here is a list of documentation links for full-text search in various databases:

  1. SQLite: - SQLite FTS5 Full-Text Search
  2. PostgreSQL: - PostgreSQL Full-Text Search
  3. MySQL: - MySQL Full-Text Search Functions
  4. MS SQL Server: - SQL Server Full-Text Search
amrutadotorg commented 1 month ago

Thank you so much. I will try that. Os it also possible to refine the search via facets and filters?

lovasoa commented 1 month ago

Yes it is! You can use the form component for that too.

amrutadotorg commented 1 month ago

That's awesome! If I encounter any issues, I will use the discussion page.