Writing

Unsolicited Advice / Tips & Tricks / Random Musings

Our ongoing commitments to innovation and training involve sharing what we know with as broad an audience as possible. By publishing our insights, we help build dialogue that moves everything forward. We reach out with technical articles on systems administration and programming as well as through our blog and updates on Twitter.

Featured Technical Article View More

Performance Tuning PostgreSQL

PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can't.

The problem is that every database is not only different in its design, but also its requirements. Some systems are used to log mountains of data that is almost never queried. Others have essentially static data that is queried constantly, sometimes feverishly. Most systems however have some, usually unequal, level of reads and writes to the database. Add this little complexity on top of your totally unique table structure, data, and hardware configuration and hopefully you begin to see why tuning can be difficult.

Read Full Article

Latest Blog Entry View More

Python Dev Tip: DRY your shell with PYTHONSTARTUP

Do you find yourself re-doing the same Python shell stuff?

I know I do. I'm constantly doing it and replaying some of my IPython history isn't cutting it for me anymore. IPython has profiles but they're not terribly easy to get working with Django and your typical manage.py shell command.

Site wide is easy, but what about per project?

You can load things and execute code for ALL your Python shells ...

Read Full Entry