Javatpoint Logo
Javatpoint Logo

SQLite Features/ Why to use SQLite

Following is a list of features which makes SQLite popular among other lightweight databases:

  • SQLite is totally free: SQLite is open-source. So, no license is required to work with it.
  • SQLite is serverless: SQLite doesn't require a different server process or system to operate.
  • SQLite is very flexible: It facilitates you to work on multiple databases on the same session on the same time.
  • Configuration Not Required: SQLite doesn't require configuration. No setup or administration required.
  • SQLite is a cross-platform DBMS: You don't need a large range of different platforms like Windows, Mac OS, Linux, and Unix. It can also be used on a lot of embedded operating systems like Symbian, and Windows CE.
  • Storing data is easy: SQLite provides an efficient way to store data.
  • Variable length of columns: The length of the columns is variable and is not fixed. It facilitates you to allocate only the space a field needs. For example, if you have a varchar(200) column, and you put a 10 characters' length value on it, then SQLite will allocate only 20 characters' space for that value not the whole 200 space.
  • Provide large number of API's: SQLite provides API for a large range of programming languages. For example: .Net languages (Visual Basic, C#), PHP, Java, Objective C, Python and a lot of other programming language.
  • SQLite is written in ANSI-C and provides simple and easy-to-use API.
  • SQLite is available on UNIX (Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE, WinRT).





Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA