KLUG : Discussed over PostgreSQL

Date : 02 / 05 / 10 Week : 50 People : 13+2

Session   : 4  pm to 6 pm

Location : Dhasthagheer’s Home

Topics Discussed : Discussed Over PostgreSQL

Attendies  : Arulalan, Balakrishnan, Dhasthagheer, Elango, Praveen, Priya, Rajkumar , Shanmugam,  Shrinivasan, Vijai Ganapathy, Vijayalakshmi, Yasir and myself ( Selvamani )

New Attendies  : Prabhu and Rajesh

About Prabhu :

Studying MCA II  year in Pallavan Engineering College.

About  Rajesh:

Studying BE  (ECE) final year in Pallavan Engineering College.

Discussion :

What is PostgreSQL?

PostgreSQL is a fully featured object-relational database management system.  It supports a large part of the SQL standard and is designed to be extensible by users in many aspects.
Arulalan took the class about PostgreSQL. He took the following things :
PostgreSQL Installation :
We require  to give the following command to install Postgresql 8.4
sudo apt-get install postgresql
We need to install another package for supporting postgresql in python. To install it through terminal, use
sudo apt-get install python-psycopg2
Switching as a postgresql user and Creating seperate user in PostgreSQL.
How to create a database and tables under a particular database in PostgreSQL.
All those thing mentioned above are explained in the psql interpreter in the terminal using the commands available for PostgreSQL. Then he taught us to connect the psql database through python interpreter. It worked successfully.
Then he explained how the data is passing and storing into database from python. Arulalan explained all these concepts only for the single localhost. Further, he explained how data can be shared from one system to another system  in a local network.
Here, Some network concepts shared with us by Mr. Vijai Ganapathy.
Then Arulalan explained some user authentication method like trust, md5, password, etc., and type of host such as localhost, host, hostssl and hostnossl available in postgresql database. A configuration file has to be changed for giving authentication to a particular user if a user does not have permission to undertake any  activities in postgresql database. Here is the link you can find more about this.
http://www.postgresql.org/docs/8.1/static/client-authentication.html
The following link will give you guide to getting started with posgresql taken by Arulalan.
PostgreSQL Basic Practical Guide from KLUG
Finally, After finishing our class, our KLUG members decided to conduct a Summer Boot Camp in Kanchipuram. This boot camp will be conducted from 31st may 2010 to 5th June 2010 at Sakthi ITI, madam street, Kanchipuram.
Linux Basics               Ilango, Yasir
Linux Histroy              Logeshpraphu, Rajkumar
HTML,CSS                   Praveen, Manigandan
Javascript                     Shanmugam, Rajkumar
Python                           Balakrishnan, Arulalan, Selvamani
PHP                                Vishnu, Dhastha
PostgreSQL, Mysql    Priya, Malathi, Suji
Ruby                               Srinivas, Shanmugam, Arulalan
Duration :  The timing is not fixed yet. It will be updated soon.
It is fully based on Open Source Technology in Linux. This boot camp will be more useful for the students who is interested in programming language.

Rocks,

செல்வமணி. ச

Advertisements

One Response to KLUG : Discussed over PostgreSQL

  1. Thyagarajan says:

    Guyz, Great, job keep it up.

    somehow i am being missed by kanchi lug guyz as i was not informed about the event.

    Earlier i requested Kanchi Lug Guyz to hold a summer camp, where many interested people like me from chennai can come and contribute sessions.

    @Admin(s): Kindly post your activity in chennai lug mailing list (or) private intimations to foss evangelists so that we could participate in the event.

    All the best,

    Thyagarajan Shanmugham

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: