
But to keep things simple, let's download the following database:Ĭlicking the above link should immediately download the file into your Downloads folder, with this filename by default: I've created a "starter pack" of SQLite databases that are interesting and relatively easy to explore: SQLite Data Starter Packs.Īt the top of the page, you can get a quick overview of what's available. So exit DB Browser and move on to the next step of downloading a pre-build SQLite database file. Just like we can open Microsoft Excel without specifying a file, we can open our database client and start empty.

(If you're at around version 3.8, it should look similar and the differences aren't important)
#Sqlite browser create view install
If you've managed to install the latest version, 3.9.1, DB Browser will look something like this: Go to your Applications folder, find the DB Browser for SQLite icon, and double-click it: This may include going to your Downloads folder and double-clicking on what you just downloaded.įor Mac users, you'll get the standard popup that asks you to download the funny icon to your Applications folder: Now Install the client by…doing whatever you usually do to install an application.

Go to the homepage and download the relevant executable: Download and launch the DB Browser for SQLite client This section contains a quick-start-click-here-type-this hand-holding walkthrough that should work on a relatively modern computer and operating system, while being understandable by a novice spreadsheet user.

If you're completely new to SQLite and databases in general, it may be easier to learn via doing.
