What database or solution to choose to replace Excel?

Question

CRM

Hello colleagues.

I ask for expert advice on choosing a database solution.
I want to create a database for working with clients (subscribers) with output to Excel. Now this task is solved by Excel in the database of which there are more than 500,000 rows (clients) and, of course, it slows down.

What functionality is needed:
Reports - month, quarter, year (for engineers, accounting and management).

Filters for chart selection and database search. It is necessary to sort and display visits of subscribers by our employees.

Sharing one file (editing) + logging user changes. Ability to rollback on error.

Attaching data from GPS trackers.

Separation of access by department

Ability to export to 1C

Speed

​​Hardware:
Supermicro SYS-6028R-TR
Virtual machines on esxi 6.0
Nas microtik and 2 gigabit switches I am

considering mostly free and open source solutions.

Answer 1

Answer 2

And why then at once 1C not to use? There are exactly two open source databases - muscle and postgres, both are good enough for your task. But the database is a database, you need to show it somehow :) Here you can either look for a ready-made face, or sculpt it yourself.

Answer 3

bases at least chew your ass
, but the visualizations for them - from CRUD to OLAP panels - gulkin's nose, in fact, your costs will run
into CRUD of the CRM type, and there are just no free ones, those that are - miserable + dependence on someone else's data scheme,
therefore you can push off from Redash and Python - a framework for some kind of CRUD
base - MariaDB with bells and whistles (Columnstore there and all that)

Answer 4

If your reporting format often does not change, then look towards PowerBI. It is a powerful tool for reporting on large datasets.
The database can be used MySql - and large volumes can be digested and placed anywhere.