MacOSX Database Clients

If you are evaluating on what Database client application to use on Mac OS X. Here's some things to consider between SQL Grinder and Aqua Data Studio.

One nice advantage that SQLGrinder has over Aqua Data Studio is that it can keep the SQL color syntax between applications.

So if I have a SQL Query and copy it to Word/TextEdit/Pages the color syntax stays the same. Aqua Studio just copies the text unformated.

SQLGrinder handles Oracle connections better than Aqua Studio. Not sure the reason, but I am unable to make connections to Oracle using Aqua Studio. I believe that JDBC connections are managed better in SQLGrinder

I did have SQL4X Manager, but the version I have is old. (Purchased July 18, 2004) At some point I plan to test the latest version.

Update BBEdit?

Should I update BBEdit? What are the new features?

I am thinking this week of updating my BBEdit to the latest version 8.7 from 8.2. The upgrade only cost $30.

Since migrating to Textmate last year, I have been using Textmate for all my initial web development. Textmate is an awesome application and I would highly recommend it! However there some features in BBEdit that are pretty cool and worth keeping , here are some examples:

• If I open up multiple documents from an FTP application, such as Interarchy, BBEdit opens one window and puts all the selected files in a Drawer, which makes it easy to move around files. Thus making it easy when editing multiple files.
• The color syntax seems to be better in BBEdit than Textmate, the color tones are easier to read.
• After many years of using BBEdit I am very familiar with all the keyboard shortcuts.

The question is are the new features in BBEdit worth the upgrade? My initial reaction is that there isn't any must-have feature that I should upgrade for. So, for now I'll just use BBEdit 8.2 and Textmate 1.5.6.

To simplify matters, I have two FTP clients in my dock. When I want to use BBEdit, I use Panic's Transmit, when I want to use Textmate I use Interarchy. I think Interarchy and Textmate combination works really well.

I will be checking into Coda, the new application from Panic, which is supposed to be the latest and greatest FTP/Editor tool all in one.

Mouse-in-a-Box

I use the Kensington #72123 Mouse-in-a-Box as my computer mouse on my Powerbook computer every day. At home I use Logitech MX518 Gaming Optical Mouse. The Logitech is a great mouse, just seems a little "over powering" at times.

What amazes me is how simplifies the Kensington mouse is compared to the Logitech mouse. I really don't need a fancy mouse to perform simple tasks, clicking, right-clicking and scrolling. The Kensington mouse performs the task very well and a good mouse to have.

I purchase Apple's Wireless Mighty Mouse when it first came out, thinking it would be cool to have a wireless mouse. Today, the mouse is sitting on a shelf on my desk at home. Why? Well I had some problems with the mouse loosing the Bluetooth signal even thou it was inches away from the computer. I do bring it with me on business trips but very rarely do I use it.

This got me thinking about Apple's new iPhone that is going to be release this week. Sure its cool, got the latest technology, awesome graphics, and probably the best sound in wireless phones. But, is that something I really need? Am I better of just using a simplified solution? Earlier this year I got the LG VX8300 phone, and signed up with Verizon for 2 years. So I won't be jumping ship just yet to get the iPhone. However, I'll be checking out the phone the next time I goto the Apple Store.

In the meantime, if your looking for a good mouse, goto eBay and pickup a Kensington #72123 Mouse-in-a-Box. Currently you can get one for around $25.

Journler

To add content to this Blog, I am now using Journler, By Philip Dow, as my primary writing tool. Journler has a great writing environment and sophisticated tools that I need, such as tagging, organizing content by categories, custom labels, and a pretty good search engine.

I also like the default font that Journler uses: Cochin Regular 14n. However, sometimes I'll switch to Georgia Regular 14. If you use any Journal tool, try using Cochin or Georgia. When writing code I find that Monaco Regular 9 is better font to use, this is due to using BBEdit so much.

I still use TextMate to clean the code prior to going live since it has excellent HTML tools such as Google linking capabilities and entities converter. TextMate has quickly become an important part of my application development.

My day-to-day note-taking tool is still DEVONThink. I use this to store my source code examples and code references. All my personal and business documents are stored in Journler. This decoupling my personal life from my work life.

If your undecided between various Journal/Notetaking applications, I would encourage you to consider using more than one application. Consider one application for you business needs and one for your personal needs.

Macintosh Journal Tools

On my laptop I have both DEVONthink, MacJournal, and Journler. At one point in time I saw some value in each application and have purchased a license.

However, having mulitple tools is not very productive and can make finding information difficult. So over the next few days I am going to pick one application and use that as my default Macintosh Journal tool.

Top 5 functionality that I am looking for:

1. Search Functionality - not only within the application but also using Spotlight.
2. Label Content - Easily identify importaint content in the listing
3. Usibility - An application thats easy to use.
4. Sorting - Ability to organize content
5. Back up - Ability to do a complete backup and remove information as needed.

iSync Error Message

With the iPhone soon to be release, owners of any LG Phone, including my LG VX8300, will be seeing the following messages in iSync for a while.

An alternative solution is to use BluePhoneElite. For some reason the Address Book works fine when importing contacts. However the first name and last name get reversed when it goes to the phone, so on each import I have to change the order of the name.

VX8300 Wallpaper

I recently upgraded my cellphone and purchase a LG VX8300. I really like this phone over my Samsung A670 since it has Bluetooth capabilities and a better sound, including a speaker phone.

The screen is a little bigger, and I with that I needed create some new Disney World Haunted Mansion wallpaper. If your a Haunted Mansion fan, and have a LG VX8300 download these wallpapers that I created.

I am working on some ring tones. For some reason, Disney isn't providing any Haunted Mansions ringtones as they did when I purchased the Samsun A670 a couple of years ago. I think this is a big mistake since there are plenty of Haunted Mansions fans that would like to have Grim Grinning Ghosts as a ring tone. Once I am done with it, I'll put it up here so others can download it.

Apple Bugs

Google it...

Oh, Vista doesn't officially come till next week. Lets see where the numbers stand Tuesday morning (January 31, 2007), once users installed it and start blogging it.

iPhone for $499

Wow Apple announced the iPhone for $499! The bad news is that it runs on Cingular network.

Apple would have been better to make a couple of these for different providers. In the northeast, Verizon pretty much has the most coverage. After all, they will have to make a different phone for Europe and for Asia.

more later...

Quicktime Feature

I have been working on the features section of this website and looking to take advantage of using Final Cut Express HD that I purchased last year.

I have my VCR connected to my Sony DCR-TRV720, as a pass-through and connected to my desktop computer using firewire. I got this working in Final Cut Express, so that I can record video, by using File > Easy Setup and selected DV-NTSC DV Converter. The only downside is that the audio doesn't play through the speakers.

Final Cut Express HD is a great piece of software, and one of the cool things that I didn't know that was included is Apple Compressor. This allows me to compress multiple Movies at the same time! Very Cool!

I currently have Media Cleaner 5 for all my compression, and its a great tool. But its a little out of date and I am unable to compress using the latest H.264 Codec. I am not sure if its worth getting the upgrade to Cleaner 6.5 since that costs $179. I think the key advanage would be the RealMedia and the popular Flash Movie Format that is not available in Apple's Compressor2.

I'll investigate other options, as there might be some plug-ins that might work with Quicktime or Compressor, such as Helix Producer.