Personal environments have a database limited to 2GB. The database stores :
System data: the meta data used by OutSystems Platform. This includes the applications definition, data model, module configurations, logs, application versions, and other information. The system data usually grows as you develop and deploy your applications;
Application data: the is the data your applications generate and manipulate. The application data usually grows as your users access your applications.
Check how much database space you have
Access your personal environment on https://<yourpersonal>.outsystemscloud.com, and navigate to the Environments tab.
In this example, we are only using 13% of the available database storage space.
You can also check how much is being used for system data, and application data. Click the View details link.
Note that these metrics are updated every hour, so they might not represent the real space you are using at the moment.
Free up system data
OutSystems Platform periodically cleans up system data, like older application versions. You can also free up some system data manually.
- Navigate to the environment management console at https://<yourpersonal>.outsystemscloud.com/ServiceCenter;
- Click on the Factory tab;
- Click on the eSpaces submenu option. Then click the Check Old eSpace Versions to Delete link;
- Choose the time period to delete, and click the Check versions to delete button.
You can then delete those module versions to free up some system data.
Free up application data
Application data is basically all the information that is stored in the database Entities of your applications.
Our recommendation to control the amount of application data stored, is to have a good data model, and only store in the database what you really need. If you store files or large chunks of data in the database and will never use them, consider deleting them from the database, or storing them on external services like Amazon S3, Box.com, Google Drive or Dropbox.
To prevent data loss, OutSystems never deletes any database table or column, even when you delete them on the IDE. So it's possible that some database storage is being for this. You can use the DB Cleaner API to programmatically delete these database columns and tables that are no longer in use.
This content was originally posted in the Community Forums: How-To: Database Usage Control in Personal Environments