Search

[loicknuchel]

Search is at the heart of Azimutt as there is no good schema exploration without a good table and column search.

The goal of the search is to help you find what you want, even if you don't exactly know what to look for.

As of today, the search is custom built around a few business rules that were relevant as a first iteration but now seem a bit odd. So we plan a full revamp of the search but for that we need your inputs about what is the importance of this (prioritization in a low resource side-project that have a lot to do ^^) and more importantly about your use cases and expectations.

For now, we plan to implement a weighted full text search, probably using flexsearch. For table we will look for table name, table comment, column names and column comments while for columns we will look for column name and column comment. We will see later for more customizations such as shown.

As comparison, the current search rank tables by match with your search query but also "popularity" (assuming a table with many columns or a short name are more important).

If you think the search evolution is important, please vote for this discussion and comment below to explain the problems with the current one and your expectations.