Category Archives: Databases

Redis and php-resque on Ubuntu 12.04

During my free time, I help to administer a machine hosting several websites which generate copious amount of traffic and at times, there can be a significant load on the server. These websites require many tasks running on the back … Continue reading

Posted in Databases, Linux, Scripting languages (PHP, Perl, etc), Web/Tech | 2 Comments

Fantastic and unorthodox solution to a database scaling problem

FriendFeed is one of my favorite sites to visit.  It aggregates and shows what users are doing or saying across the Internet.  As you can imagine, the database system required to store and query all these activities would be: 1) … Continue reading

Posted in Databases, Web/Tech | 3 Comments

PostgreSQL: How to have a column with a gap-less sequence with no skips in the incremental values

Continue reading

Posted in Databases | Leave a comment

Replicate data from MS SQL Server to PostgreSQL

Continue reading

Posted in Databases | Leave a comment

PostgreSQL – Showing Tables/Views containing a fieldname

Continue reading

Posted in Databases | Leave a comment

Materialized views with PostgreSQL

Continue reading

Posted in Databases | Leave a comment

KDE application KPoGre for PostgreSQL

Continue reading

Posted in Databases | Leave a comment

Resetting a PostgreSQL sequence

Continue reading

Posted in Databases | Leave a comment

Merlin Moncure does it again: How to do recursive sets in PostgreSQL using plpgsql

Continue reading

Posted in Databases | Leave a comment

(new) Make row-wise comparisons work per SQL in PostgreSQL 8.2

Continue reading

Posted in Databases | Leave a comment

PG Lightning Admin Available for $5.00!

Continue reading

Posted in Databases | Leave a comment

Peek into what SQL queries are being passed to your PostgreSQL database

Continue reading

Posted in Databases | Leave a comment

Simple examples using PostgreSQL’s new OUT parameter

Continue reading

Posted in Databases | Leave a comment

A kludge to do a month DateDiff() function inside PostgreSQL

Continue reading

Posted in Databases | 4 Comments

Bash script to backup PostgreSQL databases

Continue reading

Posted in Databases | 1 Comment