Query database directly from javascript

Question

Can I fetch data directly from a database using java-script.

Something like

var results = conn.query("select * from table");

then use in my html

document.innerHtml(results[0]['name']);

I think you'll get a security issue if you want to do this on the client side. — Tjasun, Jun 30 '15 at 09:43
Can you describe the context? It's a local database? Your database is hosted by a server? — R3tep, Jun 30 '15 at 09:45
@Tjasun Ya, i have thought about that. Firstly, i am trying to find a way that can we do this? Then if its possible, i will find a way for security also. — Sahil Jain, Jun 30 '15 at 09:45
@SeijiSchoch I have Looked into AJAX, but i found no way to skip server side coding — Sahil Jain, Jun 30 '15 at 09:47
You can setup a node.js server (it's pretty simple) and there you can use js (server side) for your query. Then use ajax for getting the data from the backend to your client or just use a node project. — Tjasun, Jun 30 '15 at 09:49
@SahilJain With local you have solutions. With server you can use AJAX — R3tep, Jun 30 '15 at 09:51
@Tjasun My point is that, i am trying to find a way to skip server side — Sahil Jain, Jun 30 '15 at 09:52
@R3tep Ya, i also think that its not possible till now. Can't find any way to do this — Sahil Jain, Jun 30 '15 at 09:54
The you have to use ActiveXObject. A sample you can see in answer of http://stackoverflow.com/questions/857670/how-to-connect-to-sql-server-database-from-javascript. But most clients not allows ActiveX. — Tjasun, Jun 30 '15 at 09:54

score 0 · Answer 1 · edited May 23 '17 at 12:30

0

YES. You can do it - you can query some database engines directly from Javascript. But you almost never do it, because in AJAX model you have thin clients with no fast access to database engine.

See: this answer to another question,

edited May 23 '17 at 12:30

Community

1
1

answered Jun 30 '15 at 13:52

filiprem

6,721
1
29
42

Query database directly from javascript

1 Answers1