sqlite3-compatible interface for sql.js
sql.js-as-sqlite3sql.js to make it look like sqlite3.
js
npm install sql.js sql.js-as-sqlite3 --save
`
If you're not using a bundler then use a standalone version from a CDN.
Use
$3
`js
import sqlJsAsSqlite3 from 'sql.js-as-sqlite3'
console.log(sqlJsAsSqlite3)
`
$3
`js
import sqlJsAsSqlite3 from 'sql.js-as-sqlite3'
import initSqlJs from 'sql.js'
sqlJsAsSqlite3.configure({
// sql.js package default export.
initSqlJs,
// Base URL for sql.js to get the *.wasm files like sql-wasm-debug.wasm.
// The version of the *.wasm files must match the version of the sql.js package.
// Must end with a "/".
wasmFileBaseUrl: 'https://cdnjs.cloudflare.com/ajax/libs/sql.js/1.10.2/'
})
console.log(sqlJsAsSqlite3)
`
$3
One can use any npm CDN service, e.g. unpkg.com or jsdelivr.net
`html
`
Sequelize
This package could be used to make sequelize work with sqlite database:
`js
import Sequelize from 'sequelize'
import sqlJsAsSqlite3 from 'sql.js-as-sqlite3'
const sequelize = new Sequelize('sqlite://:memory:', {
dialectModule: sqlJsAsSqlite3
})
`
See a test for a server-side example.
For a client-side example, see sequelize-browser package.
TypeScript
This library comes with TypeScript "typings". If you happen to find any bugs in those, create an issue.
GitHub
On March 9th, 2020, GitHub, Inc. silently banned my account (erasing all my repos, issues and comments, even in my employer's private repos) without any notice or explanation. Because of that, all source codes had to be promptly moved to GitLab. The GitHub repo is now only used as a backup (you can star the repo there too), and the primary repo is now the GitLab one. Issues can be reported in any repo.
License
MIT