|
- Organize tables into "folders" and easily search for tables to manage large databases
- Quickly create/copy and delete tables, with or without data.
- Make databases more managable with extended meta data for columns in tables:
- Easily add descriptions to columns that show when viewing or editing data
- When browsing, set which columns show, and the column order in which they show
- Save different views of tables so you can immediately get back to a view you like
- Inline editing that is as fast as editing a spreadsheet, but with specialized fields (see below)
- Store data with built-in AES encryption to protect sensitive information (just mark the column as encrypted)
- Advanced filtering: specialized filters for dates, numbers, booleans, text (begins with, ends with, contains), and fully custom filters as well.
- Extend MySQLs data-types and set custom validations with more than 20 validations built in, and the ability to make your own using regular expressions:
- Custom regular expression fields
- Date fields and date-time fields with graphical date pickers
- Password fields
- alpha, alphanumeric, currency, integer, real, and other validations
- Google maps field (for storing locations)
- Code fields with syntax highlight, tabbing, and brace matching: MySQL, PHP, javascript, etc.
- Various others such as drag and drop list fields, tree dropdowns, etc.
- Create and manage indexes on tables, using an easy-to-use graphical interface
- Create and manage foreign keys between tables. Never get an error 150 ever again, since we check for almost every cause before attempting to create a foreign key (see this article for a description of possible causes)
- Add application level listeners to perform different actions when inserting or updating data at the javascript, PHP and MySQL level. This gives you complete control of what happens when data is touched in the databse
|