Janus wasn’t a bad guy: Solving real problems using a key-value store inside a relational database.

*
Proposal
Short Form
Intermediate

Excerpt

We demonstrate how we used hstore inside a Postgres database to elegantly solve the problem of generating solid business-intelligence from the dregs of emailed PDF and Excel files.

Description

“Janus frequently symbolized change and transitions such as the progress of future to past, from one condition to another, from one vision to another, and young people’s growth to adulthood.” — http://en.wikipedia.org/wiki/Janus

Having two faces isn’t always a bad thing. Schema-free, NoSQL databases are all too frequently presented as the opposite of relational, SQL databases, as matter and antimatter, as the future and the past. We see them as solving different problems, and having different visions of how to work with data. A more grown-up vision of data management has relational and schema-free data stores working simultaneously to solve a single problem.

We demonstrate how we used hstore inside a Postgres database to elegantly solve the problem of generating solid business-intelligence from the dregs of emailed PDF and Excel files.

Speaking experience

This is a place holder for our development team, the final speaker is TBD.

Speakers

  • Biography

    I write code and like dogs and root beer.

  • Laurie Kemmerer

    Renewable Funding

    Biography

    I write code and like cats and beer.

  • Biography

    Dave Miller is a software developer at Renewable Funding.