Can Javascript transact with a SQLite database on a remote server from a browser?

Question

I would like to interact (select, insert, update, delete) with a SQLite database that is on my server using Javascript running on a remote browser.

You could use AJAX to communicate with a backend that could then interact with a database. — Charlie
– Charlie, Commented Feb 12, 2014 at 0:04

user2864740 · Accepted Answer · 2014-02-12 00:06:56Z

2

No. Not directly.

The remote server would need to expose a "Web API" - which could be used/consumed by the browser JavaScript - that is run on the system with direct access to the SQLite database.

There are some existing proxies that "allow direct data access" - you'll need to find or craft a suitable tool. I recommend writing a Web API that doesn't expose SQL directly, but rather exposes the required operations independent of the actual back-end.

edited Feb 12, 2014 at 0:06

answered Feb 11, 2014 at 23:55

user2864740

62.5k15 gold badges159 silver badges234 bronze badges

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

1 Comment

Abhee Over a year ago

I am trying to do the same but my HTML is in SCORM package and I want to collect some interaction details from learners. As my main intention is to do everything within a package which will on server but we can not use any server side script like PHP, JSP and ASP. Is it possible to do this with server side JavaScript if so then please provide some help links.

Collectives™ on Stack Overflow

Can Javascript transact with a SQLite database on a remote server from a browser?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related