Python Programming in Linux with JetBrains PyCharm !

Screenshot 2015-03-30 22:36:13

I just loved starting Python Programming in Linux with the free JetBrains PyCharm Community Edition Python IDE! You can download it from here >

Key Features:

  • Intelligent Editor, Debugger, Refactorings, Inspections, VCS integration
  • Project Navigation, Testing support, Customizable UI, Vim key bindings
Installation Instructions (from JetBrains site)
  • Copy the pycharm-*.tar.gz to the desired installation location
    (make sure you have rw permissions for that directory)
  • Unpack the pycharm-*.tar.gz using the following command:
    tar xfz pycharm-*.tar.gz
  • Remove the pycharm-*.tar.gz to save disk space (optional)
  • Run from the bin subdirectory

NOTE: PyCharm on Linux doesn’t need special installation or running any installation script. It runs out of the pycharm-*.tar.gz

Provides valuable and easy debugging insight by integrating with the PyDevDebugger !
Thank you JetBrains ! Love your Software!
Proud to be IntelliJ IDEA User too !

Reading EBooks PDF, EPUB, MOBI etc. in Linux via CALIBRE

Calibre is a very popular e-book reading , e-books format conversion and e-book meta-data editing software. In Linux you can install the latest version of calibre by typing the following at the terminal:

sudo -v && wget -nv -O- | sudo python -c "import sys; main=lambda:sys.stderr.write('Download failed\n'); exec(; main()"

when prompted, just enter enter the root / user password and the install begins

Calibre can also be installed via Ubuntu Software Centre.Screenshot 2015-03-30 21:56:42

How to unrar files under Linux

Pretty basic but still posting! Tested with Ubuntu 14.4 LTS Trusty Tahr.

Via command line. You will have to first install unrar apt package

1) open xterm , or gnome-terminal

2) sudo apt-get install unrar

This will install the unrar package under /usr/bin/unrar so you can run the unrar command everywhere! you can check this via command “which unrar”

3) That’s about it. Go to your folder in which you have xyz.rar file.

4) unrar t xyz.rar  (to test archive for correctness without extracting anything from it)

5) unrar x xyz.rar to extract files from the rar file onto your current directory.

SQL | Oracle | See currently executing SQL | In-Flight SQL

— In Flight SQL
SELECT nvl(ses.username,’ORACLE PROC’)||’ (‘||ses.sid||’)’ USERNAME,
ltrim(to_char(floor(SES.LAST_CALL_ET/3600), ’09’)) || ‘:’
|| ltrim(to_char(floor(mod(SES.LAST_CALL_ET, 3600)/60), ’09’)) || ‘:’
|| ltrim(to_char(mod(SES.LAST_CALL_ET, 60), ’09’))    RUNT
V$SQLtext_with_newlines SQL
and SES.USERNAME is not null
and Ses.AUDSID <> userenv(‘SESSIONID’)
order by runt desc, 1,sql.piece;

#oracle, #sql