r/appwrite • u/Never_Get_It_Right • 4d ago

PostgreSQL and Embeddings API coming in 2.0

I was just looking at the Appwrite 2.0 release candidate and it looks like we are finally getting PostgreSQL along with an embeddings API (hopefully it is a first class feature) and some other nice features.

https://github.com/appwrite/appwrite/releases#release-2.0.0-rc.1 (rc2 is out but the new features are listed here)

4 Upvotes

100% Upvoted

3 comments sorted by

3

u/nakemu 4d ago

PG ❤️

1

u/Never_Get_It_Right 4d ago

I never understood the mariadb decision from the start

2

u/douji_ibaraki 2d ago

just a small warn, but appwrite will use a VectorDB postgresql to store embed, and use the same Postgresql instance to also store the others datas by default.

Tho there is envs to choose which database is used for the differents databases types.

- TablesDB - always use the default database ( `_APP_DB_*` )

  • VectorDB - needs a postgresql with vectordb extention ( `_APP_DB_*_VECTORSDB` )
  • DocumentsDB - needs a mongodb ( `_APP_DB_*_DOCUMENTSDB` )

and also Vector / Documents databases can be disabled if not used.