Sequel Pro
Your rating: Now say why...

(6) 4.833333333333333

Manage MySQL databases.   Free
Add to my Watch List
Email me when discounted
Sequel Pro is a fork of the abandoned CocoaMySQL project, with plans to expand to other database engines and improve the user interface. For more information, visit the Sequel Pro website.
What's New
Version 1.0.2:

Interface
  • Fix blurry text in a number of SQL text views
  • Always run on Integrated Graphics on machines with both integrated and discrete to improve power consumption
  • Correctly restore the tab bar label when cancelling a connection
  • Fix high CPU usage when displaying certain blocking alerts
  • Improve menu items’ enabled state following a connection
  • Fix display of information when using the Navigator
Connection View
  • Fix crashes when importing favourites on the connection view
  • Scroll to and select newly created favourites after import
  • When selecting a favourite with no password, don’t set the focus on the password field at once, but set it as the next responder for the tab key
  • Fix a crash if duplicating a favourite and denying keychain access
  • Fix odd behaviour when trying to edit or autogenerate the name of SSH connections
  • Support favorite imports from old preference .plists
Connection Handling
  • Fix a range of crashes related to SSH connections in certain network/server conditions
  • Fix occasional invalid connection details loaded from .spf and .spfs files suring startup or when duplicating connection tabs
  • Fix the “Add to Favorites” menu item’s appearance and functionality
Translations
  • Fix support for export path tokens containing spaces, including fixes for the French translation
  • Improve localisation support across the interface
  • Fix and update translations
  • Add a Spanish localisation – with many thanks to Juan Pablo Atienza Martínez, with help from Pablo Oneto, Jaime Martin, and Samuel Abraham de Vega García
Tables List
  • Fix error dialogs when selecting tables with double dashes inside field names
  • Add an option to “Force delete” tables in the table deletion confirmation dialog to disable foreign key checks, and display a more helpful error message when deletion fails due to foreign key checks
Structure Tab
  • Fix handling of BINARY properties when reordering and editing fields
  • Fix unsetting of BINARY properties on fields
  • Fix errors editing or reordering fields on server versions which do not support character sets or collations
  • Improve interface handling and query generation on server versions which do not support character sets or collations
  • Fix errors when converting some string types to blob or binary field types
Content Tab
  • Change ‘=’ and ‘!=’ filters to be case- and collation-insensitive by default, allowing the Shift key to trigger a BINARY exact match
  • Fix escaping of backslashes when using the ‘=’ or regex content filters
  • Fix handling of primary keys using both multiple keys and specified field lengths
  • If deleting a date or time field which allows NULL, set the cell value to NULL
  • Import custom content filters into the Global group by default if no saved document is available
  • Scroll to and select newly imported custom content filters
  • Fix display truncation of the value of BINARY string types to 256 characters
  • Fix crashes when displaying certain types of BIT data
Query Tab
  • Combine the “Run All” and “Run Current/Previous/Selection” buttons into a single button
  • Add a dropdown menu to the single button to allow setting the default action and use of the alternate action
  • Move the Run commands from the “gear” button to the Run button dropdown for easier discovery of shortcuts
  • Fix SQL parsing inside unterminated delimiter statements
  • Import custom query favourites into the Global group by default if no saved document is available
  • Scroll to and select newly imported query favourites
  • Apply the theme background to the query favourites SQL editor
  • Set text entry focus to the custom query editor if the view is active when the window is opened
  • Adjust the keywords list to fix autocapitalisation of “ON”
  • Fix query execution timing for queries with no result sets
  • Update the query status results to no longer always suggest an error has occurred
Relations Tab
  • Support basic display of all the fields in composite foreign keys
Import / Export
  • Fix errors that could occur when generating new tables from CSV imports
  • Show a clearer error message if a target export folder is no longer available
  • Fix errors when exporting views with timestamp fields allowing NULL
Server Processes Panel
  • Fix process list kill query and kill connection actions on filtered process lists
User Manager
  • Improve user manager data loading to significantly speed up opening the user manager
  • Fix support for schema permissions for the Anonymous user
  • Add support for displaying ‘%’ and ” databases if already specified
  • Highlight databases in the user manager that already have permissions specified for the selected user
  • Fix crashes in the user manager when fields don’t validate but the record attempts to apply changes anyway
  • Improve data sharing for further speedups
Other
  • Fix database creation to correctly use specified database encodings
  • Display the server’s default character set when creating a database
  • Ensure that switching databases without selecting tables updates the connection encoding correctly
  • Fix errors when deleting custom content filters or query favourites while editing them
  • Add a spotlight comment to allow easy location of Sequel Pro with search terms other than the name
  • Improve upgrades from previous preference versions
Version 1.0.2:

Interface
  • Fix blurry text in a number of SQL text views
  • Always run on Integrated Graphics on machines with both integrated and discrete to improve power consumption
  • Correctly restore the tab bar label when cancelling a connection
  • Fix high CPU usage when displaying certain blocking alerts
  • Improve menu items’ enabled more...
Requirements
Intel/PPC, OS X 10.5 or later



MacUpdate - Sequel Pro




  • Querious
    +6

  • RazorSQL
    +4

  • CocoaMySQL
    +4

  • Navicat Premiu...
    +4

  • Valentina Stud...
    +3

  • SQLEditor
    +2
Sequel Pro User Discussion (Write a Review)
ver. 1.x:
(6)
Your rating: Now say why...
Overall:
(42)

sort: smiles | time
burypromote

morimuc reviewed on 04 Nov 2013
For me as a non-coder it´s great cause I don´t need no mess up with the shell.
[Version 1.0.2]


burypromote

-1

Mjmsmith reviewed on 08 May 2013
Best in class.
[Version 1.0.2]


burypromote
+1

+39

Fightingcat reviewed on 06 Feb 2013
The best client ever who I got for free to manage my SLQ dbases. And I'm so happy that this project is still alive. I only not like the new icon. Well, it's a bit funny, but it looks not like a charm. I loved so much the first icon with the dolphin... after a long time I give up to copy and past it with each update and now I got this yellow (urine) thing, served with butter :-X
[Version 1.0.1]

2 Replies

burypromote
+1

+680
sjk replied on 08 May 2013
"… and now I got this yellow (urine) thing, served with butter :-X"

Ha. Being hungry for breakfast, it looks like a short stack of fat floating pancakes with syrup and butter to me.
burypromote

+855
Negritude replied on 08 May 2013
It's obvious that you are not from North America, otherwise, you would clearly understand the powerful imagery referenced in the icon, which is the breakfast staple of pancakes with syrup.
burypromote

+16

Sparrowhawk reviewed on 25 Jan 2013
v1.0 RC1 is out (you can download it via the blog pages)

This latest release adds polish to the interface and even more stability. There are some great time savers such as folders in the connection list, and bug fixes (find/replace now work correctly in the edit-field view)

All in all, this really is a gem of the Mac development tool world.

It still has some features missing (Stored routine support is rudimentary so I use Workbench for that) but overall it is an A+ application.

Future releases plan to support PostgrSQL and possibly SQLite which will open up this wonderful app to even more developers.
[Version 0.9.9.1]

5 Replies

burypromote

+2
rz192072 replied on 21 Mar 2013
Take a look on Valentina Studio 5.1 FREE. Works with mySQL, PostgreSQL and SQLite. Also can do diagrams and reports and a lots of other things.
burypromote

+16
Sparrowhawk replied on 09 Apr 2013
I have tried Valentina: I didn't like the UI. It also failed to show me any of my stored routines, unlike Workbench or Sequel Pro.

Additionally, you really ought to publicly declare that you are the owner of the company making the product that you are recommending - I checked your profile and did a quick Google check.
burypromote

+2
rz192072 replied on 10 Apr 2013
Sparrowhawk, so easy google did job? And product I did recommend is free. What troubles?

I self have used several years CocoaMySQL and Sequel Pro working on Mac and with remote mySQL servers. And I did not like UI. But last 6 months I did stop use it, because our own Valentina Studio works now with mySQL.

We have check - procedures are shown and can be edited. In Sequel Pro procedures are shown in same list on left side where table are (hmm?). In VStudio, procedures are grouped separately. May be you did search them by habit in wrong place? Besides, we have not found way how to add a new procedure in UI of Sequel Pro.

With all respect to Sequel Pro, it does not have right now, for example:
- related data editor
- advanced filters of records
- query builder
- diagrams
- support of postgre SQL and SQLite
- support of win and linux
- ...

I hope this info can be useful for somebody :-)
Why not to use two tools if that is easy possible. Right?
burypromote
-1

+16
Sparrowhawk replied on 29 Apr 2013
Perhaps because this thread is to do with Sequel Pro and that you did not state that you are the owner of a competing product? Just a thought.

With regards procedures, I clicked on the procedures control: they simply would not load. Other object types loaded when addressed in the same way, but not procedures.

With regards your comments on Sequel Pro, I am surprised that you did not like the UI - it is a byword for good design and clarity in OS X database admin circles. I'm afraid that I found VS less intuitive - I accept that this may be personal preference.

"In Sequel Pro procedures are shown in same list on left side where table are (hmm?). In VStudio, procedures are grouped separately. May be you did search them by habit in wrong place? "

No, I saw precisely where procedures were supposed to be displayed in VS, just as with other database object types. VS studio simply did not list them. Not sure what you mean by "hmm" though: perhaps you think that this is the wrong place for them, I disagree - I prefer a tree/pseudo tree control on the left to having to click drop downs to access object types (as done by Workbench, TOAD, etc etc). Each to their own though.

"Besides, we have not found way how to add a new procedure in UI of Sequel Pro."

That's correct, it has a View source, but no create. I believe that this is coming but in the meantime, as I said, I use Workbench for Stored Procs as its editor is very capable.

"With all respect to Sequel Pro, it does not have right now, for example:
- related data editor "

Not quite sure what you mean here, but if you mean data linked through foreign key relationships, simply clicking the arrow in the field in the result set view takes you to the related row... This is not available with MyISAM tables of course.

"- advanced filters of records"
I believe that is coming soon as it is one of the most asked for features

"- query builder"
I have absolutely no need for this - I have been designing SQL databases for over 20 years so I want my toolset to be as lean and fast as possible. For beginners I agree that this may be of use

"- diagrams"
I use Workbench which is also free - incidentally, I see from your site that you must pay for the pro version to get full use of diagramming (synching between model and database bidirectionally). I have no problem with that, but it's not comparing apples with apples.

"- support of postgre SQL and SQLite"
True. I use Base for SQLite, I don't use PostgreSQL so presently this is not an issue for me. Both have been requested and I *think* are being worked on

"- support of win and linux"
Of no interest to me. When I do have to use those platforms as clients, I use Workbench (or ideally TOAD on Windows).

"- ..."
?

To be clear - I have nothing against your product. Perhaps you are not aware of the MacUpdate etiquette, but linking to your own product is considered bad form - at the very least you should add a disclaimer as to your relationship with the linked product.

This is not meant as personal criticism, I hope you do not take it that way. I wish you all the best with VS which I am sure does appeal to many people.
burypromote

+16
Sparrowhawk replied on 29 Apr 2013
To be clear, when I wrote "(as done by Workbench, TOAD, etc etc)", I was referring to the fact that the way they do it is similar to Sequel Pro.
burypromote
-1

+77

Mikael B reviewed on 14 Jan 2013
I'd love some additional features, but Sequel Pro does a whole a lot and well at that. Essential for testing MySQL on OS X.
[Version 0.9.9.1]


burypromote
+1

+5

Creativecag reviewed on 21 Feb 2012
I can't express how great this app is and I hope I reflect that within my rating but one thing that many Mac and web developers are using now is SQLite. This has been on Sequel Pros requested feature list for as long as I can remember yet it's never been implemented. There is not one single good SQLite DB editor on the market (even the paid ones suck IMO) and they could steal an entire market all with this one feature. I'm frustrated because your product rocks but it's got a glaring hole where SQLite integration should be!

Other than that little rant, great job :)
[Version 0.9.9.1]


burypromote

Mnifjm reviewed on 21 Feb 2012
As a long-time user of Navicat I was pleasantly surprised to discover Sequel Pro. Though it's not quite there yet, this could become a permanent replacement. Navicat has become increasingly frustrating to use since version 6 which was very good GUI-wise but sucked at handling Unicode data. I'm forced to use version 7 for some tasks and version 6 for others. I hate that.

I just love Sequel Pro's user interface. Moreover, it's fast and stable. So why isn't it quite there yet? Data Transfer! I've got lots of databases in two or three locations that I need to synchronise frequently. Navicat makes that a doddle. So that's my number one feature request for Sequel Pro.

Also, I haven't been able to figure out how to edit my stored procedures, but maybe I'm missing something obvious.

Overall though, this is simply a wonderful piece of software. Kudos!
[Version 0.9.9.1]


burypromote
+1

+15

Ghostcat reviewed on 09 Sep 2011
Ever since MySQL discontinued the (simple, but buggy) GUI Tool in favor of MySQL workbench, I have been meaning to find another free easy-to-use database management app.

Sequel Pro is way better than I could have hoped for. This app instantly made my life easier when it comes to databases.
[Version 0.9.9.1]


burypromote

+9

Soundfreak reviewed on 01 Jul 2011
I have been managing many databases for personal and professional websites using this tool since months. It is so easy to use, clean interface and works just fine.
I would pay for it !
[Version 0.9.9]


burypromote

+42

Peternsteinmetz reviewed on 14 Apr 2011
Worthy successor to CocoaMysql. Very convenient setup for ssh tunnels and clean gui.
[Version 0.9.8.1]


There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.


+1

whatUwant rated on 27 Oct 2013

[Version 1.0.2]



Skipras rated on 20 May 2013

[Version 1.0.2]



amoiseev rated on 09 May 2013

[Version 1.0.2]



+4

Mammut rated on 10 Oct 2012

[Version 0.9.9.1]



ste__ste rated on 08 Jul 2012

[Version 0.9.9.1]



Michael_Candelas Jr-va@y rated on 07 Jan 2012

[Version 0.9.9.1]



+7

Kyle Barrow rated on 13 Dec 2011

[Version 0.9.9.1]



Jamiepeloquin rated on 01 Sep 2011

[Version 0.9.9.1]



blublub rated on 17 Aug 2011

[Version 0.9.9]



+2

Aeon rated on 22 Jul 2011

[Version 0.9.9]


Downloads:24,051
Version Downloads:4,152
Type:Internet : Internet Utilities
License:Free
Date:08 May 2013
Platform:PPC 32 / Intel 64 / Intel 32 / OS X
Price:Free0.00
Overall (Version 1.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-10 of 33
1 2 3 4 >
Displaying 1-10 of 16
1 2 >
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
Sequel Pro is a fork of the abandoned CocoaMySQL project, with plans to expand to other database engines and improve the user interface. For more information, visit the Sequel Pro website.


- -