Sequel Pro
Sequel Pro is a MySQL Database Management Application for Mac OSX 10.5 and 10.4. It’s released under the GPL Open Source License and is a very capable MySQL management app. I’ve used a number of these over the years and Sequel Pro is probably the best fit for the needs of most average MySQL administrators / users. It’s not hugely feature rich, but it does what it does very well.
So what can it do?
- Manage multiple database connections
- Manage multiple databases within each connection.
- Add databases
- Add tables
- Modify tables
- Browse data within tables
- Filter data browsed (although I couldn’t see a way to order by)
- Create and maintain relationships on tables that support it (such as INNO tables)
- Get table statistics
- Add rows
- Remove rows
- Duplicate rows
- Issue arbitary SQL queries through the ‘command line’.
Sequel Pro New Connection Screen
Connecting to a new database is easy, using either File > New Connection or by pressing CMD-N. This will present you with a very clean dialog box to enter the server details, with the opportunity to tunnel the connection over SSH if required. I’ve not tried this since I use a VPN to connect to my production server and the development servers are on the local LAN which is firewalled anyway.
Once connected to your database, assuming there’s already data in it, you’ll see the tables on the left with the table information below, some toolbar buttons at the top, the table definitions (structure) or data in the main window and the indices defined for this table in a table underneath. An image speaks a thousand words so here’s what it will look like.It does have one major drawback when compared to phpMyAdmin however, which means we’ve rated it down a little unfortunately. The ability to import and export databases as SQL statements. Part of the way we develop websites is to develop locally, using a development database. When the site is to be uploaded and subsequently made live, it’s quite often that we like to also use the database (for example, if we’ve developed a WordPress website or a CS-Cart website, then naturally we’d want our content to be uploaded too). CS-Cart is especially useful for this because none of the URL based configuration is stored in the database, so we can develop the shop locally and then when we’re ready, upload the lot and export/import the databases. Sadly, to do that we still have to use phpMyAdmin.
No related posts.
(No Ratings Yet)
Loading ...
Just a quick note to point out that Sequel Pro does support SQL import and export – under the File menu, there’s “Import” (which also supports CSV), and “Export” > “MySQL dump…”, which also gives control over which tables to export and a couple of other things.
There’s also the ability to select a few rows and Edit > Copy as SQL, if you only need a statement for a few rows!
Both have been around for a few versions, but 0.9.7 has significantly improved speed and reliability, especially for very large SQL dumps.
User management should arrive in 0.9.8.
Some sort of migration wizard will hopefully come in future versions…
Thanks for the review – we’ll keep plugging away and improving Sequel Pro!
Hi Steve.
Enjoying your reviews, thanks.
Is it possible when including an image that might be quite large to make it a hyperlink bringing up a larger size popup of that image so that smaller detail is visible ?
Ta.