Migration
Development of a New Database
This is how we helped a consulting company set up a new database with Retool and PostgreSQL.
This is how we helped a consulting company set up a new database with Retool and PostgreSQL.
The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.
A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!
Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.
A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!
Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.
By restructuring the inventory data of doctors and clinics, we were able to support our client with the creation of a structured database.
Our client supported clinics and medical practices as a strategy consultant in the search for new medical staff and succession planning. To this end, it had a comprehensive database that recorded every doctor and every clinic in Germany. On behalf of its customers, the company then searched for medical specialists in a specific region, for example. The research was the basis for targeting potential successors to take over a medical practice.
Previously, however, it was very time-consuming to sift through and filter the database according to the right criteria, as the data was hardly structured and technically unclean. Many companies that work with extensive data face this problem. The customer therefore wanted to define the filter criteria with just a few clicks in order to display the right doctors or clinics directly.
As a solution to our customer's issue, we set out to create a structured database. As a first step, we cleaned up the existing database, structured it and set it up again with SQL using PostgreSQL. In the next step, we set up a user-friendly front end with Retool to relieve the employees of the tedious work with SQL requests. This easy-to-use interface allows users to set the appropriate filter criteria with just a few sliders, checkboxes, and search fields. In particular, a specific region can be quickly filtered out by entering the zip code and a permitted radius.
Our customer's employees were then able to export the search results with two mouse clicks, which were then easily available for further use. In this way, the CSV export could be imported back into a mailing campaign tool and the medical staff could easily be used as recipients.
With the new structured database, our customer not only saved a lot of time in their research, but also benefited from more precise results. This not only added value for our customer – the organized database also made it easier for them to reach their own customers. Win-win!
