Mocking database or in-memory database

[jellyninjadev]

Hello, I was thinking to run my migrations with pg-mem to my Postgres database.
Is there a way for me to do that?

[pkit]

What's the problem with using a disposable docker image?

[ambita-hme]

pg-mem supports migrations with node-pg-migrate format numbering format since the file prefix is sequential.
If you store the migrations in a /migrations folder in the root of your project you can just call.
await db.public.migrate();

Or specify the path with migrationsPath, i.e
await db.public.migrate({ migrationsPath: Path.resolve(__dirname, '../../migrations') });

This is on the pg-mem database object

[Shinigami92]

If I understand @ambita-hme's comment correctly, this is a (workaround) solution.
I think there is no error with using pg-mem or a real postgres docker container
node-pg-migrate just generates the SQL statements and sends them via pg-connection to the DB instance