Database schema - Moving from 1.12 to 2.x and looking forward to 3.0


I know that Elgg 3.0 is set to include a "database schema overhaul".  I'm looking for documentation on the new schema.

Also, are there any changes to the database when upgrading from 1.12 to the latest stable version (2.x)?

We have over 100 million rows in our Entities table and need to ensure a smooth upgrade

Thanks for your help!

  • Elgg 3.0 will indeed include some schema changes. They are related to

    • denormalizing metadata/annotations (the table metastring will dissapear)
    • site_guid column will dissapear for entities
    • config and datalist tables will be merged
    • removal of entity type specific tables (not yet finished)

    Elgg will provide migration scripts to move all the data around. If you have no multisite installation, no customizations on the tables and are using the Elgg API for accessing the data, it should cause not that many problems. Nonetheless going from Elgg 2.x to 3.0 will be an update that requires attention.

Feedback and Planning

Feedback and Planning

Discussions about the past, present, and future of Elgg and this community site.