Visual Query Builder for MySQL?

I ran across this the other day...


So far its helping with some complex SQL statement building process.

Just wondering if there is anything like it out there that you could be using, perhaps open source/donationware/freeware.

Ta!

We are planning to use a paid component called Active Query in one of our upcoming project.

There is also a JAVA version available.

There is a Query Builder in JQuery also. You can find it here and here.

We always use dbForge Studio for MySQL. Best one we found to create Queries visually.

I found... DBeaver - Enterprise edition only:



1 - Using Firefox you cannot see (well) that image (2021 )
2 - This might be a good idea for:
Any App Ideas? free sources

LucaMs said:

I found... DBeaver - Enterprise edition only:

View attachment 119647

1 - Using Firefox you cannot see (well) that image (2021 )
2 - This might be a good idea for:
Any App Ideas? free sources

Click to expand...

$ 230 for the Enterprise version which also contains a MySql visual query builder (which I don't know and I'm not even 100% sure about).

A whole Android app development system, B4A, for free?
Erel should at least charge € 30 a year for it !

Indic Software said:

There is a Query Builder in JQuery also.

Click to expand...

I had thought of adding something like a query builder in BVAD3 and got VueJS code that does that. The Query Builder in this instance, just like dbForge one is particular for myself as a developer and not necessary on the app side, that is my angle for now.

Im not sure, does the query builder you mention handle complex queries, joins? etc etc? Thanks hey.

Mashiane said:

Im not sure, does the query builder you mention handle complex queries, joins? etc etc? Thanks hey.

Click to expand...

I have not used it that extensively so can't tell. Do give it a try at your end.

Mashiane said:

Just wondering if there is anything like it out there that you could be using, perhaps open source/donationware/freeware.

Click to expand...

phpmyadmin
has a lot of SQL management including developing queries which can be ported to your own . l. . if I remember correctly. haven't had to do such suff for a while

I don’t fancy the drag and drop tool much. The use case I can think of is when creating foreign key or relationships between 2 tables as what I used to do in MS Access for school project.

Nowadays, I only create table using Adminer for MySQL. Visual representation is no longer important unless for documentation. However, the diagram is not even useful as an ERD or DFD so I don’t bother to have a relationship diagram created by the DBMS tool.

The visual designer as I said may be useful for someone but not a mandatory tool. I also created a web based DBMS for MySQL in B4J but I seldom use it because I prefer the more powerful Adminer.
https://www.b4x.com/android/forum/threads/jadmin.120554/

@Mashiane as much as drag/drop/visual query builders are handy they shouldn't be the way to create complex queries. There are just certain things you can't do.

Every developer should know SQL - more so if they are a backend developer.

I have 20+ years across Oracle, SQL Server, Postgres and Ingres. I still have to Google stuff (and I was once SQL Certified) so you can't know everything.

Once you know SQL it's pretty irrelevant what platform it's on. SQL is of course a standard that vendors need to attain to be compliant.

I would strongly encourage you to rather learn the hard way then to rely on a GUI.

PS a bonus for learning SQL will pay off when you need to write triggers, stored procedures, functions etc