Introduction to SQLite Database
Introduction to SQLite Database
SQLite is a small, compact, self-contained, embedded, highly reliable database. It is not a client-server database; unlike other SQL databases, it does not have a separate server process. SQLite is cross-platform and supports various platforms like:
- Windows
- Linux
- MacOS
- Android
- iOS
Getting started
You can get started with SQLite by installing it on the machine:
sqlite3 command line
The sqlite3 tool is a command line terminal-based tool to interact with the SQLite database. You can launch the tool with the following command in the prompt. Open the command prompt and cd to the extracted path, and verify if it’s working as shown below:
/> sqlite3
SQLite Command Prompt
SQLite Command Prompt ( SQLite CLI ) is the command-line interface tool or shell provided by SQLite to interact with the databases. Using the tool, we can execute SQL statements and dot commands and perform various database operations.
Installing SQLite on the computer comes with a command-line utility named sqlite3 (sqlite3.exe on Windows OS). This utility is the SQLite Command Prompt, allowing you to interact with SQLite databases in a terminal or command prompt window.
How to launch?
Let’s see the steps to launch the SQLite CLI tool:
Open the Windows command prompt.
Navigate to the SQLite installation directory if the sqlite3 executable is not in your system’s PATH. Use the cd(change directory command).
On the command prompt, type sqlite3 or sqlite3.exe
We will be connected to a temporary, transient in-memory database, and the sqlite> prompt will be displayed.
We can now enter SQL statements and commands and perform database operations using the tool.
—
SQLite Tutorials
SQLite tutorials on this website:
https://www.testingdocs.com/sqlite-database-tutorials/
