Click here to receive your FREE subscription to Campus Technology
Software Review
First Look: PostgreSQL 8.3
2/28/2008
I decided to give open source database PostgreSQL a try using version 8.3, which was released early in February. My favored environment to use is Ubuntu Linux, which currently works well with MySQL installed. However, for this test, I opted to use the Windows version of PostgreSQL.
By installing PostgreSQL on Windows XP, I had a sterile testing environment, since I've never loaded a SQL product on it before.
Installation of PostgreSQL was very straightforward. In addition to installing all necessary software components to disk, the installer also quickly allowed me to deploy PostgreSQL as an automatic service that would allow me to connect with a client to work with databases. The installer also offers many add-ons and extensions that provide additional PostgreSQL functionality to those who need or want it.
PostgreSQL 8.3 offers many useful tools in the default installation package. The most notable one is called pgAdmin III, which provides a nice GUI front end for working with databases, queries and tables. Tools like this make it easy to get started with PostgreSQL. There is also a command prompt available that allows more advanced users to interact with the database directly with hand-typed SQL statements, just like the command line interface in MySQL.
PostgreSQL 8.3 has a great number of enhancements over previous versions, too many to list here. A complete list is available at the PostgreSQL Web site.
Implementing PostgreSQL on Linux and Unix platforms is more complicated than deployment on Windows. While there is no automated installer mechanism, there are RPM packages available for Linux (Red Hat Enterprise Linux/CentOS and Fedora) and Solaris. Users of other Linux distributions and other Unix-like operating systems such as FreeBSD have the option of compiling their own binaries from source.
Will Kraft is a Web designer, technical consultant, and freelance writer. His website is Pagewizard Web Design. You can contact Will at will@pagewizardwebdesign.com.
Cite this Site
copy text (above) for proper citation
Recommended Reading
- Georgia Tech Helps Develop Web-based Tool To Improve Blood Supply
The Georgia Tech College of Computing, working in partnership with the Centers for Disease Control and Prevention, has developed a Web-based tool for tracking blood safety. The program is expected to help developing countries improve the adequacy and safety of their national blood supplies through better monitoring and evaluation.
- Mississippi State Implements Reflex Virtual Management Center
Mississippi State University has implemented Reflex VMC (Virtual Management Center) from Reflex Systems. The application allows IT administrators to monitor a virtual infrastructure and enforce business and IT policies.
- Stanford Law School Launches IP Litigation Clearinghouse
The Law, Science & Technology Program at Stanford Law School has launched the Intellectual Property Litigation Clearinghouse (IPLC), an online database that offers comprehensive information about intellectual property (IP) disputes within the United States.
- Texas A&M Health Science Center Adopts Banner Administrative Management
The Texas A&M Health Science Center has selected the Banner Unified Digital Campus (UDC) from Sungard Higher Education to help unify its geographically-dispersed community and to enhance and expand services and communications to its growing student enrollment.
- NCCC: Data Cleansing Key To Managing Growth
Community colleges are in a good spot in some ways during the economic downturn, as tight family budgets drive up the appeal of the community college option. But along with the rest of higher education, most community colleges also face shrinking IT budgets and tighter resources. That makes it that much harder to handle the growing enrollment numbers that some community colleges are seeing.
- Finjan: Layoffs Could Drive IT People To Become Cyber-Criminals
Security vendor Finjan predicts that the current economic downturn could herald a sharp rise in cybercrime during 2009--driven by the rise in the number of IT people being laid off. According to a report from the company's Malicious Code Research Center (MCRC), more unemployed IT personnel will be tempted to seek "new and easy income by purchasing and using crimeware toolkits that are sold by professional hackers."
