Github repositories which are using Postgres(or other db) and goLang
Postgres and GoLang
dat (Data Access Toolkit) is a fast, lightweight Postgres library for Go.
Focused on Postgres. See Insect, Upsert, SelectDoc, QueryJSON
Built on a solid foundation sqlx
// child DB is *sqlx.DB
DB.DB.Queryx(`SELECT * FROM users`)
SQL and backtick friendly
DB.SQL(`SELECT * FROM people LIMIT 10`).QueryStructs(&people)
Tern
Tern is a standalone migration tool for PostgreSQL. It includes traditional migrations as well as a separate optional workflow for managing database code such as functions and views.
golang-tutorial-rest-api
In this tutorial I’m going to illustrate how to serve a JSON API using Go. I’ll create a basic backend for a Vue.js application that will serve data already present in a PostgreSQL database.
https://flaviocopes.com/golang-tutorial-rest-api/
Squirrel – fluent SQL generator for Go
Squirrel helps you build SQL queries from composable parts:
A simple package written in Golang 1.7.3 for building cloud storage server or client,
A command line interface for spontaneously capturing the things you learn while coding.
https://github.com/dnote/cli
Django style fixtures for Golang’s excellent built-in database/sql library.
sample pgx stdlib
https://github.com/achiku/sample-pgx-stdlib
Electra API public web-services.
https://github.com/ruannelloyd/ElectraPay-Service
Adjust entries in config/db.json and you are ready to go.
https://github.com/JasminBektic/questionnaire
https://github.com/Yorkchung/frog
https://github.com/Yorkchung/frog/blob/fc180122ccfb659e5c087c379787635f34447c8c/local/model.go
Self-hosted Localization Management Platform built with Go and Angular 2.
https://github.com/sath1729/new1
Go File sharing HTTP server with auth and user rights management
https://github.com/ademilly/micro-share
https://github.com/byorty/hardcore
Geekmarks: API-Driven, Geeky Bookmarking Service
https://github.com/dimonomid/geekmarks
https://github.com/veselovoleg/Go_lessons
Orange Forum is an easy to deploy forum that has minimal dependencies and uses very little javascript. It is written is golang and a compiled binary is available for linux. Try the latest version hosted here. Please contact info@goodoldweb.com if you have any questions or want support.
https://github.com/s-gv/orangeforum/blob/1f6313cb3a1e755880fc1354f3e1efc4dd2dd4aa/views/comments.go
RegStat – persisting Docker registry notifications.
https://github.com/vleurgat/regstat
A Resource Booking and Managing System written in Golang and React
https://github.com/SteveYfZhao/felisResource
Galera Check Cluster Status
https://github.com/jsenon/GalAirCheck
https://github.com/sir-wiggles/zume
Written in go gopher’s spider can also be easily run in any go environment by running
https://github.com/solidfox/gopher
https://github.com/andrius4669/walitd
The hcexplorer repository is a collection of golang packages and apps for Hcd data collection, storage, and presentation.
https://github.com/thinkhero/hcexplorer
https://github.com/RDusi/borgdir-media
https://github.com/cdalong/transservice/blob/master/queries/transdb/queries.go
Dbmate is a database migration tool to keep your database schema in sync across multiple developers and your production servers.
https://github.com/turnitin/dbmate
A simple forum application written in go.
https://github.com/artificerpi/uchat
A simple Golang web application making use of go templating engine to process http responses.
https://github.com/Gidraff/task-manager-webapp
Evolution of a chat server from simple to distributed
https://github.com/sir-wiggles/chat
A public, open learning environment built on top of Wikipedia.
https://github.com/Stovoy/OpenClassroom
File system written in Go Lang
https://github.com/morenocantoj/sds-go
Important Blog-Post
pgx, migrate, squirrel and dockertest, four libraries that together make working with Postgres from Go a real pleasure.
Sumit Arora 