Yesterday I came across Principles of Simplicity by Mads Kristensen. I think this is good write up and I enjoyed reading it. This are very generic and applies to all programming language and databases applications.
Principles of Simplicity by Mads Kristensen
1. Simplicity or not at all
Some developers tend to over-complicate a task and ends up writing too many classes to solve a simple problem.
2. Don’t build submarines
It’s a common fact that IT projects take longer than scheduled even if you schedule for delays.
3. Test when appropriate
Testing is one very important factor of the development cycle and there are many different tests to perform.
4. Be precise when naming methods
A method must have a name that tells exactly what it does.
5. Comment your code the simple way
Code commenting can be done in a myriad of ways, but there really is only one that keeps your code simple at the same time.
6. Steal borrow and simplify
We all use code pieces found on the Internet all the time.
7. It’s not a question of fewer code lines
Apparently it is a common misunderstanding that simplicity is a question of writing fewer lines of code.
8. Don’t be a rock star
Know your limitations and don’t be afraid to ask for help to solve a problem.
9. Learn much about much
To be able to find the simple solution to any problem, you need diversity.
10. Don’t trust your simplicity instinct
This might be the single most important rule of simplicity.
Simplicity is an implementation philosophy and it’s a very important one.
Reference : Pinal Dave (https://blog.sqlauthority.com)