Database Schema Design

[webcrumbs-community]

Database Schema Design

[aditya4196]

https://www.wpbeginner.com/beginners-guide/beginners-guide-to-wordpress-database-management-with-phpmyadmin/

I found the above link which comprises of information on how WordPress uses the DBMS in their system.
It explains the 12 default tables which WordPress uses.

[webcrumbs-community]

Hi, @awaisarshd. That's great to hear. It's definitely an addition to the community. Let me think a little bit and I'll come back to you. Cheers!

[awaisarshd]

That's sounds like a plan. I will also look into it or maybe an alternative. And we can discuss further.

[awaisarshd]

@webcrumbs-community I have checked the description, please assign it to me.

[awaisarshd]

Hi @webcrumbs-community, do we have a Discord Server or Slack channel, for any quick discussion? or anything that we will have come to these comments or discussions section?

Btw, I have gone through the link you shared for the WordPress DB, it just contains the core CMS-related tables, I have seen other online provided details for the WP DB, and mostly have those tables and structure, which is good for a CMS but doesn't have information about the Plugin registry etc. So, I am installing WP locally to do some reverse engineering to understand how the Plugins work there.

I have noted a few things and will post all the findings and recommendations with an initial draft of the schema soon.

[webcrumbs-community]

@awaisarshd Nice. No discord or slack channel yet. I may open it soon! I'll let you know. In the meanwhile, feel free to add any discussions here! Cheers

[aditya4196]

@webcrumbs-community
can you assign this story to me too. Im currently in the process of analyzing the databases used in WordPress based on the above link i sent and some more research.
I will work on creating a rough ER diagram on how the tables are linked

[awaisarshd]

Hi @aditya4196, thanks for the above article. It has the same tables which were shared by @webcrumbs-community as part of the initial description.

Btw, i have reviewed the WP db, they dont save the Plugins details in the database. Everything is managed on the files bases. WP has a folder under wp-content/plugins and all the plugins installed are update there and used from that location only.

Only info which is saved in the DB related to plugins is the which plugins are active.

@aditya4196 Please check the this link and can view diagram of the WP tables: https://drawsql.app/templates/wordpress

[awaisarshd]

@webcrumbs-community, that store is managed externally. It's like a docker registry where people can publish their plugins and then it will automatically appear here. I am not exactly sure about the URL they use or where the list is hosted. But its not harder to find as their all the source code is open source.

[Gurnav224]

Hello 👋, I'm Gurnav. I'm eager to dive into open source to gain real-world experience and expand my knowledge.

[awaisarshd]

@webcrumbs-community thanks, yes that's the plan. I will coordinate with @aditya4196 and see how we can move forward with this.

[trdxDeepu]

what kind of database is required supabse or mongodb or maybe prisma ?

[webcrumbs-community]

We're working with MongoDB. Initially locally but eventually I'll create a production uri. We had to decide that for the issue on authentication. Do you enjoy MongoDB or have any suggestions? Cheers!

[trdxDeepu]

i dont know about backend i have worked on firebase and supabase only i dont know nodejs and how to connect mongodb through it

[trdxDeepu]

Supabase is a great Firebase replacement that uses a PostgreSQL backend. Prisma is the next generation ORM built for Node. JS and Typescript this i found on google

[trdxDeepu]

is there anything i can contribute as front end

[webcrumbs-community]

Opened a new issue for frontend.

[awaisarshd]

Hi @webcrumbs-community, I am interested in backend and db-related stuff. I don't know much about what you have in mind but I have done some work in MongoDB and would love to join and see where I can contribute.

[webcrumbs-community]

@awaisarshd I've just rewritten the description of this issue. See if it makes sense and let me know if you'd like me to assign this to you. Cheers and thanks!

[aditya4196]

Hmm understood, so they haven't kept any complexity for the DB

[awaisarshd]

yup, what they did is simple and file-based only. Each folder or php file counts as a plugin and each plugin has an entry file that has a header with a specific format that contains the metadata for the plugin.

I am working on the schema design for the MongoDb right now with what I have understood for now. will share here or maybe create a new discussion and we can see how we can improve on top of that.

[webcrumbs-community]

What about the plug-in store that appears inside the admin panel? Perhaps it calls an external url that have a plug-in db. Don't know if that part is open source.

[aditya4196]

@awaisarshd I would like to assist you with the schema design. Can we work on it together in the evening?

[awaisarshd]

@aditya4196 sure, we can definitely. Allow me some time and I will set up something for us to share and work together.

[aditya4196]

Great!!

[aditya4196]

@awaisarshd were you able to create any collab platform or you want me to create it as i have time now

[awaisarshd]

@aditya4196 I created this Discord server: https://discord.gg/GgaeFd4D

[awaisarshd]

@webcrumbs-community I have created PR #114 which has some proposed schema for the database. This has been done with the continued discussion and help from @aditya4196.

Happy to discuss further what we have proposed.

[webcrumbs-community]

Great, guys, @awaisarshd and @aditya4196. I already checked and it looks great. It will help a lot with our next steps. I'd love to hear your suggestions on how we can proceed. I'm seeing some scopes that can be done in parallel. If you have any thoughts on that, reach me out!

[aditya4196]

As we build the modules, it would get more clear on refining the schema.