Database maintenance

This section covers copying, restoring and running bulk operations on the database

This section covers different ways in which you can maintain your database to keep it running efficiently. If you want to learn more about the database in general and how it works, you can check out our dedicated article series below.

Article series: The database

The database is the filing cabinet of your application, where all data is archived for storage. Just like a regular archive, it makes sense to keep it clean and up-to-date.

This is a good idea for a few reasons:

  • Performance: The more unnecessary data you keep around, the bigger your database becomes. This means more data for Bubble to search through and overall can affect your performance

  • Privacy: Removing unneeded data is good from a privacy perspective

  • Data integrity: As you scale and grow your app, a clean database can help you with decision making, since you can confidently make decisions based on reliable data

This article series goes over a few different concepts that helps you maintain your database properly.

Copying the database

Copying the database means to clone the content of the development database into the live database or vice versa. This is a simple, automated operation in Bubble.

Article: Copying the database

Restoring database backups

Bubble keeps automated that can be restored back to that state with a simple operation.

Article: Restoring database backups

Running bulk operations

Bulk operations means to run a workflow on multiple things in your database in sequence. This helps you perform tasks that would be tedious to do manually, such as deleting and making changes to things.

Article: Bulk operations

Last updated

#686: Updates to SAWOL

Change request updated