Category Archives: linux

Penguicon 7.0

Our little gang from the Windsor Unix Users Group just got back from Penguicon 7.0 on Sunday night. As always, it was so much fun we hardly managed to get any sleep, and we all came home with a lot … Continue reading

Posted in Events, linux, tech | Tagged , , , , , , | 2 Comments

Extending PostgreSQL with Python

One of the features I enjoy the most about PostgreSQL is the ability to write stored procedures in C, Perl, TCL, PgSQL, and yes… obviously also in Python. I’ve been using this feature since 7.4, so any recent version of … Continue reading

Posted in Databases, linux, tech, unix | Tagged , , , , , , | 2 Comments

Fixing custom sequences in PostgreSQL

PostgreSQL provides a mechanism called sequences, which I believe is extracted from ANSI-SQL92, though I’m too lazy to check, which are basically stateful counters that provide some helper functions. The primary use of sequences in PostgreSQL and Oracle, is to … Continue reading

Posted in Databases, linux, tech, unix | Tagged , , , , | Leave a comment

Apache2 shortcuts

I’ve been maintaining and managing Apache servers for over 10 years now, but for some reason, I never bothered to RTFM when it came to enabling/disabling modules and site configs in apache2.. As it turns out, you don’t have to … Continue reading

Posted in linux, tech, unix | Tagged , , , , | Leave a comment

Ahh those cool little CLI tools…

The list of Unix/Linux utilities available grows every day. Here’s a little list of cherry-picked utilities i’ve found myself using more and more lately… Inotail: Inotail uses the Linux kernel’s inotify API, which was implemented with v2.6.13 to monitor changes … Continue reading

Posted in linux, tech, unix | Tagged , , , , , | 1 Comment