PHP and SQLite FTS4: How to process the matchinfo function

Part I: Reading the binary output from the matchinfo() function The MATCHINFO() function returns a binary string which represents a variable number of 32-bit unsigned integers in machine byte-order. It can be read into an array of integers using the PHP unpack() function passing ‘L*’ as the format parameter .

SQLite FTS4: Standard vs Enhanced Query Syntax

The SQLite documentation talks about two ways to perform full text queries: standard or enhanced query syntax. Be aware: which one is available depends on how SQLite was compiled. You might, like me, run into troubles when developing locally using one syntax and then publishing remotely only to find out your query does not return […]