Simplest REST API CRUD using mysql in Golang

-

This is Another interesting article,
In this project, we are creating a simple REST API for book and perform simple CRUD operation
using MySQL database. we also use gorilla mux router. and tested API on POSTMAN.




Testing endpoints using POSTMAN

1. createBook
2. getBook

3.getBooks

4.updateBook


5.deleteBook


Final getBooks

source codeThanks for Reading, Keep Learning.

Comments

Post a Comment

Popular posts from this blog

Golang Interview Questions Part 1 Theory Top 50 Question

-
 Most Frequently asked golang interview Questions         ( Based on the real interview experience)      for Fresher 0-1 year experience. Why Golang --> For its Simplicity, Build in Concurrency Support and Super Scalable. What is Goroutine --> Goroutine is like a thread in java, it's lightweight than a thread useful to achieve concurrency in Go.  https://golangbot.com/goroutines/ How to communicate between goroutines? --> By Using Channels we can communicate between Goroutines. What is mutex? -- >  https://golangbot.com/mutex/ What is synchronization in go -->  https://golang.org/pkg/sync/ How to achieve concurrency in Go   --> By Using Goroutines. What is Channels in go? -->  https://golangbot.com/channels/ What are the Types of Channels? -->  https://golangbyexample.com/channel-golang/ What is Buffered Channel and Unbuffered Channel explain? -->  https://golangbot.com/channels/ How to avoid deadlock in a goroutine? -->  https://www.geeksforgeeks.org/
Read more

Complete Golang Development setup on Linux (Ubuntu 20.04 )

-
Image
Complete Golang Development setup on Linux  (Ubuntu 20.04 ) In this article, we will see the Complete Golang development Setup on Ubuntu 20.04 Tools going to install Go VS Code Postman MySQL Database Beekeeper Studio (MySQL Client ) ZSH Shell ( optional ) but worth to install. Can watch a Video tutorial                 Go          1. Download Latest Zip   https://golang.org/dl/go1.15.2.linux-amd64.tar.gz 2. Extract  tar -C /usr/local -xzf go1.15.2.linux-amd64.tar.gz 3. gedit ~/.bashrc 4. Add this export end of the file.        export GOPATH=$HOME/go        export GOBIN=$GOPATH/bin        export PATH=$PATH:$GOROOT/bin:$GOPATH/bin        export PATH=$PATH:/usr/local/go/bin        export GOROOT=/usr/local/go                                    5. Source ~/.bashrc 6. Check to  go version & go env VS Code                        VS Code is the most popular and features rich open-source IDE. 1. Download the latest .deb from  https://code.visualstudio.com/download and install manually jus
Read more

Best GitHub repositories for Go

-
Best Repositories for Go   In this article, I will share with you the best repositories on GitHub for Go. Companies using Go https://github.com/golang/go/wiki/GoUsers Golang Roadmap https://github.com/Alikhll/golang-developer-roadmap Cheatsheet https://github.com/a8m/golang-cheat-sheet Books https://github.com/dariubs/GoBooks https://github.com/astaxie/build-web-application-with-golang/tree/master/es https://github.com/go101/go101/releases Golang code samples and examples https://github.com/inancgumus/learngo https://github.com/GoesToEleven/GolangTraining https://github.com/ardanlabs/gotraining Data structure and algorithms https://github.com/halfrost/ LeetCode-Go  ( Use Google Translator) https://github.com/emirpasic /gods https://github.com/TheAlgori thms/Go https://github.com/arnauddri /algorithms https://github.com/0xAX/go-a lgorithms https://github.com/floyernic k/Data-Structures-and- Algorithms https://github.com/PacktPublishing/Learn-Data-Structures-and-Algorithms-with-Golang ht
Read more