niche/NOTES.txt

49 line
1006 B
Plaintext

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