29 May '14, 3pm

@bdon Hey Brandon, I wonder if you have any Sequel + PostGIS tips/tricks/code; ref: Thinking about making some soon.

Sequel is a wonderful library for interacting with relational databases. Some of my favorite aspects: 1. Out-of-the box support for foreign key constraints. 2. Straightforward migration DSL. 3. Support for all major free RDBMSes and even some proprietary ones. Also JRuby support through JDBC. (although JDBC doesn’t necessarily give you all the features a native driver would. Projects like jruby-pg are making progress though.) 4. “One way to do it” for common operations such as inserts and updates. Parsimonious API (compared to ActiveRecord). 5. bin/sequel executable gives you an interactive ruby session directly from a database URL. 6. Extremely powerful Dataset abstraction lets you write general query code. 7. The source code itself is a pleasure to work with and the maintainer (jeremyevans ) is extremely diligent about pull requests. One feature i’d like to expand upon i...

Full article: http://pivotallabs.com/access-your-databases-best-feature...

Tweets