topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Sunday December 15, 2024, 2:49 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: MySQL GUI (User front end - not admin) ideas? Options?  (Read 3685 times)

Zjooj

  • Participant
  • Joined in 2006
  • *
  • Posts: 4
    • View Profile
    • Donate to Member
MySQL GUI (User front end - not admin) ideas? Options?
« on: September 02, 2008, 10:23 AM »
Hello all,

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!!

Kind regards,

Zjooj

40hz

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 11,859
    • View Profile
    • Donate to Member
Re: MySQL GUI (User front end - not admin) ideas? Options?
« Reply #1 on: September 02, 2008, 05:20 PM »
If you're using Access you might want to investigate using OpenOffice's Base component. It's culturally similar enough to Access that you should be able to pick it up quickly.

base-big.png

I'm not sure if this is "ready for prime time" since Base is relatively new, but the price is right so it doesn't cost you anything to check it out.

Take a look at this link for connecting MySQL and Base:

http://wiki.services...nnect_MySQL_and_Base