How do I find the database connection string - DIRECT_URL and DATABASE_URL(used for connection pooling)?
I have already implemented all db logic using the Prisma ORM and would require the connection string to connect to the database. Also does appwrite support PostgreSQL or are there any plans to release it in future as it currently uses MariaDB?
TL;DR
- Avoid connecting directly to the Appwrite DB, use Appwrite APIs.
- Appwrite currently supports MariaDB, not PostgreSQL.
- To obtain the database connection string:
- Use the DIRECT_URL or DATABASE_URL for connection pooling.
- Future plans for PostgreSQL support are not mentioned.
ideclon
5 Mar, 2025, 10:55
You should not connect directly to the Appwrite DB - use the Appwrite APIs for access.
ideclon
5 Mar, 2025, 10:56
Besides for the data structure not being very user-friendly, Appwrite implements caching, which could result in inconsistent data if the underlying DB is modified outside of Appwrite.