search

pikelang / Roxen

Roxen Webserver
Other
16 stars 6 forks source link

Exploring Database Connectivity with Roxen: Local vs. Remote Configuration #8

Open abdellahi-brahim opened 5 months ago

abdellahi-brahim commented 5 months ago

Hello!

It appears that Roxen manages its database using a path specified in a file named "mysql-location.txt," suggesting that the database needs to be located on the same system as Roxen. Additionally, Roxen seems to handle database upgrades and fixes itself. This makes me wonder if it's possible for Roxen to connect to a remote database, or if it's restricted to databases located on the same filesystem.

Could you clarify that?

grubba commented 5 months ago

Roxen uses a MySQL or MariaDB for internal purposes. This does not preclude accessing other databases for other purposes.

abdellahi-brahim commented 5 months ago

And from what I understood this database is managed by Roxen through the binaries right? I want this database to be a remote one, is it possible or would it require a major refactor?