Step 5 (update): Installing PostgreSQL on my Raspberry Pi 1 and 2

Update on 25/Jun/2015
We have added the links to the compiled deb packages.
Skip to this section if you only want to download and install them.

This article is an updated version of our previous post where we explained how to install PostgreSQL on the Raspberry Pi.

Continue reading

Connecting to PostgreSQL on Raspberry via Python

In this post I will explain how to connect to PostgreSQL on Raspberry PI usingĀ python. Python is a good language for scripting, so it could be useful to include our psql statements inside a python script, without the requirement of having psql installed on client machine.

Continue reading

Connecting to PostgreSQL on Raspberry via psql

In the previous post we’ve already explained how to set the Raspberry PostgreSQL server to allow incoming connections.

PostgreSQL shell client isĀ psql. Unlike pgAdminIII, psql is the terminal-based front-end to PostgreSQL, included in by default in the PostgreSQL package. psql enables to type in queries interactively, and provides meta-commands and shell-like features to facilitate writing scripts and automating a wide variety of tasks.

Continue reading

Benchmark results of PostgreSQL on Raspberry PI

In step 5, we have installed PostgreSQL. We then performed some benchmarks, by following tips and tricks contained in the world famous book about “PostgreSQL High Performance” by our dear Gregory Smith.

Results will be now presented, to test the efficiency of a PostgreSQL database server installed on a Raspberry PI. This represents a good challenge: build up a database server in a cheap way! Let’s not forget our goal: be able to adopt Postgres in schools so that the SQL language can be taught!

Continue reading