Finding a Perl Module Version

perl -MYourModule 999
perl -MYourModule -e 'print "$YourModule::VERSIONn"'

For example,

perl -MNet::SSLeay 999
perl -MNet::SSLeay -e 'print "$Net::SSLeay::VERSIONn"'

Note

• In first command, no space between and module name.
• In second command, use $ before module name.

Update all CPAN module to latest versions

Quick answer by command line

cpan-outdated -p | cpanm
# if you have not installed cpan-outdated
cpanm App::cpanoutdated

# or, you have not even installed cpanmin.us
curl -L http://cpanmin.us | perl - App::cpanminus

More in details.

Perhaps, you would like to turn off confirmation.

MySQL

Tips & Tricks: Simple and basic

• How to import text file to table with primary key as auto-increment (here)
• Delete all records from a table. (here)
• Add a column to a table
• Replace a column of data with another column from another table. If you have this error: MySQL error code: 1175 during UPDATE in MySQL Workbench, see here.
• Output MySQL query results in CSV or Tab format
• Export scheme with and without data
• Import and export individual tables
• How to get the size of mysql database?
• How to get the sizes of the tables of a mysql database?
• Unique values from a column
• Backup by mysqldump
• Shutdown. I start server from system pref panel, but fail to stop it there or mysqld. Finally, I stopped it by mysqladmin.
• What is dsn?
• How to do a begin-with query?
• Why a table is read-only in MySQL workbench? One possibility is no primary key. See here.
• Storing protein sequence.

More Tips & Tricks

• Load data infile – acceleration (link)
• When to use Views
• 20 best practices

Tools

• MySQL workbench (manual)
• MySQL monitor (command line)

Digests

• 20 design tips for MySQL enterprise architects

References

• MySQL reference manual
• [Book] Murach’s MySQL

JavaScript Medley

I meet good JavaScript libraries, frameworks, and related tools from time to time, but never get a chance to look into or write down my experiences with them. So, I put such tools here for future use.  I also put some good articles about JavaScript here.

Framework

• Ember.js

Template engine

• jsHTML (intro)
• Hogan.js: a mustache compiler
• EJS (embedded JavaScript): it uses client side templates.
• Stylus: it is not a template engine, actually, it is expressive, robust, feature-rich CSS language built for Node.js. (Github)
• LESS: dynamics stylesheet language
• Sass.js: Sass JavaScript Implementation for node.js and other CommonJS based frameworks. Sass is an extension of CSS3.
• Handlebars.js: compatible with Mustache
• Jade: node template engine
• Use HAML in JavaScript. HAML file can be generated by Mustache and then be compiled into HTML.

Visualization

• Chart.js: Easy, object oriented client side graphs for designers and developers
• dygraphs: a fast, flexible open source JavaScript charting library
• xChart (d3 based): bar chart, time-series line, with interactive feature
• C3.js (d3 based): bar chart, spline chart
• dimple (d3 based, recommended): bar, scatter, bubble, line, area charts
• Rickshaw (d3 based, recommended): many
• NVD3 (d3 based, recommended): many
• jsPhylogSVG: plot tree in SVG format. It takes different tree formats such as newick and phyloxml, but for better and customized appearance, you would better use phyloxml. You can customize the appearance by either JavaScript or XML or both.
• InfoVis toolkit: interactive data visualization
• BioJS (developed by EMBL-EBI): reusable components for presenting biological data
• Tool list
  • 33 best tools
  • Datavisualization.ch selected tools

Misc.

• JSHint: a tool to detect errors and problems in JavaScript.
• RequireJS: JavaScript file and module loader.
• Joyride: web tour. Other web tour JS.

JS tips & bites

• Open url in a new tab/window (window.open() function)

JS Digests

• Callback functions (here)

Node.js deployment

• Systemd (use no “middle man” like forever)
• Stack overflow discussion
• Heroku
• nodejistu
• stagecoach
• nDistro (old? back to 2010)
• Jenkins (here and here)
  

RESTful

Introduction

• Introductory slides
• What is and why use Hypermedia API

RESTful frameworks

• abaaso: lightweight JavaScript app framework
• sammyjs: lightweight framework with class
• cujoJS

HTTP status code

List of HTTP status code from Wiki

 

Difference between 201 created and 202 accepted

W3C definition