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
 * http://mg.pov.lt/profilehooks/

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/
 * Delete uploaded files associated with records: http://groups.google.com/group/web2py/browse_thread/thread/50b1da465eee88e8
 * 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