Tag Archives: tutorial

Using PostgreSQL With Ruby on Rails on OS X

Following on from my last post for getting PostgreSQL up and running nicely on Mac OS X, my next task was getting it playing nicely with ruby on rails - I’m off on a rails course next week so I’m … Continue reading

Posted in postgresql, ruby | Tagged , , , | 2 Comments

Install PostgreSQL on Mac OS X Leopard

This type of guide is all over the internet, but I’m too lazy to search for one every time I want to do this. So here’s a brief overview of how I got PostgreSQL set-up nicely on Mac OS 10.5… … Continue reading

Posted in mac, postgresql | Tagged , , , | 2 Comments

Sync Your Things Database via Dropbox

Dropbox is a great service, I’m using it happily to keep my files in sync across multiple computers - I’m even using it to keep all of my passwords in sync, but I’ve thought of another great use… How about … Continue reading

Posted in mac, noteworthy | Tagged , , , , , , | 12 Comments

SSH Shared-Key Setup - SSH Logins Without Passwords

SSH is a great tool for remotely accessing another machine, but entering your password every time you log into a remote box can be a pain if you would like to set-up some background scripts to connect to a server … Continue reading

Posted in linux, mac | Tagged , , , , , | 4 Comments

A Better Ls for Mac OS X

I’m a bit of a command-line freak and like to spend a fair amount of time with the terminal open… As such I like to spend a small amount of time getting the terminal set-up nicely. Other than changing the … Continue reading

Posted in mac, noteworthy | Tagged , , , , , , | 42 Comments

CSS Styled Tables

Veerle comes up with another look at styling tables with CSS. A great read. In 2005 I wrote an article about styling a table with CSS. After receiving so many requests I finally decided to give in and write another … Continue reading

Posted in snippets | Tagged , , | Leave a comment

Install phpPgAdmin on Ubuntu 7.10

Update: These instructions have been tested and work fine in the latest version of Ubuntu (8.04, Hardy Heron). phpPgAdmin is a web based GUI for administrating a PostgreSQL database server. Here’s some quick notes on getting it installed easily on … Continue reading

Posted in linux, postgresql | Tagged , , , , , | 13 Comments

Creating New Accounts in PostgreSQL

Getting a new account set up on PostgreSQL is a simple process… Create our new user: $ sudo su postgres -c createuser daz Then you have to give this new user role a name (I called it daz), and then … Continue reading

Posted in linux, postgresql | Tagged , , | 10 Comments

Install PostgreSQL on Ubuntu 7.10

If you are using the latest version of Ubuntu (8.04 - Hardy Heron), you might find these slightly updated instructions useful. This quick walk-through are my notes for installing the PostgreSQL database server and the PgAdmin administration application on Ubuntu … Continue reading

Posted in linux, noteworthy, postgresql | Tagged , , , , | 63 Comments

Adding/Deleting Rows in TableKit Tables Revisited

TableKit is a great javascript library for making your HTML tables fully editable. However, one problem is that you can’t add or delete rows from the tables… I came up with a solution to this not so long ago, but … Continue reading

Posted in javascript, noteworthy, perl | Tagged , , , , , , , | 7 Comments