2016-08-11, 10:36 PM
2016-08-12, 01:03 AM
(2016-08-11, 10:36 PM)jimski Wrote: [ -> ]Looks like default installation of MyBB creates multiple tables without primary key.
Is this a good database design practice ?
Generally no, but we're avoiding significant database changes at this point in the software's lifecycle (stability > tiny performance bumps, especially when our QA group is as small as it is at the moment), and trying to get 2.0 prepared, which will actually use indexes properly.
2016-08-12, 08:44 AM
Understood, I look forward to 2.0.
Implementing primary keys will also help with pg_admin because currently pg_admin will not allow editing any fields in tables without primary keys so a developer who would like to extent MyBB on Postgres will have to install yet another tool just to edit the database.
Thanks
Implementing primary keys will also help with pg_admin because currently pg_admin will not allow editing any fields in tables without primary keys so a developer who would like to extent MyBB on Postgres will have to install yet another tool just to edit the database.
Thanks