Software library that implements a self-contained server-less transactional SQL database engine.
To install basic SQLite (if it is not already), simply type:
$ sudo dnf install sqlite
This package provides the basic library and the command-line client
order to access SQLite databases from various programming languages (C, Tcl,
Java), the language bindings need to be installed separately:
$ sudo dnf install sqlite-devel sqlite-tcl sqlite-jdbc
sqlite client shipped with the basic database engine is command line (CLI)
based. If you prefer an application with graphical user interface (GUI), install
$ sudo dnf install sqlitebrowser
SQLite stores it’s data in single database file. To open such file (which will
be created if necessary), pass it’s name as CLI argument to
$ sqlite3 hello-world.db
After executing this command, you will be greeted with a SQLite prompt and can now insert the SQL commands to execute.
If you prefer using GUI, the Sqlitebrowser application enables you to construct your SQL queries using visual tool.
If you are new to SQL databases and would like to learn more, you can visit a W3CSchools SQL tutorial, which should give you a nice head start.
As is the custom in Fedora, SQLite documentation is available in
sub-package. Additionally, the JavaDoc documentation for JDBC bindings is also
$ sudo dnf install sqlite-doc sqlite-jdbc-javadoc
After the packages are installed, the actual documentation is located within
/usr/share/doc/PACKAGE directory and is formatted in HTML. For example, to view documentation for SQLite itself, you can open this URL in your browser: