niche/NOTES.txt

Dependancies
------------
apt-get install python-passlib python-webpy python-pip python-mysqldb
pip install bleach

mysql
-----

mysqladmin -u root -p create niche

mysql -u root -p niche

CREATE USER 'niche'@'localhost' IDENTIFIED BY 'whatever';
GRANT ALL PRIVILEGES ON niche.* TO 'niche'@'localhost';

mysql -u niche -p niche < schema.sql

Sanitizing
----------
bleach looks fine https://github.com/jsocol/bleach

Performance
-----------
All with niche-dev running a local server.

base: 1592 ms
web.config.debug = False: 841 ms
Pre-compiled templates: 848 ms
Basic MySQL caching: ~366 ms

cProfile doesn't do multiple threads.

HTML templates: 366 ms
Precompiled templates: 360 ms (no advantage)

Baseline: 366 ms
Basic caching: 228 ms
Binary pickle: 221 ms

Before launch
-------------
Error and access logging: DONE
Check /static/ is served by nginx: DONE
Check gzip effects: DONE
Way of logging bytes transferred: 
error.log has no SQL in it: DONE
memcached in monit: DONE
monit emails sending: DONE