Graphical SQLite Queries

công cụ xây dựng truy vấn cơ sở dữ liệu SQLite đồ họa cho quan hệ.

Easy Query Creator is a graphical query language which is designed to support the full functionality of SQL and is addressed to non-expert users on databases.

Metaphors, Color and other functionality like zoom are used for the best comprehension of the database schema and the query development. The multi-touch gestures which performed on the device display, translated to equivalent SQL queries and executed in the SQLite database. The by default selected database for this initial version of the application is the Chinook database.

Selection of a new database and other functionalities will be supported soon.

Easy Query Creator features & profits:

-Colors and objects for the descripton and construction of the query

-Find the relations between selected tables (Auto-Join)

-Zoom function, in order to find the correct canvas size for every user

-Easy construction of an SQL query

-Comprehension of a relational database model

-See the schema of a database in your Android device

-SQL query in text format

-Copy or change the text format of the query

-Results in a GridView

This application developed by E.Aren based on the article "EGQL: A Gesture Query Language" , Authors: E. Keramopoulos and E. Aren.