Is there a simpler method to run sqlite with javascript? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 9 years ago.

Improve this question

Here is my current plan:

HTML button calls jQuery function
Function loads PHP script
PHP script executes shell script
shell script calls SQLite
SQLite runs SQL script that creates CSV
Webpage reads CSV

Is there a simpler method? I tried sql.js but it seems to have some issues with csv files.

Well most access to a database requires the basic steps you mention. How to access the database differs. Did you look at a different php library to access the db to make it easier? — epascarello
– epascarello, Commented Dec 24, 2015 at 21:57
@epascarello I hope it does not sound too bad that I have no desire to learn php and a library... — qwr
– qwr, Commented Dec 24, 2015 at 22:06

Quentin · Accepted Answer · 2015-12-24 21:58:39Z

0

Assuming you want the database stored on the server, then you aren't going to get any simpler then:

JavaScript sends data in HTTP request
Server side program constructs SQL query
SQL query gets run by database

You can eliminate shelling out by using a PHP SQLite library.

answered Dec 24, 2015 at 21:58

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

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

Collectives™ on Stack Overflow

Is there a simpler method to run sqlite with javascript? [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related