Rationale
In real-world applications, the choice between local database and cloud-based approaches generally depends on factors such as project size, user count, data size, and security measures. In this post, we will discuss the differences and advantages between local database and cloud-based approaches for mobile applications.
Differences and Advantages
Local Database:
- Database Responsibility: Managing the database and ensuring security is your responsibility.
- Data Storage: Data is stored on the local device and does not require internet transmission.
- Security: Since data is stored on the local device, security risks associated with internet transmission are reduced.
Cloud Based:
- Database Responsibility: Managing the database and ensuring security is the responsibility of the cloud provider.
- Data Storage: Since data is stored on cloud servers, it eliminates the need for local storage.
- Security: With the security measures and processes of cloud providers, your data remains secure.
Local Database Implementation
In a project I did for a manufacturing ERP, when we chose to use a local database in the mobile app, we kept the responsibility for data storage and security in our hands. This increased the application’s speed and allowed users to enter data more smoothly. However, as the data grew, managing and updating the database became more challenging.
Cloud Based Implementation
In another project, we opted for a cloud-based approach. Having the cloud provider manage the database and ensure security was a huge advantage for us. However, since it requires data transmission, as the data size increases, costs rise and internet transmission takes more time.
Conclusion
The choice between local database and cloud-based approaches for mobile applications generally depends on factors like project size, number of users, data volume, and security measures. In this post, we covered the differences and advantages between these two approaches. Since both approaches have their own pros and cons, the choice should be made based on the project’s specific requirements.
Resources
📚 Click here to read my previous post and understand the differences and advantages between local database and cloud-based approaches for mobile apps: Mobile App Features: Local Database vs. Cloud-Based.
👍 In this post, I explained the reasons why I preferred the cloud-based approach. If you are interested in this topic and would like to get retrospective information about the cloud-based approach, feel free to contact me.