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