A community web log for monkey niches.

NOTES.txt 1006B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. Dependancies
  2. ------------
  3. apt-get install python-passlib python-webpy python-pip python-mysqldb
  4. pip install bleach
  5. mysql
  6. -----
  7. mysqladmin -u root -p create niche
  8. mysql -u root -p niche
  9. CREATE USER 'niche'@'localhost' IDENTIFIED BY 'whatever';
  10. GRANT ALL PRIVILEGES ON niche.* TO 'niche'@'localhost';
  11. mysql -u niche -p niche < schema.sql
  12. Sanitizing
  13. ----------
  14. bleach looks fine https://github.com/jsocol/bleach
  15. Performance
  16. -----------
  17. All with niche-dev running a local server.
  18. base: 1592 ms
  19. web.config.debug = False: 841 ms
  20. Pre-compiled templates: 848 ms
  21. Basic MySQL caching: ~366 ms
  22. cProfile doesn't do multiple threads.
  23. HTML templates: 366 ms
  24. Precompiled templates: 360 ms (no advantage)
  25. Baseline: 366 ms
  26. Basic caching: 228 ms
  27. Binary pickle: 221 ms
  28. Before launch
  29. -------------
  30. Error and access logging: DONE
  31. Check /static/ is served by nginx: DONE
  32. Check gzip effects: DONE
  33. Way of logging bytes transferred:
  34. error.log has no SQL in it: DONE
  35. memcached in monit: DONE
  36. monit emails sending: DONE