RDBMS are old. NoSQL or NewSQL is new. But this shift is sloq, coz RDBMS is mature.
SQLite is a Cross-platform, relational database management system contained in a small (~350 KB) C programming library that implements a self-contained, embedded, zero-configuration SQL database engine.
It was started as a embedded db project for US Navy.
It requires no Installation, No Administration.
It is used in mobile or desktop web apps. SQL92 standard compliant.
No configuration to setup.
Data is stored in a flat file on disk.
Db Max size == max file size on disk.
Serverless - requires no process for its running.
Embedded in Apps.
Can also be used as in-memory db.
Supports ACID.
Android, iOS, Firefox, Chrome, Opera use it.
sqlite3 is a command-line tool. Goto to the prompt and use .help for possible commands.
There are few limitations of SQLite - in terms of ALTER, JOIN, triggers, Views.
Alternatives: HSQLDB, Firebird, Ultralite.
SQLite is a Cross-platform, relational database management system contained in a small (~350 KB) C programming library that implements a self-contained, embedded, zero-configuration SQL database engine.
It was started as a embedded db project for US Navy.
It requires no Installation, No Administration.
It is used in mobile or desktop web apps. SQL92 standard compliant.
No configuration to setup.
Data is stored in a flat file on disk.
Db Max size == max file size on disk.
Serverless - requires no process for its running.
Embedded in Apps.
Can also be used as in-memory db.
Supports ACID.
Android, iOS, Firefox, Chrome, Opera use it.
sqlite3 is a command-line tool. Goto to the prompt and use .help for possible commands.
There are few limitations of SQLite - in terms of ALTER, JOIN, triggers, Views.
Alternatives: HSQLDB, Firebird, Ultralite.
No comments:
Post a Comment