New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support PostgreSQL or MariaDB #775

Open
AMDG2 opened this Issue Jan 11, 2019 · 8 comments

Comments

Projects
None yet
7 participants
@AMDG2
Copy link

AMDG2 commented Jan 11, 2019

It seems you support only MySQL server which is packaged by none of the majors Linux distributions today.

Is it possible to support either PostgreSQL or MariaDB just to allow administrator to easily deploy PixelFed ?

@ITwrx

This comment has been minimized.

Copy link

ITwrx commented Jan 11, 2019

i use mariadb on everything where mysql is called for. laravel docs still show mysql as supported with no mention of mariadb. i don't know what that's all about, but i use mariadb on all my laravel apps and it's supported on Homestead (laravel dev's own proprietary laravel hosting platform/app), i think.

IOW, pixelfed looks to be a laravel app so i'm sure mariadb will work fine, though official upstream, and subsequently pixelfed, support would be preferred.

@Findus23

This comment has been minimized.

Copy link

Findus23 commented Jan 11, 2019

I am using pixelfed with MariaDB 10.3.12 and didn't have any database-related issues (yet).

But I agree that pixelfed should support at least one database that is supported in every major Linux distribution (So probably PostgreSQL 9.6+ and/or MariaDB 10.1+)

@dansup

This comment has been minimized.

Copy link
Member

dansup commented Jan 11, 2019

@AMDG2 Supporting other database drivers is on the roadmap.

@asonix

This comment has been minimized.

Copy link

asonix commented Jan 11, 2019

FWIW I'm running Pixelfed in production on Postgres right now and things mostly seem to work. I needed to run a couple commands to make the DB play nice after migrations were done but otherwise it seems okay

@JohnD28

This comment has been minimized.

Copy link

JohnD28 commented Jan 12, 2019

@asonix

Postgres instaces are already too buggy for regular use.
The risk is that it will get worse and worse :(

@asonix

This comment has been minimized.

Copy link

asonix commented Jan 12, 2019

well, guess I'll stop hosting when it breaks

@darix

This comment has been minimized.

Copy link

darix commented Jan 13, 2019

@asonix do you have any documentation about the needed changes/patches for running on postgresql?

@asonix

This comment has been minimized.

Copy link

asonix commented Jan 13, 2019

@darix from #677 there's

ALTER TABLE profiles ALTER COLUMN bio TYPE CHARACTER VARYING;

and then to fix the next issue

ALTER TABLE notifications ALTER COLUMN profile_id DROP NOT NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment