Along with the general phasing out of MyISAM, InnoDB full-text search (FTS) is finally available in MySQL 5.6.4 release. Lots of juicy details at https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html. While other engines have lots of different features, this one is InnoDB, so it’s native (which means there’s an upgrade path), and that makes it a worthwhile option.
Faceted search is well-explained here and Lucene faceted through an example. EXAMPLE:
Most Basic Answer I’m using the plain sql below so that everything is as clear and readable as possible. In your project you can use the Android convenience methods. The db object used below is an instance of SQLiteDatabase. Create FTS Table db.execSQL(“CREATE VIRTUAL TABLE fts_table USING fts3 ( col_1, col_2, text_column )”); This could … Read more
Make sure you have full-text search feature installed. Create full-text search catalog (if needed) First check if any catalog already exists select * from sys.fulltext_catalogs If no catalog is found create one use [DatabaseName] create fulltext catalog FullTextCatalog as default you can verify that the catalog was created in the same way as above Create … Read more
I think you are talking about ctrl + shift + F, by default it should be on “look in: entire solution” and there you go.
git svn clone <svn url> git log -G<some regex>
In general, there is a tradeoff between “precision” and “recall”. High precision means that fewer irrelevant results are presented (no false positives), while high recall means that fewer relevant results are missing (no false negatives). Using the LIKE operator gives you 100% precision with no concessions for recall. A full text search facility gives you … Read more
I’m a fan of the Find-In-Files dialog in Notepad++. Bonus: It’s free.
I’ve been using Solr successfully for almost 2 years now, and have never used Sphinx, so I’m obviously biased. However, I’ll try to keep it objective by quoting the docs or other people. I’ll also take patches to my answer 🙂 Similarities: Both Solr and Sphinx satisfy all of your requirements. They’re fast and designed … Read more
Edit (April 2015): As many have noticed, my old blog is now defunct. Most of my articles were transferred over to the Elastic blog, and can be found by filtering on my name: https://www.elastic.co/blog/author/zachary-tong To be perfectly honest, the best source of beginner knowledge is now Elasticsearch – The Definitive Guide written by myself and … Read more