search

salk31 / RedQueryBuilder

SQL Query Builder UI JavaScript component
http://redquerybuilder.appspot.com/
Eclipse Public License 1.0
96 stars 22 forks source link

I'm trying to use requery builder with no knowledge of json. possible? #18

Closed lottabliss closed 9 years ago

lottabliss commented 10 years ago

I have a little problem. I'm learning sql, in fact I'm in an advanced sql class, and I thoroughly enjoy it. I disparately want to convert my sql queries into something that other people can enjoy. REDQUERY BUILDER is so beautiful, I'd love to understand it. I downloaded it, to see if I could fake it. I can't even find a file that has the actual data, like a file that shows how to insert the data into the tables . I just found the file that you can use to make the tables. Can anyone help me or will this take me learning json? I do know javascript. Thanks very much

salk31 commented 10 years ago

Hello, I'm afraid RedQueryBuilder is just a JavaScript component aimed at web developers to add into other things, rather than being an application in itself.

If you know JavaScript you should be 90% of the way there with JSON. JSON is an Object literal in JavaScript... Dates are a bit odd...

If you are doing advanced SQL I'm not sure RedQueryBuilder will show your queries very well. It just does joins and a few clauses. So won't be able to render any subqueries, group by, having, CTE etc that you are doing on your course.

I'm very glad you like the look of it though!

lottabliss commented 10 years ago

Yes, I like the look of it. Very sharp. I will keep plugging along, then. I wonder if you could show me what the file looks like that contains the actual data, ie the document that says somewhere "insert into country: angola, argentina, boliva, etc. or the data area that just lists the arrays or tables. Thanks again!

salk31 commented 10 years ago

The SQL for the demo is here: https://github.com/salk31/RedQueryBuilder/tree/master/redquerybuilder-jdbcsample/src/main/resources

Credits still in the header of the file. From MySql I think.

Hope you have fun.

lottabliss commented 10 years ago

Thank you. That is something I can work with. Where is the world.sql file stored in your example? When I downloaded it I don't think you have a .sql file. Is it called something else?

On Thu, Mar 6, 2014 at 1:00 PM, salk31 notifications@github.com wrote:

The SQL for the demo is here:

https://github.com/salk31/RedQueryBuilder/tree/master/redquerybuilder-jdbcsample/src/main/resources

Credits still in the header of the file. From MySql I think.

Hope you have fun.

Reply to this email directly or view it on GitHubhttps://github.com/salk31/RedQueryBuilder/issues/18#issuecomment-36936265 .

salk31 commented 10 years ago

The demo (on google app engine) is different from the minimal example in the download zip. The example doesn't have any SQL database available... Sadly the Web SQL standard got dropped so I wasn't sure about spending time on a "all in the browser" version.

I'd be great to have a full example/demo that people could download and play with but I'd have no idea what OS/language/database etc.... they wanted to use.

salk31 commented 9 years ago

Not sure much to add, feel feel to re-open.