web-go-hello-app (MyQ)

Educational web-app based on and inspired by Trevor Sawler "Bookings" Go project on udemy

App

MyQ allows me to add and search specific queries that I forget.

I always have a trouble to remember 'How do I cut word in vim?', 'What was that command for ARP cache?' or 'What I've typed in Google that directed me to that link on SO about postgres setup?'.

Well, now I can add specific query and provide consice answer or short description with optional source link. Without a SMM lifestories in the blog pages. And/or without Google's understanding of my understanding of what I actually want to find or what I mean. And move all purple links to MyQ.

Basically, it's a note app where I store answers to the general questions which are part of my own search vocabulary.

1. Add your query:

Of course, look for an answer on Google first. This is trivial example, but still, for more specific searches it would required you to scroll and look through those purple pages or find something in your bookmarks.

2. Look for it later:

back-end: chi, scs, nosurf, pgx, postgres image, docker
front-end: http/tmpl, bootstrap, sweatAlert2

Application setup:

Postgres container

docker run --name postgres \
  --network=myq_network \
  --network-alias=postgres \
  -v pgdata:/var/lib/postgresql/data \
  -p 5432:5432 \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=password \
  -e POSTGRES_DB=db \
  -d \
  postgres

don't forget to specify postgres variables according to your environment.

Create DB users and searches tables. I used a custom sql script against running container:

cat db_scripts/CreateSearchAndUserTables.sql | docker exec -i postgres psql -U postgres -h localhost -p 5432 -d db

But you can dump .sql file to the container and run it from within postgres container:

docker cp ./dump.sql postgres:/docker-entrypoint-initdb.d/dump.sql  
docker exec -u postgres postgres psql db postgres -f docker-entrypoint-initdb.d/dump.sql  

General form to the last line of code is:

docker exec -u postgresuser containername psql dbname postgresuser -f /container/path/file.sql

After postgres is setup, your DB should have two tables for searches and users.
Users:

id	username	email	password	created_at	updated_at	access_level

Searches:

id	user_id	query	query_link	description	created_at	updated_at

Start application

init.sh script has predefined values for the application environment. Postgres values, prod env, server address:

$ go run ./cmd/web -h
  -addr string
    	Application port (default ":8080")
  -cache
    	Use cache
  -dbhost string
    	DB host (default "localhost")
  -dbname string
    	DB name (default "db")
  -dbpass string
    	DB password
  -dbport string
    	DB port (default "5432")
  -dbuser string
    	DB user (default "postgres")
  -prod
    	In production