vieten / sequel-pro Goto Github PK

Replace the Table Status tab with an iphoto-style 
bottom-left-inspector-pane-thing.

What steps will reproduce the problem?

1. Set the limit to n, for example 5
2. Search "id" , ">" (or any other search condition)
3. Make the search.

What is the expected output? What do you see instead?

The last n records. But all are show. If "Limit result to" is defined in the 
preferences, the result is 
limited to this limit.

I think it should work, having "Limit result to" as the default value and 
"Limit from" as a possible 
value, if not defined, then, use the "Limit result".

What steps will reproduce the problem?
1. Right click toolbar
2. Select "Customise Toolbar"
3. Drag Show/Hide Console icon to Toolbar
4. Press done
5. Show/Hide Console is greyed out.

What version of the product are you using? On what operating system?
0.9. on OS X 10.5.4.

A quick glance over the documentation shows many pages which are no-longer 
accurate. Tickets 
need to be added for each page which needs updating.

The Show/Hide Console and Clear Console toolbar icons don't fit with our vision 
of the toolbar for 
v1.0.

Remove these toolbar icons and add a "Show/Hide Console" menu item to the View 
menu, and add a 
clear console icon to the console drawer.

Add ability to import/export favourites as an xml/plist file to the File menu.

There are references to CocoaMySQL within the binaries of the MCPKit framework. 
I also suspect the 
copy of MCPKit we have is not a Universal build (and is thus breaking our own 
ability to build as 
universal).

Create a new build from the latest stable release of MCPKit, and add it to the 
project.

The favorites system is a mess. We need to re-factor it to use bindings. Wrok 
on this has already 
begin.

The plan is to have an NSArrayController to manage the favourites, all 
controller code will access 
the favourites via this object, and the favourites editor in preferences will 
use this to 
add/remove/modify favourites.

The connect sheet will continue to use the TableObject controller as an 
intermediary between the 
connect window and the favourites, to keep changes in the connect window from 
being saved.

What steps will reproduce the problem?
1. Create a query and save it as a favorite.
2. Click Edit Favorites and Edit query.
3. Create another query and save it to favorites.
4. Click Edit Favorites again and only one favorite will be displayed.
5. Delete the previous query and the more recent one will appear in its place.

What is the expected output? What do you see instead?
There should have been a list of all favorite queries.

What version of the product are you using? On what operating system?
Mac OS X 10.5.4.

Please provide any additional information below.
I would like to be able to give my saved queries names, so that I can keep them 
organized.

Nothing major, just basic growl support for a few items:

* Import finished (good for a long import where u might switch app to 
background)
* Export finished (maybe not needed)
* Table syntax copied (after copy table syntax)
* Connected (maybe if we have an auto-reconnect preference (not that 
connections die that often)
* Disconnected (good again if in background and connection gets terminated)
* Query Failed (maybe?)

The "Table Operations" and "Create Table Syntax" toolbar icons do not fit in 
with our vision of the 
toolbar.

Remove these two toolbar icons and add a new "Toolbar" menu (to the right of 
"Database"), 
containing these items:

 * Create Table Syntax - same as the existing toolbar icon
 * Check Table - same as the Check feature in Table Operations
 * Analyze Table - same as the Analize feature in Table Operations
 * Optimize Table - same as the Optimize feature in Table Operations
 * Repair Table - same as the Repair feature in Table Operations
 * Flush Table - same as the Flush feature in Table Operations

The progress indicator that's currently in the top right while a query is 
running would look nicer in 
the centre of the window.

Move it. :)

The switch to Table Structure/Table Content/Run Query/Table Status toolbar 
items need to have 
toolbar icons created for them.

Hi,

it would be nice if you could add a Wiki page on whether/how others can
provide localizations.

Count me in for the German one.

Hi,

something nice-to-have for much later:
Syntax highlighting for the console and SQL-Query tab.

The old check-for-updates system ([MainController checkForUpdates:]) has been 
disabled, because 
it was only functional for the CocoaMySQL project.

The updates checker needs to be re-implemented to function with our Google Code 
hosting. 
Perhaps using the [http://sparkle.andymatuschak.org/ Sparkle] framework.

The 'TABLES' and 'TABLE INFORMATION' Source List keys do not use the
NSLocalizedString() function and are therefore not localizable using
Localizable.strings

I know it's probably not a top priority, but for our workflow, being able
to support MySQL over SSL makes this app a must-use for us. To my knowlege,
it shouldn't be too hard, as it's just a command line switch with a path to
the file for the mysql client, but I'm not sure how it works using the
MySQL library in OSX.

The Table Content and Run Query views are in a mess after the recent UI changes.

Clean these sections up.

When creating/modifying a table allow user to insert a field/column after the 
currently selected 
field/column. If no selection then add at the end of the fields/columns (as is 
now)

What steps will reproduce the problem?
1. Similar to issue 22
2. Instead drag upwards.

What is the expected output? What do you see instead?
- Tables Table header bar and Table Structure table header bar should line up.

We need an project icon for Sequel Pro, currently we're still using the 
CocoaMySQL icon.

I was thinking a typical stack of database cylinders with a hammer (ala Xcode), 
but I'm open to just 
about anything that looks nice.

The File menu has a lot of menu items that are not even connected to an
action (Open, Save, etc.).
I think it would be best to just drop these as they can be confusing to the
user.

Also "New Connection" would be more descriptive than "New".

The connect window's "Add to favorites" check box has not been implemented yet.

When checked, it should save the details as a new favorite.

The "Show Variables" toolbar icon does not fit in with our vision of the 
toolbar.

Remove the toolbar icon and add "Show Variables" to the database menu.

enhancement request:
please consider the support of the "foreign keys" of INNODB tables

to my opinion that means, there should be 
1. in the "add index" dropdown menu 
- an additional selector for "FOREIGN KEY"
- a selector for the referenced table and
- a selector for the referenced column

2. the display of these two additional fields in the "Indexes" pane

you find these infos of an existing database with the "SHOW CREATE TABLE ..." 
command in the 
"CONSTRAINT ... FOREIGN KEY ... REFERENCES ..." lines

The database select pull down we have now needs to be moved into the toolbar.

If it's easy, make the pull down have a minimum width that's the same width as 
the table list split 
(if not, push that back to 1.0).

If someone wants to remove the database selector from the toolbar or hide the 
toolbar (See Issue 
#13) we need an alternate system for switching databases.

Add all of the databases to the end of the Database menu.

What steps will reproduce the problem?
1. Launch Sequel Pro

What is the expected output? What do you see instead?
There is a list of Databases that isn't populated, and no way of adding to
that list. This is actually a regression from CocoaMySQL.

What version of the product are you using? On what operating system?
.8 on Leopard

Please provide any additional information below.

It should be nice to add a Show/Hide Toolbar menu item.
The "official" shortcut for this is Cmd-Opt-T (according to the Apple Keyboard 
Shortcuts Quick 
Reference (2008-03-11). Yet, Sequel Pro uses, for now, this one for 
Edit>Special Characters…

Sequel Pro (0.9) doesn't save the width of the Tables column.
It saves size/position of the main window and the width of fields/columns, yet 
and it's really nice. 
:^)

When creating a new column, the default value for the 'Null' property is always 
NO. Add a 
preference to change this to YES.

In the database connect panel, you should be able to rename favourites by 
clicking the name in the 
table view.

remove the refresh table button
replace the check all/check none by placing the tables list in an 
outline-view-group under the 
database name (so you tick/untick the database to select all/none of the 
tables).

This is not a bug but a wish for new feature, not sure if this is the right
place for this, if not please let us know where to start a list :)

1. Search & replace, I know this can be done with SQL but it would be
easier for two input fields that this could be done. 

Reported By: Benjamin Schuster-Böckler

Is it feasible to make sequelpro threaded in a way that a long query doesn't 
hang up the frontend?

When selecting monospaced fonts in Preferences the 'TABLES' Source List key
will also be monospaced which does not look very nice.

When clicking on a table name in the left column while in "Table" mode, and 
then switching to 
"Browse" mode using the icon in the toolbar, the column headings for the data 
list doesn't display.

Resizing the window fixes the problem.

Not major, but worth noting and should be easy to fix :)

Using: MacBook Pro, Mac OS X 10.5.4.

When importing a text file currently we are limited to mapping a column of data 
to a field in the 
database once.

For example I have a data file with company details.
The database has both billing_company and shipping_company fields.
Should be able to map company field from data file to both fields in database.

Currently if a field has already been mapped you can't use it again.

What steps will reproduce the problem?
1. Create a new database connection, and specify a port instead of a socket
2. Try connecting to the new database specified

What is the expected output? Should result in a valid connection. 

What do you see instead? Unable to connect to host localhost.
Be sure that the address is correct and that you have the necessary privileges.
MySQL said: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (2)


What version of the product are you using? On what operating system? 0.9.1. Mac 
OS 10.5.4


Please provide any additional information below.

I'm trying to connect to my MAMP instance of MySQL running on their 
non-standard default port 
of 8889.

The "Flush Privileges" toolbar icon does not fit in with our vision of the 
toolbar.

It needs to be removed, and the same feature added to the Database menu.

We need to find all instances of CocoaMySQL and replace them with Sequel 
Pro/sequel-
pro/SequelPro.

I've done most of this, but there is still a few more places. I'm using grep 
-irsl to find files which 
contain the CocoaMySQL string. Many of the instances in the current revision 
are binary files, so 
cannot simply be replaced in an editor.

One thing that the MS Query Explorer had that I loved was the ability to
have many queries in the SQL window, but if one specific query was
highlighted, then only that one query would run (and not try and run
everything in the SQL composing box.

I'll attach a crude drawing to explain a little better.

And thank you so much for picking this up again. Thank you!

What steps will reproduce the problem?
1. Main window, drag the splitter between indexes table and table above all the 
way to the bottom

What is the expected output? What do you see instead?
- The add, remove, duplicate, refresh column buttons are partially hidden below 
the window frame

What version of the product are you using? On what operating system?
- Latest svn revision.

The connect window help button needs to open a help page of some sort.

When creating/modifying a table we should allow the re-ordering of 
fields/columns.

Make the console log detachable from the main window, for example to be placed 
on a secondary 
display.

Add some kind of "favourites" header to the LHS favourites list, it is 
currently unclear what the 
box does, especially when empty.

The SSH section is either broken or was never implemented. If was never 
implemented or 
difficult to fix, just remove it.

Add a single line of text "enter the details of the database", and a help icon 
to take you to a help 
topic with more info.

All changes in the connect window will auto-save to the currently selected 
favourite.

Add a "Custom" favourite to the end of the favourites list, which does not save.

Add +/-/duplicate buttons to the favourites list.

"-" button removes the selected favourite after a confirm alert box.

"+" will add a new empty favourite, unless the "custom" favourite is selected.

duplicate button will duplicate the current favorite

What steps will reproduce the problem?
1. Select a database and table
2. View the table contents
3. Go to File > Print > Preview

What is the expected output? What do you see instead?
I would expect to see a view of the table formated for printing but there
will only be the Table Source list.

What version of the product are you using?
0.9

The console drawer sucks. move it in as a resizable split in the main window.