Backend Development Development Tutorials, Guides & Insights

• Regularly back up your database to prevent data loss.

• Always validate and sanitize user inputs to prevent SQL injection attacks, even though SQLite is less prone to such vulnerabilities compared to other DBMS.

No preview available for this content.

Run the migration to create the table:

php artisan migrate

Create a new file named main.go and set up the basic structure of the application:

package main

import (
	"encoding/json"
	"net/http"
	"github.com/gorilla/mux"
)

var books []Book

func main() {
	router := mux.NewRouter()

	// Define routes
	router.HandleFunc("/books", getBooks).Methods("GET")
	router.HandleFunc("/books/{id}", getBook).Methods("GET")
	router.HandleFunc("/books", createBook).Methods("POST")
	router.HandleFunc("/books/{id}", updateBook).Methods("PUT")
	router.HandleFunc("/books/{id}", deleteBook).Methods("DELETE")

	// Start the server
	http.ListenAndServe(":8000", router)
}

• Add a Book

  mutation {
    addBook(title: "1984", author: "George Orwell") {
      title
      author
    }
  }