pq VS viper

Following the completion of the series — Secure and performant full-stack authentication system using rust (actix-web) and sveltekit and Secure and performant full-stack authentication system using Python (Django) and SvelteKit — I felt I should keep the streak by building an equivalent system in PURE go with very minimal external dependencies. We won't use any fancy web framework apart from httprouter and other basic dependencies including a database driver (pq), and redis client. As usual, we'll be using SvelteKit at the front end, favouring JSDoc instead of TypeScript. The combination is ecstatic!

Go’s standard library was not built to include any specific database drivers. So we need to install a third party package. In this case we are going to install https://github.com/lib/pq. Run following command:

For Postgres the driver comes from "github.com/lib/pq" and then it is just "postgres".

With regards to 2. -- also, it looks like there's an important unfixed issue https://github.com/lib/pq/issues/939. I haven't verified whether the issue is up to date.

Postgres (pure Go): https://github.com/lib/pq [*]Postgres (uses cgo): https://github.com/jbarham/gopgsqldriver Postgres (pure Go): https://github.com/jackc/pgx [*]

lib/pq 7.3k Stars, Used by 63k

I am using the lib/pq driver. is there a driver that does allow for this syntax or is there something I can change?

Once environment variables are setup we need load them into our project. For this this i will use viper

The code uses Viper to load configuration files in the application.

github.com/spf13/viper

Instead of directly accessing environment variables with os.Getenv(), integrating a configuration handler like viper might make it maintainable.

I guess most people are using https://github.com/spf13/viper but I don't know if I should read everything from

Use Viper for config file or environmental variable configuration -- it's going to save you a whole lot of time.

Cobra and Viper.

I've mostly been using https://github.com/spf13/viper of late for my go projects. It supports the standard config formats, (json, yaml, toml etc) and lets you override any value with a ENV value.