Welcome to my website. I am always posting links to photo albums, art, technology and other creations. Everything that you will see on my numerous personal sites is powered by the formVistaTM Website Management Engine.


  • Dynamically Appending Elements to a Bash Array
    12/18/2013 2:05PM

    Following is how to dynamically append (push) items to an array in a bash script.

    declare -a ARRAY=()

    ARRAY=("${ARRAY[@]}" "item1")

    ARRAY=("${ARRAY[@]}" "item2")

  • Install Android Application Directly Without it Being in the Market
    12/05/2013 10:20AM

    When developing apps you will not only want to test them against the Eclipse AVDs but also install them on an actual device.

    To do so, set up an HTTP server (here is a link to another article on how to set up a quick and dirty HTTP server) and put you .apk file somewhere where you can get to it from your local network.

    Make sure that you check the 'Unknown sources' setting that will enable you to install applications that are of non-Market origin. 

    Then just open a browser on your Android device and download the .apk file.  Once done, when you attempt to open the .apk file the device will ask you if you want to install it.

  • Deleting Safari Cookies in iOS Simulator
    11/06/2013 9:36AM

    If you are doing any kind of development that involves cookies and need to be able to delete them while testing iOS you will likely need to delete them as well.

    The iOS simulator (Launched from Xcode by going to Xcode > Open Developer Tool > iOS Simulator) stores data for the simulator in the following directory on the host Mac OSX file system:  /Users/<uid>/Library/Application Support/iPhone Simulator/

    First, quit out of the iOS Simulator.

    To find the cookies and delete them open up a terminal and cd to the iPhone Simulator directory.

    $ cd /Users/<uid>/Library/Application\ Support/iPhone\ Simulator/

    Then execute the following find command to find the cookie data file:

    $ find ./ -type f -iname '*binarycookies*' -exec ls -l {} \;
    -rw-r--r--  1 ryanchapin  staff  2503 Nov  6 08:32 .//7.0-64/Applications/630F9FE9-87B2-4A6D-8C60-CA70EBC5FD8A/Library/Cookies/Cookies.binarycookies

    You can then update the find command to the following to delete the file.

    $ find ./ -type f -iname '*binarycookies*' -exec rm {} \;

  • Executing MySQL Queries and Commands from the Command Line to a Remote Server
    10/31/2013 10:56AM

    Following are a couple of ways to execute SQL on a remote MySQL server via the shell.

    Executing SQL directly from the command line:

    $ mysql -u uid -p -h remote.host database -e 'SQL query here;'

    Executing SQL from a file on the local host on the remote server:

    $ mysql -u uid -p -h remote.host database < file.sql

    You can also connect to the remote mysql server and from the command line execute SQL from files on the local drive as such (as long as the file is in the same directory from which the mysql connection is made

    mysql> \. file.sql

    Notice NO ';' at the end of the command.

    Moreover, you can use the following to run commands in your local shell

    mysql> \! ls

    Will give you the directly listing of the dir from which you invoked the mysql remote connection.

    mysql > \! vi file.sql

    Will allow you to edit the file on your local drive without having to close the mysql cli.

  • Executing Dynamically Generated SQL Queries from a Shell Script
    10/25/2013 1:03PM

    Following is how to generate dynamic SQL in a shell script and then execute those queries.

    Let's say, for instance, that you have a list of tables that you want to flush regularly during development and don't want to type in the SQL queries each time.  Moreover, you just want to maintain a list of the table names and add and remove from it when necessary and have your script dynamically generate and execute the delete statements.

    For the purposes of this tutorial we are running these commands as root to avoid the additional complication of authentication.

    The first thing you need is your text file with the list of your tables:





    for i in `cat tables_list.txt`

       mysql -u root dbase_name << END_SQL
       delete from ${i};
    # It is imperitive that the END_SQL redirect identifier
    # be on its own line without any leading or trailing spaces


    The script will run, will make a connection to MySQL and then execute the command with the dynamically generated target table.

    This will work with other databases other than MySQL as well.

  • 1 2 3 4 5 6 7 8 >>
Advanced Search