About a plugin to clean and tidy our database

[jiangcaiyang]

Hello, after months of running NodeBB instance, I've acculumated quite a few data from my database. But perhaps I've made something wrong with my mongodb, there are still some failure to our forum, i.e, I could not delete certain user from our chat room whereas I can when adding user to chat room.
Is there any plugin or tool that can clean and tidy the database of my own, cleaning the dirty data from our database? Thanks.

[Jenkler]

Yeah, a cleanup plugin would be nice to verify consistency of the database. Good idea

[jiangcaiyang]

Anybody good ideas? As the forum develops, the data that once is useful would be discarded when we upgrade the forum. So consistency is important.

[AOKP]

@jiangcaiyang I am pretty sure that this already exists for MongoDB:
https://github.com/NicolasSiver/nodebb-plugin-ns-utils

But to be honest I doubt that it is that heavily needed unless you run a really big database. What would indeed be quite useful would be an option to purge deleted posts and topics all at once over the AdminCP.

[jiangcaiyang]

@AOKP It is, that I would make the mongo database dirty, I mean, by accidentally insert-delete some data from MongoDB, and result in unreasonable failure on NodeBB, the data zombie I could tell, so I need a tool to clean them.
https://github.com/NicolasSiver/nodebb-plugin-ns-utils
I will use this tool then.

[julian]

Difficult to know what data is used, and what isn't. Plugins are able to add data anywhere in the db, and many do just that (instead of keeping everything in their settings:pluginName hash), as it is just a suggestion.

[yariplus]

I feel like this is way outside of the intended use for plugins. Although you can make a plugin to do this, there are already tons of standalone tools for database maintenance that will be better than anything you could possibly make with a plugin.

[SuperMike]

@jiangcaiyang said in About a plugin to clean and tidy our database:

I could not delete certain user from our chat room whereas I can when adding user to chat room.

I faced the same problem when upgrade to 1.10. But I could delete user after create a new room. So I think it must be caused by the consistence of data in DB.