In order to keep things nicely separated I would always prefix tables and columns from extensions with
vendor_extensionname_
. But 30 characters is way too short for doing this. Is there any reason why there is a 30 character limit?vendor_extensionname_
. But 30 characters is way too short for doing this. Is there any reason why there is a 30 character limit?That would imply that anyone using Oracle would not be installing extensions (may possibly be true, but cannot be guaranteed)
That's good for now, but it would be cleaner if you use the same prefix everywhere (instant recognisable) for anything related to your extension.
Doctrine ORM trims column-names and adds a counter-number, but there is an open bug on it. And I don't know about the indexes and tables.DavidIQ wrote: ↑Tue Apr 24, 2018 12:15 pm It's also not just table names. There's limitations on index names as well. In any case I'm not sure that adding conditionals to the dbal for doing different things depending on dbms versions is something we'd want to do (more of). However there's been some discussions about just going with Doctrine's ORM instead of continuing with our dbal so maybe this would get addressed at that point.
Isn't it Doctrine DBAL instead of ORM? I hope it's not ORM!