Which engine to choose for databases?

Question

Database design

Hello,
I can't select a database engine. I read other questions on this topic but did not find an answer.
The situation is this: I need an engine that will be fast in both fetch and write cases and reliable, like InnoDB, but full-text mode like MyISAM is badly needed. I can't choose InnoDB due to the lack of a full text feature and MyISAM I hear only negative reviews due to blocking entire tables and unreliability.
Can you advise a universal solution for such problems? (Writes and fetches from databases occur equally frequently.)

Answer 1

postgres!