Passing database connections

[jollyrogue]

What's the best way to handle passing database connections into route functions?

I've been creating a global variable to handle the database connections in some simple applications I've written, but I'm wondering if there is a better way.

There is creating a custom context, but attaching a database to it doesn't seem like a great idea.

[aldas]

Do you use same db schema for all users or user/company has their own schema (multi tenancy)?

In case of former see #2075 (comment) "controller" that have db injected to them (second one) example.

NB: it would be better if you do not call DB from handler directly and instead create service-like structs that you call from handler. In that case you separate your transport (HTTP) layer from service (business) layer.

[jollyrogue]

Do you use same db schema for all users or user/company has their own schema (multi tenancy)?

It uses the the same DB schema for everything. It's an internal service, and the functions to retrieve data from the database are already separate.

In case of former see #2075 (comment) "controller" that have db injected to them (second one) example.

Alright, I'll check that out.

Is there an example if something was multi-tenant? I don't expect to need that, but now I'm curious.