Limitations

Right now on Database we have the follow limitations:

1. REST API Usage: Limitations on POST and DELETE Methods

   POST Method:

   • Single Entry Only: The POST method is designed for creating or updating one entry at a time. Bulk creation or updates are not supported.

   DELETE Method:

   • Individual Deletion: The DELETE method allows for removing only one entry per request. Bulk deletions are not possible yet.

   Rationale:

   • Data Integrity & System Stability: These limitations prevent mass changes that could lead to data loss or system strain.

   • Control & Security: Ensuring modifications are deliberate and individualized enhances data security.

   Recommended Approach:

   • Sequential Modifications: For multiple entries, use separate, sequential API calls.

   • Test Before Implementing: Always test API calls in a controlled environment.

   For further assistance, please contact our support team.

2. Table UI: Limitation on removing data

   • Right now, it's not possible to remove data on the table page. You can only add or update data.

   This is something we are going to change in the future.

3. Table Column Name Changes: Not Permitted

   Changing the names of table columns is not allowed due to the following reasons:

   • Data Consistency: Fixed column names ensure consistency across the database, which is crucial for data integrity and accurate query processing.

   • System Integration: Many system functions and integrations rely on predefined column names. Changing these names could disrupt these dependencies, leading to system errors and data retrieval issues.

   For maintaining database stability and reliability, it's essential to keep column names unchanged.

4. Import Limitation on Storage Type Column

   Currently, importing data directly into the Storage type column is not possible.

5. Index creation:

   • Query Parameters Limitation:

     • You can perform queries using parameters. However, if a query involves more than two parameters, an index must be created to facilitate the search.

   • Index Creation Time:

     • Creating an index for complex queries (with more than two parameters) is not instantaneous. It can take several minutes to complete. This is necessary to ensure efficient data retrieval and maintain overall system performance.