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. 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. Looking forward to seeing all the enhancements to come.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. And, I know that it's already getting a following on Git. However, it is open source and available on Git Hub and I know the Moballo, LLC team is focused on trying to address some of the quirks. That could definitely be a lot easier to do. plugin to format your sql statement takes some real digging on the inter webs to make work. ![]() There's some quirks that will drive you crazy. It's not perfect, if possible I would have given it 4.5 stars. Poke around in the tool, you'll be surprised at some of it's features. Very handy for getting test data from a production database into your test database. Write a query or filter the rows in a database and if needs be you can select all the rows and copy it as a giant SQL Insert statement. Sure, it's got all your normal tools for working with databases, see table info, details, change schemas, write sql etc. This is a handy, quick, Mac native tool for working with MySQL databases. An indispensable tool for your database toolkit.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |