- Ability to create a SQLite DB within Shift
- Use Shift to access Safari's HTML5 offline SQLite DB's
- Database snapshot manager (diffs?)
- Schema view with graphical builder
- Support for SSH connections with the ability to automatically setup tunneling. (Matthew Byrne)
- This might be under "Schema view with graphical builder" but CocoaMySQL used to have a Right Click dropdown that allowed you to "Add field > Before the Selected Field / After the Selected Field / After Last Field" (Dave Rupert)
- A button or something on a field that allows you to reset auto_increment = 0 (Dave Rupert)
- A quick button ALTER TABLE sometable auto_increment = 0 (Dave Rupert)
- The program could have "quick queries" for frequent queries (a better version of "select query from history...") (Dave Rupert)
- AN ADD TO FAVORITES BUTTON (right now you have to save the database info in the form before you connect...) (Dave Rupert, Niklas)
- PHP Bridge (would probably have a special gearbox for that) (Olivier)
- For those with obsessive tendencies, the ability to rearrange columns of a table would be nice (with, I suppose, the purpose of being able to have them look nice on a printed sheet).
- Use tabs in the ui and enable cmd+1 - 4 keycombo for switching between the various 'views'.
- The ability to create a text selection of a query in the manual sql area and being able to execute only the selected part (SQLYog (WIndows) does this)
- Being able to move fields/columns in the structure view (this worked fine in CocoaMySQL until OSX 10.5)
- Have favorite queries (which I can name myself) globally or per favorite server
- Query performance suggestions, I'm imagining some visual aid which can make valid suggestions on where to add indexes, change JOIN orders etc.
- SQLite support (as suggested already) would be awesome awesome
- Many of the current database client tend to clutter my desktop with a lot of different windows, it may be a personal preference, but I really dislike this.
- Localization
- Sync 2 servers (even between 2 types e.g. mysql -> sqlite)
- Ability to copy a database from one server to another (Dave Rupert)
- Associate .sql files with Shift to allow editing/executing on open
Download in other formats:
