Skip to main content
Add as a preferred source on Google


First Look: PostgreSQL 8.3

  • By Will Kraft
  • 02/28/08

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.

About the Author

Will Kraft is a Web designer, technical consultant, and freelance writer. His website is Pagewizard Web Design. You can contact Will at [email protected].

Featured

  • Abstract neural network 3D illustration

    Intel® AI EmpowerED: The AI-Ready Campus, Delivered

    Artificial intelligence is transforming higher education, prompting institutions to rethink how they manage infrastructure, security, governance, and workforce readiness. Successful adoption requires a strategic, institution-wide approach that aligns AI initiatives with educational goals, faculty enablement, and scalable operational frameworks.

  • Robot typing on fluorescent keyboard

    The Wrong Battle: Why Your Institution's AI Policy Is Probably Solving the Wrong Problem

    The conversation on most campuses has become consumed with detection: How do we catch students using AI when they shouldn't? The impulse to protect academic integrity is legitimate, but the detection-first approach has a fatal flaw.

  • Neon blue security locks with a single red highlight

    AI Shifts Cybersecurity Focus from Finding Flaws to Fixing Them

    For decades, one of cybersecurity's most difficult challenges has been finding vulnerabilities before attackers do. A growing number of security professionals now say artificial intelligence is changing that equation, shifting the focus from discovering flaws to fixing them quickly enough to prevent exploitation.

  • humanoid robot with circuit board background

    Meta Expands into Physical AI with Acquisition of Robotics AI Startup

    Meta Platforms has acquired Assured Robot Intelligence (ARI), a robotics artificial intelligence startup focused on humanoid systems, as the company expands its AI work beyond software and into models that could help robots operate in physical environments.