#DB BROWSER FOR SQLITE PORTABLE HOW TO#
#DB BROWSER FOR SQLITE PORTABLE INSTALL#
#DB BROWSER FOR SQLITE PORTABLE MOD#

You can create routes individually, but this way uses less code and is easier to understand. Here we are creating a “Group” for our routes. Now, there are several ways to set up a router in Go, but this pattern is my favorite: v1 := r.Group('/api/v1') This fires up a Gin default router we can work with. PORT environment variable was defined.īefore we go further, let’s look at what this code does.įirst, we start up the router: r := gin.Default() By default it serves on :8080 unless a Let’s add the following code in our main() function: r := gin.Default() While this sounds complex, Gin handles it very elegantly. If it’s a POST, it will route the user somewhere different. If it sees a GET request, it will pass the user off to code used to handle GET requests. Then, create a new file named main.go and add the following: package mainįor now, we’re going to set up our router, but the application isn’t going to do anything useful yet.Ī router takes incoming requests and routes them to functionality to handle them.

#DB BROWSER FOR SQLITE PORTABLE INSTALL#

Next, we’ll install the libraries we’re going to use for this application: go get -u /mattn/go-sqlite3

#DB BROWSER FOR SQLITE PORTABLE MOD#

Let’s get started! Step 1: Create the applicationĬreate a folder on your hard drive and type in the following: go mod init /personweb I am using Pop!_OS Linux for this demo, but the instructions will be the same if you’re using Linux, OSX, or Windows.

Optionally I am using DB Browser for SQLite, which is available in Windows, OSX, and Linux. The database from our Previous Go Project, which you can download here.To build this application, you need a computer with It’s ubiquitous in mobile phones and devices, and SQLite powers many websites today. You’re likely already using SQLite every day, and you don’t know it. That makes this application small, efficient and portable. It’s all self contained in a file that ships with your application. What’s great about SQLite is you don’t need a database server. SQLite is a small, fast, self contained, high reliability SQL database engine. Today you’ll be able to develop your first Gin application. You can build Web APIs or complete web applications with it. It’s incredibly powerful yet simple to use. If you need smashing performance, get yourself some Gin. It features a Martini-like API with much better performance – up to 40 times faster. Gin is a HTTP web framework written in Go (Golang). Gin is a screaming fast, simple web framework.

#DB BROWSER FOR SQLITE PORTABLE HOW TO#

How to connect your API to a SQLite Databaseīy the time you’re done with this tutorial, you can build screaming fast web applications in Go.

How to create, read, update, and delete records (CRUD) with SQLite and Go.

How to build a Web API with the Gin Web Framework.

SQLite has been trending among developers for its ability to host small data very quickly, safely, and contained in a single file. Go is one of the hottest languages in development right now, known for its simple structure and blazing performance. Today, we’re going to build a Web API version of it. In a previous post, we learned how you can use Go and SQLite together, and we built a nice little console application. If you need to build lean, performant, and scalable applications, Go and SQLite together are an excellent choice.

Part one of a five part series on building a web application with Go.

Db browser for sqlite portable