Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.
How Sphinx’s Multi-Valued Attributes Replaces the Need for an OR Comparison Operator
Sphinx documentation doesn’t give examples nor explain how to use SOURCE-TYPE ‘field’ with Multi-Valued Attributes (sql_attr_multi). After experimenting, I discovered that a simple comma delimited list of ids populated in the the referenced field of my record_sphinx_index table does the trick!
Facebook App-Scoped User IDs in API v2
My company’s website recently went through the Facebook API v1 to v2 upgrade. Besides having to upgrade the OS on all our web servers so we could upgrade PHP, and having to rewrite our implementation code, the only real undocumented issue was dealing app ID format changes.
Happy Holidays from Hello Techo – Fun with CSS
See this Pen on Codepen
View source code on wifeo/code
How To Create a Simple Gantt Chart with Google Sheets
Here’s a little trick to make a super-basic Gantt Chart / timeline graph using Google Sheets.