rss_admin_db_manager: Database management in Textpattern

gaekwad · 2021-04-19 17:38:35

Bumping this since I’m keen to get more eyes on Textpattern 4.8.6 code so we can release it soon.

Bloke has made some changes to rss_admin_db_manager and Textpattern for MySQL users. Here’s the info, including the minimum requirements for it to work:

github.com/textpattern/textpattern/issues/1653#issuecomment-818076099

There are three tabs added to the Diagnostics detail dropdown: Database Manager, Database Backup and Run SQL. Look:

Neat, huh? Anyone interested in this extra functionality is invited to test it out. As it stands right now, tis is the only issue on the v4.8.6 issue list, so if we can give this some eyeballs, v4.8.6 will be coming soon.

jakob · 2021-04-19 21:18:54

Cool! While I quite like my regular work, it is stopping me from keeping up with Stef’s amazingly prolific output. That and the fact that an O2 “upgrade” to a cable connection has left us without internet for nigh-on 10 days now.

Bloke · 2021-04-19 22:59:44

gaekwad wrote #329914:

As it stands right now, tis is the only issue on the v4.8.6 issue list

Ummm, oops¹

¹ sorry

gaekwad · 2021-04-20 12:06:02

Bloke wrote #329919:

Ummm, oops^1^

¹ sorry

Do we need a tracking issue for this, or is it job-done territory?

phiw13 · 2021-04-20 12:17:33

gaekwad wrote #329914:

Bumping this since I’m keen to get more eyes on Textpattern 4.8.6 code so we can release it soon.

For anyone wanting to play at home: if you use the plugin, you need to download a copy from the diag-panel branch, here

I had originally downloaded from the main branch only to discover that nothing was happening as described. I’ll try to have a look tomorrow.

Bloke · 2021-04-20 12:49:40

phiw13 wrote #329940:

For anyone wanting to play at home: if you use the plugin, you need to download a copy from the diag-panel branch

Heh, uhhh, thanks :$ I shoulda linked to it, sorry for wasting your time. I’ve updated the OP with links to both.

phiw13 · 2021-04-21 09:27:39

Ok, so I briefly played around with the most recent 4.8.6-dev build.

the diagnostics panel behaves as expected, at first there is no visible change :-)
with the extension installed, one can find 3 new items in the select widget that allow to manage the DB – that is nicely tucked away, protecting the innocent.
the 3 subitems generated by the extension show what they are supposed to show, afaict. How well they actually work I don’t know, some basic tests, create a backup, run a SQL query did do fine.

And nothing destroyed the DB.

Bloke · 2021-04-21 09:42:16

Yay, thank you for trying it out. I was in two minds whether to just add a single ‘Database management’ item to the dropdown and then have the backup/SQL links from that panel only. But it ended up being less hassle – and slightly more usable – to provide direct links to each panel from the outset.

Glad your database didn’t catch fire.

phiw13 · 2021-04-21 11:24:44

Bloke wrote #329945:

I was in two minds whether to just add a single ‘Database management’ item to the dropdown and then have the backup/SQL links from that panel only.

I think it is a reasonable way to handle this without sending the user down a bit of labyrinth. When I first saw the subject discussed on GH, I was a bit afraid you would put one or more additional button-links on the panel; the select route is a good way to hide the complexities from the less savoury user, if the plugin is installed.

Or is it still the idea to have the plugin code integrated within Textpattern Core?

Bloke · 2021-04-21 11:47:58

phiw13 wrote #329947:

the select route is a good way to hide the complexities from the less savoury user, if the plugin is installed.

I concur.

Or is it still the idea to have the plugin code integrated within Textpattern Core?

Nope, I think this works better as a plugin.

colak · 2021-04-21 14:04:16

One of my issues regarding this plugin is the user permissions which I need to change for some installs. The sql language is cryptic for not seasoned users. drop for example does not immediately equate with delete for many.

Is it possible to change the permissions in the core for just administrators, or add a preference as to which user roles have access to it?

Bloke · 2021-04-21 14:16:41

colak wrote #329949:

One of my issues regarding this plugin is the user permissions which I need to change for some installs.

What do you need to change it to? The plugin is hard-coded to only run for Publisher-level accounts. I wouldn’t trust anyone else with it.

The sql language is cryptic for not seasoned users. drop for example does not immediately equate with delete for many.

We can change the language string to ‘Delete’, no problem, if it’s clearer. Just takes up a bit more space, and the actions do seem to merge together a bit already. I don’t know how best to separate them and still let them flow on smaller screens. If anyone has any cool core classes or HTML markup (or at a push inline CSS) here that would help, please let me know.

Is it possible to change the permissions in the core for just administrators, or add a preference as to which user roles have access to it?

A preference is possible, sort of. One of the downsides of having the plugin built into the Diagnostics panel is that we’re then governed by Txp’s core permissions. The panel’s only available to levels 1 and 2 so if you set the plugin to be visible to Copy Editors, for example, it wouldn’t appear: the core privs mean the entire panel is a Restricted Area. In this case I didn’t think it mattered since we really don’t want anyone else tinkering with the database, so restricting the plugin to Publisher-only roles fits within the core panel privs already.

I’m not quite sure how adding a preference helps, but may be missing something. EDIT: or do you mean, a preference for just making the ‘drop’ visible? If so, how would that work, given that only Publishers can see the plugin content anyway?

Last edited by Bloke (2021-04-21 14:19:01)

colak · 2021-04-21 14:44:58

Ok I may be referring to older versions which I was using where staff writers had access to the pane. Publishers are the right level. The reason I brought it up is that, as I mentioned in another thread, I’m redesigning a site that I want to keep privileges to the content part as the person is lost in the other panes.

Bloke · 2021-04-21 14:46:57

Yep, cool. Publishers only for this ride from now on. It’s been like that ever since I took over maintenance of it.

But if anyone has any thoughts on how to pretty up the ‘Actions’ column, I’d love to hear them. I tried pipe symbols between them but they get ugly when the viewport is resized, sometimes putting pipes at the end of a line or the start and everything just looks wonky and amateurish.

colak · 2021-04-21 15:29:32

Is there a reason they can not reside in flexbox divs? It will also save the problem with the non-repairable tables appearing on the wrong spot.

Textpattern CMS

Textpattern CMS support forum

#16 2021-04-19 17:38:35

Re: rss_admin_db_manager: Database management in Textpattern

#17 2021-04-19 21:18:54

Re: rss_admin_db_manager: Database management in Textpattern

#18 2021-04-19 22:59:44

Re: rss_admin_db_manager: Database management in Textpattern

gaekwad wrote #329914:

#19 2021-04-20 12:06:02

Re: rss_admin_db_manager: Database management in Textpattern

Bloke wrote #329919:

#20 2021-04-20 12:17:33

Re: rss_admin_db_manager: Database management in Textpattern

gaekwad wrote #329914:

#21 2021-04-20 12:49:40

Re: rss_admin_db_manager: Database management in Textpattern

phiw13 wrote #329940:

#22 2021-04-21 09:27:39

Re: rss_admin_db_manager: Database management in Textpattern

#23 2021-04-21 09:42:16

Re: rss_admin_db_manager: Database management in Textpattern

#24 2021-04-21 11:24:44

Re: rss_admin_db_manager: Database management in Textpattern

Bloke wrote #329945:

#25 2021-04-21 11:47:58

Re: rss_admin_db_manager: Database management in Textpattern

phiw13 wrote #329947:

#26 2021-04-21 14:04:16

Re: rss_admin_db_manager: Database management in Textpattern

#27 2021-04-21 14:16:41

Re: rss_admin_db_manager: Database management in Textpattern

colak wrote #329949:

#28 2021-04-21 14:44:58

Re: rss_admin_db_manager: Database management in Textpattern

#29 2021-04-21 14:46:57

Re: rss_admin_db_manager: Database management in Textpattern

#30 2021-04-21 15:29:32

Re: rss_admin_db_manager: Database management in Textpattern

Board footer