Database manager

[rmehta]

Would love to have a simple database editor inside Press

• Browse schema feat: database query editor #2217
• Run SQL queries and see results feat: database query editor #2217
• Run DDL queries feat: database query editor #2217
• Users and permissions (DB) feat: db users and permission manager #2237
• Processlist [already present] support to kill a process can be added
• Bin logs [already present]
• Slow query logs [already present]
• Performance insights feat: performance insights for database server #2296
• Replica setup / monitoring (dynamic scaling)
• Table creation on demand (Table Creation on Demand frappe#1052) - this can free up information schema so we can install 5k sites on a server (instead of 1k)
• Separate app / db_agent?

[NagariaHussain]

Why not also allow to spin up independent database instances AKA DBaaS? 👀

Supabase can be a source of some inspiration here. They have executed it 🔥

[tanmoysrt]

@NagariaHussain
We were discussing last day , we may make this db thing a separate product/service and press will have integration with it.

Need to discuss and explore more on this thing, before attempting any of the features.

Will update on GP

[tanmoysrt]

Moved the tasks to this Github Project board > https://github.com/orgs/frappe/projects/95/views/1