DeveloperGuidelines

---

Python debugging

• use Web2Py shell: ​http://www.vimeo.com/879939
• ​http://docs.python.org/library/doctest.html
• ​http://docs.python.org/library/bdb.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)

Web2Py

• Arbitrary HTML tags using TAG, e.g. TAG.LEGEND('a','b',_c='d')
• 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: ​http://www.wellbehavedsystems.co.uk/web2py/examples/
• 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://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

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