Update Django in Nitrous.io

Nitrous.io Django boxes doesn't have the latest version of Django. To upgrade it use the following command:

pip install Django --upgrade

SQLite3 in PHP

As you may probably know even the last version of PHP doesn't support SQLite3 but only version 2.

Allow javascript to load files from disk

By default Google Chrome doesn't allow to load local files with Javsacript. To get rid of this, just run chrome with --allow-file-access-from-files option flag.

chrome.exe --allow-file-access-from-files

Disable focus on tooltip with jQuery Ui

$(document).tooltip().off("focusin focusout");

Play and close wav file on Windows

C:\WINDOWS\system32\sndrec32.exe /play /close C:/path/sound.wav

Obtain create and last update time of MySQL table

This query brings you create and last update among other useful information.

SELECT *
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'databasename'
AND TABLE_NAME = 'tablename' ;

MySQL query logic

SELECT case
when c.boarding_number is not NULL then 'YES'
else 'NO'
end ;
It's syntactically correct.