61
Programming using the Ultra Hal Brain Editor / BRAINS / DATABASES how?
« on: February 08, 2005, 10:58:35 am »
spydaz,
Ah-Hah! You see our challenge. Adding a data base is just the first step. Now how to search it effectively, hmm? I'm not a data base expert (not yet anyway). However, standard query commands in data bases, like Access for instance, don't search for keywords or phrase matches in the way we would like them to. If you tinker with Access you won't find a command to do a fuzzy search for a phrase. The "LIKE" operator in Access will do a somewhat fuzzy text comparison, but it is not very flexible nor programmable. I believe you must write a custom search function to search the data base in the way needed. I suppose with thousands of programmers out there that someone has written many such custom functions already. A bit of research is needed to find the best approach.
=vonsmith=
Ah-Hah! You see our challenge. Adding a data base is just the first step. Now how to search it effectively, hmm? I'm not a data base expert (not yet anyway). However, standard query commands in data bases, like Access for instance, don't search for keywords or phrase matches in the way we would like them to. If you tinker with Access you won't find a command to do a fuzzy search for a phrase. The "LIKE" operator in Access will do a somewhat fuzzy text comparison, but it is not very flexible nor programmable. I believe you must write a custom search function to search the data base in the way needed. I suppose with thousands of programmers out there that someone has written many such custom functions already. A bit of research is needed to find the best approach.
=vonsmith=