- #SEQUEL PRO FOR MAC MAC OS X#
- #SEQUEL PRO FOR MAC MAC OS#
- #SEQUEL PRO FOR MAC UPDATE#
- #SEQUEL PRO FOR MAC FULL#
- #SEQUEL PRO FOR MAC PLUS#
It's not a silver-bullet solution of course it doesn't do much more than PHPMyAdmin and the things it does can be replicated in PHPMyAdmin with relative ease but then it can't be a bad thing to have lying about, especially since it's free!
#SEQUEL PRO FOR MAC MAC OS#
It's a bloody useful tool and a must for anyone working with MySQL databases under Mac OS X. Any of the generated result sets can be exported in the previously mentioned formats for easy data filtering and export. The power here comes from the ability to store previously used queries and access recent queries via a query history.
The editor itself has autocompletion and some niceties like smart quoting of field names. This view allows you to enter queries and run them against the database.
#SEQUEL PRO FOR MAC PLUS#
Copying rows as INSERT statements is a big plus ( ^+⌥+⌘+C) and useful when copying singular entries between a development and live database, rather than dumping the data from a custom query. Inserting NULL values is as simple as hitting ^+⇧+N.
#SEQUEL PRO FOR MAC UPDATE#
The SQL import will obviously just run the query and update the various tables as required, the CSV import on the other hand allows you to select the table and marry rows in the CSV file to those in the table you wish to import to.Īs detailed above the table structure view allows you to define the structure of the tables in the database and to set up the indexing and keys for the fields.Ī nice touch available here is the ability to reorder pre-existing fields by dragging and dropping them in the relevant places and the ability to duplicate fields rather than have to re-enter details for virtually identical fields.įrom there you can add, modify, duplicate and delete rows in the table, all of which you'd really expect from the table contents view.Īgain, like the table structure view, you can duplicate entries to save re-entering similar data. ⌘+⇧+I invokes the import dialog which allows you to select an SQL dump or CSV of values to import into the selected database. From the File > Export menu you can export data in various formats, CSV and XML being the most useful. The +/- toggle at the bottom left allows you to add and remove keys/indexes.Ĭhanges the view to the structure view as shown and detailed above.Īnother of the real selling points for Sequel Pro for me is the ability to easily import and export data. This area allows you to manage keys and indexes of the table you're viewing. This portion of the interface is controlled by whichever view is selected from the icons appearing in the application toolbar. From here we can add, remove, duplicate and truncate tables with ease (with conformation on the obviously destructive actions). Below the list of tables is a small section with meta-data on the currently selected table, under this is the controls for the database tables. If the number of tables is large enough a filter field appears at the top of this list allowing you to filter the tables based upon their names. The list of tables in the currently selected database. The image above is an annotated view of the Sequel Pro interface, the main portions of the interface that I use day-to-day are highlighted and numbered, each of the numbered areas correspond to:Ī basic drop-down list where you can select a database to work with or add a new database.
Sequel Pro essentially provides a desktop solution that is very similar to PHPMyAdmin, anyone who has experience using PHPMyAdmin should have no problems to adjusting to using Sequel Pro in its stead. Sequel Pro is a very streamlined and powerful program for database management, it provides the facility to add, modify and remove entire databases supports various import and export formats for singular tables, entire databases or selected query results allowing modification of table properties as well as inline SQL querying.īefore finding Sequel Pro I was a full-time user of PHPMyAdmin, a system which I continue to use in some instances.
#SEQUEL PRO FOR MAC MAC OS X#
The best tool by far I've found for managing MySQL databases under Mac OS X is Sequel Pro (previously CocoaMySQL). MySQL is my DB of choice, due to working mainly on LAMP architecture systems. A good Database Management System (DBMS) tool is one such tool since database management and manipulation plays such a large part of developing any content managed website, especially for quick modifications, testing and deployment. I need a set of good tools in order to make aspects of the work easier or I'd spend my entire life at odds with what I do.
#SEQUEL PRO FOR MAC FULL#
I do a lot of web development it's my full time job, my hobby and a means to potentially earn some money on the side.
0 kommentar(er)
