Hey folks, I hope by now everyone can agree that we need to replace Riak (it's been unmaintained for quite some time now). However, we might not all agree yet on what it should be replaced with (at least not officially). We've discussed it in threads here and there, but I'd like to get some official consensus before we really hit the ground running.
I would like to propose that we replace Riak with PostgreSQL. Here are some of the reasons that I can think of (and have been mentioned by others in the past) for us to use PostgreSQL: - we all have much experience running it in production (because we already run it for the Traffic Ops database) - it would simplify ATC deployments by removing one more component from the system - it would simplify development as ATC devs are already familiar with traditional SQL databases, and we could reuse a lot of the existing code - it has a healthy community of support and doesn't seem to be losing steam anytime soon (it still remains the 2nd most popular OSS relational database behind MySQL [1]) I would like this thread to focus on the merits (or lack thereof) of using PostgreSQL as a replacement for Riak. We can discuss the low-level implementation details separately in the blueprint I will propose as a follow-up to this discussion. Unless someone is vehemently -1 on using PostgreSQL to replace Riak, I will take silence as assent and move forward with the blueprint process. - Rawlin [1] https://db-engines.com/en/ranking_osvsc
