i am a newbie evaluating cockroachdb as a replacement for MariaDB.
i have been using node sequelize with postgresql and Mariadb for some time and find sequelize to be a great ORM. its really nice to be able to have a table model and structure queries using sequelize.
however when i try to use sequelize with cockroachdb, i ran into serious issues. The sequelize people sound pessimistic that sequelize will ever be compatible with cockroach.
here is their last response:
These queries are executed when we connect to new connection through our own connection pool, to set proper timezone and retrieve the proper OIDs. There is no option to turn them off and they are vital so we can’t allow that either.
This is now CockroachDB’s compatibility issue which they have to solve. I think you should switch to Postgres, what extra features CockroachDB offers?
yes there is a bit of bias here.
does anybody have any experience using sequelize.io, or is there a better node-ORM for cockroach-node?