Monthly Archives: March 2009
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
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
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
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
on Delicious
on Facebook
on Google Books
on HackerNews
on LinkedIn
on StackOverflow
on Twitter