I started down the road with TypeORM for my starter, and I ran into several pain points. I was reading the Knex docs last night actually, heavily considering switching. I also wrote a quick `pg.ts` file to just use node-postgres directly, but the lack of migrations is just too painful. I looked at db-migrate briefly but didn't come to any conclusion.
So that's a long way of saying, I think Knex was a good choice. Provides migrations, handles connection pooling and transactions, but doesn't deviate too far from SQL.
I started down the road with TypeORM for my starter, and I ran into several pain points. I was reading the Knex docs last night actually, heavily considering switching. I also wrote a quick `pg.ts` file to just use node-postgres directly, but the lack of migrations is just too painful. I looked at db-migrate briefly but didn't come to any conclusion.
So that's a long way of saying, I think Knex was a good choice. Provides migrations, handles connection pooling and transactions, but doesn't deviate too far from SQL.