mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Month: September 2022

How to create a web-based data management system in 7 minutes

analyticsHow easily (and securely) can you manage your business data? In my experience, businesses typically answer this question in one of three ways:

1.“We use spreadsheets to manage data”.
This is probably the most common response, but also the riskiest approach. Sure, spreadsheets are readily available and easy to work with. They do the job when you only have small amounts of data. The problem is that many businesses stick with this approach as their data grows. This is a mistake. Why? Spreadsheets aren’t designed to be multi-user data management tools. When you’re managing lots of data across many users, spreadsheets will waste time and lead to data errors.

2. “We don’t really have a good way for users to manage data.”
In many companies, data just sits in the database–inaccessible to business users. Sure, the IT department can run reports and make changes but no one else can.

3. “We have a web-based database management system.”
This is the ideal response. A web-based data management system provides a secure way for end users to manage database tables using a web browser. Security is in place to ensure that users can’t see or manage data that they’re not authorized to manage.

If you don’t have a web-based data management system yet, how do you create one? We’ve recently published a video that walks you through the whole process. In this video, we create three different applications that let users view and manage their database tables from a web browser. Then, we’ll add security to ensure that only specific users can modify the database. Finally, we’ll wrap everything up into a data management portal so users can easily access all of the applications. All this in 7 minutes! You can watch it here:

Want to learn more? Set up a demo here: Set up a demo.