We will be using DB Browser for SQLite to create and manage our databases.
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It can be installed on both Windows and on Mac operating systems.
The software can be downloaded from the DB Browser site From the front page you can select the version you require. There are specific downloads for Windows and Mac users. For various Linux distributions there are detailed instructions at the bottom of the page.
For a current Windows environment the 64-bit windows download will be most appropriate.
The download is a windows executable file which you can run by double clicking it. It opens an installation wizard. You can default all of the options in the wizard. You will require admin permissions on the PC/Laptop you install on. By default the application is launched automatically when the installation is complete. It does not create an icon on the desktop. To explicitly launch the application after installing it, use the windows button (bottom left of screen) and type in ‘DB Browser’ in the search bar and selecting the application when it appears.
OSX 10.8 (Mountain Lion) - 10.13 (High Sierra) are tested and known to work
An OSX installer can be found here: