Skip to content

PostgreSQL migration #429

Open
Open
@builder-247

Description

@builder-247

Limitations of MongoDB:

  • Querying nested json data is really slow - this caused custom leaderboards to break at around 80k players
  • Since MongoDB stores key/value pairs, it takes a lot of storage space

PostgreSQL's JSONB format allows us to store the same data taking less space and being faster to query.

One big downside is that a lot of the API functionality has to be rewritten, for example a lot of filtering relies on MongoDB's query language.

Checklist moved to PR

Metadata

Metadata

Assignees

Labels

importantIssues that should be focused onrefactorCode that should be improved

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions