Database

        Shortcut to run current command with sudo in bash
        
       2012/09/20 
        
      For me, I mostly forget to add “sudo” to the command until the time I am actually supposed to run it. Also sometimes, on some systems, bash completion does not work as expected with “sudo”. With these …
      
        gqlplus – sqlplus with readline (tab completion)
        
       2012/08/03 
        
      Tab completion is something which is missing in the sqlplus and if you have lot of tables with long names or lot of columns then it is sufficiently difficult to type them 🙂
Here is a solution for this …
      
        Oracle Select the top 5 queries
        
       2012/02/27 
        
      Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle.

        Backup of files in the directory.
        
       2011/12/01 
        
      I was working on some scripts and the changes that I was making in the scripts was very dynamic, which I did want to keep backing up in the version control system. But for the peace of my mind, I …
      
        Faster blog with stats removed
        
       2011/06/18 
        
      I was thinking of removing the statpress plugin for quite some time now, but did not have a good alternative. Today finally I managed to do this as I had few hours to spare. Now that this is done, you …
      
        mysql output to an array for easy parsing.
        
       2011/05/11 
        
       Today I was looking for some way to put the output of the mysql output in an array in a bash script. Quick google search yeilded to results something like this:
[…] <td> <div …

        Make any command read line enabled (on *nix)
        
       2010/11/25 
        
      Make any command read line enabled (on *nix)
[…] <td> <div class="text codecolorer"> rlwrap sqlite3 database.db </div> </td> </tr> Enable readline even …
      
        Using SQLite to maintain your monthly bills.
        
       2010/08/24 
        
      I was looking for a small application to maintain my every month bills. The application had to be small and script-able. I basically wanted to keep track of the bills that have been generated and …
      
        SQLite – simple use in scripts
        
       2010/08/21 
        
      Today we will look a the most simple use&#8217;s in the scripts and how to use them.
[…] echo &#8221;insert into bills values (&#8221;$name&#8221;,$date_now, …

        SQLite : Manager for this simple database
        
       2010/08/19 
        
      We will look at sqliteman – <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite Database manager.
If you are looking for a …
      
        SQLite – Easy to use, dependable and good to use database for small applications.
        
       2010/08/17 
        
      For last couple of days I am looking at <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite, a very footprint, file based …
      
        SQuirrel SQL for Graphical interface to Oracle/MySQL and loads of other database – OSS and free.
        
       2010/06/04 
        
      <a href="http://blog.amit-agarwal.co.in/category/linux/">Bookmark this category
SQuirrel <a class="zem_slink freebase/en/sql" title="SQL" …