March 23, 2021
After many months of working to create a nice search algorithm, including experience from working on another website of mine, BestInternetSearch I, Stan Switaj, can say that Python and SQL
make a nice combination to produce a concise SQL statement that is both fast and easy to maintain.
UltraHot.TV runs two SQL statements at this time, one searches any number of search terms against the video name database field.
The nice thing about this statement is that it factors the singular, plural, with (‘s’, ‘es’, ‘ies’) endings,
and (‘er’, ‘est’) endings, and also the (‘en’) ending by adding, and even removing it
from each term of any number of search terms of a search string delimited by spaces input by a person searching.
The other SQL statement that runs in addition to the first SQL statement searches against the categories of a video, and it too factors singular, plural with adding and removing the (‘s’, ‘es’, ‘ies’) from a search term.