Github supports static webpages. Sqlite database is a binary file. Can a static webpage with javascript access make queries on the sqlite database in the same folder?
Many web development projects require a database. This is for demonstration purposes only and does not need to support many users.
Yes, but read-only. sql.js is a Javascript SQLite library which compiles the SQLite C library into Webassembly.
Here's an example of loading an existing SQLite database from a URL and querying it.
var xhr = new XMLHttpRequest();
// For example: https://github.com/lerocha/chinook-database/raw/master/ChinookDatabase/DataSources/Chinook_Sqlite.sqlite
xhr.open('GET', '/path/to/database.sqlite', true);
xhr.responseType = 'arraybuffer';
xhr.onload = e => {
var uInt8Array = new Uint8Array(this.response);
var db = new SQL.Database(uInt8Array);
var contents = db.exec("SELECT * FROM my_table");
// contents is now [{columns:['col1','col2',...], values:[[first row], [second row], ...]}]
};
xhr.send();