#964 (ok 3.4) AJAX-based graphical query builder

fixed
nobody
None
1
2013-06-11
2006-10-06
No

One admittedly quirky step in my workflow is to build complex MySQL
queries using Microsoft Access' visual query builder. This useful feature
displays tables and their fields graphically, allowing me to construct
queries quickly and intuitively by dragging and dropping query elements,
including relationships.

For the most part, the resulting SQL statements come over to MySQL
easily, but it is an extra hurdle I wish I didn't have to jump through and is
one which I don't jump unless I'm building complex queries with various
types of JOIN statements. I've been searching for an equivalent to Access'
tool for ages but have never found one. Some come close but none do
exactly what I need with ease.

If I had time, I would write my own AJAX tool to do this (I tend to roll my
own solutions for this type of thing), but even the best tool I could write
would be the poor man's replacement for one integrated directly into
phpMyAdmin.

(PS - To give you an idea of how useful this is to me: it is the *only* use
for Access I've had in years, and is, in fact, one of the only uses I have for
Windows at all. I'm in a Mac environment, and every time I have to build a
complex query, I have to fire up WinXP in a Parallels virtual machine.)

Discussion

  • Michal Čihař

    Michal Čihař - 2011-03-02
    • priority: 5 --> 1
    • summary: AJAX-based graphical query builder --> (ok 3.4) AJAX-based graphical query builder
     
  • Michal Čihař

    Michal Čihař - 2011-03-02

    This sort of matches visual query builder introduced in 3.4. It could be definitely improved and made more intuitive, but it's there.

     
  • Michal Čihař

    Michal Čihař - 2011-05-11
    • status: open --> closed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks