Iterative Optimization on Hot Paths: Storing JSON in the database

users.go

type User struct {
	ID            int64 `sql:",primary"`
	Name          string
	Configuration Configuration `sql:",json"`
}

users_repository.go

func (s *UserRepository) Update(ctx context.Context, u *User) error {
	return s.DB.Update(ctx, &u)
}

func (s *UserRepository) ById(ctx context.Context, id int64) (*User, error) {
	var user *User
	if err := s.DB.QueryRow(ctx, &user); err != nil {
		return nil, err
	}

	return user, nil
}