search

ever-co / ever-traduora

Ever® Traduora™ - Open Translation Management Platform - https://traduora.co
https://traduora.co
GNU Affero General Public License v3.0
1.97k stars 197 forks source link

[Feature] Ability to use PostgreSQL #390

Closed vvadymk closed 3 months ago

vvadymk commented 11 months ago

Is your feature request related to a problem? Please describe.

Add the ability to use PostgreSQL in addition to MySQL

evereq commented 11 months ago

Duplicate to https://github.com/ever-co/ever-traduora/issues/75, but let's keep it open for now till we finish it as PR connected to it :)

evereq commented 10 months ago

@vvadymk , I tried your PR (merged it to our repo branch and did few tiny improvements). I was able to register / login and create project, etc, but I am getting error in the terminal output (not in UI), see below

postgresdb  | 2023-09-16 19:08:09.388 UTC [82] ERROR:  missing FROM-clause entry for table "projectlocale" at character 8
postgresdb  | 2023-09-16 19:08:09.388 UTC [82] STATEMENT:  SELECT projectLocale.localeCode AS "localeCode", count(*) AS "translated" FROM "project_locale" "projectLocale" LEFT JOIN "translation" "translations" ON "translations"."project_locale_id"="projectLocale"."id" WHERE "projectLocale"."id" IN ($1) AND "translations"."value" <> '' GROUP BY localeCode
traduora    | QueryFailedError: missing FROM-clause entry for table "projectlocale"

I am using PostgreSQL v15, maybe it's related? You can try using docker-compose I created if you pull branch https://github.com/ever-co/ever-traduora/tree/feat/postgres and run docker-compose -f .\docker-compose.postgres.yaml up --build

evereq commented 9 months ago

Hey @vvadymk will you be able to take a look into those issues over the next weeks?

vvadymk commented 9 months ago

Hi @evereq. Yes, I will be able to look into those issues this week

evereq commented 5 months ago

Hey @vvadymk I assume you did not have time to finalize this one, should I assign our engineer to work on it? (unless you already make it working?)

vvadymk commented 5 months ago

Hi @evereq! Sorry, I have a lot of work last weeks. I remember what need to be fixed here, I will add this task to my calendar for this weekend. I will do it.

vvadymk commented 5 months ago

Hi @evereq . Just let you know, I am working on fix, it is in progress. Will finish it soon

bakdakonusuruz commented 2 months ago

@vvadymk , I tried your PR (merged it to our repo branch and did few tiny improvements). I was able to register / login and create project, etc, but I am getting error in the terminal output (not in UI), see below

postgresdb  | 2023-09-16 19:08:09.388 UTC [82] ERROR:  missing FROM-clause entry for table "projectlocale" at character 8
postgresdb  | 2023-09-16 19:08:09.388 UTC [82] STATEMENT:  SELECT projectLocale.localeCode AS "localeCode", count(*) AS "translated" FROM "project_locale" "projectLocale" LEFT JOIN "translation" "translations" ON "translations"."project_locale_id"="projectLocale"."id" WHERE "projectLocale"."id" IN ($1) AND "translations"."value" <> '' GROUP BY localeCode
traduora    | QueryFailedError: missing FROM-clause entry for table "projectlocale"

I am using PostgreSQL v15, maybe it's related? You can try using docker-compose I created if you pull branch https://github.com/ever-co/ever-traduora/tree/feat/postgres and run docker-compose -f .\docker-compose.postgres.yaml up --build

Hi @evereq , I'm still getting the same error, did you guys managed to solve it? (I used 'develop' branch)

evereq commented 2 months ago

@bakdakonusuruz would you mind creating a separate issue and copying that error description to it, we will try to look into it more, but last time I tried to run docker-compose it was all good with PG DB...