opencredit / badgeos

BadgeOS is a plugin to WordPress that allows you to easily create badges and set up the steps and achievements users take to earn them. Badges are Mozilla OBI compatible and sharable via Credly.
http://www.badgeos.org
GNU Affero General Public License v3.0
92 stars 64 forks source link

Custom db tables #676

Closed FarooqAbdullah closed 5 years ago

FarooqAbdullah commented 5 years ago
lkraav commented 5 years ago

Hi. Custom tables is a valuable feature, our post table is approaching 3 million rows by now.

Clicking a web UI button is prone to a lot of failure, though. Is there a WP CLI migration process implemented or planned as well?

FarooqAbdullah commented 5 years ago

Hi @lkraav We have just released a new version of the add-on in which we have added a new option on badgeos setting page to upgrade db as background process so you can safely move the achievements and points to the new tables. We have set 0 limit for max execution time for this upgrade query. So it will be stopped only when database reach to it's maximum execution time. Note: don't forget to take the backup first.

the-wooninjas commented 5 years ago

Hi @lkraav https://github.com/lkraav We have just released a new version of the add-on in which we have added a new option on badgeos setting page to upgrade db as background process so you can safely move the achievements and points to the new tables. We have set 0 limit for max execution time for this upgrade query. So it will be stopped only when database reach to it's maximum execution time. Note: don't forget to take the backup first.

Thanks Zee

On Sun, Aug 18, 2019 at 1:51 PM Leho Kraav notifications@github.com wrote:

Hi. Custom tables is a valuable feature, our post table is approaching 3 million rows by now.

Clicking a web UI button is prone to a lot of failure, though. Is there a WP CLI migration process implemented or planned as well?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/opencredit/badgeos/pull/676?email_source=notifications&email_token=AGHJATHTXGBYYLIWWMFQ5NDQFGK4DA5CNFSM4IMLNBV2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4RF2RY#issuecomment-522345799, or mute the thread https://github.com/notifications/unsubscribe-auth/AGHJATDTAZ5KNBZXG4PAPB3QFGK4DANCNFSM4IMLNBVQ .

--

Regards,AdeelSenior Consultant and Developer at WooNinjas

[image: WooNinjas.com] http://t.sidekickopen16.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4RYFTvW3MhKNj8qlZ-YVRzDdF56dxryf8TpQhY02?t=https%3A%2F%2Fwooninjas.com%2F&si=4831161197264896&pi=889fecc0-e3c1-4243-f7b1-117a499169dd

(408) 520.9836 <(408)%20520-9836> / info@wooninjas.com / Skype: Wooninjas

WooNinjas Office: (408) 520.9836 <(408)%20520-9836>

2637 E Atlantic Blvd #31922 Pompano Beach, FL 33062 https://wooninjas.com/

[image: Facebook] http://t.sidekickopen69.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4RYC0qW8q-l8g5v7g-TW1pwZJR56dvJVf76c2sC02?t=https%3A%2F%2Fwww.facebook.com%2Fwooninjas&si=4836079909863424&pi=5ecff769-2278-43c5-9aaa-5ae0d82906d7 [image: Twitter] http://t.sidekickopen16.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4RYFTvW3MhKNj8qlZ-YVRzDdF56dxryf8TpQhY02?t=https%3A%2F%2Ftwitter.com%2Fthewooninjas&si=4831161197264896&pi=889fecc0-e3c1-4243-f7b1-117a499169dd [image: Google Plus] http://t.sidekickopen16.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4RYFTvW3MhKNj8qlZ-YVRzDdF56dxryf8TpQhY02?t=https%3A%2F%2Fplus.google.com%2F113074469747412685074%2F&si=4831161197264896&pi=889fecc0-e3c1-4243-f7b1-117a499169dd [image: Linkedin] http://t.sidekickopen16.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJN7t5XX4RYFTvW3MhKNj8qlZ-YVRzDdF56dxryf8TpQhY02?t=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2F10268055&si=4831161197264896&pi=889fecc0-e3c1-4243-f7b1-117a499169dd

lkraav commented 5 years ago

Thanks. I'm sure you know, WP CLI is a ton better solution. Perhaps additional funding can be found somewhere to implement as well? Not everybody has shell access to their apps, so AJAX will work for them.