It is independent of 32/64 bit machines, it is also run on SmartPhone OS like Android, Black Berry, Linux, Mac, Ios, Windows and browsers such as chrome, mozilla etc. Most of other SQL database engines store data as group of multiple large files and are stored at specific location only which can be accessed using database engine only.Ĭross-Platform :Sqlite file format is cross-platform and can be copied and accessed in various other machines or devices with different architecture. This file is also open to be copied to other storage medium or can be also shared over internet. File can be located in the directory hierarchy where it is writable and changes can be made in this file. If this file is readable by Sqlite, then any data entered in this file can be read. Single Database File :Sqlite saves complete data in a single disk file. Programs which use Sqlite needs no administrative support and any program which is able to access the disk can use Sqlite database. As mentioned above, there is no server process to install, setup, configure, manage, start or troubleshoot which seems to be the biggest advantage of Sqlite being serverless. There is no intermediate platform like server is required for data entering. You can access the database anytime and perform read and write actions directly from the database file saved in disk. Serverless :Sqlite has completely different working style and unlike other SQL database engines it does not work on a server. There is no complication of configuration files as Sqlite don't use them and system will easily run Sqlite. In fact to access database no process of assigning access permission is required. There is no requirement for an administrator for creating new database instance. It is not connected to any server and is completely server-less, thus there is no server process which needs to be initiated, managed, stopped or configured. No Need of Configuration :Sqlite does not need any installation procedure and it has no "setup" as it is required in other applications. Section below will illustrate why Sqlite is a commendable database management application and what are its highlighting characteristics which makes it different from other SQL database engines Users develop these spreadsheet-like databases to stores, search and edit data without any complicated commands like used in SQL Server. Now you can write commands and create database and to exit type “.quit”.Sqlite is high quality, open source, visual tool for creating, designing, and editing database files.
sudo apt-get install sqlite3 libsqlite3-devģ: The installation will continue after this and let it complete.Ĥ: Further just type sqlite3 this will prompt the version number the other details.
In Linux operating system use the following steps:Ģ: Now write the following command to get started.
In Mac the sqlite is pre installed in the system, all you need is to know how to use it.Ģ: Locate your present directory using pwd command(present working directory).ģ: Create a directory using mkdir and name it sqlite further using cd(change directory) move to the dir.Ĥ: Now use sqlite3 test.db (test is database name).
To run command in SQLite open Command Prompt move to the path where SQLite is copied. It is available locally over the device(mobile, tablet) and contain data in text format, it carry lite weight data and suitable with any languages.Ģ: Scroll Down and found Precompiled Binaries for Windows and on link to download.ģ: Get the file downloaded on your local system, now open C drive create a new folder like SQLite3 paste the downloaded file here.Ĥ: Now you are done with installation. It support embedded relational database features.Īndroid has built in SQLite database implementation. SQLite is a open source, lite weight, no network access, standalone database.