SQLite Database

SQLite is a relational database management system that written in C programming language. SQLite is stand-alone database (not a client-server database). SQLite is a popular database for local storage in application software. There are many applications that use SQLite for local storage such as web browsers. SQLite is used in web browsers for storing bookmarks, configuration, etc. SQLite is also used in Android for local apps database such as contact, notepad, dictionary, and many more. Another famous product that use SQLite can be found in here.

SQLite database file is usually have extension .sqlite or sqlite3, but any format can be used on SQLite file such as .db or .db3. You can also use personal choice such as .bookmark or .index, so it may make sense to your database scheme that you are storing. SQLite is use command line tool for manage the database, so if you are not familiar with command line, you can also download GUI tool. There are many GUI tools for manage SQLite database. I'm using DB browser for SQLite. I choose this tool because it's open source and easy to use for create, design, and edit SQLite database file. The DB browser for SQLite can be download from here.

If you want to use command line version, you can download from here. For windows users, download the sqlite-shell and sqlite-dll file, both file are in .zip format.