Other articles


  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. Page 1 / 1

blogroll