Welcome to what seems like my tenth installment (actually, it’s the fourth) of showing you how I setup my development environment on a fresh OSX install. In this case, I’m actually getting a MacBook setup for a new employee with Snow Leopard.Over the years, I’ve evolved these following steps and they’ve helped our team...
Read more »
Recently, Carlos, suggested that I should start sharing some basic SQL tips that help with performance and/or general usage. I recently came across some code that I didn’t like to read and/or write. For example, let’s take the following…SELECT * FROM brochures WHERE published_at <= now() AND archived_at >= now()Essentially, this is pulling back...
Read more »
As mentioned in a recent article1, I’ve been diving deep into Google Analytics lately while working on a few client projects. We’re aiming to use much more of the features of Google Analytics and have been hitting some roadblocks with the development versus production application environments. Once you begin to dive into event tracking...
Read more »
Hello fellow PostgreSQL and Ruby on Rails geeks,Alexander Tretyakov (twitter) recently released a plugin for Ruby on Rails, which extends migrations and provides you with the ability to create.
Functions (pg docs)
Triggers (pg docs)
Views (pg docs)While you can already do something like this with execute in your migrations:execute("CREATE VIEW my_tasty_snacks AS SELECT * FROM snacks...
Read more »
At the end of the day, you have to ship code. Or sleep.MySQL vs. PostgreSQL comparison – Reasonably fair, though it misses the fact that GUI tools for MySQL are generally better.
Software patents should be abolished – Amen.
script/nginx – Instructions for getting nginx + passenger running in your dev environment.
RubyMine 2.0 Beta Overview –...
Read more »
Birthday season is just about over around here. A good thing, as I need to get some work done.open_gem – Gem extension to make it simple to open installed gems in your text editor. I’ve mentioned this before, but it’s still gaining useful features and I find I’m using it daily.
Ruby 1.8.6pl383 released –...
Read more »
I recently had to work through a problem where inserts were failing due to duplicate primary keys.Here’s the error (edited for clarity):PGError: ERROR: duplicate key violates unique constraint "contracts_pkey": INSERT INTO "contr...
Read more »
Earlier this week, our team launched a client’s project into the public. We began working on it early this year and it was quite an endeavor for our team. The company that we helped launch is AlphaClone, a premier stock research and portfolio simulation service for individuals and professional investors alike. Clone, backtest and...
Read more »
Bob Zurek, the Chief Technology Officer at EnterpriseDB interviewed me a few months ago for their new Database Radio podcast. It finally was published last week. Bob and I had a nice conversation about PostgreSQL and it’s community, our use of PostgreSQL with Ruby, Ruby on Rails, and development tools/methods.You can listen to the...
Read more »
Are you using PostgreSQL? EnterpriseDB want’s to hear your story at Postgres Rocks
Read more »
#rails – Twitter Search