Awesome
react-native-sqlite
NOTE: This hasn't been maintained for a while and was never very complete to start with. Check out https://github.com/andpor/react-native-sqlite-storage for a more usable library!
A binding for sqlite3 for React Native. Allows a database to be opened and for SQL queries to be run on it.
Written by Thomas Parslow (almostobsolete.net and tomparslow.co.uk) as part of Active Inbox (activeinboxhq.com).
Installation
Install using npm with npm install --save react-native-sqlite
You then need to add the Objective C part to your XCode project. Drag
AIBSQLite.xcodeproj
from the node_modules/react-native-sqlite
folder into your XCode project. Click on the project in XCode, goto Build Phases
then Link Binary With Libraries
and add libAIBSQLite.a
and libsqlite3.dylib
.
NOTE: Make sure you don't have the AIBSQLite
project open seperately in XCode otherwise it won't work.
Usage
var sqlite = require('react-native-sqlite');
sqlite.open("filename.sqlite", function (error, database) {
if (error) {
console.log("Failed to open database:", error);
return;
}
var sql = "SELECT a, b FROM table WHERE field=? AND otherfield=?";
var params = ["somestring", 99];
database.executeSQL(sql, params, rowCallback, completeCallback);
function rowCallback(rowData) {
console.log("Got row data:", rowData);
}
function completeCallback(error) {
if (error) {
console.log("Failed to execute query:", error);
return
}
console.log("Query complete!");
database.close(function (error) {
if (error) {
console.log("Failed to close database:", error);
return
}
});
}
});
Database Location
It will first look for the database filename you give in the Documents
directory inside the app sandbox. If it doesn't find anything there it will look in the app bundle and try and copy it to the Documents
directory. If it doesn't find the database in either place then it will create a new blank database in the Documents
directory.
In the future it should probably be made possible to open/create databases in the tmp
and Libraries
directories.
Known Issues
- Doesn't support reading of BLOB fields right now. I'm not entirely sure what would be the best way to pass back binary data. Maybe Base64?
- Database needs to be closed manually. I'm not sure how I could do this automatically.
Feedback Welcome!
Feedback, questions, suggestions and most of all Pull Requests are very welcome. This is an early version and I want to figure out the best way to continue it.
I'm also available for freelance work!
I'm @almostobsolete on Twitter my email is tom@almostobsolete.net and you can find me on the web at tomparslow.co.uk and almostobsolete.net