Studying MCA II year in Pallavan Engineering College.
Studying BE (ECE) final year in Pallavan Engineering College.
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.
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
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.
This entry was posted on Monday, May 3rd, 2010 at 12:19 pm and is filed under Linux. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.