open source alternatives
September 5, 2007 9:57 AM Subscribe
Does anyone know of a good open source alternative to Navicat for MySQL?
I've developed a web app with a fairly intense database behind it that several users need to sometimes create custom reports from.
Rather than waiting for me to code a report for them on request, they'd like to be able to create them on their own. So I'm looking for something similar to the visual query builder in Navicat.
Think easy to use, and would only be able to understand very basic SQL if necessary.
Thanks!
I've developed a web app with a fairly intense database behind it that several users need to sometimes create custom reports from.
Rather than waiting for me to code a report for them on request, they'd like to be able to create them on their own. So I'm looking for something similar to the visual query builder in Navicat.
Think easy to use, and would only be able to understand very basic SQL if necessary.
Thanks!
Actually the MySQL Query Browser has a Query Browser ;-) (MySQL Admin just launches it, its a separate app)
The Workbench may do what you want but I'm not familiar with Navicat so I can't answer authoritatively and my experience with the workbench was at an extremely buggy state.
posted by bitdamaged at 10:33 AM on September 5, 2007
The Workbench may do what you want but I'm not familiar with Navicat so I can't answer authoritatively and my experience with the workbench was at an extremely buggy state.
posted by bitdamaged at 10:33 AM on September 5, 2007
I still prefer Navicat, but years ago, I was using SQLYog, which practically has the same functions. I believe they still have a "community edition," which is free.
posted by chette at 11:56 AM on September 5, 2007
posted by chette at 11:56 AM on September 5, 2007
HeidiSQL is very good. I'm not sure if it i has a visual query builder.
posted by null terminated at 1:59 PM on September 5, 2007
posted by null terminated at 1:59 PM on September 5, 2007
Does it have to be a desktop app? phpMyAdmin (or its equivalent for your platform) might suffice.
posted by planetthoughtful at 9:12 PM on September 5, 2007
posted by planetthoughtful at 9:12 PM on September 5, 2007
Also, Navicat looks like a good product, but am I the only person who is deterred by different OS pricing? As a Windows user, the Navicat pricing makes me feel like I'm subsidising OS/X and Linux users. Not to say that arguments couldn't be mounted to defend this strategy (e.g., perhaps the dev environment costs more for the Windows build etc), but I still find it niggling enough to probably not put my money down.
posted by planetthoughtful at 9:15 PM on September 5, 2007
posted by planetthoughtful at 9:15 PM on September 5, 2007
Response by poster: phpMyAdmin is great... thats what I use ;-)
Hoping to give the users who don't know SQL some sort of access though, and this sort of GUI looked promising...
http://support.navicat.com/visual_tutorial/query_builder.html
posted by vitrum at 6:48 AM on September 6, 2007
Hoping to give the users who don't know SQL some sort of access though, and this sort of GUI looked promising...
http://support.navicat.com/visual_tutorial/query_builder.html
posted by vitrum at 6:48 AM on September 6, 2007
This thread is closed to new comments.
posted by ijsbrand at 10:25 AM on September 5, 2007