Database Recommendations?

[Slugger]

Originally Posted by stuckless

I'd have to agree... H2 is a solid and feature rich database. I think that there is a sagex-h2 plugin in the repository. It's not mine, but I do depend on it in phoenix as well... even though I haven't actually needed to use the database yet. I'd recommend using it, since it has the plugin configuration for setting the port, enabling the servers, etc. We probably don't want to have 4-5 different H2 instances all running inside side.

Yeah, I'm depending on the already existent sagex-h2 plugin. I own enough plugins in the repository as it is. I'm all for it anytime I can avoid adding another one.

[tmiranda]

Wow, I never looked at the UserRecordAPI before. If I can use that I will go that route because it's a lot easier than H2. (Don't worry Slugger, I'll still help with SJQv4 )

My only concern is bloating the wiz.bin of unsuspecting users.

[GKusnick]

Originally Posted by stuckless

If I get time, I'll probably add a data browser to the bmt web ui, so that people can browse the stores, data, remove them, etc.

I was thinking along the same lines, that a general-purpose DB maintenance plugin might be handy for identifying and deleting orphaned plugin data. But my feeling is that it should be a lightweight standalone plugin in its own right, with minimal dependencies, so that non-BMT users (yes, there are a few) can benefit from it.

[stuckless]

Originally Posted by GKusnick

I was thinking along the same lines, that a general-purpose DB maintenance plugin might be handy for identifying and deleting orphaned plugin data. But my feeling is that it should be a lightweight standalone plugin in its own right, with minimal dependencies, so that non-BMT users (yes, there are a few) can benefit from it.

Since you have skills, you should do it. I can't code in studio to save my life, or else I would The only reason I use the web ui is because I can actually do something with it. The UserRecordApi has the ability to get the fields for a record which is handy when doing a data browser type of plugin. If I were to do a web based viewer, then it wouldn't be for a few months (or a year, given how much other stuff I have to do ), but I think having such a plugin would be very handy.