Database manager

[rmehta]

Would love to have a simple database editor inside Press

• [x] Browse schema https://github.com/frappe/press/pull/2217
• [x] Run SQL queries and see results https://github.com/frappe/press/pull/2217
• [x] Run DDL queries https://github.com/frappe/press/pull/2217
• [ ] Users and permissions (DB) https://github.com/frappe/press/issues/2237
• [x] Processlist [already present] support to kill a process can be added
• [x] Bin logs [already present]
• [x] Slow query logs [already present]
• [ ] Performance insights
• [ ] Replica setup / monitoring (dynamic scaling)
• [ ] Table creation on demand (https://github.com/frappe/frappe/issues/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