Writing a Command Line Shell for Sqlite With Go
In this guide we are creating a simple command line shell in Golang that would let us create a SQLite DB and run SQL queries in that database. Think of it as a simple version of MySQL CLI application. This is to give you some idea how DB connections in Golang works. Let’s dig in.
Initializing the project First of all, let’s create a directory for our application. I’m going to use *nix commands but you can, however, follow this with Windows using GUI.