Goodbye TABLE_PREFIX

· · labs

Post image tableprefix

Active Collab has always prefixed its tables with “acx_”, or a different value that the user specified during the installation. The reasons for this are purely historical.

Some packages even limited users to just one database. This forced users to install multiple applications in a single database, so all of the applications had to “namespace” their tables with a prefix. For example, if application #1 had a “users” table, another application couldn’t have a table with that name unless they put a prefix in front of it (app1_users and app2_users). For that reason, pretty much all PHP apps that you could self-host had a prefix - phpBB “phpbb_”, WordPress “wp_”, Active Collab “ac_” or “acx_” etc.

The time to retire the table prefix in Active Collab has come with version 5. Now that VPS plans are so common and affordable, you’re the one controlling your platform and you can create as many databases as you want. Even most shared plans (which we don’t recommend) provide an unlimited number of databases. So it’s time to move on. The new Active Collab will require that you prepare one empty database, which the app can then fully manage.

Even if you’ll be upgrading, a clean database is required for the migration to work. The upgrade script will move your Active Collab 4 tables to the new database, and automatically remove the table prefix along the way. It’ll also make sure that your tables are using a modern storage engine and character set.

The end result is one less thing to worry about. We prefer to focus on stuff that actually matters (user experience, performance, features, etc.) instead of dealing with a limitation enforced by strange hosting practices of the past.

Recommend this Article
Related Articles
Comments
comments powered by Disqus
We are

Powerful, yet simple project management

Active Collab helps your team stay organized when you outgrow email. But it’s so much more than that — with plenty of neat add-ons, it’s a one-stop solution for all your business needs.

Find out more