Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Visual Query Builder [closed]

Tags:

If been using "dbForge Query Builder" lately and I'm gotten used to the ease of building and testing a query, specially for those complex ones with inner joins, aliases and multiple conditionals.

The expiry date of the trial is about to come, and while wanting to remain on the legal side for this I'd rather not pay the 50USD it costs (although I must say it's pretty cheap for what it does).

So my question would be: Are there any free alternatives to replace this visual query builder? I've failed to find any and fear that my only two options are paying for it, or going to the dark side.

like image 850
johnnyArt Avatar asked Mar 24 '10 09:03

johnnyArt


People also ask

What is Visual Query Builder?

The Visual Query Builder helps you construct complex database queries without you having to know the syntax of SQL statements. A rich set of visual options are available to let you combine SQL clauses like JOINs, GROUP BY with properties like Indexes, Operators, Aliases, Sort Type, Sort Order and Criteria.

What is Query Builder in C#?

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird. sqlkata.com.


2 Answers

You may try FlySpeed SQL Query. It has the same powerful visual query builder and it's free if you don't need data export and printing.

like image 146
Sergey Smagin Avatar answered Sep 25 '22 01:09

Sergey Smagin


You should try SQLyog, it has powerful visual query builder. It is very easy and intuitive to use.

SQLyog Query Builder Screenshot

like image 27
jsist Avatar answered Sep 26 '22 01:09

jsist