Tech Tips - Revision history

Kemiko at 17:59, 15 October 2017

2017-10-15T17:59:57Z

2017-10-15T17:58:16Z

2017-10-15T17:35:13Z

2017-08-26T04:03:05Z

2017-08-26T04:01:28Z

2017-06-11T05:18:08Z

2017-02-19T02:18:52Z

2017-02-13T07:14:29Z

2017-02-11T05:55:29Z

2016-11-26T06:30:39Z

@@ Line 162: / Line 162: @@
 <ul>
   <li>
-   In general use a where clause even if selecting everything..."where 1" or "where 1 = 1".  This reminds someone editing the code that this query is operating on EVERYTHING.  Remove the where clause can sometimees greatly optimize code.  Make a comment to note this.
+   In general use a where clause even if selecting everything..."where 1" or "where 1 = 1".  This reminds someone editing the code that this query is operating on EVERYTHING.  Remove the where clause can sometimes greatly optimize code.  Make a comment to note there is NO where clause.
   </li>
   <li>

@@ Line 41: / Line 41: @@
      </li>
      <li>
-      Good paring words: staring/finished, source/target, etc.
+      Good pairing words: staring/finished, source/target, etc.
      </li>
     </ul>
    </li>
   </ul>

@@ Line 41: / Line 41: @@
      </li>
      <li>
-      Good log terminators: staring/finished, etc.
+      Good paring words: staring/finished, source/target, etc.
      </li>
     </ul>

@@ Line 39: / Line 39: @@
      <li>
       tail -f error logs when developing
      </li>
     </ul>

@@ Line 79: / Line 79: @@
     </li>
     <li>
-     Always add comments...you may not remember what you did day, months, years from now
+     Always add comments...you may not remember what you did days, months, years from now
     </li>
     <li>
-     Line up block brackets up vertically
+     Line block brackets up vertically
     </li>
     <li>
@@ Line 130: / Line 130: @@
     <ul>
      <li>
-      Put number in 09 format to make easier to read, parse and sort
+      Put number in 09 format to make easier to read, parse and sort (multiple spaces are fine)
      </li>
      <li>

@@ Line 148: / Line 148: @@
    <li>
     Comments are handy even in SQL for debugging and as comments.  "--comments" is universal, but also /* comments */ in MySQL, {comments} in Informix, etc.
    </li>
   <ul>

@@ Line 11: / Line 11: @@
   <ul>
    <li>
-    Know the animal before trying to tame
+    Know the animal before trying to tame.
    </li>
    <li>
-    Some vendors use MB/GB (decimal...1000s) and some use MiB/GiB (binary...1024s)
+    Some vendors use MB/GB (decimal...in goups of 1000) and some use MiB/GiB (binary...in groups of 1024).
    </li>
    <li>
-    Always query before running modification command(s)
+    Always query before running modification command(s) whether using the OS, database or apps.
    </li>
    <li>
-    Backup or already have a backup before modifying files
+    Backup or already have a backup before modifying files, database, apps.
    </li>
    <li>
@@ Line 26: / Line 26: @@
    </li>
    <li>
-    Always tail -f error logs when developing
+   Learn all available debugging tool...it can save a ton of time
    </li>
   </ul>

@@ Line 62: / Line 62: @@
    <ul>
     <li>
-     Top-down and bottom-up design
+     Top-down vs bottom-up design
     </li>
     <li>
-     Always add comments
+     Always add comments...you may not remember what you did day, months, years from now
     </li>
     <li>
-     Line block brackets up vertically
+     Line up block brackets up vertically
     </li>
     <li>
@@ Line 77: / Line 77: @@
     </li>
     <li>
-     Pick a style and stay consistent
+     Pick a style and stay consistent...this sometime means following someone else's style when modifying existing code
     </li>
     <li>
@@ Line 83: / Line 83: @@
     </li>
     <li>
-     Give some thought to designing your log files.
+     Give some thought to designing your log files...
      <ul>
       <li>

@@ Line 51: / Line 51: @@
     </li>
     <li>
-     Name using noun first then verb.  ex: logCreate, logList, etc.
+     Name using noun first then verb.  ex: logCreate, logList, dateStart, dateEnd, etc.
     </li>
    </ul>