Iterative Optimization on Hot Paths: Storing JSON in the database

users.go

type User struct {
	ID   int64 `sql:",primary"`
	Name string
	// The go struct representation of our data.
	Configuration Configuration `sql:"-"`
	// The JSON blob to be stored in and fetched from the database.
	ConfigurationBlob []byte `graphql:"-" sql:"configuration"`
}

users_repository.go

func (s *UserRepository) Update(ctx context.Context, u *User) error {
	// Serialize the configuration struct into JSON
	b, err := json.Marshal(u.Configuration)
	if err != nil {
		return err
	}
	// Set the blob to be saved to the database
	u.ConfigurationBlob = b
	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
	}
	// De-serialize the JSON from the database into the Go struct
	if err := json.Unmarshal(user.ConfigurationBlob, &user.Configuration); err != nil {
		return nil, err
	}

	return user, nil
}