First Android Phone Setup

All free apps

– Android File Transfer (OK, that one I actually installed on my latop to sync my phone on my Mac)

Llama – Change phone settings based on location

TrustGo Mobile – antivirus (one can never be too careful)

Aviate – Theme your phone based on times of day

PasswdSafe/PasswdSafeSync (to be able to open your PasswordSafe  file straight from your dropbox)

JuiceSSH – free good SSH client

AndroZIP – Handles Archive Files

Dropbox – Access your dropbox files

AndSMB – Access your network shares to upload and download files

Komik Reader – Read comics!

Job Scheduler Search – Juicebox

Evaluation is still work in progress but I thought I would jolt down my findings as I go.

  • Tool Description and Relevant Links

http://en.wikipedia.org/wiki/Juice_Box_Job_Scheduler

http://juiceboxjobs.com/tutorial.html

  • Connection to database (to run jobs directly on the source of the data)

I used a MS SQL database for my test, other sources of data are available as per Juicebox one pager documentation but I haven’t tried these.

I didn’t find it a straightforward process but then I am no java expert. The MSSQL driver (I used the Microsoft JDBC Driver 4.0 for SQL Server – http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774) isn’t included in the Juicebox application and I didn’t find a way to add it while running the application using the embedded jetty server, I am guessing it would require unpacking the juicebox.war, adding the driver JAR, and repacking it.

Instead, I installed Apache Tomcat, deployed juicebox on it and added the JAR file to the exploded juicebox file structure, $CATALINA_HOME\webapps\juicebox\WEB-INF\lib (I am on Windows). This makes the MS SQL driver available to Juicebox.

Do read the help file bundled with the driver files for the syntax to use to define your Driver and Connection URL. For me, it ended up looking like the below:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Connection URL: jdbc:sqlserver://<serverName>:<serverPort>;databaseName=<databaseName>;user=<userName>;password=<userPassword>;

And it works!

Useful Free WordPress Plugins

Security

Content Management

Cloning/Manual Backup

Analytics/SEO