Skip to content

A Superficial Review of Sequel PRO

Dear Reader,
If you work with MariaDB (MySQL) a lot, you understand the need for a good database client. I’ve worked with many different RDBMs in my career. Over the years I have learned what to expect from a good RDBMS client and Sequel Pro – a free database client running on OSX – has most of them.

Easily create databases and tablesScreen Shot 2015-10-07 at 8.47.32 AM

Most RDBMS clients will let you execute an valid SQL. You can write your own Create statements, Alter statements, or any other Data Definition Language (DDL) and execute it in the query window. A good tool – one like Sequel Pro – will make it easier for you.

Sequel Pro shines in this area by giving you the “Structure” area. You can examine and alter the structure of any existing table and create new ones by simply defining the entities in the form provided. All of the options that you can define in a Create/Alter statement can be set from this form.

Hand coded DDL is a thing of beauty but it can be a pain, especially if – like most developers I know – you only do it every now and then. Having a tool that helps you create your database is a wonderful thing.

Of course this isn’t a substitute for a good “Entity-Relationship Diagramming” (ERD) tool. If your database is going to contain more than 5-7 tables, you are going to need to diagram it out. There are some good tools on the market to do this, but don’t expect it from your client.

 

Easily see data

Screen Shot 2015-10-07 at 8.47.55 AMWhen I started learning about RDBMS I was working with a language called FoxPro. FoxPro was awesome because it was a language built around an RDBMS. One of the great features of FoxPro is what we called “Danger Browser”. In Browse mode, we could simply open a table and scroll through the data. The upside is that it was very handy, especially in development, to be able to just see the raw data. The downside was that you browsing the data LIVE. One errant keystroke and you could easily wipe out the data in a field.

Sequel Pro gives you the power of the Browse with it’s “Content” area. When you click on “Content, you can select any table and browse through it 100 records at a time. Like Foxpro, the data is live and you can edit it – accidentally or on purpose – right in the grid.

One really cool feature of Sequel Pro’s Browse is that you can apply a simple filter to the grid. At the top of the grid are 3 simple fields.

  1. A drop down of all the fields in the current table.
  2. A list of common conditionals like “equals”, “contains”, starts with”, etc.
  3. A text box to enter a value.

Using these three fields, you can quickly filter the data to only the records for which you are looking. Once you have the data filtered, you are still in Danger browse mode, you can still edit the data live.

 

Easily execute queriesScreen Shot 2015-10-07 at 8.48.42 AM

This is the main purpose of the database client, to execute Data Manipulation Language. (DML) Select statements, Updates, Deletes, Inserts. The heart of any CRUD application. The whole point of having a client is so that you can easily run these types of statements. Regardless of whether you are doing maintenance on the database, or testing the query, a good database client will make this task easy.

Sequel Pro does a great job of this. Queries can easily be executed using the “Query” area. The resulting rows – if the query returns a result set – can easily be exported to CSV or even SQL statements.

The Query window can hold multiple statements. Not all RDBMS clients will allow you to do this. Do not take this handy feature for granted.

The “Run” button changes based on context.

  • If your cursor is on a statement, then you can “Run Current”
  • If you have selected text, – regardless of whether it is syntactically valid DML – you are offered the option of “Run Selection”.
  • If your cursor is just past a statement, you are offered the option to “Run Previous”

The only thing to watch out for is properly ending your statements with a semi-colon. Without that, Sequel Pro will assume that two statements are together, even if there are blank lines between them.

Easily manage usersScreen Shot 2015-10-07 at 8.49.13 AM

Managing users in MySQL has always been a  pain. The command line client that comes with MySQL does not make this task any easier. Sequel Pro does. It makes it very easy to manage users, but also the hosts from which a user can connect. Defining the permissions for any given user/host combination is easy and the flow is obvious to anyone who has worked with MySQL.

Previous versions of Sequel Pro had an issue where the program would abort after setting user permissions. The permissions were set, but to confirm them, you had to restart the program. The most recent version – Sequel Pro 1.1, Build 4499 – seems to have cleared this problem up.

Conclusion

Screen Shot 2015-10-07 at 9.13.17 AM

Sequel Pro is a good solid Mariah DB (MySQL) client. Sadly for my non-OSX friends, it is only available for OSX. The current version, 1.1, is rock solid on El Capitan. I’ve not had a single problem with it.

Sequel Pro is one of the 2-3 programs that I have open at all times and usually connected to multiple databases. It is a tool that I have come to rely on and one that is easy for me to recommend to any developer.

Until next time,
I <3 |<
=C=

SQLYog – A superficial review

Dear Reader,

SQLYog About ScreenSeeing my recent superficial review of MySQL Workbench and knowing that I like SQLyog, my buddies over at webyog pinged me and asked if I would be interested in reviewing SQLyog also. Knowing me as they do (I’ve been a beta tester for several years) they did the one thing they knew would get my attention, they gave me an enterprise license. (Actually, they replaced the one I had and had lost)

(more…)

MySQL Workbench – A Superficial Review

Dear Reader,

MySQL Workbench Splash screen
Those of you who know me, know I am an old school database guy. One of the things I miss from my pre-web programming days is sitting down with an Entity-Relationship Diagramming tool and painting a picture of the database I want for my application. Since moving to MySQL as my primary database, I’ve tried out several ERDs. I’ve loved at least one, hated most others for either lack of features or price tag – or both – or been generally just unimpressed. Recently I got an email from MySQL saying the latest version of their ERD tool had been released. Honestly, it had been a while since I had taken a look at it so I thought maybe I’d give it a go. Below is what I consider a very superficial review of this tool and a couple of conclusions, both good and bad.

(more…)

New Project – Queuebuddy

Dear Reader,

I’ve been working on a project for a while now and it’s finally ready for testing. Queuebuddy.com started life as a way to help me keep track of movies I want to see but don’t feel like paying to see in the theater. (If you are really curious, email me, I’ll give you what Wife 1.23 refers to as “The Hollywood Speech”) Anyhow, you can register, login and grab the bookmarklet. Then when you are surfing imdb.com you can click on the bookmarklet when you are on a page of a movie you want to see on DVD> When it comes out on DVD.

There’s no fee, there’s no commitment and other than an email when the DVD comes out, we won’t even bug you. So if your interested, drop by and try it out.

Two notes:

  • Since it relies on a bookmarklet, it’s only really usable in FireFox. Apologies to all my Microsoft friends.
  • I’m currently only tracking Region 1 release dates. Since the MPAA and it’s friends deem it necessary to screw over the rest of the world with this stupid region encoding scheme, I will too. (I did have high hopes that Austrailia was going to pass a law a few years ago that made region encoding illegal but I guess too many people decided they couldn’t live unless Hollywood craps in their living rooms because the law failed to pass.)

Oh yeah, as with every web 2.0 property, this is a BETA. There will be bugs and I’m a programmer, not a designer, so it’s pretty ugly right now.

One final note, it”s written using the newly released Zend Framework 1.0. I’m working on a tutorial for DevZone that shows some of the things I learned.

Until next time,
(l)(k)(bunny)

=C=

You heard it here first. (Job Posting)

Dear Reader,

Ok, I’ve got 2 really primo jobs hanging out in my mail box and before I start pimping them on CL and elsewhere on the net, I thought I’d post them here for my friends or friends of friends.

I am helping a friend and previous employer, Jupiter Hosting. (www.jupiterhosting.com), find a few good people to flesh out their operations team. The first thing they are looking for is a

“Unix Systems Administrator | WEEKEND DAY SHIFT OPERATIONS”.

Now first, I’ve got to limit this San Jose/Santa Clara/Silly-con Valley area people as this is an on-site position.

To fill this position you will have to be fluent in FreeBDS and Most current Linux distros. There’s a hardware support involved in this job. (rack, cable and IP servers) You’ll also do a little troubleshooting of hardware. (backup the hard drive, pull it out, fling it against the wall, install a new HD and restore the backup, re-rack the server before the original harddrive is finished spinning down. the normal Herculean efforts that Admins perform on a daily basis at a hosting company)

The job is mainly software support though. You need a thorough (and yes, I mean seriously thorough) understanding of the following packages:

  • MySQL
  • Apache
  • DNS Record Administration
  • NFS / NAS File Servers Administration and Troubleshooting
  • PHP (Installation, configuration, and troubleshooting – NOT PROGRAMMING)
  • Rsync
  • Most Open Source Mail Applications
  • SSHd

There are other qualifications and restrictions. Drop me an email and ask for the complete job description if you are interested.

This is a great position and a super company to work for. I personally know a lot of the people on the Ops teams and you won’t find a better group to work with.

They are also looking for an “Operations Manager”. Someone who knows all of that but can also manage the teams.

These type of positions don’t come around often. I’ll be posting them around the net in the next few days but if you want to be considered for one of them early, send me your resume IN A TEXT FILE to calhr@1100tech.com. Make sure you specify “Admin” or “Ops Manager” in the subject line.

Until next time,
(l)(k)(bunny)
=C=

p.s. NO AGENCIES! and sorry, no telecommute.