ClearSQL

What do you like best?

Easy to update existing packages from source and compare how changes affected the analysis. Overall it's a required tool to simplify and make sure the team all has a common practice for code reviews.

What do you dislike?

too much content on the flowcharts, need a way to simplify this.

Needs an easier interface to code review straight from the database.

Needs autofix.

Recommendations to others considering the product:

The team uses the tool during code reviews, but an API to oracle sql developer even your own tool (SD) would be better. If i owned both SD and CS, would be nice to have all the functionality in SD. There is a limited version in SD. To convert my team to SD, we need to also have a better tool there. For our code review sessions, it would be nice to have a code review session area where we can have an assigned person to acknowledge the changes.

What problems are you solving with the product? What benefits have you realized?

It gives the team a common tool and way to see if their code passes reviews prior to meetings.