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
- RIAA Outsources Fingering of Students Who Share Music Illegally
The RIAA is outsourcing the hunt for music thieves. Its largest target currently is those who operate from within colleges and universities, a move that has piqued the attention of Educause.
- Microsoft Expands Education Footprint in Asia Pacific Region
Microsoft Chairman Bill Gates announced new partnerships to extend accessibility and computer literacy in the Asia Pacific region during a speech in Jakarta at a government leader gathering earlier this week.
- IT Struggling Over Security, Compliance
IT pros are having a hard time balancing security, software patch management and IT auditing with a host of other duties, according to a survey released Monday by Shavlik Technologies.
- Toronto College Upgrades Network with Gigabit Ethernet Wireless Links
Toronto-based George Brown College has gone public about its deployment of six BridgeWave GE60 wireless links to upgrade its campus-wide network.
- Gates Highlights R&D at CES08, Unveils Microsoft Touch Wall
Microsoft's Chairman Bill Gates spent a lot of time Wednesday talking about "empowering the workers" at the Microsoft's 12th annual CEO Summit 2008 in Redmond, WA, where he gave a keynote speech. However, Gates wasn't talking about political revolutions or even pay raises for office workers before the CEO crowd. Instead, he was referring to new software technologies that can better enable collaboration, social networking and decision-making on the job.
- Vista Vulnerability Study Puts Microsoft on Defensive
Microsoft and some independent security researchers had the blogosphere buzzing Wednesday over a series of denunciations after one company claimed that the Vista operating system was more vulnerable to malware and other exploits than previous operating systems.
