Use of Budibase couchDB and its replacement

[naveenkumar1012]

Hi,

We are hosting budibase on our EKS cluster(K8s). We want to know the detailed use of couchdb cluster which is created by budibase chart. What the good alternatives of it(third party) and how to use those?

[phamalda]

Good day, Naveen. I am certainly no Budibase Pro but has been really important for me to keep in mind that CouchDB is a NoSQL DBMS.
If you'd prefer to use a relational data source, there are many available to include several SQL databases to include SQL Server, MySQL, PostgreSQL, and even Oracle if you've got the coin.
You can see all of those just by clicking the plus sign to add a new data source.

[naveenkumar1012]

@phamalda : Thank you for your post!
I want to know what's the use case of having couchDB, what are we storing inside that.

[mike12345567]

Hi @naveenkumar1012 - CouchDB is used to store everything that makes up a Budibase app - app definitions, automation information, internal table data, user information and so on. Couch acts as the store for everything that makes Budibase apps function.

Right now there isn't a way to swap out CouchDB for another database for these purposes, but you can connect any RDBMS you would like to store your data in, if you utilise say Postgres none of the data within those tables will be stored inside CouchDB.