- Notifications
You must be signed in to change notification settings - Fork689
SQLite
Mathias Rangel Wulff edited this pageMar 12, 2018 ·6 revisions
AlaSQL can read from SQLite files if theSQL.js is included. When the library is included you can attach a SQLite db file to AlaSQL like in the example below:
<scriptsrc="alasql.js"></script><scriptsrc="sql.js"></script><script>alasql(['ATTACH SQLITE DATABASE Chinook("Chinook_Sqlite.sqlite");\ USE Chinook; \ SELECT * FROM Genre']).then(function(res){console.log("Genres:",res.pop());});</script>
You can use this feature for advancedETL operations. For example, you can easily openSQLite file and store it toIndexedDB database:
alasql(['ATTACH SQLITE DATABASE geo("geo.sqlite") AS geo1; \ ATTACH INDEXEDDB DATABASE geo AS geo2; \ SELECT * INTO geo2.cities FROM geo1.cities']);Please note that it's not yet possible to update the SQLite db file from AlaSQL.
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo