Installing MySQL

by editor April 15, 2012

Step by Step Installation of MySQL on Linux MYSQL is one of the world’s most powerful relational database management systems available as open source database. It provides high reliability, fast and consistent performance and even is easy to use. MYSQL database is highly flexible providing that it can be installed on more than 20 different [...]

Read the full article →

Python and Dtabases

by editor April 15, 2012

Database Connection in Python Python supports a large number of databases like MySql, Sqlite, Oracle, PostgreSql etc. Now lets see how to connect python with some of the standard databases . MySql Connection :- For to connect mysql python you have to download and install the mysqldb interface which connects MySql database server with python [...]

Read the full article →

Python Regex

by editor April 15, 2012

Regular Expressions The regular expression in python are similar to regular expressions that are used Perl. The regular expression can be used like Unix commands such as “ls*.*” . The regular expressions is used to match a set of strings. The regular expressions in python are made up of combination of both special and ordinary [...]

Read the full article →

Python exception handling

by editor April 6, 2012

Exception handling: The errors that occur during the excecution of the program is known as the exception. The exception can be handled using the try .. except method . For example : import sys try: s = raw_input(“Input your data”) except error: print “|n an error occurred ?” sys.exit() except : print ‘|n Exception occured’ [...]

Read the full article →

linux : cores, cpus, hyper-threading

by editor April 6, 2012

Information on physical cpus, cores and if hyper-threading is on can be derived from /proc/cpuinfo. Generally scenario is like a box with .. 2 physical CPUS with 2 cores 2 physical CPUS with 2 cores and 2 threads cores is like multiple cpus on a single chip. A dual core processor can really run two [...]

Read the full article →

SSH

by editor April 5, 2012

SSH What is ssh? Ssh (Secure Shell) is a program to log into another computer over a network, to execute commands in a remote machine, and to move files from one machine to another. It provides strong authentication and secure communications over unsecured channels. It is intended as a replacement for rlogin, rsh, and rcp. [...]

Read the full article →

python classes and objects

by editor March 30, 2012

Classes and Objects The object has both data and method in it. A object can also be said as a instance of a class. The class is user defined which categorize the object. The class can be defined using the keyword class and then with the class name ending with a semicolon at the end. [...]

Read the full article →

sybase cheatsheet

by editor March 25, 2012

Sybase cheatsheet Logging using isql From isql: $ isql -S server_name -U user_name password: To run a script, enter the following command: isql -U user -P password -i script_name.sql -o log_name.log How to list the column names of a table with data type 1> sp_help table_name 2> GO sp_help [<object>] Provides information about a database [...]

Read the full article →

Python file operations

by editor March 25, 2012

Python file operations File Operations The file is one of the input/output steps where we can perform read, write methods in it. For example : fileeg = open(‘d:/pythoneg/test.txt’, ‘w’) fileeg.write(“This is an example”) fileeg.close() Here the open is a method which is used to open the empty file test.txt which is saved in the location [...]

Read the full article →

Python modules

by editor March 25, 2012

Python Modules Modules : The module is the set of functions and variables which is previously defined . The module files come with an extention .py . A module can be imported to the program by the import statement. The python library is made up of modules. For example :Lets we create a function and [...]

Read the full article →

← Previous Entries