All geek questions in one place

MySQL full-text search in PHP

I plan to use full-text search to search a potentially large database that is constantly changing. I read in several sources that full-text search is usually not recommended for databases that are constantly changing. I am looking for the best mysql-built-mehod to search for this database. Would full-text search still be the recommended search method if I cannot implement an external search engine?

+4
source share
2 answers

I used the Lucene port when I had this problem. I don’t know if it is available outside of Symfony or Zend, but it worked like a charm using the sfLucene plugin. He solved all my text distortions. This site can help you: lucene tutorial

If you are looking for a MySQL replacement where you have full text search and relationship processing and are still compatible with MySQL, go and see MariaDB . It is integrated with Shpinx. You can read about the features here .

+1
source

Full text search depends on the designer. Meaning, if you create your database as a relational database, you lose the full-text search in the case of innodb. Myisam allows you to fully search for text, but you are losing the true relational database. I would suggest abandoning sql db and use another db if possible. A good suggestion is CouchDB. Obviously, you will have to have a virtual or dedicated server to install CouchDB or any other db, even if you ask your host if they can install it for you. In most cases, the host will not just install the software just for you. There are free CouchDB sites. http://www.iriscouch.com I also understand the work that will be involved in switching everything to use alternative db. However, these are developer use cases.

+1
source

Source: https://habr.com/ru/post/1385616/

More articles:


All Articles