Convertigo Public Knowledge base

CouchDB database size management

The No Code Studio and PWA forms rely on the noSQL database CouchDB server.

Forms response are stored in the c8oforms_response_fs database.

Depending on the number of pages, inputs and files or images you can upload, the database size can grows drastically.

We will present here some tools to manage the database size.

The first custom project is used to directly and definitively delete the forms reponses. It will identify the documents to delete, count them, then, database will be purged and compacted:

convertigo_tools.car

Another tool, less specific, will let you manage all your databases. You will have statistics about the databases size, fragmentation percentage before you can apply changes to databases:

GitHub - convertigo/c8oprj-lib-compactcouchdb: Convertigo Library that help to compact CouchDB databases and views

(c) Convertigo 2023 https://www.convertigo.com