Image generator

Last modified: April 3, 2025

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.