Go CRUD APIs with Gin Framework and SQLite

This repository contains a set of CRUD (Create, Read, Update, Delete) APIs built with Go (Golang) using the Gin framework and SQLite database. The APIs allow for managing data stored locally in an SQLite database, providing endpoints for creating, retrieving, updating, and deleting records. The API is in master branch

Features

• Create API: Allows users to create new records in the SQLite database by sending a POST request with the necessary data.

• Read API: Provides endpoints for retrieving records from the database. Users can fetch all records or retrieve specific records by their unique identifiers.

• Update API: Enables users to update existing records in the database by sending a PUT request with the updated data.

• Delete API: Allows users to delete records from the database using their unique identifiers.

• SQLite Database: Utilizes SQLite as the local database for storing and managing data. The database schema is included in the repository for reference.

Technologies Used

• Go (Golang): A statically typed, compiled programming language designed for simplicity, efficiency, and concurrency.

• Gin Framework: A lightweight web framework for Go that provides routing, middleware support, and more, making it easy to build web applications and APIs.

• SQLite: A lightweight, serverless database engine that is self-contained, reliable, and widely used in embedded systems and small-scale applications.

Usage

1. Clone the repository to your local machine.
2. Navigate to the project directory.
3. Install any necessary dependencies.
4. Run the main application file.
5. Access the CRUD APIs using an HTTP client such as Postman or curl.

ER Diagram

Outputs

• POST:

• POST:

• GET:

• GET:

• DELETE:

• PUT:

Contributing

Contributions to this project are welcome! If you find any issues, have suggestions for improvements, or would like to add new features, please feel free to open an issue or submit a pull request.

License

This project is licensed under the MIT License. You are free to use, modify, and distribute the code for both commercial and non-commercial purposes. See LICENSE for more information.