"Again, depending on the choice of the database-engine, MySQL can lack certain f... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

dkoch on March 20, 2014 | parent | context | favorite | on: SQLite vs MySQL vs PostgreSQL

"Again, depending on the choice of the database-engine, MySQL can lack certain features, such as the full-text search."

Both of the two biggest engines (MyISAM, InnoDB) support full-text search. It was added to InnoDB in MySQL 5.6/Maria 10.

McGlockenshire on March 20, 2014 | [–]

Given all of the odd default behavior and caveats in InnoDB FTS[1], I'd sooner just continue to use an external search solution, like ElasticSearch.

1: http://www.mysqlperformanceblog.com/2013/03/04/innodb-full-t...

copergi on March 20, 2014 | [–]

Innodb doesn't have fulltext search, it has "fulltext search*". Big difference.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact