Technology Insights

How to View Your Personal Skype Profile As Other Skype Users See It

Earlier I was playing around with my Skype profile and I realized there wasn’t a link that was obvious to view my own Skype profile. I wanted to make sure profile items that I was allowing only contacts to see were only seen by contacts.

Finally I thought of a way to view the profile without the link actually being provided. While you cannot add the contact your are signed in with to your contact list you can actually still search for that user and view the profile. First lets make any necessary modifications to your personal Skype profile.

Details
Technology Insights

Outline Every Cell In Every Row Of A Table Using Textile Formatting

Textile formatting is used in numerous wiki applications and other places where easy formatting is needed for text input fields without using a WYSIWYG interface. Currently I am using textile a bunch because I spend at least some time every day adding tickets, updating tickets, and adding/modifying wiki pages in Redmine. In Redmine you have the option of using Textile formatting or no formatting by default. If anyone is on the fence regarding Textile formatting I suggest you give it a chance as it grows on you after a short amount of time.

There are a couple different ways to outline each cell within a table created using textile. Below I will explain two options available to put a border around each cell. First lets explain how to create a basic table of cell provider email addresses using Textile.

Details
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 tweetlater.com 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.

Details
Technology Insights

Use WordPress to Block Comments From a Certain Domain

It is easy to use your default WordPress admin interface to block comments from a certain domain. You can either have these comments require moderation or you can have the comments immediately marked as spam. My suggestion would be to initially have the comments require moderation just to make sure you are not also catching legit comments.

To block comments based on a certain domain follow the steps below.

Details
Code Snippets

Writing a function for frequently used SQL (returning custom columns) in PostgreSQL

There’s no real easy way to do this, but I’d like to write a database function (in this case a PL/pgSQL function) to run a SQL SELECT statement with custom columns in the output.

First, you need to create a custom data type for the custom columns (apparently, this step won’t be necessary when PostgreSQL 8.4 supports the RETURNS TABLE syntax in functions).  For example

Details