Assuming a shapefile called myshapefile.shp, a table mytable in schema xyz, in a PostGIS enabled database called mydb on localhost. The table is owned by user dbuser who has password “secret”. Using shp2pgsql shp2pgsql myshapefile -I xyz.mytable > statements.sql psql…
tikZ and LaTeX PGF/TikZ is a tandem of languages for producing vector graphics from a geometric/algebraic description. You can use this language inside tex files, to programmatically draw nice 2D and 3D graphics. Another package which some people prefer for…
Download sourcecode Choose the appropriate sourcecode version by going to wget # or use curl
Nagios looks at 1) return codes and 2) output to stdout. This is the hello world of Nagios plugins, written in Python: check_helloworld.py: #!/usr/bin/env python # optparse is Python 2.3 – 2.6, deprecated in 2.7 # For 2.7+ use …
In terminal you can write something like: say ‘hello world’ Which will make your computer talk. To save the audio output to a file, use the -o option. A full example is: say -o hello.aiff -v ‘Alex’ ‘Hello, my name…
My top seems to act a little strange (running Snow Leopard). It doesn’t respond to the key commands I’m used to, e.g. for sorting on Memory Usage etc. Nevertheless, this is how I found out (by chance really) how to…
These instructions show how to install pip and virtualevn on a Mac running Snow Leopard 10.6.8 and using Python 2.7. I used this to install Django 1.3.1 (installation instructions included). Installing pip (skip if you have pip installed) First make…
Here’s a game I like to play. Select two wikipedia pages at random, and find a route from one to the other. I stated a theorem once that: you can get from any page on wikipedia to the page on…
This howto shows how to get Nagios up and running on an Amazon EC2 Instance using Apache web server to serve the Nagios UI. You could argue that a more light-weight web server would be better, but I’d argue that…
Google Fusion Tables is a service for storing tabular data online. It has an API that allows you to make an SQL-like request for data from an online table, like the following: sql=SELECT * FROM 1906375 (clicking the link will…