Re:The Great Migration from MongoDB to PostgreSQL
by kstrauser on Friday March 29, 2024 @10:53AM
(#39864794)
That mirrors my experience. MySQL was faster for use cases where data loss was acceptable. Will anyone die if you lose some web log analysis stats? Probably not. You wouldn’t want to use it for anything where guaranteed consistency was critical, like anything involving money, but it was an alright replacement for things like an in-memory data store.
Re:The Great Migration from MongoDB to PostgreSQL
by gkbrk on Friday March 29, 2024 @10:56AM
(#39864819)
If you want a fast DB for web log analysis, you shouldn't look at MySQL or PostgreSQL anyway. ClickHouse will run circles around both of them for the use case of web log analysis.
Re:The Great Migration from MongoDB to PostgreSQL
by kstrauser on Friday March 29, 2024 @11:06AM
(#39864964)
That was an example of the sort of thing that someone might reasonably have used MySQL+MyISAM for in the past. I wouldn’t use that combination at all today.
I say “was”. I hear it’s vastly better now.