Navicat Review

I do a good amount of work in MySQL so that I need a good database admin tool.  I come from a Microsoft Enterprise Manager/Management Studio background so much of this review compares to that as a benchmark.

The Good

• Import/Export Data feature rocks.  Much easier to use then DTS for simple imports & exports & supports multiple formats (db, dbf, txt, html, xls, wk1, wq1, xml, mdb, ODBC)
• Dump as SQL.  Will write out your table to .sql file with the full inserts.  Microsoft so needs this.
• Maintain Tables.  Easily able to
• Backups.  Straight forward step by step.
• Saved Queries.  Navicat saves then within the application at the database level not a sql file, this makes finding queries much faster.
• Scheduled Job.  Again straight forward step by step
• Manage Users.  They make it as simple as MySQL can be (which isn’t that simple sense you have to create a user multiple times to have access from localhost and from anywhere)
• Data Transfers.  Their version of DTS, not as robust but gets the job done.

The Bad

• Query Windows.  This is my biggest complaint of Navicat and almost a show stopper for me. Tabbed windows are great BUT having multiple tabs within tabs causes my eye to lose focus of which tab I need.  Not good for quick tabbing, I have to think before clicking which slows me down. I much prefer how Management Studio has tabs for queries but shows results at the bottom of that window.

 

• Query Builder.  I do most of my SQL by hand so this doesn’t effect me to much but Navicat’s query builder uses the dreaded Grave `instead of the Quote ‘.  So if you use their query builder to get a sql statement started, maintaining it could be a nightmare.
• Designer. Seems clunky and implemented as a second thought.  Big improvements here.

Overall Navicat is the most feature rich MySQL tool on the market (I’ve tried ~4 so far). Pricing is at $139, well within reason. Besides a reworking of the query window, Navicat is a finely tuned.  2 TechToolBlog thumbs up.

Written by Tim on April 26th, 2007 with 7 comments.
Read more articles on database.

Adobe Open sources Flex - Who Cares?

Yesterday, Adobe announced they are open sourcing Flex, their all wiz bang Flash based web application builder. This seems to stem from their concern about Microsoft Silverlight/WPF/WP or whatever they are calling it today. This looks to be a Adobe’s last ditch effort to save Flash aka to Sun open sourcing Java. There is a reason Flex has never taken off, Adobe sucks at writing tools & programming languages/API for developers. Macromedia was bad (see Actionscript), Adobe is worse. Some companies can compete with Microsoft in terms of IDE & programming languages (Borland does a decent job) but Adobe is not one of them. Not to mention their Eclipse based IDE is not part of the open source release.

Most Flex/Flash users are designers in nature that want to go further so they pick up action script for a programming language on the side. Now you want these people to tear into some Java code? This could get ugly real fast. I’m not saying Silverlight/WPF/WP is going to be the end all, but sorry Adobe who cares?

---

Trying to write your own Java or Flash code? It might be easier to start with custom PHP/Perl script writing. Writing code can be tricky if you’ve never attempted it before, so look at free PHP scripts online first. Custom web programming is great if you can pull it off.

Written by Tim on April 26th, 2007 with no comments.
Read more articles on web 2.0 ish.