Does Easy!Appointments supports Postgres?

[Matus]

Does Easy!Appointments supports Postgres? 

[Matus]

oh found it, this needs to be changed 

$db['default']['dbdriver'] = 'mysqli';

to `postgre` 

On Wednesday, 17 September 2025 at 14:32:55 UTC+2 Matus wrote:

Does Easy!Appointments supports Postgres? 

[Matus]

Hmm so I did the change above, build the image locally and run it as this docker compose

services:

easyapointments:

image: easyappointments:v1.0.1

restart: always

ports:

- '80:80'

environment:

- BASE_URL=http://localhost

- DEBUG_MODE=TRUE

- DB_HOST=postgres

- DB_NAME=easyappointments

- DB_USERNAME=postgres

- DB_PASSWORD=secret

- MAIL_PROTOCOL=mail

- MAIL_SMTP_DEBUG=0

- MAIL_SMTP_AUTH=0

- MAIL_SMTP_HOST=smtp.example.org

- MAIL_SMTP_USER=

- MAIL_SMTP_PASS=

- MAIL_SMTP_CRYPTO=tls

- MAIL_SMTP_PORT=587

- MAIL_FROM_ADDRESS=in...@example.org

- MAIL_FROM_NAME=Example

- MAIL_REPLY_TO_ADDRESS=in...@example.org

volumes:

- easyappointments:/var/www/html

postgres:

image: postgres:15

restart: always

ports:

- '5432:5432'

environment:

- POSTGRES_PASSWORD=secret

- POSTGRES_DB=easyappointments

- POSTGRES_USER=postgres

volumes:

- postgres:/var/lib/postgresql/data

volumes:

easyappointments:

postgres:

And getting now error with 

http://localhost/index.php --> The requested URL was not found on this server.

is this expected? Thanks for any info, and thank you for your great work, the app is awesome! 

[Matus]

From the answer in https://discord.com/channels/513770643947257862/513771577142280214 

"Hello! There are currently some queries in the app and structure that might be MySQL / MariaDB specific. One would have to go through these and see if they need to be fine tuned Other than that for the most part the query build of CI3 is used, which already supports postgres So there would need to be code changes too before this work"

[Alex Tselegidis]

That's right, some of the queries might not work with Postgres and might need to be updated. 

I do not expect them to be many, but they require a thorough test before getting this change to production. 

Alex Tselegidis, Easy!Appointments Creator
Need a customization? Get a free quote!