QuerySniper: A tool for every SQL guys

I’ve done a new project recently: QuerySniper.

A kind of « visual » join system for SQL database. Currently only supporting MySQL, the system is able to graphically print intermediate results of a join.

The system is based on this idea:

SELECT * FROM company WHERE id IN (SELECT company_id FROM user WHERE id = 1)

gives the same result as:

SELECT company.* FROM company, user WHERE user.id = 1 AND company.id = user.company_id

From this, it was easy to design a step by step SELECT, keeping intermediate results and programatically build next query with result of previous query, allowing to do something close to the first SELECT above (select calling select calling…).

Here is the query builder in action:
visual query builder

And the final result:
Visual join structure

For the following database schema, with random data (using the excellent Mockaroo):
Query Sniper example database

Go check it out on Github Here, it’s free!

Publicités

3 Commentaires

  1. Pingback: DB Tools | MySQL

  2. Pingback: DB Tools | Opensource

  3. Pingback: QuerySniper: A tool for every SQL guys | Simple API | Programming Tools

Laisser un commentaire

Entrez vos coordonnées ci-dessous ou cliquez sur une icône pour vous connecter:

Logo WordPress.com

Vous commentez à l'aide de votre compte WordPress.com. Déconnexion / Changer )

Image Twitter

Vous commentez à l'aide de votre compte Twitter. Déconnexion / Changer )

Photo Facebook

Vous commentez à l'aide de votre compte Facebook. Déconnexion / Changer )

Photo Google+

Vous commentez à l'aide de votre compte Google+. Déconnexion / Changer )

Connexion à %s

%d blogueurs aiment cette page :