Limitless Strings for PostgreSQL
Limitless Strings for PostgreSQL
Installing Ruby on Rails, Passenger, PostgreSQL, MySQL, Oh My Zsh on Snow Leopard, Fourth Edition
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 maintain...
Using BETWEEN for SQL comparisons
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...
Tracking Google Analytics events in development environment with GoogleAnalyticsProxy
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...
RailsOnPg released
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.
While you can already do something like this with execute in your migrations:
execute("CREATE VIEW...Double Shot #550
Double Shot #518
Dealing with ‘duplicate key violates unique constraint’ on the primary key
AlphaClone on PostgreSQL and Ruby on Rails
Interviewed by Database Radio Podcast
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.
Follow seriouslyruby on Twitter!
