JeevesBond — Thu, 16 Nov 2006 12:32:04 +0000

Nearly forgot, the graphical tools for MySQL management I'm aware of are:

None of them are web-based however, the only one I know of that is: phpMyAdmin. Which you already know about.

JeevesBond — Thu, 16 Nov 2006 12:26:43 +0000

BKuhlOrElse wrote: We're not writing a PHP editor... we're writing Database Management software such as PHPMyAdminp

Ooops! Entirely my mistake. I read your reply incorrectly.

Thinking about things I dislike about phpMyAdmin: -

Cluttered.
No AJAX.
Not Web Standards compliant.
Looks pretty ugly.
High learning curve for new users.

So if I were you, I'd be thinking of creating a very clean interface that uses AJAX to send SQL requests and recieve the resultsets. That would be nice, and would use less bandwidth.

In common use of MySQL I typically create new users, assign permissions and create new databases. Occassionally I do SELECT queries, usually to see what users are in the database.

Probably best is to concentrate on getting a great-looking design, that's immediately comfortable to use, with AJAX for most operations. Don't worry too much about features, that's one area where I don't believe you can compete with phpMyAdmin. Just try doing something different, for a different market.

Does that help?

BKuhlOrElse — Wed, 15 Nov 2006 14:32:41 +0000

I'm getting Frustrated. I'm trying to get feedback for software I'm working on, but forums just aren't providing enough of what I need. How do I get customer feedback without having a copy of the software out equipped with a feedback option? I'm trying to find out what the customers want before putting features in that aren't wanted or won't be used.

BKuhlOrElse — Mon, 13 Nov 2006 20:49:31 +0000

We're not writing a PHP editor... we're writing Database Management software such as PHPMyAdmin with enhanced features, better design, and additional tools for webmasters to manage their programmers/graphic designers and their web sites.

I appreciate the links to those other database management scripts. I"ll be taking a look at them.

JeevesBond — Mon, 13 Nov 2006 20:10:36 +0000

BKuhlOrElse wrote: I'm talking about web software written in PHP

If this is an answer to the platform question, I meant will it work on Windows, Linux, and Mac (or any combination of these)?

As it won't be Free (as in freedom) I would never use it anyway. I have one editor that works for everything, Haskell through to C to PHP, I regard it as a royal pain to switch specialised editors every time I switch languages and that's Vim. It's probably the editor with the steepest learning curve, but the things that can be done with it are astounding.

Looks like I'm not in your target market really!

I am aware of some of the competition you'll have in the PHP editor market: Zend Studio and Komodo. Are they able to do the same things you're proposing? There may well be some merit in integrating everything (scripting, FTP, database access) into one product.

BKhulOrElse wrote: However the only software we've really used is PHPMyAdmin to manage our databases.

Seems this is the software most people use to manage their databases. It follows the Open Source mantra of: 'Do one thing, and do it well.' There are also the tools I mentioned above (MySQL Administrator and Query Browser) and third-party tools such as: Navicat, or Webyog. Those are the ones I've heard of/tried to use at one time or another.

BKuhlOrElse — Sun, 12 Nov 2006 03:59:50 +0000

I'm talking about web software written in PHP you install on your web server and grant specific access to. Specific lisencing hasn't been setup/specified, however we do know for the everyday user it won't be free. BETA testers and those who contribute to our development will receive a reward, whether that be a free lisence or not is undetermined at this point.

The software is primarily designed to allow for webmasters to better manage their employees (i.e - programmers/graphic artist). To-do lists, ftp permissions, database permissions and such are some features to put more control into the webmaster's hands. We're pondering what options we should include in our database manager. However the only software we've really used is PHPMyAdmin to manage our databases. I'm trying to get a feel from more experienced people of what makes up good database/ftp management software, and what is it missing?

JeevesBond — Sat, 11 Nov 2006 19:03:42 +0000

What platform(s) are you creating this software under? What license will you be using? These are important questions for some of the people on this site, we may not be in your target market as we're Linux users.

For MySQL database management I use the MySQL command-line client over SSH. There's nothing bad about it for dba style tasks, it's simple and works. Occassionally I want to have a rich client that can display large result sets better, in this case I use the MySQL Query Browser. It seems to work perfectly fine. Haven't got any complaints, but then I don't often use it! There's also the MySQL Administrator, which can help with dba tasks.

FTP (using a GUI) under Linux could definately be improved upon, there's only one option called: gFTP. It's lacking a few features and sometimes crashes. Although they're just minor annoyances, certainly not enough to make me use a proprietary tool--or worse--go back to Windows!