Image generator
The Image generator produces small images, for example, icons or thumbnails, encoded in formats like PNG or JPEG, and stores the binary data in BYTEA fields, which are commonly used in PostgreSQL. This generator is ideal for stress-testing systems where images are stored and retrieved from a database, evaluating functionality like image compression handling, query optimization, and frontend rendering consistency.
Generator properties
The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.
| Short name | Example of generated data | Data type matching | Country-specific |
|---|---|---|---|
| Image | fill with small colored images | bytea | Default |
Matching rules
The generator can be assigned to a column that matches any of the following rules:
- The column name is ‘photo’ or ‘image’ and it belongs to a table whose name is ‘product’.
- The column name starts with ‘prod’ and ends with ‘image’ or ‘photo’, with any or no characters in between, regardless of the table name.
- The column name is ‘picture’, regardless of the table name.
Configure additional settings
The tool allows you to set additional options:
- In the File to load data from box, select … to choose a file to load data from. The default path to the file is .\ProductImage.
- Include the subfolders.
- Specify a file encoding and a file pattern.
Preview of the column data generated by the Image generator
