SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files.
SQLite is a popular database engine because it is:
- Lightweight: Requires minimal setup, with no separate server needed.
- Self-contained: All database functions are stored in a single file, making it easy to manage.
- Zero-configuration: No complex installation or configuration is required.
- Cross-platform: Works on multiple operating systems without modification.
- Reliable: Well-tested and used in many applications, ensuring data integrity.
- Open-source: Free to use, with a permissive license for developers.
All you need to run SQLite is the sqlite3- application and you can downloat it from:
https://www.sqlite.org/
In order to use SQLite in Windows, download and unzip the file sqlite-tools-win-x64....
You can start to use example a database named mydb.db with the command
sqlite3 mydb.dbIf the database named mydb.db, does not exists, SQLite will create it.
If you want to use a Graphical application to work with SQLite, you can use DBeaver or SQLite Studio. You can download SQLite Studio from https://sqlitestudio.pl/.
