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
- Zoho Launches Online Document Management Tool
Online collaborative technology developer Zoho has launched its new Zoho Docs, a Web-based document management tool that's designed to integrate with Zoho's online spreadsheet, presentation, and document creation software.
- Red Hat Makes Strategic Virtualization Buy
Open source server distributor Red Hat Inc., which is carving out a virtualization path unique in the industry, added another arrow to its quiver Thursday with the acquisition of Qumranet Inc.
- Security Exploits to Google Chrome Browser Emerge
Google's Chrome Web browser--complete with quirky marketing comic book--made a splash when announced Tuesday, but what a difference a day makes. On Wednesday, proof-of-concept bugs affecting the Internet app were disclosed. Chrome is still early in its first public beta.
- Sun xVM VirtualBox 2.0 Hypervisor Adds 64-bit Support, Bolsters Performance
Sun Microsystems this week rolled out version 2.0 of its xVM VirtualBox. The product is a cross-platform, open source hypervisor that supports hosts ranging from Mac OS X and Windows to Solaris and 18 varieties of Linux.
- Rarity for China Schools: Nanjing University Deploys Campus-wide Wireless LAN
Nanjing University of Posts and Telecommunications in China has deployed a campus-wide wireless LAN (WLAN) from Motorola. The WLAN will enable multimedia Internet-based teaching, automatic academic office management, Internet access, long-distance teaching, and other services. Nanjing University of Posts and Telecommunications is one of the few universities in China to provide complete wireless LAN coverage to every building in addition to the campus' outdoor spaces.
- Pac-10 Teams Score Competitive Insight with BlueArc Storage
The Pacific-10 Conference (Pac-10), a group of sports teams from 10 colleges and universities, has expanded the use of its BlueArc Titan storage solution housed at the University of California, Los Angeles (UCLA) to store dozens of terabytes of game footage. In the 2008-2009 season, all of the Pac-10 football, women's volleyball, and men's and women's basketball teams will access opponents' video for competitive analysis from Titan storage.
