Why is SQLite preferred over any other database management system?

devquora
devquora

Posted On: Feb 22, 2018

 

SQLite is recommended to be used because of following advantages:
  • SQLite supports almost all Operating Systems.
  • It is free of cost and flexible.
  • It is very compact less than 400KiB.
  • It requires no setup or administration as it comes with zero-configuration.
  • No separate server processor system is required to operate.
  • An SQLite database can be stored in a single cross-platform disk file.
  • It is self-contained that means no external dependencies.
  • It provides easy access to API as it is written in ANSI-C.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQLite interview questions

    What is SQLite and where is it used?

    The SQLite is mostly ACID (Atomicity, Consistency, Isolation, and Durability) compliant relational database management ..

    SQLite interview questions

    Distinguish between SQLite and SQL?

    SQLite: It is a well built, embedded relational database management system that is mostly used in mobile devices for da..

    SQLite interview questions

    Mention some SQLite commands and also explain them?

    The SQLite commands interact directly with relational databases and are similar to SQL. Below are the standard SQLite c..