react-native-quick-websql-uhc
v0.3.0
Published
Fast WebSQL-compatible SQLite driver for React Native
Downloads
6
Readme
This library provides a WebSQL-compatible API to store data in a react native app, by using a fast JSI implementation of the SQLite driver react-native-quick-sqlite.
Installation
yarn add react-native-quick-websql react-native-quick-sqlite
npx pod-install
Usage
See an example project for more detail.
import { SQLitePlugin } from "react-native-quick-websql-uhc";
// check if Platform.OS !== "web"
const pluginSQLite = new SQLitePlugin() // initializing the class
const db = pluginSQLite.openDatabase('mydb.db')
db.transaction(
(txn) => {
console.log('Running transaction')
txn.executeSql('DROP TABLE IF EXISTS Users', [])
txn.executeSql(
'CREATE TABLE IF NOT EXISTS Users(user_id INTEGER PRIMARY KEY NOT NULL, name VARCHAR(30))',
[]
)
txn.executeSql('INSERT INTO Users (name) VALUES (:name)', [
'nora',
])
txn.executeSql('INSERT INTO Users (name) VALUES (:name)', ['takuya'])
txn.executeSql('SELECT * FROM `users`', [], function (_tx, res) {
for (let i = 0; i < (res.rows?.length || 0); ++i) {
console.log('item:', res.rows?.item(i))
}
})
},
(e) => {
console.error(e)
}
)
Limitations & Debugging
As the library uses JSI for synchronous native methods access, remote debugging (e.g. with Chrome) is no longer possible. Instead, you should use Flipper.
Contributing
See the contributing guide to learn how to contribute to the repository and the development workflow.
License
MIT by Takuya Matsuyama