3 ms·
I agree, and the example could make the problematic aesthetics of plural names even more obvious: SELECT id, name FROM users JOIN countries ON users.coun
by jacknews 4y ago
I agree, and the example could make the problematic aesthetics of plural names even more obvious:
SELECT id, name
FROM users
JOIN countries ON users.countries_id = countries.id
WHERE countries.name = 'Canada';
But the real problem is that in the ORMs and frameworks, entities are related through english-language pluralization rules, magically applied. That can be confusing to newcomers (and non-native speakers), and even experienced users, and sometimes gets badly in the way when the pluralization logic fails.
Just stick to singular, and a whole class of issues disappears.