A single fixture, yes. If there are many fixtures of the same name in different test modules, it wouldn't work, but that's not how I understood the problem in the blog post, which says

>rename every instance of a pytest fixture from database -> db

Every instance of a fixture, not every instance of all fixtures of the same name.