Move the production PostgreSQL DB to the local machine

[goneall]

We're currently using an AWS RDB installation which is rather expensive and overkill for how it is being used.

To migrate the database, we'll need to:

• Update the production docker-compose.prod.yml file to create the PostgreSQL container
• Change the DB configuration for the Django app to point to the local PostgreSQL DB
• Migrate the data from the RDB database to the local database
• Shut down the RDB database

[bact]

Wonder if it is possible to use no database at all (under different architecture).

The SQL database requirement looks like mainly comes from Django and not the actual SPDX functionalities
(except the Redis server which is used by SPDX License Matcher to speed up license comparison).

[goneall]

Wonder if it is possible to use no database at all (under different architecture).

The SQL database requirement looks like mainly comes from Django and not the actual SPDX functionalities (except the Redis server which is used by SPDX License Matcher to speed up license comparison).

The database is used to track license submissions - very lightweight, but it does require a DB

[bact]

Thank you for clarification.

[bact]

Thank you for clarification.