javascript - How to fetch server-side sqlite database to user-side in order to make use of "sql.js"? -

javascript - How to fetch server-side sqlite database to user-side in order to make use of "sql.js"? -

i found tool called "sql.js" can access sqlite database straight javascript. in order utilize it, user-side has have sqlite database file first. in situation, database maintained @ server-side. here question: how move sqlite database file server-side user-side-javascript user-side can create utilize of "sql.js" access database? possible in ajax call? sample code appreciated!

think example in docs wasn't added @ time question asked:

<script src='js/sql.js'></script> <script> var xhr = new xmlhttprequest(); xhr.open('get', '/path/to/database.sqlite', true); xhr.responsetype = 'arraybuffer'; xhr.onload = function(e) { var uint8array = new uint8array(this.response); var db = new sql.database(uint8array); var contents = db.exec("select * my_table"); // contents [{columns:['col1','col2',...], values:[[first row], [second row], ...]}] }; xhr.send(); </script>

bear in mind if database large, sql.js isn't suitable.

(partly because you'll have transfer database user, , partly because sql.js memory hungry, may improve running queries on server anyway.)

javascript ajax sqlite