Iterative Optimization on Hot Paths

sqlgen_example.go

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

sqlgen_example.sql

CREATE TABLE users (
  id   BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255)
);

storing_json.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"`
}

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
}

storing_json.sql

CREATE TABLE users (
  id            BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name          VARCHAR(255),
  configuration JSON
);

storing_json_after.go

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

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
}