DeveloperGuidelines

---

Python debugging

• use Web2Py shell: ​http://www.vimeo.com/879939
• Debug Tools: ​http://docs.python.org/library/debug.html

CSS & Javascript debugging

• use Firebug: ​http://code.google.com/support/bin/answer.py?answer=77412&topic=12044
• ​http://pastebin.me (allows edits of HTML & previews)
• ​http://trac.openlayers.org/wiki/Documentation#BeforeGettingStarted--TheTechnologiesBehindOpenLayers

Web2Py

• ​https://mdp.cti.depaul.edu/web2py_wiki/default/wiki/tips
• ​https://mdp.cti.depaul.edu/web2py_wiki/default/wiki/widgets
• Arbitrary HTML tags using TAG, e.g. TAG.LEGEND('a','b',_c='d')
• New syntax for low-level database record create/update/delete: ​http://groups.google.com/group/web2py/browse_thread/thread/d79a6e52824d4221
• Edit multiple records at once: ​http://groups.google.com/group/web2py/browse_thread/thread/401b4c192871194c/a96cc8c7923a8565#
• THIS_NOT_IN_DB custom validator: ​http://groups.google.com/group/web2py/browse_thread/thread/27b14433976c0540?pli=1
• Custom Forms - less retyping of code in view using SQLFORM extensions: ​http://groups.google.com/group/web2py/browse_thread/thread/2d8cc57352d158bd
• Custom Forms - alternate approach: ​http://www.wellbehavedsystems.co.uk/web2py/examples/
• Custom Form Helper field2html(): ​http://groups.google.com/group/web2py/browse_thread/thread/1012c11c977aa05e
• HTML Helpers can be navigated/manipulated like the DOM: ​http://groups.google.com/group/web2py/browse_thread/thread/ac045f3b1d3846d9
• Lambda tricks: ​http://p-nand-q.com/python/stupid_lambda_tricks.html
• IS_IN_DB (...,order_by=...): ​http://groups.google.com/group/web2py/browse_thread/thread/5fe6e343d115590d/2a8c38fccb2cf3cf#2a8c38fccb2cf3cf
• Inline Images in T2 CRUD: ​http://groups.google.com/group/web2py/browse_thread/thread/d954bf883baf7adc/3b55a819b425a741
• Multi-column unique constraint: ​http://groups.google.com/group/web2py/browse_thread/thread/f5ab94cc7d511e0b
• Hierarchical References: ​http://groups.google.com/group/web2py/browse_thread/thread/a4f57635d4a05f83
• JSON datetime serialization: ​https://mdp.cti.depaul.edu/web2py_wiki/default/wiki/JSONdatetime
• EPB: ​http://groups.google.com/group/web2py/browse_thread/thread/c090560680b65db2
• Auto-complete (for when Dropdowns get too long):
  • ​http://groups.google.com/group/web2py/browse_thread/thread/e1034df0091b5bfd
  • ​http://groups.google.com/group/web2py/browse_thread/thread/f6e0170273b14241
  • ​http://www.pengoworks.com/workshop/jquery/autocomplete.htm
  • ​http://plugins.jquery.com/project/autocompletex
  • ​http://plugins.jquery.com/project/YA_AutoComplete

jQuery:

• ​http://www.tvidesign.co.uk/blog/improve-your-jquery-25-excellent-tips.aspx
• ​http://jqueryfordesigners.com/jquery-tabs/
• ​http://15daysofjquery.com/

Ext:

• ​http://extjs.com/learn/Tutorial:Introduction_to_Ext_2.0
• ​http://extjs.com/learn/Manual:Basic_Application_Design
• ​http://extjs.com/forum/showthread.php?t=26728
• ​http://extjs.com/learn/Ext_FAQ_Debugging

Bugmail add-on for Thunderbird:

• ​https://addons.mozilla.org/en-US/thunderbird/addon/9584

Especially useful for USB (minimise disk access)

• ​http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html

SQL design:

• ​http://www.sqlteam.com/article/database-design-and-modeling-fundamentals
• ​http://www.tomjewett.com/dbdesign/dbdesign.php?page=intro.html
• ​http://www.w3schools.com/Sql/sql_join.asp
• ​http://www.plus2net.com/sql_tutorial/sql_linking_table.php

---

DeveloperGuidelines