craftzdog / Pouchdb Adapter React Native Sqlite
Licence: mit
PouchDB adapter using ReactNative SQLite as its backing store
Stars: ✭ 98
Programming Languages
javascript
184084 projects - #8 most used programming language
Projects that are alternatives of or similar to Pouchdb Adapter React Native Sqlite
Sqlboiler
Generate a Go ORM tailored to your database schema.
Stars: ✭ 4,497 (+4488.78%)
Mutual labels: database, sqlite3
Database rewinder
minimalist's tiny and ultra-fast database cleaner
Stars: ✭ 685 (+598.98%)
Mutual labels: database, sqlite3
Edge Sql
Cloudflare Workers providing a SQL API
Stars: ✭ 429 (+337.76%)
Mutual labels: database, sqlite3
Mikro Orm
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
Stars: ✭ 3,874 (+3853.06%)
Mutual labels: database, sqlite3
Rxdb
🔄 A client side, offline-first, reactive database for JavaScript Applications
Stars: ✭ 16,670 (+16910.2%)
Mutual labels: database, pouchdb
Better Sqlite3
The fastest and simplest library for SQLite3 in Node.js.
Stars: ✭ 2,778 (+2734.69%)
Mutual labels: database, sqlite3
Couchdb Net
EF Core-like CouchDB experience for .NET!
Stars: ✭ 50 (-48.98%)
Mutual labels: database, pouchdb
Perfect Sqlite
A stand-alone Swift wrapper around the SQLite 3 client library.
Stars: ✭ 42 (-57.14%)
Mutual labels: database, sqlite3
Sqlite3 Ocaml
OCaml bindings to the SQLite3 database
Stars: ✭ 77 (-21.43%)
Mutual labels: database, sqlite3
Pouchdb
🐨 - PouchDB is a pocket-sized database.
Stars: ✭ 14,625 (+14823.47%)
Mutual labels: database, pouchdb
Kivik
Kivik provides a common interface to CouchDB or CouchDB-like databases for Go and GopherJS.
Stars: ✭ 200 (+104.08%)
Mutual labels: database, pouchdb
Denodb
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Stars: ✭ 498 (+408.16%)
Mutual labels: database, sqlite3
Pydbgen
Random dataframe and database table generator
Stars: ✭ 191 (+94.9%)
Mutual labels: database, sqlite3
Android dbinspector
Android library for viewing and sharing in app databases.
Stars: ✭ 881 (+798.98%)
Mutual labels: database, sqlite3
D2sqlite3
A small wrapper around SQLite for the D programming language
Stars: ✭ 67 (-31.63%)
Mutual labels: database, sqlite3
pouchdb-adapter-react-native-sqlite
PouchDB adapter using ReactNative SQLite as its backing store.
Why?
SQLite storage performs much faster than AsyncStorage, especially with secondary index. Here is benchmark results:
1) allDocs speed |
min | max | mean |
|---|---|---|---|
| AsyncStorage | 72ms | 94ms | 77ms |
| SQLite | 27ms | 39ms | 28ms |
2) query speed |
min | max | mean |
|---|---|---|---|
| AsyncStorage | 1,075ms | 1,117ms | 1,092ms |
| SQLite | 33ms | 39ms | 35ms |
- Device: iPhone 6s
- Documents: 434
- Update seq: 453
- Iterations: 100
- Used options:
{ include_docs: true }
On Simulator
- Device: iPad Pro 9.7" (Simulator) - iOS 10.3.2
- Documents: 5000
3) bulkDocs speed |
total | mean |
|---|---|---|
| AsyncStorage | 25.821ms | 5.16ms |
| SQLite | 22.213ms | 4.44ms |
4) allDocs speed |
total | mean |
|---|---|---|
| AsyncStorage | 189,379ms | 37.87ms |
| SQLite | 30,527ms | 6.10ms |
-
allDocsoptions:{ include_docs: true, attachments: true } - Using this test script
How to use it
Check out the craftzdog/pouchdb-react-native repository.
Changelog
- 3.0.1
- Fix dependency and import
- 3.0.0
- 2.0.0
- Upgrade pouchdb-adapter-websql-core to 7.0.0
- 1.0.3
- Remove
pouchdb-utilsdependency
- Remove
- 1.0.2
- Upgrade pouchdb-util & pouchdb-adapter-websql-core to 6.2.0
- Update benchmark result
- 1.0.1
- Remove unnecessary console output
- 1.0.0
- Initial release
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].