basics, content, database, full, full-text, howto, implementation, index, indexing, MySQL, search, sql, Sqlite, textBasic approach
tokenize into words
case folding
stemming (convert each word into its root form; porter stemmer very popular stemmer for English
remove stop words
for each word left create posting list per word
Queries
OR queries do an intersection
AND queries do a union
Phrase Queries
Bad way: Do an [...]
php html2text html2txt convert html plaintext text Ready-made custom PHP function for performing boring task – converting fancy spicy html to bare hardcore plain text. Use with care. Can cause brain damage.
function html2text($html)
{
$tags = array (
0 => ‘~<h[123][^>]+>~si’,
1 => ‘~<h[456][^>]+>~si’,
[...]
web20 online-tools spreadsheet Google began accepting sign-ups to participate in a limited public beta test earlier this month (check Google labs for link). Basically it’s not Excel killer, there are no PivotTables, there’s no charting, and apart from sorting, you can’t do much with text. But there’s a lot more functionality than you might expect. [...]
refactoring software programming ReSharper In software engineering, the term refactoring means modifying source code without changing its external behavior, and is sometimes informally referred to as “cleaning it up”. In extreme programming and other agile methodologies refactoring is an integral part of the software development cycle: developers alternate between adding new tests and functionality and [...]