Professional Project NASA Footprints
The system search is slightly more advanced than a simple “match up a name” type of things. It’s somewhat customizable. Again, since the database is normalized and it requires several tables to make up a profile, the search needs to run through all of those tables.
It will parse the input, separate the words, build a join clause for all of the specified tables, build a conditional clause checking each word against each of the specified fields for each table, put the query together and execute it.
There are still a few performance-related things that could be improved upon, but for the sake of this demo it works quite well.
Copyright © 2009 Ryan Heath | Services | Resumé A Ruby on Rails production with strict XHTML and valid CSS.
This portfolio is a Formed Function. Formed Function LLC | @formedfunction
Working...