Database
Postgres and Moving Databases
18/01/24 10:23 Filed in: Systems Administation
Recently I had to recover a Postgres DB and for 'convenience' I moved it from its original Linux environment to OS X. The process had a few wrinkles most important was that the linux environment used a locale of en_US.utf8 and MAC OS only has en_US.UTF-8
Read More...
Read More...
Don't forget your keys
14/05/13 09:17 Filed in: Management | Programming
Data cleansing is the process of taking the data contained in a data base and correcting the errors in it. It is probably one of the most hated jobs in the industry as it tends to be both tedious and exacting. The final two nails in its coffin is that it is almost never finished and almost never completely correct. All in all a miserable and mostly unsatisfying experience.
One of the secrets to success in data cleansing is in selecting keys i.e. the fields that allow the identification of the record to be updated. Read More...
One of the secrets to success in data cleansing is in selecting keys i.e. the fields that allow the identification of the record to be updated. Read More...