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
 * Custom Forms - multiple per page: http://groups.google.com/group/web2py/browse_thread/thread/57e452d186d48fa4
 * 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/
 * http://devsnippets.com/reviews/using-jquery-to-style-design-elements-20-impressive-plugins.html
 * Web2Py HTML Helper: http://groups.google.com/group/web2py/browse_thread/thread/ec63ee9af3ee659f

==== 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

==== Misc ====
 * 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