Many script languages (e.g., Perl, Python, Ruby, etc.) and frameworks (e.g., Android) have support for SQLite; this is done with a built-in copy of the SQLite library, which does not need to be installed separately.
For testing SQL, it might be useful to use the command-line shell (
It is already shipped with most Linux distributions; on Windows, download the precompiled binaries in the
sqlite-tools package, and extract them somewhere.
SQLite already has extensive documentation, which should not be duplicated here.