Inheritance Collection

It isn’t clear to me on the Inheritance Collection page what the requirements are that allow for creation of an inheritance. With MariaDB as my main database, I don’t see the dropdown option in the “Create Collection” dialog box that would be used to select the parent collection.

The user guide for Inheritance Collection can be found here:
:link: https://docs.nocobase.com/handbook/data-source-main/inheritance-collection

As for why the option doesn’t appear when using MariaDB, I’ll need to investigate further. I’ll get back to you once I have more information.

Hi, just to clarify — MariaDB itself does not support table inheritance.
Unlike PostgreSQL, it doesn’t provide a native INHERITS syntax or similar mechanism.

Is that the same thing as saying that MariaDB will not allow “inheritance” within NocoBase, or is there some special sauce that is supposed to make it happen anyways?

Sorry for my dense question. :slight_smile:

You’re right: since MariaDB doesn’t natively support table inheritance (unlike PostgreSQL), the “Inheritance Collection” feature in NocoBase won’t work when using MariaDB as your database.

There isn’t any special workaround or internal mechanism in NocoBase that bypasses this limitation. So for now, this feature is only available when using PostgreSQL.