I have been a DBA with MySQL (which I absolutely love) for a few years now. I am not gonna claim I know everything there is to being a DBA but the whole experience has been a pleasure. The front ends (for the users I support) have always been developed by others and I simply managed the back-end in conjunction with the FE developers. I have now decided to make my foray <sp?> into GUI devleopment and wonder if anyone has any suggestion for a FE app that would help in conjunction with MySQL. Unfortunately I would like to stay away from the pure web development (PHP/ASP coding etc - I can handle it a little but it makes me nervous) if possible but would get over my nervousness asap if that is my only option.
So far the ideas I have found in my search have been MSAccess, Which I have been using for a long time and am quite comfortable with but gets expensive quickly, and an app called DBACentral (found here
. which I know almost nothing about but it has a web form interface creator that looks interesting.
Unfortunately I don't quite get the microolap/DBACentral app as far as end user (FE) development and whether I will need to purchase end user licenses (as I have basically done with MSAccess for about 9 users now). Futuristically speaking we will be developing for at least 40 or 50 more users and so far the microolap app looks better than MSAccess on the cost side. The one thing that makes me nervous is that I have always been put off by "vague" advertisements (which is what DBACentral seems to be doing) that don't tell me what I will need (at the time of purchase) if I am ready to develop for a large user base. I feel like they are trying to snag me into buying and then say "oh and by the way if you need it for ten more users that will cost you...blah blah blah" UGH!
Does anyone out here have any other ideas for user (FE) Gui development and MySQL? Has anyone used the DBACentral app?
One note: This current app will be a field service type of application where in some instances the end user will NOT be connected while using the app and will later connect to "sync" the data entered while out in the field.
I hope I haven't yammered on too much and am happy to give more info if needed.
...and of course any suggestions feedback or help would be greatly appreciated!!