Querying data with JavaScript

Question

I am currently looking for an intelligent best practice solution for the following problem. Within a web page, I want to make use of data that is currently organised in some MySQL tables.

Problem: I cannot access the database from the webserver, so I am not able to query the data using SQL. Therefore, I thought to transform the data into something JavaScript can handle (e.g. JSON) and perform all the operations on the data on client-side.

Doing SQL-like queries on an object will probably be kind of hard, even if those I need will probably be easy (simple SELECTs). Is there a elegant way to do that? Some nice little javascript library?

Thanks in advance for your ideas.

are you using any databases right now? if yes, what kind of access do you have for it? — Anurag
– Anurag, Commented Jun 21, 2010 at 9:04
if you cannot access the db then surely you will not able able to access the db with js either? — matpol
– matpol, Commented Jun 21, 2010 at 9:09

T.J. Crowder · Accepted Answer · 2010-06-21 08:57:35Z

3

Best practice would (of course) be to put some kind of link (even if not a direct one) between the database and the web server.

For SQL in the browser, though, there's the TrimQuery library, basically a mini-SQL engine written in JavaScript for use on the browser. You would output the "tables" as arays of objects using JSON (as you indicated), and then query it via TrimQuery's SQL support.

But if you can't access the database from the web server, I assume you'll be making a mostly-static copy of the data as an admin procedure and placing it on the webserver. That being the case, you may well be better off determining your usage patterns in your web app and then formatting the data into useful objects as part of the DB->web server copy operation. But if you really need ad-hoc queries into the data, TrimQuery may be a route you could use.

edited Jun 21, 2010 at 8:57

answered Jun 21, 2010 at 8:52

T.J. Crowder

1.1m201 gold badges2k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

auralbee Over a year ago

Great, I will have a look on TrimQuery. Indeed I was thinking in doing it the way you sketched it and transforming the database tables into a static textfile.

mamoo · Accepted Answer · 2010-06-21 08:53:25Z

3

You can try JSINQ:

http://jsinq.codeplex.com/

which is a Javsascript LINQ implementation. It allows to "query" json object with linq expressions (then in a sql-like way).

answered Jun 21, 2010 at 8:53

mamoo

8,1762 gold badges31 silver badges38 bronze badges

Collectives™ on Stack Overflow

Querying data with JavaScript

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related