search

mediacms-io / mediacms

MediaCMS is a modern, fully featured open source video and media CMS, written in Python/Django and React, featuring a REST API.
https://mediacms.io
GNU Affero General Public License v3.0
2.7k stars 498 forks source link

Documentation on setup using MySQL instead of PostgreSQL #571

Closed KyleMaas closed 1 year ago

KyleMaas commented 1 year ago

Describe the feature you'd like Django supports running atop MySQL. It would be nice if the setup instructions gave alternate instructions for using MySQL from the start instead of assuming PostgreSQL.

mgogoulos commented 1 year ago

I will close this as there are some features that work only with PG - as the full text search / vector search and this prohibits the usage of MySQL or another DB...

KyleMaas commented 1 year ago

Is there a full list of the components that rely on Postgres-specific features? Reason being that it would be quite nice if I could run MediaCMS on MySQL Galera clusters.

mgogoulos commented 1 year ago

Is there a full list of the components that rely on Postgres-specific features? Reason being that it would be quite nice if I could run MediaCMS on MySQL Galera clusters.

Hi, that would be 

files/feeds.py:from django.contrib.postgres.search import SearchQuery
files/models.py:from django.contrib.postgres.indexes import GinIndex
files/models.py:from django.contrib.postgres.search import SearchVectorField
files/views.py:from django.contrib.postgres.search import SearchQuery

basically, search relies on GinIndex (https://docs.djangoproject.com/en/4.1/ref/contrib/postgres/indexes/) and PostgreSQL related functionality (https://docs.djangoproject.com/en/4.1/ref/contrib/postgres/) there's a chance that this is now supported for MySQL as well but this has definitely not been the case 2-3 years ago

KyleMaas commented 1 year ago

Cool. That gives me something to go on. Thanks!