Category Archives: Python

Why Not Auto Increment in MongoDB

Posted on August 4, 2010 by kgorman

I came across this blog post with a nice pattern for auto-increment in MongoDB. It’s a great post, but there is something to think about beyond how to logically perform the operation; performance. The idea presented in the blog is … Continue reading →

Posted in Data Architecture, Database Engineering, Mongodb, Python | Tagged , , , , | View Comments

mongo_graph: a rrdtool graphing utility for MongoDB

Posted on July 23, 2010 by kgorman

I just uploaded a little utility that pulls performance data from MongoDB and loads it into rrdtool for trending and analysis. Sure there are options like cacti out there, but this is just a simple raw utility vs something designed … Continue reading →

Posted in Mongodb, Python | Tagged , , | View Comments

mongostat 0.2b

Posted on February 9, 2010 by kgorman

I have been playing quite a bit with MongoDB lately. MongoDB is a nosql type database. It’s different than a simple k/v store however. It allows sorting, secondary indexes and such. It’s format is BSON a binary representation of JSON … Continue reading →

Posted in Mongodb, Python | Tagged , , , | View Comments

pgstat 0.8beta released on PgFoundry

Posted on March 3, 2009 by kgorman

I moved the pgstat (previously named pgd) project to pgfoundry. Thank you to the folks over there approving the project. I added a column for ‘active’ processes from pg_stat_activity as well as some fixes requested by Devrim that I really … Continue reading →

Posted in PostgreSQL, Python | View Comments

Cluster data, save cash

Posted on February 13, 2009 by kgorman

Since the economy is not exactly rocking these days, I suspect there are a lot of companies out there trying to save a buck or two on infrastructure. Databases are not exactly cheap, so anything that an engineer or DBA … Continue reading →

Posted in Database Engineering, PostgreSQL, Python | View Comments

Python/cx_Oracle utility functions

Posted on March 31, 2008 by kgorman

I recently created some utility functions to startup, mount and stop Oracle via cx_Oracle and thought I would share them. You will want to make sure you have password files setup correctly in order for this stuff to work. # … Continue reading →

Posted in Python | Tagged , | View Comments

Python and cx_oracle

Posted on March 9, 2008 by kgorman

I decided to start futzing with Python and Oracle. I generally use perl for most everything, and sometimes php for web based things, but I wanted to try Python at the urging of colleagues. I downloaded the source from here, and added … Continue reading →

Posted in Python | Tagged , | View Comments