Fishery vs Redgate SQL Prompt
Fishery
github.comRedgate SQL Prompt
red-gate.comSide by side
| Figure | Fishery | Redgate SQL Prompt |
|---|---|---|
| Price from | Free | $17.50/mo |
| Free plan | Yes | — |
| Free trial | — | Yes |
| Open source | — | — |
| Windows | — | Yes |
| Plans published | 1 | 3 |
| Spec score · Test Data Generation Tools | 7.7 (#11) | 7.5 (#18) |
| Purpose | Fishery is a JavaScript library for setting up objects for tests and other data needs. | SQL Prompt is an add-in for SQL Server Management Studio and Visual Studio that completes, formats, analyzes, fixes, and refactors SQL code. |
Plans
Redgate SQL Prompt
- SQL PromptPriced on request
- SQL Prompt$210 a year
- SQL Toolbelt Essentials$1,410 a year
In their own words
Fishery
Fishery is a free JavaScript library for preparing objects as test data and for other situations where JavaScript data needs setup. Its factories define defaults, and build() creates objects with supplied parameters layered over those defaults. TypeScript users can obtain typed factory parameters and return objects, while the library also works without TypeScript. Factories may define onCreate behavior for asynchronous work; create() then performs that work and returns a promise. Additional factory capabilities include sequences, transient parameters, associations, and hooks that run after building or creating objects. Developers can extend factories with reusable builder methods by subclassing Factory. The documentation describes using factories alongside other factories to build associated objects. Installation instructions cover npm and Yarn as development dependencies. The repository identifies Fishery as free software under the MIT license and says thoughtbot, inc. maintains and funds it. GitHub Issues is the listed channel for bug reports and change requests.
Redgate SQL Prompt
Redgate SQL Prompt has no write-up on Specifiction yet; its figures are above.