App::AltSQL - CPAN Pull Request Challenge, May 2017
Welcome to our fourth post in our series of monthly posts about our development team’s extra-curricular involvement in the CPAN Pull Request Challenge.
This month we tackled: App::AltSQL.
App::AltSQL is an alternative command line client to SQL databases, it can be used as a replacement for connecting to mysql like so:
mysql -h <host> -u <username> -D <database> -p<password>
altsql -h <host> -u <username> -D <database> -p<password>
Rather than the ASCII art interface you are used to, you get a nicer output as per the screenshot above. It also allows via the same client access to mysql, sqlite3, sql and infact any database that has a Perl DBI driver. This month we has some of our team start using the module on their development PCs before the challenge evening and finding the module was helpful in their day to day work. So being assigned this module has been a great find of a new dev tool we can use day to day.
As some of the team had started using the module before the challenge we walked into this one with a new feature idea, and we were able to implement it and make a pull request with relative speed and ease. This month some of the participants who are not in the Perl development team worked with the Perl developers and achieved the goal of making a pull request.
Along with a new feature we were able to imporove the testing code around the module. Both fixing some tests that had some problems and also extending the functionality and flexibility of the tests also. We resolved some small behavioral issues in some edge cases as well.
The author Eric Waters, was really communicative and enthusiastic towards our efforts which was great and helped make this one of the most energetic evenings we have had this year… alternatively it could have been the radical decision to have Chinese food rather than Pizza!
See you next month!