[PR #158] [MERGED] Add MySQL support #559

New issue

Closed

opened 2026-02-25 21:32:14 +03:00 by kerem · 0 comments

kerem commented

2026-02-25 21:32:14 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/ciur/papermerge/pull/158
Author: @francescocarzaniga
Created: 10/10/2020
Status: ✅ Merged
Merged: 10/11/2020
Merged by: @ciur

Base: master ← Head: master

📝 Commits (3)

1a5ab58 DB type selection
38e6743 Add DB type to documentation
da69294 Field > 255 chars requires MySQL 5.7.7 or innodb_large_prefix

📊 Changes

3 files changed (+35 additions, -12 deletions)

View changed files

📝 config/settings/base.py (+13 -3)
📝 docs/source/settings.rst (+20 -8)
📝 requirements/extra.txt (+2 -1)

📄 Description

Added new variable DBTYPE to choose MySQL or PostgreSQL. Due to fields possibly longer than 255 chars MySQL 5.7.7 (or innodb_large_prefix on older versions) is required.
This is not working yet.
What is working:

Possible to choose backend from settings (DBTYPE)
Documentation updated
Right now migration aren't working, in particular 0001_initial and 0005_auto_20200419_0639 since they require PostgreSQL fulltext search (django.contrib.postgres.search.SearchVectorField)

Input from the author is necessary to decide how to rewrite the migrations, since fulltext search is not supported on MySQL.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/ciur/papermerge/pull/158 **Author:** [@francescocarzaniga](https://github.com/francescocarzaniga) **Created:** 10/10/2020 **Status:** ✅ Merged **Merged:** 10/11/2020 **Merged by:** [@ciur](https://github.com/ciur) **Base:** `master` ← **Head:** `master` --- ### 📝 Commits (3) - [`1a5ab58`](https://github.com/ciur/papermerge/commit/1a5ab585d2081140b2ffe6d6d041b0940cc7b9a7) DB type selection - [`38e6743`](https://github.com/ciur/papermerge/commit/38e6743741575c0f06b71a1b398fc4b1cdb2f95b) Add DB type to documentation - [`da69294`](https://github.com/ciur/papermerge/commit/da692947cfa117ae951e144f487f7e9f08e8093d) Field > 255 chars requires MySQL 5.7.7 or innodb_large_prefix ### 📊 Changes **3 files changed** (+35 additions, -12 deletions) <details> <summary>View changed files</summary> 📝 `config/settings/base.py` (+13 -3) 📝 `docs/source/settings.rst` (+20 -8) 📝 `requirements/extra.txt` (+2 -1) </details> ### 📄 Description Added new variable DBTYPE to choose MySQL or PostgreSQL. Due to fields possibly longer than 255 chars MySQL 5.7.7 (or innodb_large_prefix on older versions) is required. **This is not working yet.** What is working: - [x] Possible to choose backend from settings (DBTYPE) - [x] Documentation updated - [x] Right now migration aren't working, in particular 0001_initial and 0005_auto_20200419_0639 since they require PostgreSQL fulltext search (django.contrib.postgres.search.SearchVectorField) Input from the author is necessary to decide how to rewrite the migrations, since fulltext search is not supported on MySQL. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>