Changes between Version 104 and Version 105 of DeveloperGuidelines/Tips

Timestamp:

07/21/10 09:21:53 (15 years ago)

Author:

Fran Boon

Comment:

--

DeveloperGuidelines/Tips

@@ -1 +1 @@
 DeveloperGuidelines
-
 ----
-==== Python debugging ====
+== Python debugging ==
  * WSGI likes print statements to go to {{{sys.stderr}}} not {{{sys.stdout}}}: http://code.google.com/p/modwsgi/wiki/DebuggingTechniques
  * use Web2Py shell: http://www.vimeo.com/879939
@@ -17 +16 @@
   * Using with Web2Py: http://www.wingware.com/doc/howtos/web2py
  * [DeveloperGuidelinesEclipse Eclipse] IDE
-==== CSS & Javascript debugging ====
+
+=== Reserved Keywords ===
+ * 'request' -> web2py internal use
+ * 'key' as a db row name -> MySQL confuses it with internal keyword KEY
+ * http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-0.html
+ * http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html
+
+== CSS & Javascript debugging ==
  * use Firebug: http://code.google.com/support/bin/answer.py?answer=77412&topic=12044
  * use Venkman: http://www.mozilla.org/projects/venkman/
  * http://pastebin.me (allows edits of HTML & previews)
  * IE6 cheatsheet: http://www.virtuosimedia.com/tutorials/ultimate-ie6-cheatsheet-how-to-fix-25-internet-explorer-6-bugs
-==== Web2Py ====
+
+== Web2Py ==
  * http://web2py.com/examples/default/docs
  * Prevent HTML tags being escaped in views: {{{{{=XML("<p>Not escaped!</p>")}}}}}
@@ -92 +99 @@
  * Use the StatusBar for dynamic status updates
  * http://code.google.com/p/web2pyorm/
-==== !JavaScript ====
+
+== !JavaScript ==
  * http://trac.openlayers.org/wiki/Documentation#BeforeGettingStarted--TheTechnologiesBehindOpenLayers
  * http://eloquentjavascript.net
@@ -101 +109 @@
   * JS: {{{var RE_JSVAR = new RegExp("\W", "g"); var variable_name = string.replace(RE_JSVAR, '_');}}}
  * Loop timings: http://blogs.sun.com/greimer/entry/best_way_to_code_a
-===== jQuery =====
+
+=== jQuery ===
  * http://www.tvidesign.co.uk/blog/improve-your-jquery-25-excellent-tips.aspx
  * http://james.padolsey.com/javascript/things-you-may-not-know-about-jquery/
@@ -111 +120 @@
  * Web2Py HTML Helper: http://groups.google.com/group/web2py/browse_thread/thread/ec63ee9af3ee659f
  * jqGrid in Web2Py: http://groups.google.com/group/web2py/browse_thread/thread/2caa0e4e0161bb8d
-===== Ext =====
+
+=== Ext ===
  * http://extjs.com/learn/Tutorial:Introduction_to_Ext_2.0
  * http://extjs.com/learn/Manual:Basic_Application_Design
@@ -120 +130 @@
   * http://blog.extjs.eu/know-how/mastering-ext-direct-part-1/
 
-==== HTML/CSS ====
+== HTML/CSS ==
  * http://enhance.qd-creative.co.uk/2008/06/28/the-misunderstood-div/
  * http://enhance.qd-creative.co.uk/2008/10/14/7-things-you-can-do-so-your-users-wont-leave/
@@ -132 +142 @@
   * http://webtips.dan.info/graceful.html
 
-==== SQL ====
+== SQL ==
 Basics of Design:
  * http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/
@@ -157 +167 @@
  * Especially useful for USB (minimise disk access): http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html
 
-==== XSLT ====
+== XSLT ==
  * XPath: http://www.w3schools.com/xpath/default.asp
  * XSLT: http://www.w3schools.com/xsl/default.asp
 
-==== GIS ====
+== GIS ==
  * http://linfiniti.com/dla/ (includes videos, etc)
  * http://desktopgisbook.com/
@@ -174 +184 @@
 Print
  * http://www.amazon.com/Primer-GIS-Fundamental-Geographic-Cartographic/dp/1593855656
-==== Misc ====
+
+== Misc ==
  * Bugmail add-on for Thunderbird: https://addons.mozilla.org/en-US/thunderbird/addon/9584
 
 ----
-
 DeveloperGuidelines