Running node-postgres in memory

Question

I'm using Node and the node-postgres package and I would like to perform some unit tests using jest and supertest without saving to the actual database.

When using sequelize it is possible to configure the storage in memory, like so:

const sequelize = new Sequelize({
  ...
  storage: ":memory:"
});

I know it is possible to set the dialect to Postgres in sequelize, but I was wondering how would one go about to set the in memory storage using node-postgres. Is that possible?

Thanks

Shankar · Accepted Answer · 2022-05-03 14:59:35Z

1

I think in sequelize that ":memory:" storage would be available only for sqlite like in memory databases. It isn't possible to run postgresql in memory so you can't connect to in memory postgres from node-postgres/any client.

You can refer this answer for more details (Using in-memory PostgreSQL)

answered May 3, 2022 at 14:59

Shankar

3701 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eulavo Over a year ago

Thank you. Would it be considered a bad practice to create a local database , separated from the actual database, just to run tests?

Shankar Over a year ago

That's the way to do it I think. You can have different test database for running tests.

Oleksandr Hrin · Accepted Answer · 2022-12-06 14:58:30Z

0

for my approach I'm using docker-container with clear postgres server, which is getting up before all the tests.

then I run all migrations and seeds, then I run all the tests, then I kill that container. All that stuff is done automatically.

But I'm using it in mocha/chai, and using globalSetup and globalTeardown hooks for that. Don't know if it is possible in Jest

answered Dec 6, 2022 at 14:58

Oleksandr Hrin

9361 gold badge12 silver badges14 bronze badges

Collectives™ on Stack Overflow

Running node-postgres in memory

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related