I had a chat with @ashleygwilliams about or DB strategy and how we can improve our situation here. She has suggested using bookshelf. Bookshelf appears to provide all we want: control over queries (via knex), transactions, connection pooling, and migrations
it's probably also a lot nicer on contributors over raw sql
:raised_hands: i have implemented the publish.webmaker.org API using it. see this PR for the knex implementation. will add the bookshelf stuff in a following pr.
I had a chat with @ashleygwilliams about or DB strategy and how we can improve our situation here. She has suggested using bookshelf. Bookshelf appears to provide all we want: control over queries (via knex), transactions, connection pooling, and migrations
it's probably also a lot nicer on contributors over raw sql
cc/ @simonwex