Huge News!Announcing our $40M Series B led by Abstract Ventures.Learn More
Socket
Sign inDemoInstall
Socket

@cliqz-oss/react-native-sqlite-2

Package Overview
Dependencies
Maintainers
3
Versions
1
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

@cliqz-oss/react-native-sqlite-2

SQLite Storage for React Native

  • 1.5.3
  • latest
  • Source
  • npm
  • Socket score

Version published
Maintainers
3
Created
Source

React Native SQLite 2

SQLite3 Native Plugin for React Native for Android/iOS/Windows. This plugin provides a WebSQL-compatible API to store data in a react native app, by using a SQLite database on the native side.

Inspired by fantastic work done by Nolan Lawson. It should be a drop-in replacement with react-native-sqlite-storage. It works pretty well with PouchDB on React Native app.

The reason of this plugin is that react-native-sqlite-storage has some problems to use with PouchDB:

This plugin avoids these problems.

Getting started

$ npm install react-native-sqlite-2 --save

Mostly automatic installation

$ react-native link react-native-sqlite-2
iOS

In Xcode, add libsqlite3.tbd to your project's Build PhasesLink Binary With Libraries.

Manual installation

iOS
  1. In XCode, in the project navigator, right click LibrariesAdd Files to [your project's name]
  2. Go to node_modulesreact-native-sqlite-2 and add RNSqlite2.xcodeproj
  3. In Xcode, in the project navigator, select your project. Add libRNSqlite2.a to your project's Build PhasesLink Binary With Libraries
  4. Run your project (Cmd+R)<
Android
  1. Open up android/app/src/main/java/[...]/MainActivity.java
  • Add import dog.craftz.sqlite_2.RNSqlite2Package; to the imports at the top of the file
  • Add new RNSqlite2Package() to the list returned by the getPackages() method
  1. Append the following lines to android/settings.gradle:
    include ':react-native-sqlite-2'
    project(':react-native-sqlite-2').projectDir = new File(rootProject.projectDir, '../node_modules/react-native-sqlite-2/android')
    
  2. Insert the following lines inside the dependencies block in android/app/build.gradle:
    compile project(':react-native-sqlite-2')
    
Windows
  1. Open the solution in Visual Studio for your Windows apps.
  • Right click your in the Explorer and click Add > Existing Project....

  • [UWP] Navigate to ./<app-name>/windows/RNSqlite2/ and add RNSqlite2.csproj.

    [WPF] Navigate to ./<app-name>/windows/RNSqlite2.Net46/ and add RNSqlite2.Net46.csproj.

  • Right click on your React Native Windows app under your solutions directory and click Add > Reference....

  • [UWP] Check the RNSqlite2 you just added and press Ok.

    [WPF] Check the RNSqlite2.Net46 you just added and press Ok.

  1. Open MainPage.cs in your app
  • Edit it like below:
using RNSqlite2;

get
  {
      return new List<IReactPackage>
      {
          new MainReactPackage(),
          new RNSqlite2Package(),
      };
  }

Usage

import SQLite from 'react-native-sqlite-2';

const db = SQLite.openDatabase('test.db', '1.0', '', 1);
db.transaction(function (txn) {
  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; ++i) {
      console.log('item:', res.rows.item(i));
    }
  });
});

There is a test app in the test directory.

Using with PouchDB

It can be used with pouchdb-adapter-react-native-sqlite.

import PouchDB from 'pouchdb-react-native'
import SQLite from 'react-native-sqlite-2'
import SQLiteAdapterFactory from 'pouchdb-adapter-react-native-sqlite'

const SQLiteAdapter = SQLiteAdapterFactory(SQLite)
PouchDB.plugin(SQLiteAdapter)
var db = new PouchDB('mydb', { adapter: 'react-native-sqlite' })

Original Cordova SQLite Bindings from Nolan Lawson

https://github.com/nolanlawson/cordova-plugin-sqlite-2

The issues and limitations for the actual SQLite can be found on this site.

Keywords

FAQs

Package last updated on 20 Mar 2018

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc