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