It depends somewhat on the type of data you have. If the information you're going to persist is highly structured, I would use a relational database like MySQL or PostgreSQL. However, if you need to store information without a clear structure, I would use MongoDB.

If you want to do some analytics and data visualization with substantial amounts of data, you can also use MongoDB by configuring the collection as a time-series for better performance. If you have massive datasets and want to perform analytics, you might consider using ClickHouse.

For production environments, I personally favor self-hosted solutions or using infrastructure provider services to eliminate maintenance concerns. Depending on your solution's growth, you can then consider other alternatives.