Musings from Mars Banner Image
News in Mysql: Aqua Data Studio: Query and Data Model Analyzer... | PGnJ: Database Manager for Postgres and MySQL... | DbVisualizer: New Version of Universal Database Management Tool... | CocoaMySQL: The Absolute Best Tool for Managing MySQL Data on Mac OS X... | Tense Log and Related Site Management Tools... | PHP Class To Convert MySQL to JSON... | Mambo: Best Open Source CMS?... | 
For Software Addicts: Yes!MaybeNah!
Articles in

Articles in "Mysql"

October 17th, 2006

What’s The Best Mac Database Tool for MySQL?

Although I’ve been MySQL Mac OS X Database Tools Shootoutdeveloping websites with MySQL for over 7 years now, until recently I had almost always used phpMyAdmin to manage my databases. phpMyAdmin is such an excellent web application and makes managing MySQL so easy that the only time I strayed was when it wasn’t available on the host server (which was very rare). When I needed a desktop MySQL client, I had turned to YourSQL, which I determined a couple of years ago was the best for me when connecting to MySQL from Mac OS X.

For various reasons that I won’t bore readers with here, I found myself needing a Mac desktop client for MySQL again recently, so I took the opportunity to review the market once again. What surprised me most, I suppose, is how many options there are for Mac OS X users who do a little light database work. (Caveat: I am by no means a database administrator, and my knowledge of SQL and MySQL is merely sufficient to develop web applications—meaning, I can build tables, relate tables, and build queries for those tables. The tools reviewed here are from this use case alone.) In the course of testing, I tried out nine different database apps:

Full article

April 12th, 2006

Web-Based Collaborative Editing: Twiki, Tiddly, or TikiWiki?

Wiki ExplosionI spent a few weeks in December 2005 investigating the universe of wiki software, and confirmed what I already suspected: It’s a very big universe with many wikis! It would be impossible to explore them all, so I first tried to come up with a short list of wiki engines to focus on. Fortunately, there are a number of excellent sites that attempt to provide matrices of wiki software functions and abilities. Here are a few I used and recommend:

After studying these various resources, I was able to narrow the list of wikis down to the following:

MediaWiki was the default choice, since I assumed it was probably the best of the lot, given its starring role in powering Wikipedia and just about every other high-profile wiki you encounter on the web. After a painless default installation of MediaWiki, I had the usual MediaWiki shell and did a few quick walk-throughs of the structure just to make sure all the plumbing was in place. It seemed to be, so I proceeded to install a few of the others from my short list.

Full article