Closed

Visual Javascript SQL query builder

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, ....)

avoid duplication, follow re-factoring guide lines and develop javascript in object oriented way.

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)

Skills: Bootstrap, HTML5, Javascript, jQuery / Prototype, SQL

See more: javascript sql query builder, jquery query builder, query builder jquery, jquery sql query builder, sql query builder jquery, javascript query builder, jquery sql query builder example, jquery visual sql query builder, json query builder, bootstrap query builder, query builder javascript, javascript sql builder, sql builder visual, bootstrap sql query builder, jquery based query builder, sql query builder bootstrap, jquery sql builder, javascript visual query, javascript query designer, query builder, visual sql query builder, jquery visual query designer, visual sql query designer java, implement oracle query builder web based java application, visual query builder javascript

About the Employer:
( 0 reviews ) Tehran, Iran, Islamic Republic of

Project ID: #4508928

10 freelancers are bidding on average $24/hour for this job

leadconcept

Respected Sir, Thank you for taking the time to read our initial posting, we have read initial project description and wanted to confirm you that we can do this project. So, please drop us a message from Freelancer More

$30 USD / hour
(17 Reviews)
7.7
qualifiedcoders

Hi We have read your requirements.I have in depth expertise in Jquery,Javascripting,[url removed, login to view],EXT JS and have completed over 100 complex projects using JS. Please check private message board for details.

$20 USD / hour
(6 Reviews)
6.5
hemanshusondhi

**************We are U.K. based company and have all the required designer and developer you are looking for. We can allocate dedicated resources for your project. You will be very happy and satisfied with our services More

$15 USD / hour
(11 Reviews)
4.2
onlymaj

Hi Ashkan . i'm a web developer with more than 5 years experience in this field. i'm familiar with most of above techs . i can help you if you provide me more details about your wishes . i'll be happy if i could help y More

$21 USD / hour
(14 Reviews)
3.9
Reza2012

Hi I want to do this. thanks

$19 USD / hour
(5 Reviews)
3.7
bickos

Ready to start.

$10 USD / hour
(3 Reviews)
2.6
vk2tds

Sounds like a great project

$30 USD / hour
(0 Reviews)
1.1
tusherity

i can do that project

$33 USD / hour
(0 Reviews)
0.0
franceson2it

Kia ora! [url removed, login to view] are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$30 USD / hour
(0 Reviews)
0.0
xuliang482

I can do it for you

$27 USD / hour
(0 Reviews)
0.0