23 August 2014

PHP convenience classes for MySQL and SQLite database access

A quick note that in addition to SQLBrite, a convenience class for SQLite3, ComfySQL, a PHP class for easy MySQL access is now also available on GitHub. They both support placeholders for values, automatic escaping for values and callbacks. Happy programming!

WordNet MySQL Table and Value Map

For anyone using WordNetSQL, the MySQL table version of the WordNet lexical database, I created the following map which I found quite useful when writing queries. Also, if you're new to the project, be aware that some "tables" are actually views, so any query on them will be quite slow.