MongoDB

We use MongoDB to store invoices data, like total, items included, date. we use it to store and read data from it via an API with fast API and that's it. so far we have had zero problems.

• Reduced errors and load of invoices data by a factor of 10.

Spring Boot, Fortinet FortiGate, Portainer

In my organization, we use MongoDB as a temporary mid-size storage database. We have very large databases and process a massive amount of data per day. Throughout the day we identify notable events and records and need to extract them for continued analysis. This is where our MongoDB environment comes into play. We roll all of these detected records into MongoDB for further use.

• Speed at which we can store and query noteworthy data.
• Reduced downtime due to high availability.
• Save time due to quick setup and deployment.

MySQL

ServiceNow IT Service Management, Splunk User Behavior Analytics (UBA), Microsoft Azure

Quick application development in the cloud in a no-SQL environment. For POC purposes, we sometimes are able to get free usage and also can evaluate the loads on the system which can be exploited to estimate real-time loads.

• Quick spinning up of DB in cloud
• The documentation is really helpful
• no SQL expertise is needed

PostgreSQL

SAP ERP, SAP Cloud Appliance Library, SAP Business Technology Platform

Due to the software developments made, the institution's NoSQL technology was needed. Therefore, a solution was created by purchasing the enterprise version.

• It consumes a lot of RAM due to its in-memory feature. If you have a fast-growing structure, you should do the RAM memory planning well.

Redis™*, Microsoft SQL Server, RabbitMQ

We use it as one of the internal database types in our REST APIs via a Spring/JAP connection in high-load applications. MongoDB is highly scalable, and compared to traditional SQL systems, reads and writes much faster than SQL. What is done on Mongo is as simple and clear as possible, and if there are problems with the amount of data in relational databases, such “bicycles” will have to be invented that will reduce all the advantages of these databases to zero. It’s probably hard to do an initially limited project on ordinary relational databases, that is, not to think about what will happen when everything is slowly covered up ... It’s better to devote more time to the design of the initial data, which will remove all questions in the future.

• I’m at a loss to give numbers right away, but that’s exactly how the pool of threads is much smaller at high load due to the very high write and read speed of Mongo, as a result, we save up to $ 12,000 per month only on server rental.

Apache Cassandra and PostgreSQL

MySQL, Apache Cassandra