User Registration and Accounting: Flex Objects + External Relational DB?

Hello friends!

TASK:

  1. To organize the registration and accounting of users of up to 10,000 people, with the development of up to 1 million people.

  2. To organize the management of users’ financial accounts in monetary units and/or in units of the in-game currency.

  3. To organize the accrual, debit and transfer of funds between user accounts in real time.

CONDITIONS:

  1. User details rarely change.

  2. The user’s balance changes frequently.

  3. I would like to use Grav CMS as the main system.

  4. I have experience writing simple plugins for Grav CMS for internal use.

  5. I’ve been using PHP for a long time, with 30 years of experience and a slightly above average level of knowledge. In the past, I have experience writing and actually operating my own CMS.

  6. I have experience working with databases.

  7. I have experience working with client-side JS and jQuery.

  8. In the context of this situation and time, for me personally, it will take a very long time to learn something new like Python + Django…

  9. I am ready to share the results of all developments with the community!

ASSUMPTIONS:

  1. User registration can be implemented using standard Grav CMS tools.

  2. It is impractical to maintain the user’s balance using regular Grav CMS tools due to frequent changes.

  3. Maybe we should use a plugin for Grav CMS to cross Flex Objects and a DATABASE like PostgreSQL?

  4. In this newly written plugin (or group of plugins), implement all operations for working with the user’s account balance, accruals and transfers?

QUESTIONS:

  1. Can you suggest the most correct CONCEPTUAL approach to the organization of such a system in this context?

  2. Maybe someone has ready-made developments on combining Flex Objects in the case of Users Registration and databases like MariaDB, MySQL, PostgreSQL?

  3. What other third-party developments and solutions can be the key to a quick launch of such a system?

  4. I will be glad of any opinions and advice!

Thanks!

@jooru, Nice April Fool’s Day prank… :slight_smile:

1 Like

It was still March 31st on my calendar at that moment…
So, unfortunately or fortunately, everything is serious for me )