Pluralsight course.

http://www.pluralsight.com/courses/creating-web-applications-go

Reminding myself how to use Git and Github at the same time.

1. All data is hard-coded.
2. Only one category (Juices) has been implemented.
3. Stand_locator doesn't implement the postcode finder. Just returns hardcoded data.
4. Tests only added for a few types.

GOPATH: seems good practice to have a library folder as the first element of the path then your current project. Any packages that are downloaded then go to the lib and are compiled for your platform, out of the way of your current project. Possibly this strength could be a downside i.e. you have all packages globally on your machine and not specific to project(s) that need them.

The name of the source file has no bearing on how the contents is referred to in other source files. Any public methods will be visible to a consumer once the package is imported.

Thanks to http://nathanleclaire.com/blog/2014/08/09/dont-get-bitten-by-pointer-vs-non-pointer-method-receivers-in-golang/, I understand the reason for func (this *struct) Fn() + func (this type) Fn() and when to chose between them. Hoorah!

MVC has proven hard to follow in this project. Naming conventions (matching concepts have the same name in model/package/controller/converter folders) seemed to be a large part of the issue.

SQLite go library chosen: https://github.com/mattn/go-sqlite3

64-bit MINGW build that worked with CGO here:

• http://sourceforge.net/projects/mingwbuilds/ and also here
• http://sourceforge.net/projects/mingw-w64/files/Toolchains%20targetting%20Win64/Personal%20Builds/mingw-builds/5.2.0/threads-win32/seh/

SQLite manager recommendation: http://stackoverflow.com/questions/835069/which-sqlite-administration-console-do-you-recommend

Database structure:

CREATE TABLE "member" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "email" VARCHAR, "password" VARCHAR, "first_name" VARCHAR)

CREATE TABLE "session" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "session_id" VARCHAR NOT NULL , "member_id" INTEGER NOT NULL )

CREATE TABLE sqlite_sequence(name,seq)