What is SQLite ? Top Features Of SQLite You Should Know

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

1. SQLite is totally free: SQLite is open-source. So, no license is required to work with it.
2. SQLite is serverless: SQLite doesn't require a different server process or system to operate.
3. SQLite is very flexible: It facilitates you to work on multiple databases on the same session on the same time.
4. Configuration Not Required: SQLite doesn't require configuration. No setup or administration required.
5. 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.
6. Storing data is easy: SQLite provides an efficient way to store data.
7. 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.
8. 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.
9. SQLite is written in ANSI-C and provides simple and easy-to-use API.
10. SQLite is available on UNIX (Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE, WinRT).

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

About Mariano

I'm Ethan Mariano a software engineer by profession and reader/writter by passion.I have good understanding and knowledge of AngularJS, Database, javascript, web development, digital marketing and exploring other technologies related to Software development.