Ive been writing SQL in an sql file and then converting them to Knex queries in Nodejs. This is taking much more time than I thought it would and have been using knex.raw a lot since it doesnt support lot of PostgreSQL features like ON CONFLICT, GENERATED BY, ::CASTING, etc and decided it might be better to just go with writing raw queries.I do love the knex migrations/seed feature and if anyone knows of an good library for migrations for node that would be helpful too.Ive been looking at these libraries for writing raw sql:node-postgress aka pgmassivejspg-promiseslonikFor migrations:postgres-migrationsAlso might just use knex for migrations only if there isnt anything better.Do you guys have any experience with any of these? I saw that pg was the most popular by far.https://www.npmtrends.com/pg-vs-pg-promise-vs-knex-vs-slonik
Submitted August 23, 2019 at 04:46AM by natpagles
No comments:
Post a Comment