Skip to content
Related Articles
Open in App
Not now

Related Articles

Difference between PouchDB and SQLite

Improve Article
Save Article
  • Last Updated : 26 Jun, 2020
Improve Article
Save Article

1. PouchDB :
PouchDB is an open-source, NoSQL, in-line database. It is designed after CouchDB, which is a NoSQL database that powers npm. It is written in JavaScript language. There is no need to perform queries over the network as PouchDB resides inside the browser and thus it makes it extremely faster. It stores data locally using IndexedDB and WebSQL in the browser.

2. SQLite :
SQLite is a software library that provides a relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system (DBMS) or requiring a database administrator. The lite in SQLite means light weight in terms of setup, database administration, and required resource.

Difference between PouchDB and SQLite “

1It is developed by Apache Software Foundation.It is developed By D. Richard Hipp .
2It was released in 2012.It was released on August 2000.
3It is written using Javascript language.It is written in C language..
4The primary database model for PouchDB is Document Store.The primary database model for SQLite is Relational DBMS.
5PouchDB server operating systems are server-less, requires a JavaScript environment (browser, Node.js).SQLite does not require a server to run. Hence, it is serverless.
6It is Data Schema free.Its Data Schema is fixed.
7It does not has predefined data types.It has predefined datatypes such as float, date, number, etc.
8It does not provide ACID transactions.It provides ACID transactions.

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!