Other articles


  1. Splitting a large polygon into a grid

    Large POLYGONs can be hard to deal with in PostGIS. The common and easy way to index a polygon is with its bounding box, if a shape is very large, then the bounding box is also large and is not very useful. (At least I think this is a ...

    read more

    There are comments.

  2. Copying a PostgreSQL table structure

    Often you might have a table in PostgreSQL and you want to make a complete copy of that table, including all the indexes.

    You can copy that table with this command:

    CREATE TABLE newtablename ( LIKE oldtablename INCLUDING ALL );
    

    Replace newtablename and oldtablename with the new and old table names respestively ...

    read more

    There are comments.

  3. Turning off the pager in psql

    psql, the command line PostgreSQL tool is great. By default if the output of some command (or query) takes too much screen space, psql will use your default unix terminal pager to page through results.

    Sometimes you want to turn this off. This can happen if you want to see ...

    read more

    There are comments.

  4. First Payment

    Since it's actually possible for me to recieve payments, I have started to recieve money from this Kindle Maps adventure.

    It's great to be on the road to viable micro-business. All I have to do is several orders of magnitude increases in sales. :)

    read more

    There are comments.

  5. Viewing all PostgreSQL queries

    When debugging an application that uses PostgreSQL it can be very helpful to see what queries are actually being sent to the server. This can allow you to try running the queries yourself and you can see what results are coming back.

    On a normal PostgreSQL 8.4 install on ...

    read more

    There are comments.

  6. Competition!

    While browsing around the Amazon Kindle Store, I found someone else selling loads of Maps on the Kindle. They have a much larger selection than I do, hundreds of maps. It's good to see someone else validate my theory that you can sell maps on the Kindle.

    However from ...

    read more

    There are comments.

  7. How to echo to stderr

    On the unix command line, each command can print to stdout (standard output) or stderr (standard error). By convention, error messages go to stderr, and normal messages go to stdout. You usually connect stdout to the stdin (standard input) of another process. Having a long pipe of commands and this ...

    read more

    There are comments.

  8. 2011 Q2 report

    In the spirit of openness and sharing (and since I've learned from other microbusinesses online that are open), I'm going to file reports on how things are going. Quaterly is a good benchmark, so I'll start with that.

    This quarter was launch quarter when I started. I ...

    read more

    There are comments.

  9. Kindle Screen Size

    A map (in book form) is a sequence of pages, you can't have a big fold out map on a Kindle! So I had to make each page the same size as a

    The Kindle 3 has the following screen sizes:

    • height: 800 pixels
    • width: 600 pixels
    read more

    There are comments.

  10. Page 1 / 1

blogroll