Technology Insights

Automatically Follow People On Twitter

Automatically following people on Twitter when they start following you is easy. All you need to do is sign up for an account at Tweet Later. Setting up and account at Tweet Later will provide you with a dashboard where you can configure multiple Twitter accounts. Once configured you will be able to set up various automation tasks including following those that have followed you, sending private messages to people, or stop following people who stop following you.

Once you have a verified Tweet Later account login to the website. Once logged in select the Accounts menu item which will open a sub navigation menu. Select “Add Account” to add the Twitter account where you want to set up automation tasks. During the setup process you will be able to configure multiple options including Auto Welcome, Auto Follow, Vet Followers, and Auto Unfollow. Below is a brief description of each of these four options.

Technology Insights

Postgres Table pg_stat_activity Table Fields Explained

The pg_stat_activity table will show you what activity is currently happening on your PostgreSQL database server. The information will detail the database the activity is occuring on, the username initiating the activity, the length of time the acitivy has been occuring for, and much more.

Below is example output from running a SELECT query against the pg_stat_activity table. The pg_stat_activity table is located by default in the postgres database and can be accessed as shown below.

Technology Insights

PostgreSQL 8.3: postgres wont start with stats_start_collector = on

PostgreSQL 8.3 changed the way the Query and Index Statistics are configured from previous versions of postgreSQL including 8.2 and below. Things are technically easier now as the stats collecting is turned on by default and there are less commands to enter into the configuration to get all of the stats you will need. I had to look into this problem as I wanted to install some cacti postgres templates and the configuration stated to add the following lines to the postgresql.conf configuration file.