Latest Article:

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 is a mature object-relational database that has been in open source development since 1996. Learn how to install and configure PostgreSQL for the best performace on your Slice.

Postgres Installation:

Ubuntu Hardy - installing PostgreSQL: Installing PostgreSQL on your Ubuntu Hardy (LTS) Slice is very easy using the aptitude package manager. Let's see how.

Ubuntu Hardy - Ruby on Rails and PHP integration with PostgreSQL: Now postgreSQL has been installed on our Ubuntu Hardy Slice, we can look at getting our language/framework of choice to integrate with the database.

PostgreSQL General:

Introducing PostgreSQL Access Control : Now PostgreSQL is installed we need to take a moment to look at the important concept of access control. This concept is key to future articles and working with PostgreSQL in general.

PostgreSQL - local connections as postgres: Now the basics have been covered we can connect to the database server using the 'postgres' user. We'll use a tool named psql.

PostgreSQL - creating and deleting roles: Let's take a look at creating and deleting roles in PostgreSQL. Once this skill has been learnt, adding and deleting roles is simple via the command line.

PostgreSQL - creating and dropping databases: Now we know how to add and delete roles within PostgreSQL, we can move into creating and dropping databases. let's take a look.

PostgreSQL and connections:

PostgreSQL - making connections #1: So now PostgreSQL is installed, we can take an in depth look at making connections to the database.

PostgreSQL - making connections #2: Let's continue with our journey into making local and remote connections with PostgreSQL.

PostgreSQL - making connections #3: Finishing the discussion about connections, we can take a look at security and how we can tighten up PostgreSQL with regard to remote connections.

PostgreSQL and DB manipulation:

PostgreSQL -Creating and dropping tables: Let's start looking at how we can manipulate the DB by seeing how easy it is to create, drop and rename tables.

PostgreSQL - Working with columns and rows: Continuing working with the DB we can now move onto working with columns and rows.

Please feel free to request articles or comment with any suggestions or ideas of your own.