Use Postgres in Development

[harshkhandeparkar]

Replace the sqlite3 development database with Postgres to better represent the production environment.

[shikharish]

Pls assign me this.

[shikharish]

I belive these env variables would also have to be included if postgres is used. And README has to be updated as well.

DATABASE_HOST=
DATABASE_PORT=
DATABASE_NAME=
DATABASE_USERNAME=
DATABASE_PORT=

[harshkhandeparkar]

@shikharish assigned. What is your plan here?

[shikharish]

@harshkhandeparkar Turns out it won't be as trivial as I thought it would be. The solution I can see right now is using a postgres docker container.

[harshkhandeparkar]

@harshkhandeparkar Turns out it won't be as trivial as I thought it would be. The solution I can see right now is using a postgres docker container.

Hmm. Is there no way to run a postgres db from a file?

[shikharish]

We can but I think it would be more difficult to configure(like username, password, port etc. which would be easier in case of a container).

[shikharish]

We can but I think it would be more difficult to configure(like username, password, port etc. which would be easier in case of a container).

We can import an SQL file into a postgres database, not directly run the file.

[harshkhandeparkar]

We can but I think it would be more difficult to configure(like username, password, port etc. which would be easier in case of a container).

So the best way is to set up the container separately?

[shikharish]

Yes.

[harshkhandeparkar]

How would we do this for the CI tests?

[shikharish]

How would we do this for the CI tests?

Haven't looked into the tests. Where can I find them? (Should we continue this on Discord?)