How to run H2 database script from command line

http://stackoverflow.com/questions/10675768/executing-script-file-in-h2-database

 

You can use the RUNSCRIPT SQL statement:

RUNSCRIPT FROM 'test.sql'

or you can use the RunScript standalone / command line tool:

java -cp h2*.jar org.h2.tools.RunScript -url jdbc:h2:~/test -script test.sql

You can also use the RunScript tool within an application:

RunScript.execute(conn, new FileReader("test.sql"));

How to rotate video with ffmpeg

http://duxyng.wordpress.com/2013/04/07/rotateflip-video-with-ffmpeg/

http://erikwramner.wordpress.com/2013/05/28/rotate-video-with-ffmpeg/

http://phayz.wordpress.com/2011/10/28/howto-rotate-a-video-using-ffmpeg/

To rotate 90 degrees clockwise and convert to mp4 (HTML5 compatible), I use:

$ ffmpeg -i 20130914_180610.mp4 -vf transpose=1 -vcodec libx264 -r 30 -strict experimental 20130914_180610-3.mp4