hybrid cargo
TypeORM is an Object Relation Mapper (ORM) that can handle several different database types (mysql, postgres, mssql, sqlite, etc). You could do that single table through it if you wanted to.
Seems like really you just need a simple database connection though, yeah? I'd make a custom provider for the connection object and inject the connection where it is necessary
Then you can do raw SQL queries where the connection is injected
stark forge
Then you can do raw SQL queries where the connection is injected
If I may raw SQL queries can easily become a burden even on simple projects
ORMs get things done right quickly at low cost
I find Sequelize easier to use than TypeORM but both are good and nicely supported by Nest
hybrid cargo
If I may raw SQL queries can easily become a burden even on simple projects
Can be. It really just all depends on what's being ran and written. I've personally really liked using kysely as a query builder, good Typescript support and a nice API to work with, but no hassle of setting up entities based on classes. A simple interface suffices and I can be on my way (plus I stop thinking that the ClassSerializerInterceptor is gonna do things for me cause I know I have to turn it into a class based on the result first 🙂
stark forge
Can be. It really just all depends on what's being ran and written. I've persona...
Very interesting I didn't know kysely I have at least one service that could really benefit from it
do you happen to know if there is a performance difference (even at small scale)?
hybrid cargo
Very interesting I didn't know kysely I have at least one service that could rea...
Nice little contrived example that uses it: https://github.com/jmcdo29/nest-e2e-sample
hybrid cargo
do you happen to know if there is a performance difference (even at small scale)...
Between it and what?
stark forge
say TypeORM