Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=39
Reporter:[email protected] Date:2008-08-27 21:00:40 Status:Implemented Closed:2010-02-01

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. :)

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=40
Reporter:[email protected] Date:2008-08-27 21:08:26 Status:Fixed Closed:2009-02-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=42
Reporter:[email protected] Date:2008-08-28 02:49:23 Status:Verified Closed:2008-09-01

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.
:^)

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=4
Reporter:[email protected] Date:2008-04-12 23:01:25 Status:Implemented Closed:2010-09-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=45
Reporter:[email protected] Date:2008-08-30 14:28:03 Status:Implemented Closed:2010-03-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=24
Reporter:[email protected] Date:2008-05-19 21:03:04 Status:Verified Closed:2008-05-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=48
Reporter:[email protected] Date:2008-09-09 03:59:49 Status:Verified Closed:2008-09-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=9
Reporter:[email protected] Date:2008-04-19 05:33:56 Status:Verified Closed:2009-05-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=26
Reporter:[email protected] Date:2008-05-25 21:20:28 Status:Verified Closed:2008-09-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=12
Reporter:[email protected] Date:2008-04-23 01:01:47 Status:WontFix Closed:2009-05-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=46
Reporter:[email protected] Date:2008-08-30 14:33:31 Status:Verified Closed:2009-03-01

Hi,

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=15
Reporter:[email protected] Date:2008-04-23 16:55:14 Status:Verified Closed:2008-07-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=21
Reporter:mattlangtree Date:2008-04-23 17:40:07 Status:Duplicate Closed:2009-02-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=25
Reporter:[email protected] Date:2008-05-25 16:15:29 Status:Verified Closed:2008-09-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=33
Reporter:[email protected] Date:2008-08-22 18:55:49 Status:Implemented Closed:2010-03-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=7
Reporter:[email protected] Date:2008-04-15 01:30:37 Status:Duplicate Closed:2011-01-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=3
Reporter:[email protected] Date:2008-04-04 18:47:33 Status:Verified Closed:2008-04-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=20
Reporter:[email protected] Date:2008-04-23 17:21:09 Status:Verified Closed:2008-04-01

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

Clean these sections up.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=36
Reporter:[email protected] Date:2008-08-22 19:12:17 Status:Fixed Closed:2008-09-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=22
Reporter:[email protected] Date:2008-04-24 23:38:14 Status:Verified Closed:2008-04-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=6
Reporter:[email protected] Date:2008-04-15 01:27:25 Status:Verified Closed:2008-09-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=32
Reporter:[email protected] Date:2008-08-01 00:03:20 Status:Fixed Closed:2008-12-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=11
Reporter:[email protected] Date:2008-04-23 01:00:15 Status:Fixed Closed:2008-12-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=37
Reporter:[email protected] Date:2008-08-25 18:01:53 Status:Fixed Closed:2008-09-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=19
Reporter:[email protected] Date:2008-04-23 17:10:04 Status:Verified Closed:2008-05-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=49
Reporter:[email protected] Date:2008-09-17 04:20:43 Status:Fixed Closed:2009-11-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=8
Reporter:[email protected] Date:2008-04-19 05:29:49 Status:Verified Closed:2008-04-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=16
Reporter:[email protected] Date:2008-04-23 17:00:42 Status:Verified Closed:2008-05-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=35
Reporter:[email protected] Date:2008-08-22 19:01:12 Status:Verified Closed:2008-08-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=47
Reporter:[email protected] Date:2008-09-06 02:40:40 Status:Accepted

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=29
Reporter:[email protected] Date:2008-06-04 16:02:10 Status:Fixed Closed:2008-11-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=10
Reporter:[email protected] Date:2008-04-19 18:42:25 Status:Fixed Closed:2009-06-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=18
Reporter:[email protected] Date:2008-04-23 17:07:46 Status:Verified Closed:2008-04-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=50
Reporter:[email protected] Date:2008-09-17 09:15:17 Status:Fixed Closed:2009-07-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=13
Reporter:[email protected] Date:2008-04-23 16:50:17 Status:Verified Closed:2008-04-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=31
Reporter:[email protected] Date:2008-06-15 22:03:31 Status:Implemented Closed:2009-11-01

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

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=44
Reporter:brad.estey Date:2008-08-29 13:19:19 Status:Fixed Closed:2008-11-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=27
Reporter:[email protected] Date:2008-05-26 21:11:50 Status:Implemented Closed:2010-09-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=1
Reporter:[email protected] Date:2008-04-04 18:36:09 Status:Verified Closed:2008-08-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=41
Reporter:[email protected] Date:2008-08-28 02:27:55 Status:Verified Closed:2008-09-01

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…

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=2
Reporter:[email protected] Date:2008-04-04 18:42:13 Status:Verified Closed:2008-04-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=5
Reporter:[email protected] Date:2008-04-12 23:21:00 Status:Invalid Closed:2008-09-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=43
Reporter:[email protected] Date:2008-08-28 07:05:18 Status:Fixed Closed:2009-03-01

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!

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=23
Reporter:[email protected] Date:2008-04-25 00:03:10 Status:WontFix Closed:2008-04-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=34
Reporter:[email protected] Date:2008-08-22 18:58:00 Status:Fixed Closed:2008-11-01

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

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=38
Reporter:mattlangtree Date:2008-08-26 16:59:25 Status:Duplicate Closed:2008-12-01

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?

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=30
Reporter:[email protected] Date:2008-06-04 16:13:20 Status:Implemented Closed:2009-05-01

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)

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=14
Reporter:[email protected] Date:2008-04-23 16:52:29 Status:WontFix Closed:2009-05-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=17
Reporter:[email protected] Date:2008-04-23 17:03:25 Status:Verified Closed:2008-05-01

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.

Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=28
Reporter:[email protected] Date:2008-05-31 18:19:19 Status:Fixed Closed:2009-05-01

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