my current preference are as follows
postgresql for transactional logs
clickhouse for analytics data
elasticsearch or quickwit for terabytes of data, disk persisted, if i need thorough search on structured jsons
---
others i use for different use case
typesense for searching mbs to gbs of data, memory persisted
redis for caching kbs of data, memory persisted