Design and develop visual database explorer that enable users to explore tables, views, functions and enable users to create query based on selected tables and aggregate functions without any knowledge of SQL, all parts must be done in user friendly environments based on JQuery and bootstrap and mock service must be implement for testing, this application will be integrate with our java web application.
for integration purpose you must provide json object as mock service, data will be passed to you by json and you must return json to server after query created completely. and all information of created query will be passed to server (filters, joins, columns, query, order, groups, ...)a
joins must be detect automatically and it is possible for expert users to edit joins and queries.
visual part for creating order and filters of query.
filters must be create based on type of fields, for example for Date fields: between, before, after, ...
for String fields: equal, contains, uppercase, ...., any possible functions based on each database type.
this query builder must support MySQL, SQL Server, Oracle, PostgreSQL, DB2, Sqlite. and last 4 versions of theses database. (oracle 11g, 10g, 9i, ....)
you must document all parts, and provide developer guide.
We want high quality design and clean code, with best practices and technologies, without coupling (With the reason we will accept better technologies and solutions)
for more info please visit following links.
jasper server BI (commercial version(ad-hoc report designer and domain designer))
[url removed, login to view]
Dbideas based on EXT on google code
Please inform me how long does it take for you to completing this task (man/hour)
10 freelancers are bidding on average $24/hour for this job