GovLens icon indicating copy to clipboard operation
GovLens copied to clipboard

Migrate DB to use Postgres

Open morisy opened this issue 6 years ago • 3 comments

So that the database remains stable, we need to swap from SQLLite to PostGres. This is a relatively high priority item so that we can ensure data is dropped properly in.

We’ll also need to make sure this works well with the deployment process after we move the code over.

morisy avatar Oct 01 '19 23:10 morisy

@morisy Need any help or any remaining tasks that I could help with? 😄

JakeTobin avatar Feb 05 '20 01:02 JakeTobin

@JakeTobin I would check in with @kbalajisrinivas or @gsireesh next time they're in! This is above my knowledge grade.

morisy avatar Feb 05 '20 01:02 morisy

Hi! Sorry, I've been out. @JakeTobin the code was already set up when I started working on this, but definitely needs a little bit more documentation. There are environment variables defined implicitly in the settings file that, when set, will cause the server to connect to a PG instance rather than a SQLite store.

gsireesh avatar Feb 10 '20 16:02 gsireesh