You generally wouldn't "switch" from one to the other, they'd be used in concert for different purposes
MySQL/SQLite/PostGres fall under the "transactional" database category and others like DuckDB, Redshift, or Clickhouse are considered "analytical" ones and are meant for aggregating large volumes of data
It's a pretty deep topic so searching for something like "OLTP vs OLAP databases" will give you a lot of reading material
MySQL/SQLite/PostGres fall under the "transactional" database category and others like DuckDB, Redshift, or Clickhouse are considered "analytical" ones and are meant for aggregating large volumes of data
It's a pretty deep topic so searching for something like "OLTP vs OLAP databases" will give you a lot of reading material