Hacktivity report (Jan-Mar 2013)
SHARYANTO::SQL::Schema and Postgres. Most of February was spent on coding for $work, related to processing SpamExperts report emails. During this period I became fed up with two of SQLite's main drawbacks: very limited ALTER TABLE functionality and its poor concurrency. I decided to ditch it altogether and migrated to the rich data type world of Postgres. It's a breath of fresh air, even when compared to MySQL, mainly as I can do proper date arithmetics and have true boolean type. SHARYANTO::SQL::Schema got written during this time (while I hope to use something like Sqitch someday, what I needed was something quick and simple, where everything is included in a single script, and no fancy features yet like per-branch/per-feature SQL sets). Postgres' transactional DDL really helps when doing schema upgrades, which can fail in the middle due to typos in SQL commands. Now I can freely and frequently evolve database schema without pain.
Text::ANSI::Util. The other thing that distracts me is Text::ANSI::Util which will be required by my upcoming Text::ANSITable (previously Text::PrettyTable) to replace the venerable Text::ASCIITable due to the desire to look prettier on the terminal.
Others. Some other modules that got some love during this period: dux, Perinci::Access::HTTP::Server. Some other new modules that got created during this period: App::ListPrereqs, App::smtpstatus, SyntaxHighlight::Any, Carp::Always::SyntaxHighlightSource, App::cal::id.