Table Editor Comparison
Everybody loves a good table editor. Right? Well perhaps not, but they do however save you an ass load of time when it comes to providing GUIs for "punters". Personally, when I was looking round for a decent one, I couldn't find one that did everything I wanted so I ended up doing the usual thing, and wrote it myself. Not everyone wants to do that though, so since I'm such a nice guy, here's a comparison of the feature sets of a few common ones. Hopefully unbiased, but lets face it, mines the best. :-)
Bear in mind that it's not an exhaustive list, but most of the major features are listed. Any omissions or errors, let me know.
Feature Comparison
| Feature | MySQL TableEditor | phpMyEdit | dbPerceptor |
|---|---|---|---|
| Type | Library | Library | Application |
| License | PHPGuru | GPL | GPL |
| PHP Version | 4.3+ | 4.1.2+ | 4 |
| Installation | Coding Required | Utility Provided | Configuration Required |
| URL | Link | Link | Link |
| Add Record |  |
|
|
| Edit Record | |
|
|
| Copy Record | |
|
 |
| View Record | |
|
|
| Delete Record | |
|
|
| Multiple Deletes at once | |
|
|
| Search | |
|
|
| Advanced Search | |
|
|
| CSV Download | |
Commercial Extension | |
| Enable Disable Above Functions | |
|
|
| File Upload | |
With patch & callbacks | |
| Custom Callbacks Supported | Pre-Display (per column), Data Filter, Post Add/Edit/Copy/Delete | Pre/Post actions via include files | |
| Record Paging | |
|
|
| Record Sorting | |
|
|
| Multiple Sort Fields | |
|
|
| Record Filtering | |
|
|
| Required Fields (Add/Edit) | |
|
|
| Custom Field Types (Add/Edit) | Date/Time/Datetime, Email, Password, Bitmask | Password, Calendar and Richtext HTML editing via extensions | Spellcheck, Rich Text, Word Count, Calendar |
| Field/Column Hiding | |
|
|
| Multiple Nav Styles | |
|
|
| Look/Feel Manipulation | |
|
|
| Multilanguage Support | |
|
|
| Logging User Actions | Any via Custom Callback Function | MySQL Table and Email | |
| Foreign Key Support (ie. 1:M) | |
|
|
| Table Join Support | |
|
|
Author: Richard Heyes
Posted: 26th June 2005 02:00
Posted: 26th June 2005 02:00
Hendy Irawan:
> Very cool!
>
> Why isn't phpMyAdmin there?
It doesn't fit the same category. The apps/libraries compared here are aimed at end users for managing specific tables, whereas phpMyAdmin is a database administration tool.
Quote> Very cool!
>
> Why isn't phpMyAdmin there?
It doesn't fit the same category. The apps/libraries compared here are aimed at end users for managing specific tables, whereas phpMyAdmin is a database administration tool.
Author: Elantrix
Posted: 20th September 2005 11:16
Posted: 20th September 2005 11:16
Richard Heyes:
> Hendy Irawan:
> > Very cool!
> >
> > Why isn't phpMyAdmin there?
>
> It doesn't fit the same category. The
> apps/libraries compared here are aimed at end
> users for managing specific tables, whereas
> phpMyAdmin is a database administration tool.
phpMyAdmin is also designed to just handle tables too. I personally never needed anything else.
Quote> Hendy Irawan:
> > Very cool!
> >
> > Why isn't phpMyAdmin there?
>
> It doesn't fit the same category. The
> apps/libraries compared here are aimed at end
> users for managing specific tables, whereas
> phpMyAdmin is a database administration tool.
phpMyAdmin is also designed to just handle tables too. I personally never needed anything else.
Author: Vince
Posted: 19th October 2005 14:18
Posted: 19th October 2005 14:18
>> phpMyAdmin is also designed to just handle tables too. I personally never needed anything else.
Me too, but wouldn't give it to users, which is the main use of this version.
Great work.
Look forward to being able to add a CSV file upload feature ;-)
QuoteMe too, but wouldn't give it to users, which is the main use of this version.
Great work.
Look forward to being able to add a CSV file upload feature ;-)
Author: Rafia alotibi
Posted: 17th November 2005 14:14
Posted: 17th November 2005 14:14
Multiple Sort Fields now is Support
if Field Type is set inputType will Be checkbox
also if Field Type is enum inputType Be will radio
View Data list
http://www.arabportal.net/TableEditor/Datalist.png
View Add/Edit Record
http://www.arabportal.net/TableEditor/EditAdd.png
Example code
http://www.arabportal.net/TableEditor/example.phps
You can get the New code
http://www.arabportal.net/TableEditor/TableEditor_New.phps
Quoteif Field Type is set inputType will Be checkbox
also if Field Type is enum inputType Be will radio
View Data list
http://www.arabportal.net/TableEditor/Datalist.png
View Add/Edit Record
http://www.arabportal.net/TableEditor/EditAdd.png
Example code
http://www.arabportal.net/TableEditor/example.phps
You can get the New code
http://www.arabportal.net/TableEditor/TableEditor_New.phps
Author: Rafia alotibi
Posted: 21st November 2005 13:13
Posted: 21st November 2005 13:13
Sorry, I meant above the feature of "Multiple Field TYPE support" not "Multiple Sort Fields" so this is a correction.
Quote
Author: mattpaul
Posted: 9th June 2006 00:36
Posted: 9th June 2006 00:36
nice functionality + clean UI but I was a little disappointed to see all layout / presentation living in the same single PHP file which makes your project a tad more difficult to extend
mp
Quotemp
Author: Richard Heyes
Posted: 26th June 2007 11:00
Posted: 26th June 2007 11:00
mattpaul:
> nice functionality + clean UI but I was a little
> disappointed to see all layout / presentation
> living in the same single PHP file which makes
> your project a tad more difficult to extend
You could say that's an advantage. Just one file to move or copy around and very easy to keep up to date. Only having one file was very much intentional.
Quote> nice functionality + clean UI but I was a little
> disappointed to see all layout / presentation
> living in the same single PHP file which makes
> your project a tad more difficult to extend
You could say that's an advantage. Just one file to move or copy around and very easy to keep up to date. Only having one file was very much intentional.
Author: Elantrix
Posted: 7th October 2007 19:33
Posted: 7th October 2007 19:33
Vince:
> >> phpMyAdmin is also designed to just handle
> tables too. I personally never needed anything
> else.
>
> Me too, but wouldn't give it to users, which is
> the main use of this version.
> Great work.
> Look forward to being able to add a CSV file
> upload feature ;-)
A lot of hosting companies now use PHPMyAdmin as their primary database editing tool because it easily integrates into most setups and is simple and powerful not only to the professionals, but also for the general users with little knowledge of MySQL or databases in general.
Quote> >> phpMyAdmin is also designed to just handle
> tables too. I personally never needed anything
> else.
>
> Me too, but wouldn't give it to users, which is
> the main use of this version.
> Great work.
> Look forward to being able to add a CSV file
> upload feature ;-)
A lot of hosting companies now use PHPMyAdmin as their primary database editing tool because it easily integrates into most setups and is simple and powerful not only to the professionals, but also for the general users with little knowledge of MySQL or databases in general.
Author: Lesley
Posted: 26th October 2007 17:06
Posted: 26th October 2007 17:06
Elantrix:
> Vince:
> > >> phpMyAdmin is also designed to just
> handle
> > tables too. I personally never needed
> anything
> > else.
> >
> > Me too, but wouldn't give it to users, which
> is
> > the main use of this version.
> > Great work.
> > Look forward to being able to add a CSV file
> > upload feature ;-)
>
> A lot of hosting companies now use PHPMyAdmin
> as their primary database editing tool because
> it easily integrates into most setups and is
> simple and powerful not only to the
> professionals, but also for the general users
> with little knowledge of MySQL or databases in
> general.
Elantrix, you are totaly outside. I have used all of this "tools" to creating backend administration for sites ,witch I can provide for my users(customers) latter.
I have also working with PhpMyAdmin, but this is for webmasters (Creating Database, Export, Import, even Drop...) so this have nothing in comune with the products presented above.
Nice article ! Thanx.
Quote> Vince:
> > >> phpMyAdmin is also designed to just
> handle
> > tables too. I personally never needed
> anything
> > else.
> >
> > Me too, but wouldn't give it to users, which
> is
> > the main use of this version.
> > Great work.
> > Look forward to being able to add a CSV file
> > upload feature ;-)
>
> A lot of hosting companies now use PHPMyAdmin
> as their primary database editing tool because
> it easily integrates into most setups and is
> simple and powerful not only to the
> professionals, but also for the general users
> with little knowledge of MySQL or databases in
> general.
Elantrix, you are totaly outside. I have used all of this "tools" to creating backend administration for sites ,witch I can provide for my users(customers) latter.
I have also working with PhpMyAdmin, but this is for webmasters (Creating Database, Export, Import, even Drop...) so this have nothing in comune with the products presented above.
Nice article ! Thanx.
Comments
Posted: 25th June 2005 18:59