49 rindas
1006 B
Plaintext
49 rindas
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
|