Some of you may know that we are currently developing two systems – Navigator and Navigator365. It was with Navigator365 that we made the decision to move databases from Microsoft SQL Server (MSSQL) to PostgreSQL. Why did we decide to take such a decisive step? There were several good reasons for this.
Lower licensing costs
Microsoft SQL is an excellent product, widely used in medium and large enterprises. Unfortunately, changes in licensing make it too expensive for smaller customers. Using some database components significantly increased installation costs, requiring higher (and thus more costly) licensing models.
More flexibility in the operating environment
PostgreSQL can be installed on virtually any modern operating system such as Windows, Linux or macOS. This allows us to install it on our existing infrastructure without having to buy additional licenses, for example.
JSON data support and NoSQL functionality
Modern applications are increasingly using flexible data structures. PostgreSQL enables native storage and processing of data in JSON format, which opens up new opportunities for Navigator365 development.
The openness of the code allows you to add your functionality
PostgreSQL allows you to add your own functions, operators or data types. This allows us to customize the database to meet the specific requirements of the system without the limitations of a closed ecosystem.
There are at least a few more reasons. But we can already say that yes – it was worth it. You can read about all of them on the Navigator365 website.
All in all, all data migration to PostgreSQL allows us to better adapt Navigator365 infrastructure to the requirements of modern applications. We gain more flexibility, control over data and lower maintenance costs. It’s a step toward a more scalable and efficient system that will better support the growth of our users in the future.
He feels best creating, that’s why he is in charge of creative marketing at the company. He writes a lot – mostly popular science articles for Holistic.news but other times fantasy "drawer novels". He also designs tabletop games and likes to treat it as a "break from digitization".
