Tonic Fabricate release information

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.

SQL exports now use multi-row inserts.

Added the ability to customize the distribution of locations and other domain-specific data.

Added the ability to set a seed in order to freeze columns and tables.

Added the following functions to allow you to generate Luhn check digits:fab_luhn_check_digitfab_append_luhn_check_digit

Added the ability to generate HCPCS codes.

Added the ability to generate US Hospital data.

Added the ability to generate US Social Security Numbers.

Added the ability to generate US Employer Identification Numbers.

Added the ability to generate US Bank routing numbers, names, and addresses.

‍

Fixed an issue with the Number generator where decimal places were ignored when using variants.

Added the ability to define unique constraints across multiple columns.

Improved compatibility with MSSQL.

For the List generator, added the ability to specify a weight for each value.

Added support for Microsoft SQL Server.

Added support for MySQL.

When you export, you can now order by a specific column.

The Foreign Key generator now includes the setting Generate rows for each key until the value in this column is 0 or less.

Sum generator now includes an Order By field.

Added Views

Added support for JSON arrays using SQLite's json_group_array() and json_object() functions.

Added support for generating time series data.

Added a Sum generator that generates the sum of all previous values in a column.

Fixed a bug that prevented foreign key columns from referencing SQL columns as the primary key.

Added a Rank generator.

Added the ability to generate a random datetime that is relative to another datetime column.

Added a Domain Name generator.

Renamed the "Stock" generators to "Company".

‍

Added a Nickname generator, which generates a common nickname that corresponds to the generated first name.

Added a Product Subcategory generator.

Added the following new function to add typos to a string:fab_add_typos(input, unit, value)

When you use the Number generator, you can now specify conditional variants. For example, you could use this feature to create seasonal pricing trends.

Fixed an issue where Percentage Null was ignored for Foreign Key fields.

When exporting, you can now append static data to any table.

Updated the default datetime format to use ISO 8601 (no T between the date and time).

You can now export databases and single tables to JSONL.

‍

Improved the performance of the Column From Another Table generator.

‍

You can now set min and max values for all numeric distributions.

Added Product Name, Product Description, Product Category, and Product Price generators.

Added the ability to exclude columns when exporting.

Added the fan_gen(generator, ...params) SQL function to allow programmatic access to generators.

You can now specify the number of decimal places for all numeric distributions.

‍

You now create a table from example CSV or JSON data.

Added a Language generator.

Added a MAC Address generator.

Added a Heroku-style project name generator.

‍

Added the ability to export a single table.

Fixed a bug where order by random() did not work with the SQL generator.

Added the Column From Another Table generator.

Added Credit Card Number and Credit Card Type generators.