UUID primary keys

The current database schema of AbterPHP stores IDs naively in char(36) columns. This is purely a temporary, technical workaround and is planned to be changed before the first stable release.

While the pros and cons of this design decision is certainly make up for a long list, AbterCMS for the time being will default to use UUIDs as primary keys. We also experimented with ULIDs which we consider a very viable and promising alternative, but it’s not yet supported by databases and therefore we decided to use UUIDv4 instead.

If you want to learn more about the pros and cons of this design decision, we recommend reading Tom Harrison’s post