openedx / openedx/openedx-core
Add PostgreSQL support
@qasimgulzar is already working on this.
Since Nov 11, 2024.
- Dominant language
- Python
- Stars
- 10
- Forks
- 32
- Avg merge
- 2d 17h
- Merged PRs (30d)
- 12
Description
This repo currently has a set of collation-related helpers that it uses to help normalize model collation behavior between MySQL and SQLite:
- https://github.com/openedx/openedx-learning/blob/main/openedx_learning/lib/collations.py
- https://github.com/openedx/openedx-learning/blob/main/openedx_learning/lib/fields.py
They manifest in the migrations files like this:
The MultiCollationCharField is also used in one place in edx-platform
Anyone looking to add PostgreSQL support would need to look for all instances of MultiCollationCharField and MultiCollationTextField and put the postgres-specific mappings there. That includes the convenience methods like case_insensitive_char_field in fields.py, as well as in the individual migration files that have the sqlite/mysql arguments serialized out.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.