Support nullable types in DB schema about service HOT 3 CLOSED

No worries. I'm happy you asked the question and don't ever stop questioning things when they don't make sense.

I didn't notice they added this package to the module we already import. That is super confusing to have this package in two places. It wasn't necessary a bad idea, but I only use pgx for the driver. I am using sqlx to actually interact with the DB.

from service.

Where is the definition of this type pgtype.Text? Are you are talking about this package?

https://github.com/jackc/pgtype

If you are suggesting to bring this package in just for a single type and not for any of its behavior. I'm not a fan of that.

We have a NULL type in the standard library sql.Null that I do use when NULL is a valid option for a field.

type user struct {
	ID           uuid.UUID      `db:"user_id"`
	Name         string         `db:"name"`
	Email        string         `db:"email"`
	Roles        dbarray.String `db:"roles"`
	PasswordHash []byte         `db:"password_hash"`
	Department   sql.NullString `db:"department"`
	Enabled      bool           `db:"enabled"`
	DateCreated  time.Time      `db:"date_created"`
	DateUpdated  time.Time      `db:"date_updated"`
}

What is the problem with using sql.Null. We have the to functions to perform the data transformation between the layers.

from service.

Yeah, I've found it in the service project github.com/jackc/pgx/v5/.
So I made a use of github.com/jackc/pgx/v5/pgtype to work with geopoints pgtype.Point. That's why I've got an idea to use pgtypes for postgres oriented structs..

What is the problem with using sql.NullString

Actually that's kinda my mistake. I'm a newbie in go, so I now feel ashamed about not knowing about such simple things...)

Thank you for the quick and very useful repsonse!

from service.