Add search functionality (globally and per-model (generic)) about nmsprime HOT 2 CLOSED

AFAIS this can be done in three ways:

1. Simple SQL queries: „SELECT * FROM * WHERE a LIKE…“
2. Using FULLTEXT indexes of MariaDB
   • This means for our version that database engine have to be MyISAM (instead of the currently used InnoDB). Then MariaDB makes all the work. There are some amazing features – be sure to check https://mariadb.com/kb/en/mariadb/fulltext-index-overview. Using this in Laravel should be straight forward – read http://creative-punch.net/2013/12/implementing-laravel-4-full-text-search.
   • IMHO this is the way we should go…
3. Use an external search engine like elasticsearch, solr, etc
   • This is the fastest option with very interesting features like facets – and it is highly scalable as you can outsource that engine in a cloud. Check http://www.fullstackstanley.com/read/simple-search-with-laravel-and-elasticsearch
   • But: man has to install that engine, configure it and implement the bindings to laravel – much more to do compared to variant 2)
   • We should remember this if our system has to manage 10 million customers

by @xee8ai

from nmsprime.

There are some problems with using the fulltext index for searching:

• no left truncation
• MAC and IP addresses are (default) not part of the index

So in the first step we implemented simple search (first option above) which is ATM fast enough. Complexity is O( n ) – this should be fast enough for the next time…

from nmsprime.