PostgreSQL and Ruby

Today was a day of strange sensations and frustrations. The Stripe backend code was written in Ruby, a language I have no familiarity at all in. (At least Javascript kinda looked like the C++ I attempted back in the 1990s).

To really make the page work, I wanted to include a running total of donations. I figured this would have been something provided by stripe - but no - I would have to log every transaction manually.

I thought about logging them to a CSV file, but the problem is - what happens when two people donate at the same time? Data corruption is no fun.

So that meant installing a PostgreSQL database.

Joy.

PostgreSQL, actually, wasn't that difficult once I was able to access it via the terminal with psql. I didn't need to do all that much. Create a table, and just gather e-mails and donations (mostly to write thank-you notes and keep track of unique donors.)

Postgres

I can pretty much write whatever I'd like to get the data out of the database, but the trick was passing the information out of the Ruby-based backend program into PostgreSQL. And since I didn't know Line One of Ruby, I needed expert guidance.

Ruby

Jhass over in #ruby on freenode had the patience of a saint, and we pretty much pair-coded (well, okay, it was mostly his ideas) and got the thing working, finally. Now, running totals and progress-bars are possible. YAY!

logs

Brian Boyko

Read more posts by this author.

Austin, Texas

Subscribe to Brian Boyko

Get the latest posts delivered right to your inbox.

or subscribe via RSS with Feedly!