AbstractsComputer Science

Usability of PostgreSQL

by Xi Zeng




Institution: Kemi-Tornion ammattikorkeakoulu; Lapin ammattikorkeakoulu
Department:
Year: 2011
Record ID: 1134044
Full text PDF: http://publications.theseus.fi/handle/10024/30123


Abstract

My topic of the thesis is usability of PostgreSQL. It presents basic information aboutPostgreSQL, such as its history, function, and comparison with one of the most popular databases - MySQL. PostgreSQL has been tested in different environments and with different programming languages. The research is based on the documents from PostgreSQL official website.The thesis introduces and proves the usability and the compatibility of PostgreSQL. PostgreSQL has been installed on Windows workstation and checked in different programming environments . Those environments which have been chosen are free and open sources, such as Qt ceator, Dev-Cpp, and Eclipse. Whole the tests have been used by different programming languages (C, C++, Java, PHP, Ruby and Python) in the different environments, to check using create, select, insert, and delete commands to control PostgreSQL. Most of the codes and solutions can be found in documents and FAQ in official websites. Those tests can prove PostgreSQL's compatibility and usability. PostgreSQL is absolutely safe, fast, and technique strong. Key words: PostgreSQL, programming environment, programming languages, Windows.