Categories
gsoc

Started coding

Last week I learned more about Postgres and I think I will like that better than MySQL once I have completely figured it out. I also looked at the GIS extension PostGIS and in particular how I can access it through Python. I considered Django and some other options, but this part is still a bit vague to me. I’ll fgure that out later.

In my previous post I mentioned that I will be using Git for my project. Of course, I will also keep my repository synchronized with the OpenStreetMap subversion repository (through git-svn). I already ran into my first Git nuiscence: Git doesn’t like empty directories.

Next I have been reading about Test Driven Development and Agile stuff in general. There is even such a thing as testing databases. It was interesting to read about the cultural impendance mismatch between data professionals and application developers.

Today, May 26th, I started writing actual code for my project! This is what’s new:

  • a script that downloads the SRTM tiles for Australia and tests if the download was a succes
  • tests to verify the content of these tiles

The files are encoded as binary big-endian signed integers and so I needed to figure out how to deal with them. I am not sure if all went right, but I’ll find out later.

I wrote a lot of tests today so once I have more Fingerspitzgefühl for all the tools, I should be able to try some real TTD.

I will write a new post at least once a week during the project. I will try to do this whenever I reach an interesting milestone, so I can keep the titles a bit more interesting than “Weekly Status report #3”.

One reply on “Started coding”

Er zijn blijkbaar nogal wat manieren om PostgreSQL te gebruiken met Python:
http://packages.ubuntu.com/hardy/python-pgsql (PostgreSQL v7.x only?)
http://packages.ubuntu.com/hardy/python-psycopg
http://packages.ubuntu.com/hardy/python-psycopg2
http://packages.ubuntu.com/hardy/python-pygresql

En kende je osm2pgsql al?
http://packages.ubuntu.com/hardy/osm2pgsql – OpenStreetMap data to PostgreSQL converter

Ik neem aan dat je PostGIS al gevonden had?
http://packages.ubuntu.com/hardy/postgresql-8.3-postgis – geographic objects support for PostgreSQL 8.3

Wat algemene PostgreSQL tools:
http://packages.ubuntu.com/hardy/pgadmin3 – graphical administration tool for PostgreSQL
http://packages.ubuntu.com/hardy/phppgadmin – Set of PHP scripts to administrate PostgreSQL over the WWW
http://packages.ubuntu.com/hardy/postgresql-autodoc – utility to create PostrgreSQL database schema overview in HTML, DOT and XML

En mocht je Python als procedurele taal *binnen* databases willen kunnen gebruiken:
http://packages.ubuntu.com/hardy/postgresql-plpython-8.3 – PL/Python procedural language for PostgreSQL 8.3

Zelf ben ik bezig met PL/pgSQL. Zie http://www.postgresql.org/docs/8.3/static/xplang.html voor meer informatie over procedurele talen in PostgreSQL.

Django is een web framework. Ik weet niet of je doel het bouwen van een website is, maar anders heb je daar niet zoveel aan waarschijnlijk.

Zelf heb ik vorige week de dblink-module ontdekt en die maakt mijn leven een heel stuk simpeler (remote databases in 1 omgeving samenbrengen): http://www.postgresql.org/docs/8.3/static/dblink.html

Ik ben zelf dus ook bezig met PostgreSQL. Ik werk niet met geografische data, maar ben wel geïnteresseerd in wat je allemaal uitspookt met PostgreSQL.

Leave a Reply to Nils Cancel reply

Your email address will not be published. Required fields are marked *