Mashiane Expert Licensed User Longtime User Sep 26, 2021 #1 I ran across this the other day... MySQL Query Builder — Visual Tool for Smart Query Design Create and edit SQL visually using dbForge MySQL Query Builder. Save your time, avoid syntax errors, and generate clean queries. Try it for free now! www.devart.com 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!
I ran across this the other day... MySQL Query Builder — Visual Tool for Smart Query Design Create and edit SQL visually using dbForge MySQL Query Builder. Save your time, avoid syntax errors, and generate clean queries. Try it for free now! www.devart.com 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!
Indic Software Active Member Licensed User Sep 27, 2021 #2 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 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.
alwaysbusy Expert Licensed User Longtime User Sep 27, 2021 #3 We always use dbForge Studio for MySQL. Best one we found to create Queries visually.
LucaMs Expert Licensed User Longtime User Sep 27, 2021 #4 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 Last edited: Sep 27, 2021
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 Expert Licensed User Longtime User Sep 27, 2021 #5 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 !
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 !
Mashiane Expert Licensed User Longtime User Sep 27, 2021 #6 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.
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.
Indic Software Active Member Licensed User Sep 27, 2021 #7 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: 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.
rabbitBUSH Well-Known Member Licensed User Longtime User Sep 27, 2021 #8 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
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
aeric Expert Licensed User Longtime User Sep 28, 2021 #9 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/
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/
tchart Well-Known Member Licensed User Longtime User Sep 28, 2021 #10 @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
@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
