Ask HN: What is the most fluent query builder UI you have come across?

10 points by codegladiator ↗ HN
The part after "where" in the sql, and before "group by"

Do you have any preferences ?

3 comments

[ 5.3 ms ] story [ 20.9 ms ] thread
Old school: The query building in Microsoft Access 2000 was fairly easy to use, and the resulting query could be viewed as an SQL statement.
I always really liked Access. Are you saying it's gotten worse since 2000? I think you could even convert from SQL back to graphical and then edit it there too, but it's been many years since I've used it.

My comparison, I recently used a brand new MySQL tool, and it was horrible.

It's my personal belief that things have been on a downhill decline since about 1982. That was the year our computers were the most secure, we had hardware enforced, write protectable floppy disks (which suck in every other way, size, speed, reliability, cost). The shift to bulk hard drives was the beginning of that downward slope.

The peak for programming was somewhere around Delphi, Visual Basic 6, Microsoft Office 2000 Professional. (Right before .NET). In Delphi or VB6, You could build a UI in a matter of an hour or so, and then "wire up" code to all the events, and you were done. My preference was for Delphi, but the amazing thing about VB6 was you could do anything with Office 2000, including databases, email, etc.

Access 2000 allowed you to have "relationships" between tables, that it just took care of, like magic. The tools were amazing. Delphi could tie into it through ODBC, as could VB6.

Since the web, and the push to make everything an "app" on a phone, the number of layers and adapters has gone through the roof, and it's all unsustainable.