Simcall
Type
Industry
Country
USA
Highlights
- Setup of an AWS backup database
- Creation of migrations to add new database objects
- Implementation of new APIs on the backend application
- Addition of a new set of queries to Retool
Challenge
The client is a communications carrier who takes a long-term or short-term lease on wireless cellular connectivity and resells it both to individual users and businesses. For businesses, the main advantage in purchasing from the client is that a business owner can simulate various scenarios (i.e., a massive volume of phone calls) and test how well their system performs under such load.
When the client approached SoftTeco, he already had an application for collecting and analyzing information on postpaid wireless cellular connectivity. The application was built on Retool and the client requested us to design a similar solution for the prepaid wireless cellular connectivity. The main challenge was, however, that the client needed the application to consist of two parts: one for viewing the general information on all lines and the other for the grouped view.
Solution
Simcall is an application for managing and monitoring prepaid wireless cellular connectivity on the base of the Retool tool and the Postgres database. The application consists of two parts: one is used for managing general information on all prepaid wireless cellular connectivity, and the other provides a comprehensive grouped view. The grouped view is intended for when a carrier has one main line and several sublines, belonging to the main one. In this way, users can find the needed subline easily and in a faster manner, as well as finding how many spots are left in the group to fill them up.
Tech Stack
Backend
Python
AWS RDS (Postgres)
Frontend
Retool
React
JavaScript
Tailwind
Vite
How it works
The application is based on the Retool platform and the Postgres database. Since the SoftTeco’s team designed the app from scratch, we had to take care of both frontend and backend parts of the application. For the frontend, we had to redesign the app’s logic (using the existing application for postpaid lines as a base) so it enables general data scanning for all lines and a drill-down for the grouped view. The new application also required new indications for the database (whether the line is main or not) and new filters, which we enabled by using JavaScript.
Need a high-performing solution to augment your business?
Let SoftTeco handle your tech challenges and design a software solution tailored precisely to your unique requirements.
In order to switch from using Retool to creating an independent frontend application, the team used Vite, React and Tailwind. We also created new views (i.e., pages) by following a specific and updated business logic and added a new set of queries to the Retool service.
As for the backend part of the application, SoftTeco first stabilized the existing production database and disclosed multiple potential transaction lockers on the database. We then created migrations to add several new database objects according to the provided business logic. To ensure that the product functions as intended, the team added a staging database to test the migrations before running them on the production database. In addition, we added an Excel adapter to convert Google Sheets tables into database entries and added a separation of environments. This enabled the application to make requests to the production and staging databases independently.
Results
The SoftTeco team delivered a high-performing application that fully meets the client’s requirements and allows him to effectively manage both prepaid and postpaid lines. Right now, we continue working on the project, adding enhancements and improvements.
