`Go` `WebSocket` Example with Push to `Postgres`

[nelsonic]

We need write a lightweight (unauthenticated) WebSocket example in Go that pushes data to a Postgres Database. Essentially we are going to be replicating the hits which just receives requests and logs them to the DB.

The most similar project is: https://github.com/dwyl/hits-nodejs in terms of simplicity/structure except that the Node.js version is backed by fs not Postgres.

Todo

• [ ] Write a step-by-step guide to building a basic "hits" service in Go in this repo under the subdirectory /tutorial Starting point: https://gowebexamples.com/websockets looks like a concise example. Which uses https://github.com/gorilla/websocket ref: https://gorilla.github.io
• [ ] Make it as beginner-friendly as possible but it's safe to assume the person already knows Node/JS 🔰
• [ ] Include all of the steps you took 📝
• [ ] Use Go Doc comments to document all functions, see: https://tip.golang.org/doc/comment 📘
• [ ] All code must be fully tested, ref: https://blog.jetbrains.com/go/2022/11/22/comprehensive-guide-to-testing-in-go/ ✅
• [ ] Setup the GitHub CI pipeline to ensure tests are run on each git push. 🤖
• [ ] Expand any sections of the README.md that you feel are needed.

GO!

Context: We need this to pass basic events from the Web UI to the Backend. Eventually each WebSocket channel will be authenticated using a Token (TBD) that will be provided by our SSO... But that's complexity we don't need to deal with at this stage and is just focus on the basic.

Note: we may end up shifting this to it's own repo e.g: hits-go in the future ... But for now, just use this repo and expand the

@LuchoTurtle this is a task for whenever you feel you have "free" time or are "waiting" for someone to ask you to do something. Do it to the best of your abilities because we will be showing this to people who need to transition from Node.js to Go. As usual, please log your progress as comments in this issue and/or commits in the brach. Thanks.

[LuchoTurtle]

Gonna have a look at it 👌

[nelsonic]

Go recently broke into the Top 10 Programming Languages on GitHub: 🎉 https://github.blog/2023-11-08-the-state-of-open-source-and-ai/#the-most-popular-programming-languages

So we can update that section in the README.md. 📝

[nelsonic]

We could use a web framework for this example see: #5 🔍 Or we can try and make it as barebones as possible. 💭 What are your thoughts? 🤔