-Be literate in your programming. -Use ad_proc, ad_library, and ad_page_contract to provide -documentation for your code, use comments on your datamodel, -explain what things mean and how they should work.
-Test. Write test cases for your -API and data model; test negative cases as well as positive; -document your tests. Provide tests for bugs which are not yet -fixed. Test, Test, Test.
-Use namespaces. For new packages -choose a namespace and place all procedures in it and in oracle -create packages.
+Be literate in your programming. Use +ad_proc, ad_library, and ad_page_contract to provide documentation +for your code, use comments on your datamodel, explain what things +mean and how they should work.
+Test. Write test cases for your API and +data model; test negative cases as well as positive; document your +tests. Provide tests for bugs which are not yet fixed. Test, Test, +Test.
+Use namespaces. For new packages choose a +namespace and place all procedures in it and in oracle create +packages.
Follow the constraint naming and the PL/SQL and PL/pgSQL rules. Naming constraints is important for upgradability and for consistency. Also, named constraints can be immensely helpful in developing good error handling. Following the PL/SQL and PL/pgSQL rules ensure that the procedures created can be handled similarly across both Oracle and PostgreSQL databases.
-Follow the code formatting -guidelines. The code base is very large and -if things are formatted consistently it is easier to read. Also, if -it conforms to the standard it won't be reformatted (which can -mask the change history and making tracking down bugs much harder). -Using spaces rather than tabs makes patches easier to read and -manage and does not force other programmers to decipher what tab -settings you had in place in your editor.
-Use the standard APIs. Don't -reinvent the wheel. Prefer extending an existing core API to -creating your own. If something in the core does not meet your -particular needs it probably won't meet others as well and -fleshing out the core API's makes the toolkit more useful for -everyone and more easily extended.
+Follow the code formatting guidelines. +The code base is very large and if things are formatted +consistently it is easier to read. Also, if it conforms to the +standard it won't be reformatted (which can mask the change +history and making tracking down bugs much harder). Using spaces +rather than tabs makes patches easier to read and manage and does +not force other programmers to decipher what tab settings you had +in place in your editor.
+Use the standard APIs. Don't reinvent +the wheel. Prefer extending an existing core API to creating your +own. If something in the core does not meet your particular needs +it probably won't meet others as well and fleshing out the core +API's makes the toolkit more useful for everyone and more +easily extended.
Make sure your datamodel create/drop scripts
work. Break the table creation out from the
package/stored procedure creation and use create or replace where possible so that
scripts can be sourced more than once. Make sure your drop script
works if data has been inserted (and permissioned and notifications
have been attached etc).
-Practice CVS/Bug Tracker Hygiene. -Commit your work. commit with sensible messages and include patch -and bug numbers in your commit messages.
Create bug tracker tickets for things you are going to work on +Practice CVS/Bug Tracker Hygiene. Commit +your work. commit with sensible messages and include patch and bug +numbers in your commit messages.
Create bug tracker tickets for things you are going to work on yourself (just in case you don't get to it and to act as a pointer for others who might encounter the same problem).
-Solicit code reviews. Ask others -to look over your code and provide feedback and do the same for -others.