3 ms·
Speaking of JS, do you guys have a suggestion for good SQL querybuilder and maybe a migration tool for Node? I prefer to do everything else by hand or use small
by parthdesai 8y ago
Speaking of JS, do you guys have a suggestion for good SQL querybuilder and maybe a migration tool for Node? I prefer to do everything else by hand or use smaller libraries.
Not that i don't know how to write SQL queries by hand, it's just raw SQL queries with conditions is just ugly.
- Lasokki 8y agoI've been satisfied with Knex.js. It handles query building, transactions, connection pooling and migrations https://knexjs.org/ https://knexjs.org/
- honopu 8y agoKnex is really nice. I use objection which extends it for orm stuff. The insert graph features are pretty neat. I definitely don’t use all it has to offer.
- tobyhinloopen 8y agoI really like TypeORM (for Typescript projects) & Knex (for non-TS projects)
- davedx 8y agoI'm using sequelize with an SQL Server database, it's decent so far. I do migrations by hand with a custom __migrations table.