Database setup for Weblate

[iKhalidObaid]

Hi ,
I have noticed in Weblate documentation, there were no mention of Oracle or SQL Server in Database setup for Weblate section. Is it not supported or compatible?

[nijel]

No, these are currently not supported.

[iKhalidObaid]

I might be repeating your point but please bear with me as i would like to understand this.

• So I must have postgresql to be able to run weblate there is no workaround? and weblate will not be able to start on any other database?

-As I've tried to connect to Oracle DB by using settings_override.py copied to /app/data (inside the container) unfortunately , Weblate showed the error ValueError: POSTGRES_DATABASE has to be configured!:

settings_override.py:
DATABASES = { "default": { "ENGINE": "django.db.backends.oracle", "NAME": ( "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.221)(PORT=5432))" "(CONNECT_DATA=(SERVICE_NAME=free)))" ), "USER": "weblate", "PASSWORD": "weblatePass", } }

Weblate logs:
custom-image]$ weblateLogs Starting Weblate 5.3.1... Creating /app/data/python/customize Traceback (most recent call last): File "/usr/local/bin/weblate", line 8, in <module> sys.exit(main()) ^^^^^^ File "/usr/local/lib/python3.11/site-packages/weblate/runner.py", line 19, in main utility.execute() File "/usr/local/lib/python3.11/site-packages/django/core/management/__init__.py", line 382, in execute settings.INSTALLED_APPS File "/usr/local/lib/python3.11/site-packages/django/conf/__init__.py", line 102, in __getattr__ self._setup(name) File "/usr/local/lib/python3.11/site-packages/django/conf/__init__.py", line 89, in _setup self._wrapped = Settings(settings_module) ^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/django/conf/__init__.py", line 217, in __init__ mod = importlib.import_module(self.SETTINGS_MODULE) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1204, in _gcd_import File "<frozen importlib._bootstrap>", line 1176, in _find_and_load File "<frozen importlib._bootstrap>", line 1147, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 690, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 940, in exec_module File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed File "/usr/local/lib/python3.11/site-packages/weblate/settings_docker.py", line 55, in <module> "NAME": get_env_str("POSTGRES_DATABASE", required=True), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/weblate/utils/environment.py", line 31, in get_env_str raise ValueError(f"{name} has to be configured!") ValueError: POSTGRES_DATABASE has to be configured! Failed to load configuration, please see errors above.

[nijel]

Only PostgreSQL, MariaDB, and MySQL are supported. See also https://docs.weblate.org/en/latest/admin/install.html#database-setup-for-weblate.

Moreover, the Docker image supports direct configuration for PostgreSQL only as that is our recommended database server, see https://docs.weblate.org/en/latest/admin/install/docker.html#mysql-or-mariadb-server.

Adding support for other Django supported databases should be possible, the most important thing we handle using database-specific code is full-text search, which should be doable using https://www.oracle.com/database/technologies/appdev/oracletext.html.