Simple CRUD App w/ Gorilla/Mux, MariaDB alternatives and similar packages
Based on the "Server Applications" category.
Alternatively, view Simple CRUD App w/ Gorilla/Mux, MariaDB alternatives based on common mentions on social networks and blogs.
-
consul
Consul is a distributed, highly available, and data center aware solution to connect and configure applications across dynamic, distributed infrastructure. -
SFTPGo
Fully featured and highly configurable SFTP server with optional HTTP/S, FTP/S and WebDAV support - S3, Google Cloud Storage, Azure Blob -
RoadRunner
🤯 High-performance PHP application server, process manager written in Go and powered with plugins -
Ponzu
Headless CMS with automatic JSON API. Featuring auto-HTTPS from Let's Encrypt, HTTP/2 Server Push, and flexible server framework written in Go. -
Jocko
Kafka implemented in Golang with built-in coordination (No ZK dep, single binary install, Cloud Native) -
algernon
Small self-contained pure-Go web server with Lua, Teal, Markdown, Ollama, HTTP/2, QUIC, Redis and PostgreSQL support -
Rendora
dynamic server-side rendering using headless Chrome to effortlessly solve the SEO problem for modern javascript websites -
go-feature-flag
GO Feature Flag is a simple, complete and lightweight self-hosted feature flag solution 100% Open Source. 🎛️ -
SDNS
A high-performance, recursive DNS resolver server with DNSSEC support, focused on preserving privacy. -
Euterpe
Self-hosted music streaming server 🎶 with RESTful API and Web interface. Think of it as your very own Spotify! ☁️🎧 -
goproxy
🦁 goproxy is a proxy server which can forward http or https requests to remote servers./ goproxy 是一个反向代理服务器,支持转发 http/https 请求。 -
Eru
Eru, a simple, stateless, flexible, production-ready orchestrator designed to easily integrate into existing workflows. Can run any virtualization things in long or short time. -
simple-jwt-provider
Simple and lightweight provider which exhibits JWTs, supports login, password-reset (via mail) and user management.
WorkOS - The modern identity platform for B2B SaaS
Do you think we are missing an alternative of Simple CRUD App w/ Gorilla/Mux, MariaDB or a related project?
README
Simple CRUD App w/ Gorilla/Mux, MariaDB, Redis
NOTE
This project is not longer maintained. I'll make a new better project.
Features
Basic CRUD operations (Create-Read-Update-Delete).
Database Scheme
Data table:
create table products
(
id int(11) unsigned auto_increment primary key,
name tinytext null,
manufacturer tinytext null
);
You can generate data from http://filldb.info/.
Users table:
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` text NOT NULL,
`saltedpassword` text NOT NULL,
`salt` text NOT NULL,
PRIMARY KEY (`id`)
);
Password+Salt
is encrypted with bcrypt
with 10 rounds and stored in saltedpassword
column.
Caching
You can edit cache time from this line:
err = a.Cache.Set(r.RequestURI, content, 10*time.Minute).Err()
Example Requests
To get all entries from table:
curl --user user1:pass1 127.0.0.1:8000/api/products/list
To get an entry with id
(where id equals 10):
curl --user user1:pass1 127.0.0.1:8000/api/products/10
To create an entry:
curl --header "Content-Type: application/json" \
--request POST \
--data '{"name": "ABC", "manufacturer": "ACME"}' \
--user user1:pass1 127.0.0.1:8000/api/products/new
To update an entry:
curl --request PUT \
--data '{"name": "ABC", "manufacturer": "ACME"}' \
--user user1:pass1 127.0.0.1:8000/api/products/11
To delete an entry:
curl --request DELETE --user user1:pass1 127.0.0.1:8000/api/products/10