Thursday, June 21, 2012

Oracle SQL Query to print Unix Timestamp

The actual query is available in http://jehiah.cz/a/oracle-date-to-unix-timestamp , but here is a slightly modified version which strips the decimal points and prints only the elapsed seconds.
---
SELECT abs(to_number(((sysdate - to_date('01-JAN-1970','DD-MON-YYYY')) * (86400)))) as dt FROM dual;
---

Tuesday, May 15, 2012

Ubuntu Linux - Change from GUI mode to Command line / Text mode

Simple stuff - just documenting my learnings

So here's how we change Ubuntu from its usual GUI mode to the Command line mode (black screen / text mode)

Note : If"sudo" is used before a command, then you will have to enter root password.


  • Open the Terminal, and cd /etc/default
  • Open the "grub" file in vi editor as root : sudo vi grub
  • Change the property GRUB_CMDLINE_LINUX_DEFAULT from "quiet splash" to "text". See below
    • ========
    • #GRUB_CMDLINE_LINUX_DEFAULT = "quiet splash"
    • GRUB_CMDLINE_LINUX_DEFAULT = "text"
    • ========
  • Run this command to update grub : sudo update-grub
  • Reboot Ubuntu : sudo /sbin/reboot
On reboot, you should be able to see the command-line screen instead of GUI.

Saturday, May 12, 2012

Automate Sphinx - Create rst files automatically from a list of topics

You have lots of topics to document using Sphinx, but bored of creating each .rst file manually? Not to worry at all. Here is a script that will just automate the file-creation task for you. Here we go:

First, download the zip or gz package from https://github.com/thyag/SphinxAutomation/downloads


And read the below to get your stuff donne : 

Friday, May 11, 2012

Create a PDF document from your Sphinx Documentation using rst2pdf

Pre-requisites & Assumptions

  • You have installed Python.
  • You have installed and used Sphinx documentation generator.
  • You have created an HTML documentation using Sphinx

Friday, May 4, 2012

Buying books online - some how tos, tips and thoughts


  • Ask in quora.com for the best books in your topic of interest
  • Read the reviews about those books in amazon.com. Make sure that the rating is good, if not great. Beware of those reviews which are done by the author's buddies. Check the date of publication and the date of review to get some idea ( usually fake reviews are added immediately after publication date, and they are added in the same week or month)
  • Even if a book's rating is good, read the contents and the first chapter on amazon. Make sure it captivates you. The best book still may not work for you, so watchout.
  • Search for the price of the book in atleast 4 e-commerce sites. In India, I search at flipkart.com, indiaplaza.com, homeshop18.com, bookadda.com, and sapnaonline.com. Don't buy immediately. Impuse is maya. Just put the book on wishlist. Give atleast 1 week, sleep over the book, and decide if you really need the book. There are also sites like mysmartprice.com and junglee.com which do price comparisons. 
  • If you really need the book, order the book based on what is priority for you - cost, delivery time,quality of service, etc.

Tuesday, April 24, 2012

Share your local folder over HTTP - The easist way

Here is a one liner to share your local folder in a LAN environment :
  • Install Python
  • Open cmd prompt or terminal, and navigate to your desired directory. Type the command :
  • python -m SimpleHTTPServer
  • Open http://localhost:8000 on your browser.
To use a different port number (say 17740) :
  • python -m SimpleHTTPServer 17740

Friday, April 20, 2012

The Read More link option in Blogger / Blogspot post

This is a minimal tutorial to add a "Read More" link in your Blogger  / Blogspot post
  • Login to your Blogger account. Click on Compose and start typing your post. Or Click Edit if it is an existing post.
  • Place the cursor on the text section where you want to add the Read More link (usually after the 3-4 lines of the first paragraph)
  • Click on the "Insert Jump Break" button (on the toolbar above).
  • Publish or Update your post.

Thursday, April 19, 2012

Pune to Shirdi and Shani Shinganapur - Our one day trip


Sunday, 08 April 2012
People : Abinash, Sachin, Kushal, and Me
We started the trip from Magarpatta city, Pune at 5.15 am. We were late by about 30 mins, but wasn't much of a problem.

We took the Pune-Nasik route and the road was bad. (The best route is to take the Ahmadnagar road). At 7.30 am, we had breakfast at a place called Kamat's. There was car parking, toilet facilities, and decent+expensive food.

We reached Shirdi at 11 am. We left our slippers, mobile and other belongings at the car. Later we realized that leaving the slippers in the car was a big mistake because walking barefoot literally burned our foot.
Lesson : if you are visiting a hot place, always wear (inexpensive) slippers and leave them at the temple entrance.

When we entered the temple premises, a couple of shopkeepers misguided us and made us buy a lot of prasad and pooja items. That was mistake number 2. Don't be fooled by some strangers who are accosting you. Take your time, analyze the place and then buy only when necessary.
On reaching the temple's main gate, we came to know that the Darshan is closed from 11 to 1 pm. So we spent some time within the temple premises visiting the other smaller shrines.
We visited the dargah where Shirdi baba spent his childhood days. We also visited the museum which has the photos and items that belonged to Shirdi baba.

At 1 pm, we started lining up for the darshan at Gate 1. As it was Sunday, there was a lot of rush. We stood in a kind of managed queue  system where within the railings there were benches to sit (which was useful). The queue passed through 3 huge halls. And finally we hit the main hall which houses the statue of Shirdi baba. We gave the pooja items and the prasad to the priest sitting infront of the statue. We did our darshan for about 30 seconds and the service folks quickly escorted us out. It was 2.30 pm by then. We came out of the temple and jumped into the car.
Our next desitnation was Shani Shinganapur - the town without doors or locks. It was an 80 km drive from Shirdi.

Legend has it that Shani bhagwan descended into this village in the form of a 5 foot stone one fine day. The villagers, after seeing the stone, were naturally curious and started piercing the stone with a sharp tool. To their surprise, they saw blood oozing out of the stone.  Yes, blood.

Following the blood oozing incident, during the next few days, the villagers started reporting that they were getting dreams where Shani bagwan spoke to them - asking them to erect him (the stone) on a platform without any roofing. Its like, the stone should be erected on an open space. The whole idea is about openness. This explains why all the houses and shops in the Shinganapur town do not have doors or locks. People don't really bother about their belongings as they believe that Shani bhagwan will bring it back. They also believe that Shani would punish the wrong-doers, which is the reason why the locals are scared about stealing.

So yeah, we reached Shani real quick. The darshan was straightforward. Just park the car, enter the temple, pray, and exit. Its not as time-consuming or as procedural as Shirdi.

We also took some sesame oil and poured it at a particular spot near Shani's shrine. According to legend, Shani was once injured by Hanuman. They say one must pour oil on Shani to alleviate his pains. To understand more, you might want to check Dr Robert Svoboda's beautiful book : The Greatness of Saturn
That was it. We took the Pune-Ahmadnagar highway in the evening, and reached our place at night. Overall, it was a nice day out (one day is more than enough). It is better to go on a Saturday (because of Shani).

Where is the Dunkirk Lines Post Office in Pune?

Update: This article was relevant back in 2012-13. Please validate before any action as I have left Pune many years ago.
The Dunkirk lines post office is named " DUKIRKLINE" in the Indiapost tracking website : http://www.indiapost.gov.in/tracking.aspx

I was struggling to find the location of this post office and found it somehow after 2 days. To start with, you will have first check this wikimapia link to get the approxmate location of the post office:
This is how you reach this place : 
  1. If you are in Kharadi,

GIT Commands - My notes from Michael Hartl's Rails Tutorial

# initial one-time setup
git config --global <options> 

#Necessary each time you create a new repository.
#Commands need to be executed from the the project directory. Eg : C:/rails_tutorial/first_app

# To initialize a new repository
git init


A Compilation of Ayurveda websites, blogs, articles,etc

Good Books on Ayurveda:

  • Ayurveda and Panchakarma: The Science of Healing and Rejuvenation  - Dr. Sunhil, M.D. Joshi
  • Ayurveda: The Science of Self Healing - A Practical Guide - Dr, Vasant Lad
  • Ayurveda: Life, Health, and Longevity - Robert Svoboda
  • Prakriti: Your Ayurvedic Constitution by Robert Svoboda (Jun 1, 1998)


Some links on Ayurveda
http://www.ayurvedicdietsolutions.com/incompatible-foods.php