To start working with SQLite, you simply need the libraries/utilities installed on your local workstation. In order to benefit from the spatial functions that can be used within a SQLite database, you will also need the Spatialite libraries.

Install SQLite: https://sqlite.org/download.html

Spatialite libraries: https://www.gaia-gis.it/fossil/libspatialite/index

Working with SQLite directly is relatively easy in a Unix-like environment, as it is in most package management tools (e.g. apt, yum, brew).

In Windows, it may take some additional effort to get native SQLite tools working. See the following from the DB Browser for SQLite project on how to get spatial support working under Windows.