Cosette: An Automated SQL Solver

cosette.cs.washington.edu

Cosette allows you to evaluate whether or not two SQL statements are functionally identical, in that they return exactly the same results in all possible cases. This is extraordinarily useful if you care about code readability and performance and find yourself doing a lot of SQL refactoring.

I personally think that even though SQL is 40 years old, it's still only beginning to be well-used within analytics. Tools like this get me really excited. I plan on using Cosette extensively.

Read more...
Linkedin

Want to receive more content like this in your inbox?