Tonic Fabricate release information

Security enhancements. When a user creates an account with an email address and password, they must now confirm the email address before they can long into Fabricate.

Improved security, including requiring users to enter their current password before setting a new password.

On the cloud application, you can now select the LLM provider to use for the Unstructured Data generator. You can also set the model to use for each type of content (free text, conversation, and JSON). The configuration is available to account owners, and is in a new Unstructured Data Generator section of the My Account page.

For additional security, Fabricate now limits login attempts from a single IP address to 5 per minute, and locks out users after 5 failed login attempts. Self-hosted instances can configure these limits using the environment variablesFABRICATE_MAX_LOGIN_ATTEMPTS_PER_MINUTE and FABRICATE_MAX_LOGIN_ATTEMPTS.

Improved performance for data regeneration.

Fixed an issue with Azure Active Directory single sign-on.

Fixed an issue with using the Unstructured Data generator with Azure OpenAI.

Creating a database based on Swagger YAML - On the database creation panel, in the Schema Definition field, in addition to a SQL DDL script or a prisma.schema script, you can now provide Swagger YAML API definition. Fabricate uses the API endpoint request and response information to derive the database tables and columns.

For the Foreign Key generator, the cardinality distribution types are now limited to Fixed, From Column, Normal, Uniform, and Until column <= 0.

Self-hosted instances can now use either Azure OpenAI or OpenAI to support Fabricate AI features.

Made general improvements to user interface text.

Self-hosted instances can now use Azure Blob Storage and Google Cloud Storage to store generated data. Previously only Amazon S3 was supported.

Improved performance for database deletion.

Updated the link to the Fabricate documentation.

Updated the release notes link.

Edited on-screen text and labels.

The Unstructured Data generator now includes a JSON type option that you can use to generate JSON objects.

For the Foreign Key generator, added the ability to specify a relative prevalence for each key.

Added the ability to generate IBANs.

For the Foreign Key generator, added a From Column... option to the Distribution setting. This allows you to specify a column in the primary key table that contains the number of rows to generate for each key.

Mock APIs can now modify database snapshots.

Added an AI Composer to the mock API editor.

Added history tracking to the mock API editor.

When it generates tables, Fabricate's AI now learns from comments in the DDL.

For the Number generator, added a "series" distribution. This allows you to generate a series of numbers progress linearly, exponentially, or logarithmically from a starting value to an ending value, optionally partitioned by a column and ordered by another column.

‍

Added the Value From Previous Row generator.

Added European banks.

Added the ability to subset categorical generators by 'in', 'not in', 'is null', and 'is not null'.

Added workspaces, which allow you to manage multiple projects within a single account, each with their own users, API keys, and databases.

Added the ability to search for tables in the Explorer.

API keys can now be assigned Viewer or Editor roles.

Added support for Oracle.

Added the ability to define constraints that specify that columns should not be equal.

Added 3-character country codes.

Added the ability to hide the time component of a datetime value.

You can now define postprocessing SQL for any field.