PostgreSQL - working with columns and rows

The previous article explained how to create and drop tables using the psql client.

Now we'll explore adding columns and rows (records) to our database's tables.


PostgreSQL - creating and dropping tables

This article will explain how to create and drop database tables using the psql client.

Many web frameworks, such as Ruby on Rails, handle creation and access to database tables automatically. But it's a good idea to learn the basics of working with them manually; also, not everyone running a postgres server will use it in conjunction with a web framework.


PostgreSQL - making connections #3

Following part 2, this article addresses some security-related concerns affecting postgres servers open to remote TCP connections.


PostgreSQL - making connections #2

Following part 1, this article explains how to configure our postgres server for less restricted local and remote TCP connections.

For a full treatment, refer to Chapter 21 in the official documentation.


PostgreSQL - making connections #1

Following installation, access to our PostgreSQL database server is highly restricted owing to its default configuration — this was first explained in the local connections as postgres article.

The present article and the next two will explain how to enable postgres for less restricted local and remote connections, a necessity if we're going to use it as the datastore for our web applications, or connect to it remotely with a database admin tool.


Ubuntu Hardy - Rails and PHP options for PostgreSQL

Ruby on Rails and PHP are popular web application frameworks; both commonly make use of a database server on the back-end.

This article will cover installation of the packages needed to integrate PostgreSQL with Ruby on Rails and a standard PHP install.


PostgreSQL - creating and dropping databases

This article will explain how to create and drop databases using the psql client, and alternatively using the shell commands createdb and dropdb.


PostgreSQL - creating and dropping roles

This article will explain how to create and drop database roles using the psql client and alternatively using the shell commands createuser and dropuser.


PostgreSQL - local connections as postgres

In this article, we'll connect to the database server as the "postgres" role, using the psql client software for the first time.


PostgreSQL - access control

Following from the PostgreSQL installation article, we now take a look at some important concepts you will need to be familiar with when working with PostgreSQL.

As such, we'll introduce access control and terms such as roles, attributes and privileges.


Ubuntu Hardy - PostgreSQL Installation

Installation of PostgreSQL on Ubuntu Hardy is easily accomplished with the 'aptitude' package manager.

This article will work through the installation process and some configuration changes suggested for a typical setup.