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
- Microsoft Outlines Next-Generation Databases
Microsoft is planning to enhance the BI capabilities in the next version of its flagship SQL Server database, the company revealed Monday. The company kicked off its second annual Business Intelligence Conference in Seattle by outlining plans for a new set of managed self-service analysis and reporting capabilities that will be integrated into the next version of SQL Server.
- Red Hat Expands HPC Solution Availability
Open source software vendor Red Hat went global with its high-performance computing (HPC) product Thursday. An announcement issued by the Raleigh, NC-based company claims that the Red Hat HPC Solution product is the "first" integrated Linux-based HPC platform.
- IBM Aims To Boost Mainframe Competency with Scholarship Program
As we reported recently, IBM is accelerating its efforts to bolster mainframe education in an effort to increase the number of professionals entering the workforce with mainframe skills. Now the company is putting additional money where its mouth is with a new scholarship program supported by itself and its partner ecosystem, along with higher education institutions.
- Microsoft's 'Dublin' App Server Tied to .NET 4.0
New Windows Server and .NET Framework 4.0 technologies aimed at developers who are building composite applications will be released at Microsoft's Professional Developers Conference, Oct. 26-30. The server technologies are the first to support Microsoft's upcoming "Oslo" modeling platform, according to Microsoft.
- WoW: Microsoft, Cisco Continue to Cozy Up
The ongoing relationship between Cisco Systems and Microsoft has become even closer, according to recent news that the Windows Server on WAAS (WoW)-- an appliance that merges Cisco's Wide Area Applications Services with Microsoft Windows Server 2008--is available to order.
- Yahoo Fixing Zimbra Bug, Integrating with Exchange
Web-search advertising giant Yahoo plans to resolve a password security vulnerability identified in late September in its Zimbra open source e-mail and collaboration software. On Wednesday, a Yahoo spokesperson stated by e-mail that the problem will be addressed in a few weeks' time.
