SQL for Smarties | SQL Programming Style | Trees and Hierarchies in SQL | SQL Puzzles and Answers | Data and Databases

Wednesday, May 31, 2006

Google API to make text search into database

SQL Apprentice Question
I'd like to know if it's possible to use Google APIs to make a text
search into DBs such Oracle or Sql Server.

Celko Answers
Do not use SQL for text and document searching; get a tool built for
this job. If you are doing this only once, then you can use whatever
your RDBMS product has for strings.

No comments: